12. Extracting Data from the Website(Power Query,Pivot Table)/2. Combining Queries.mp487.01MB
2. Creating Excel Tables,PivotTables and PivotCharts/1. Freezing Header or Row.mp416.41MB
2. Creating Excel Tables,PivotTables and PivotCharts/2. Converting Data in an Excel Table.mp422.82MB
2. Creating Excel Tables,PivotTables and PivotCharts/3. Adding Records in an Excel Table.mp441.76MB
2. Creating Excel Tables,PivotTables and PivotCharts/4. Renaming and Finding Records in an Excel Table.mp428.62MB
2. Creating Excel Tables,PivotTables and PivotCharts/5. Editing and Deleting Records in an Excel Table.mp426.01MB
2. Creating Excel Tables,PivotTables and PivotCharts/6. Remove Duplicates.mp426.95MB
2. Creating Excel Tables,PivotTables and PivotCharts/7. Sorting Date Column in an Excel Table.mp419.59MB
2. Creating Excel Tables,PivotTables and PivotCharts/8. Sorting Multiple Columns.mp422MB
2. Creating Excel Tables,PivotTables and PivotCharts/9. Filtering Data in an Excel Worksheet and Deleting an Excel Table.mp434.52MB
2. Creating Excel Tables,PivotTables and PivotCharts/10. Filtering Data by Creating Criteria.mp430.86MB
2. Creating Excel Tables,PivotTables and PivotCharts/11. Filtering Data in an Excel Table by Using Slicer.mp423.35MB
2. Creating Excel Tables,PivotTables and PivotCharts/12. Splitting the Worksheet into Panes.mp430.6MB
2. Creating Excel Tables,PivotTables and PivotCharts/13. Calculating Records in an Excel Table.mp424.67MB
2. Creating Excel Tables,PivotTables and PivotCharts/14. Inserting Subtotals.mp435.97MB
2. Creating Excel Tables,PivotTables and PivotCharts/15. Creating and Adding Data in a Pivot Table.mp434.72MB
2. Creating Excel Tables,PivotTables and PivotCharts/16. Filtering Data in a Pivot Table.mp426.43MB
2. Creating Excel Tables,PivotTables and PivotCharts/17. Adding Pivot Chart in a Pivot Table.mp419.06MB
2. Creating Excel Tables,PivotTables and PivotCharts/18. Home Work.mp46.7MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/1. Adding Data in Excel Table.mp421.97MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/2. Adding and Formatting First Chart in Pivot Table.mp435.29MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/3. Adding and Formatting Second Chart in Pivot Table.mp429.97MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/4. Adding and Formatting Third Chart in Pivot Table.mp429.48MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/5. Adding and Formatting Fourth Chart in Pivot Table.mp430.55MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/6. Adding and Formatting Fifth Chart in Pivot Table.mp428.39MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/7. Adding and Formatting Sixth Chart in Pivot Table.mp421.71MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/8. Adding Chart in Excel Dashboard.mp423.34MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/9. Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box.mp428.12MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/10. Inserting Slicers in the Dashboard for Analyzing Sales Data.mp438.15MB
4. Data Validation and Inserting Comments/1. Specifying a Validation Rule by Using List.mp440.25MB
4. Data Validation and Inserting Comments/2. Show an Input Message on an Active Cell.mp429.78MB
4. Data Validation and Inserting Comments/3. Displaying Error Alert Message.mp429.2MB
4. Data Validation and Inserting Comments/4. Circle Invalid Data.mp47.64MB
4. Data Validation and Inserting Comments/5. Inserting Comments in a Worksheet.mp418.83MB
4. Data Validation and Inserting Comments/6. Home Work.mp44.99MB
5. Analyzing Data in the Table/1. Introducing and Converting a Range to a Table.mp434.2MB
5. Analyzing Data in the Table/2. Sorting a Table using Different Methods.mp438.59MB
5. Analyzing Data in the Table/3. Filtering a Table using Different Methods.mp454.41MB
5. Analyzing Data in the Table/4. Analyzing Basic Table Operations.mp461.39MB
5. Analyzing Data in the Table/5. Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions.mp468.89MB
6. Analyzing Data with PivotTables/1. Introducing PivotTables.mp418.97MB
6. Analyzing Data with PivotTables/2. Creating PivotTable.mp440.74MB
6. Analyzing Data with PivotTables/3. Inserting Subtotals In the PivotTable.mp431.41MB
6. Analyzing Data with PivotTables/4. Summarizes Value Field by Changing Functions.mp417.51MB
6. Analyzing Data with PivotTables/5. Adding PivotChart and Slicer in the PivotTable.mp430.03MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/1. Introducing Power Query and Upload CSV File.mp418.37MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/2. Retrieving Power Query Data into an Excel Table and Editing a Query Data.mp435.7MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/3. Adding a New Column and Grouping Values in a Power Query Data.mp441.39MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/4. Analyzing Revenue Data by Adding Trendlines in the Chart.mp439.63MB
8. Analyzing Data with Business Intelligence (Forecast Sheet)/1. Analyzing Revenue Data by Creating a Forecast Sheet.mp448.7MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/1. Introducing Database and Upload Access Database File.mp420.64MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/2. Creating the Data Model.mp427.21MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/3. Transferring Data in the Power Pivot.mp428.92MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/4. Exploring the Data Model in the Diagram View.mp411.5MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/5. Managing Table Relationships in the Power Pivot.mp418.17MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/6. Creating a PivotTable from the Data Model.mp434.61MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/7. Adding a Timeline Slicer in the PivotTable.mp416.58MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/8. Drilling down into the Data in the PivotTable.mp425.75MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/9. Visualizing Stores Sale Data with Power Map.mp459.51MB
10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/1. Importing Population and Area Data from the Website and Creating Queries.mp442.27MB
10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/2. Extracting Population and Area Data into PivotTable.mp451.66MB
10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/3. Merging Two Queries into One query.mp443.97MB
11. Loading Website Data into Power Map(Power Query,Power Map)/1. Loading Website Data into Power Map.mp476.14MB
12. Extracting Data from the Website(Power Query,Pivot Table)/1. Extracting and Transforming User Rating Data from the Website.mp460.57MB
1. Introduction/1. Course Files.mp45.76MB
13. Extracting Football Team Data from the Website(Power Query,Pivot Table)/1. Extracting and Transforming Data from the Website.mp451.09MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/1. Cost-Volume-Profit(CVP) Chart Analysis.mp419.51MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/2. Find the Break-Even Point by Using Goal Seek.mp430.23MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/3. Generate $30000 Net Income of Company by using Goal Seek Tool.mp49.76MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/4. Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume.mp436.86MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/5. Completing the One-Variable Data Table.mp424.85MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/6. Creating the CVP Chart of the Data Table.mp429.35MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/7. Viewing the Impact of Changing the Sales Price in the Data Table.mp428.83MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/8. Creating the Two-Variable Data Table.mp455.1MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/9. Create a Chart of the Two Variable Data Table.mp449.8MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/1. Define Names for the Income Statement Values.mp421.92MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/2. Adding the Scenarios in the Scenario Manager.mp470.11MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/3. View the Impact of the Reduced Operations Scenario.mp440.35MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/4. Creating the Scenario Summary Report.mp422.76MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/5. Creating the Scenario PivotTable Report.mp453.92MB
16. Analyzing Business Data with Solver/1. Understand Solver with Simple Example.mp434.29MB
16. Analyzing Business Data with Solver/2. Introducing Product Mix and Find an Optimal Solution with Solver Part 1.mp448.66MB
16. Analyzing Business Data with Solver/3. Introducing Product Mix and Find an Optimal Solution with Solver Part 2.mp462.82MB
16. Analyzing Business Data with Solver/4. Creating a Solver Answer Report.mp420.51MB
16. Analyzing Business Data with Solver/5. Saving and Loading Solver Model.mp419.85MB
17. Introduction to Excel/1. Starting With Excel.mp49.84MB
17. Introduction to Excel/2. Excel Tabs,Groups and Commands.mp413.15MB
17. Introduction to Excel/3. Excel Rows and Columns.mp416.46MB
17. Introduction to Excel/4. Changing the Size of Columns and Rows.mp418.68MB
17. Introduction to Excel/5. Entering Text and Numbers in Worksheet.mp420.38MB
17. Introduction to Excel/6. Wrap Text Inside the Cell.mp48.6MB
17. Introduction to Excel/7. Edit Text Within a Cell.mp46.97MB
17. Introduction to Excel/8. Merging and Formatting Cells in a Worksheet.mp421.29MB
17. Introduction to Excel/9. Formatting Header in a Worksheet.mp413.17MB
17. Introduction to Excel/10. Adding Image in a Worksheet.mp420.95MB
17. Introduction to Excel/11. Formatting Date in Excel Worksheet.mp419.88MB
17. Introduction to Excel/12. Working of Undo & Redo Commands in an Excel Worksheet.mp414.98MB
17. Introduction to Excel/13. Home Work.mp49.37MB
18. Calculations With Basic Formulas/1. Introduction to Arithmetic Operators.mp48.88MB
18. Calculations With Basic Formulas/2. Calculations with Arithmetic Operators.mp433.64MB
18. Calculations With Basic Formulas/3. Copy and Paste the Formula.mp49.37MB
18. Calculations With Basic Formulas/4. Auto Complete Formula.mp47.69MB
18. Calculations With Basic Formulas/5. Inserting and Deleting Columns and Rows.mp410.38MB
18. Calculations With Basic Formulas/6. Hide and Unhide Columns and Rows.mp47.48MB
18. Calculations With Basic Formulas/7. Moving a Cell or Range by Drag and Drop Method.mp47.29MB
18. Calculations With Basic Formulas/8. Moving a Cell or Range by Cut and Paste Method.mp43.87MB
18. Calculations With Basic Formulas/9. Relative and Absolute Cell References.mp419.86MB
18. Calculations With Basic Formulas/10. Home Work.mp48.83MB
19. Calculations with Simple Excel Functions/1. Introduction to Function Syntax.mp415.11MB
19. Calculations with Simple Excel Functions/2. Calculating Total Sales by Using SUM Function.mp430.74MB
19. Calculations with Simple Excel Functions/3. Calculating Total Sales Quantities by Using SUM Function.mp415.23MB
19. Calculations with Simple Excel Functions/4. Count Price Items by Using COUNT Function.mp416.57MB
19. Calculations with Simple Excel Functions/5. Count Food Items by Using COUNTA Function.mp417.71MB
19. Calculations with Simple Excel Functions/6. Calculating Average Sales by Using AVERAGE Function.mp424MB
19. Calculations with Simple Excel Functions/7. Calculating Maximum Sales Value of Customer by Using MAX Function.mp417.79MB
19. Calculations with Simple Excel Functions/8. Calculating Minimum Sales Value of Customer by Using MIN Function.mp418.04MB
19. Calculations with Simple Excel Functions/9. Calculating Total Price of Products by Using PRODUCT Function.mp422.39MB
19. Calculations with Simple Excel Functions/10. Calculating Sales Data by Using Auto FUNCTION Button.mp422.4MB
19. Calculations with Simple Excel Functions/11. Calculating a Tax Rate on Total Sales.mp429.32MB
19. Calculations with Simple Excel Functions/12. Home Work.mp48.68MB
20. Formatting a Worksheet/1. Merging Two or More Cells into One Cell.mp415.29MB
20. Formatting a Worksheet/2. Alignment of Cell Text.mp415.77MB
20. Formatting a Worksheet/3. Splitting Text into Multiple Lines.mp415.45MB
20. Formatting a Worksheet/4. Rotating a Cell Text or Numbers.mp411.12MB
20. Formatting a Worksheet/5. Formatting Background Color of Text and Numbers.mp423.76MB
20. Formatting a Worksheet/6. Formatting Font Size and Font Color.mp418.1MB
20. Formatting a Worksheet/7. Adding Border into Cells.mp413.05MB
20. Formatting a Worksheet/8. Formatting Cell Styles.mp419.12MB
20. Formatting a Worksheet/9. Find and Replace Text in a Worksheet.mp422.95MB
20. Formatting a Worksheet/10. Calculating Students Enrollment and Difference Between two Columns Values.mp434.1MB
20. Formatting a Worksheet/11. Calculating Percentage Difference Between two Columns Values.mp425.3MB
20. Formatting a Worksheet/12. Conditionally Formatting Cells in a Worksheet.mp427.05MB
20. Formatting a Worksheet/13. Conditionally Formatting Cells with a Top and Bottom Rules.mp416.34MB
20. Formatting a Worksheet/14. Home Work.mp45.53MB
21. Saving and Printing a Workbook/1. Saving a Workbook.mp47.43MB
21. Saving and Printing a Workbook/2. Worksheet Views,Page Orientation and Scaling.mp430.93MB
21. Saving and Printing a Workbook/3. Setting Margins in a Print Page.mp49.97MB
21. Saving and Printing a Workbook/4. Adding Header and Footer in a Print Page.mp432.65MB
21. Saving and Printing a Workbook/5. Print Preview and Selecting Print Area.mp420.86MB
21. Saving and Printing a Workbook/6. Setting Scaling and Margins in a Print Page(Document 1).mp434.23MB
22. Project Calculations with Operators and Functions/1. Calculating the Area of Field and Plots.mp436.46MB
22. Project Calculations with Operators and Functions/2. Calculating the Grown and Empty Area of Vegetables Field.mp417.95MB
22. Project Calculations with Operators and Functions/3. Calculating the Percentage of Grown and Empty area in Vegetables Field.mp415.91MB
22. Project Calculations with Operators and Functions/4. Calculating Cost of Sales and Weightages of Vegetables.mp436.23MB
22. Project Calculations with Operators and Functions/5. Calculating Profit and Percentage of Profit from Vegetables.mp428.52MB
22. Project Calculations with Operators and Functions/6. Calculating Revenue by Using Sum,Max,Min,Average and Median Functions.mp448.27MB
22. Project Calculations with Operators and Functions/7. Introduction to NESTED Function.mp414.47MB
22. Project Calculations with Operators and Functions/8. Nesting the SUM and MEDIAN Functions within ROUND Function.mp417.61MB
22. Project Calculations with Operators and Functions/9. Home Work.mp49.23MB
23. IF and VLOOKUP Functions/1. Introduction to IF Function and Apply Weather Condition on IF Function.mp431.37MB
23. IF and VLOOKUP Functions/2. Apply Different Conditions on IF Function.mp463.48MB
23. IF and VLOOKUP Functions/3. Introduction to VLOOKUP Function.mp427.44MB
23. IF and VLOOKUP Functions/4. Apply VLOOKUP Function on Data Table.mp417.94MB
23. IF and VLOOKUP Functions/5. Retrieving Values from Data Table by Using VLOOKUP Function.mp418.03MB
23. IF and VLOOKUP Functions/6. Errors in VLOOKUP Function.mp416.38MB
23. IF and VLOOKUP Functions/7. Home Work.mp45.75MB
24. Adding Column and Pie Charts in an Excel worksheet/1. Embed Column Chart in a Worksheet.mp420.95MB
24. Adding Column and Pie Charts in an Excel worksheet/2. Analyzing Data with a Column Chart.mp443.43MB
24. Adding Column and Pie Charts in an Excel worksheet/3. Analyzing Data with a Pie Chart.mp430.86MB
24. Adding Column and Pie Charts in an Excel worksheet/4. Recommended Charts.mp426.94MB
24. Adding Column and Pie Charts in an Excel worksheet/5. Home Work.mp44.12MB
25. Date and Time Functions in an Excel/1. NOW and TIME Functions.mp427.1MB
25. Date and Time Functions in an Excel/2. HOUR,MINUTE and SECOND Functions.mp419.91MB
25. Date and Time Functions in an Excel/3. TODAY,DATE and DAYS Functions.mp424.43MB
25. Date and Time Functions in an Excel/4. YEAR,MONTH and DAY Functions.mp428.09MB
25. Date and Time Functions in an Excel/5. WEEKDAY Function.mp421.44MB
25. Date and Time Functions in an Excel/6. WEEKNUM Function.mp412.73MB
25. Date and Time Functions in an Excel/7. EDATE Function.mp417.12MB
25. Date and Time Functions in an Excel/8. EOMONTH Function.mp421.98MB
25. Date and Time Functions in an Excel/9. Determining Person's Birthday.mp414.79MB
25. Date and Time Functions in an Excel/10. Calculating Age of Person.mp417.48MB
25. Date and Time Functions in an Excel/11. Formatting Date in a Cell.mp49.9MB
25. Date and Time Functions in an Excel/12. DATEVALUE Function.mp414MB
25. Date and Time Functions in an Excel/13. DAYS360 Function.mp412.77MB
25. Date and Time Functions in an Excel/14. ISOWEEKNUM Function.mp49.88MB
25. Date and Time Functions in an Excel/15. NETWORKDAYS Function.mp410.44MB
25. Date and Time Functions in an Excel/16. TIMEVALUE Function.mp412.6MB
25. Date and Time Functions in an Excel/17. YEARFRAC Function.mp415.05MB
26. Logical Functions in an Excel/1. Calculating the Age of Employees and Length of Service.mp437.54MB
26. Logical Functions in an Excel/2. Analyzing Data by Using IF Function.mp449.11MB
26. Logical Functions in an Excel/3. Determining Birthday of Employees.mp431.38MB
26. Logical Functions in an Excel/4. Specifying Day of Birthdate by Nesting DAY Function Within IF Function.mp442.92MB
26. Logical Functions in an Excel/5. Determining Employee Eligibility for Promotion by Using AND Function.mp450.8MB
26. Logical Functions in an Excel/6. Nesting the AND Function Within IF Function.mp451.16MB
26. Logical Functions in an Excel/7. Determining Employee Eligibility for Promotion by Using OR Function.mp440.76MB
26. Logical Functions in an Excel/8. Nesting the OR Function Within IF Function.mp457.16MB
26. Logical Functions in an Excel/9. IFERROR Function.mp420.28MB
26. Logical Functions in an Excel/10. IFNA Function.mp442.19MB
26. Logical Functions in an Excel/11. FALSE Function.mp415.48MB
26. Logical Functions in an Excel/12. IFS Function.mp449.92MB
26. Logical Functions in an Excel/13. NOT Function.mp420.77MB
26. Logical Functions in an Excel/14. SWITCH Function.mp427.56MB
26. Logical Functions in an Excel/15. TRUE Function.mp416.54MB
26. Logical Functions in an Excel/16. XOR Function.mp418.12MB
26. Logical Functions in an Excel/17. Home Work.mp45.31MB
27. Lookup and Reference Functions in an Excel/1. Extracting Value from Data Table by Using VLOOKUP Function.mp463.46MB
27. Lookup and Reference Functions in an Excel/2. Extracting Value from Data Table by Using HLOOKUP Function.mp445.75MB
27. Lookup and Reference Functions in an Excel/3. Calculating Discount and Total Price.mp415.25MB
27. Lookup and Reference Functions in an Excel/4. Calculating Tax Rate on Total Price Value.mp49.47MB
27. Lookup and Reference Functions in an Excel/5. Extracting Value by Using CHOOSE Function.mp433.37MB
27. Lookup and Reference Functions in an Excel/6. Nesting the CHOOSE Function Within Sum Function.mp435.63MB
27. Lookup and Reference Functions in an Excel/7. MATCH Function.mp423.72MB
27. Lookup and Reference Functions in an Excel/8. Extracting Value by Using INDEX Function.mp426.81MB
27. Lookup and Reference Functions in an Excel/9. Nesting the MATCH Function Within an INDEX Function.mp428.36MB
27. Lookup and Reference Functions in an Excel/10. Nesting the VLOOKUP Function Within an IFERROR Function.mp434.16MB
27. Lookup and Reference Functions in an Excel/11. COLUMN Function.mp410.3MB
27. Lookup and Reference Functions in an Excel/12. LOOKUP Function.mp450.22MB
27. Lookup and Reference Functions in an Excel/13. TRANSPOSE Function.mp428.49MB
27. Lookup and Reference Functions in an Excel/14. Home Work.mp43MB
28. Adding Line and Combination Charts in an Excel/1. Adding and Formatting Line Chart.mp430.74MB
28. Adding Line and Combination Charts in an Excel/2. Adding and Formatting Combination Chart.mp433.22MB
29. Text Functions in an Excel/1. BHATTEXT Function.mp411.38MB
29. Text Functions in an Excel/2. CHAR Function.mp413.49MB
29. Text Functions in an Excel/3. CLEAN Function.mp48.14MB
29. Text Functions in an Excel/4. CODE Function.mp47.51MB
29. Text Functions in an Excel/5. CONCAT Function.mp423.53MB
29. Text Functions in an Excel/6. DOLLAR Function.mp413.5MB
29. Text Functions in an Excel/7. EXACT Function.mp415.43MB
29. Text Functions in an Excel/8. FIND Function.mp424.1MB
29. Text Functions in an Excel/9. FIXED Function.mp416.74MB
29. Text Functions in an Excel/10. LEFT Function.mp416.62MB
29. Text Functions in an Excel/11. LEN Function.mp411.48MB
29. Text Functions in an Excel/12. LOWER Function.mp412.38MB
29. Text Functions in an Excel/13. MID Function.mp423.19MB
29. Text Functions in an Excel/14. NUMBERVALUE Function.mp417.69MB
29. Text Functions in an Excel/15. PROPER Function.mp48.23MB
29. Text Functions in an Excel/16. REPLACE Function.mp425.02MB
29. Text Functions in an Excel/17. REPT Function.mp425.21MB
29. Text Functions in an Excel/18. RIGHT Function.mp417.56MB
29. Text Functions in an Excel/19. SEARCH Function.mp424.29MB
29. Text Functions in an Excel/20. SUBSTITUTE Function.mp423.09MB
29. Text Functions in an Excel/21. T Function.mp410.19MB
29. Text Functions in an Excel/22. TEXT Function.mp425.34MB
29. Text Functions in an Excel/23. TEXTJOIN Function.mp421.52MB
29. Text Functions in an Excel/24. TRIM Function.mp410.67MB
29. Text Functions in an Excel/25. UNICHAR Function.mp47.42MB
29. Text Functions in an Excel/26. UNICODE Function.mp49.5MB
29. Text Functions in an Excel/27. UPPER Function.mp413.65MB
29. Text Functions in an Excel/28. VALUE Function.mp411.52MB
30. Math and Trigonometry Functions in an Excel/1. SUM Function.mp445.07MB
30. Math and Trigonometry Functions in an Excel/2. MOD Function.mp410.14MB
30. Math and Trigonometry Functions in an Excel/3. POWER Function.mp419.04MB
30. Math and Trigonometry Functions in an Excel/4. SUBTOTAL Function.mp450.82MB
30. Math and Trigonometry Functions in an Excel/5. SUMIF Function.mp458.64MB
30. Math and Trigonometry Functions in an Excel/6. SUMIFS Function.mp460.22MB
30. Math and Trigonometry Functions in an Excel/7. SUMPRODUCT Function.mp431.16MB
30. Math and Trigonometry Functions in an Excel/8. ROUND Function.mp438.12MB
30. Math and Trigonometry Functions in an Excel/9. ROUNDDOWN Function.mp415.69MB
30. Math and Trigonometry Functions in an Excel/10. ROUNDUP Function.mp414.51MB
30. Math and Trigonometry Functions in an Excel/11. CEILING.MATH Function.mp422.15MB
30. Math and Trigonometry Functions in an Excel/12. FLOOR.MATH Function.mp420.16MB
30. Math and Trigonometry Functions in an Excel/13. EVEN Function.mp410.33MB
30. Math and Trigonometry Functions in an Excel/14. ODD Function.mp410.34MB
30. Math and Trigonometry Functions in an Excel/15. INT Function.mp413.69MB
30. Math and Trigonometry Functions in an Excel/16. TRUNC Function.mp420.69MB
31. Statistical Functions in an Excel/1. AVERAGE Function.mp412.76MB
31. Statistical Functions in an Excel/2. AVERAGEIF Function.mp470.08MB
31. Statistical Functions in an Excel/3. AVERAGEIFS Function.mp482.57MB
31. Statistical Functions in an Excel/4. COUNT and COUNTA Function.mp430.96MB
31. Statistical Functions in an Excel/5. COUNTBLANK Function.mp418.5MB
31. Statistical Functions in an Excel/6. COUNTIF Function.mp455.47MB
31. Statistical Functions in an Excel/7. COUNTIFS Function.mp461.71MB
31. Statistical Functions in an Excel/8. LARGE Function.mp429.68MB
31. Statistical Functions in an Excel/9. SMALL Function.mp428.98MB
31. Statistical Functions in an Excel/10. MAX and MIN Function.mp420MB
31. Statistical Functions in an Excel/11. MEDIAN Function.mp420.39MB
31. Statistical Functions in an Excel/12. MODE.MULT Function.mp423.07MB
31. Statistical Functions in an Excel/13. MODE.SNGL Function.mp419.42MB
32. Engineering Functions in an Excel/1. BIN2DEC Function.mp417.98MB
32. Engineering Functions in an Excel/2. BIN2HEX Function.mp421.34MB
32. Engineering Functions in an Excel/3. BIN2OCT Function.mp419.69MB
32. Engineering Functions in an Excel/4. COMPLEX Function.mp422.06MB
32. Engineering Functions in an Excel/5. CONVERT Function.mp429.45MB
32. Engineering Functions in an Excel/6. DEC2BIN Function.mp417.09MB
32. Engineering Functions in an Excel/7. DEC2HEX Function.mp412.01MB
32. Engineering Functions in an Excel/8. DEC2OCT Function.mp411.31MB
33. Information Functions in an Excel/1. CELL Function.mp461.12MB
33. Information Functions in an Excel/2. ERROR.TYPE Function.mp411.98MB
33. Information Functions in an Excel/3. INFO Function.mp418.41MB
33. Information Functions in an Excel/4. ISBLANK Function.mp424.79MB
33. Information Functions in an Excel/5. ISERR Function.mp411.32MB
33. Information Functions in an Excel/6. ISERROR Function.mp422.67MB
33. Information Functions in an Excel/7. ISEVEN Function.mp416.58MB
33. Information Functions in an Excel/8. ISFORMULA Function.mp417.61MB
33. Information Functions in an Excel/9. ISLOGICAL Function.mp419.36MB
33. Information Functions in an Excel/10. ISNA Function.mp418.33MB
33. Information Functions in an Excel/11. ISNONTEXT Function.mp418.13MB
33. Information Functions in an Excel/12. ISNUMBER Function.mp416.12MB
33. Information Functions in an Excel/13. ISODD Function.mp418.38MB
33. Information Functions in an Excel/14. ISREF Function.mp418.23MB
33. Information Functions in an Excel/15. ISTEXT Function.mp418.29MB
33. Information Functions in an Excel/16. N Function.mp420.1MB
33. Information Functions in an Excel/17. NA Function.mp418.31MB
33. Information Functions in an Excel/18. SHEET Function.mp418.36MB
33. Information Functions in an Excel/19. SHEETS Function.mp415.69MB
33. Information Functions in an Excel/20. TYPE Function.mp425.47MB
34. Database Functions in an Excel/1. DAVERAGE Function.mp440.98MB
34. Database Functions in an Excel/2. DSUM Function.mp425.87MB
34. Database Functions in an Excel/3. DMAX and DMIN Functions.mp439.1MB
34. Database Functions in an Excel/4. DCOUNTA Function.mp438.9MB
35. Financial FunctionsBorrow Money to Bank/1. Calculating a Quarterly Payment of Loan by using the PMT Function.mp452.23MB
35. Financial FunctionsBorrow Money to Bank/2. Calculating a Future Value of Loan by using the FV Function.mp442.12MB
35. Financial FunctionsBorrow Money to Bank/3. Calculating a Payment Period of Loan by using the NPER Function.mp430.42MB
35. Financial FunctionsBorrow Money to Bank/4. Calculating a Present Value of Loan by using the PV Function.mp435.4MB
35. Financial FunctionsBorrow Money to Bank/5. Calculating an Interest Rate of Loan by using the RATE Function.mp431.78MB
35. Financial FunctionsBorrow Money to Bank/6. Positive Cash Flow and Negative Cash Flow.mp420.7MB
35. Financial FunctionsBorrow Money to Bank/7. Calculating the Value of Inflation by Using FV Function.mp422.35MB
35. Financial FunctionsBorrow Money to Bank/8. Calculating a Monthly Car Payment.mp428.84MB
35. Financial FunctionsBorrow Money to Bank/9. Calculating the Interest Payment by using IPMT Function.mp440.02MB
35. Financial FunctionsBorrow Money to Bank/10. Calculating the Principal Payment by using PPMT Function.mp426.33MB
35. Financial FunctionsBorrow Money to Bank/11. Calculating Remaining Principal Amount and Total Payment.mp430.91MB
35. Financial FunctionsBorrow Money to Bank/12. Completing the Amortization Schedule of Loan.mp452.23MB
35. Financial FunctionsBorrow Money to Bank/13. Plotting Interest and Principal Payments.mp436MB
35. Financial FunctionsBorrow Money to Bank/14. Calculating Cumulative Interest Payments by Using CUMIPMT Function.mp440.67MB
35. Financial FunctionsBorrow Money to Bank/15. Calculating Cumulative Principal Payments by Using CUMPRINC Function.mp448.66MB
35. Financial FunctionsBorrow Money to Bank/16. Calculating Remaining Principal,Total Interest and Total Principal Payments.mp458.91MB
35. Financial FunctionsBorrow Money to Bank/17. Calculating Total Loan Amount.mp448.39MB
36. Financial FunctionsInvest Money in the Bank Saving Account/1. Calculating the Compound Interest.mp437.39MB
36. Financial FunctionsInvest Money in the Bank Saving Account/2. Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions.mp440.57MB
36. Financial FunctionsInvest Money in the Bank Saving Account/3. Calculating the Future Value of an Investment by Monthly and Initial Deposits.mp446.82MB
36. Financial FunctionsInvest Money in the Bank Saving Account/4. Calculating the Interest Rate of an Investment.mp446.14MB
36. Financial FunctionsInvest Money in the Bank Saving Account/5. Calculating the Total Number of Deposits of an Investment.mp446.24MB
36. Financial FunctionsInvest Money in the Bank Saving Account/6. Calculating the Initial Deposit or Present Value of an investment.mp437.58MB
36. Financial FunctionsInvest Money in the Bank Saving Account/7. Calculating the Value of Deposit Per Month.mp434.12MB
36. Financial FunctionsInvest Money in the Bank Saving Account/8. Calculating the Variable Interest Rates by using FVSCHEDULE Function.mp430.12MB
36. Financial FunctionsInvest Money in the Bank Saving Account/9. Amortization Schedule of an Investment 1.mp442.95MB
36. Financial FunctionsInvest Money in the Bank Saving Account/10. Amortization Schedule of an Investment 2.mp447.89MB
37. Financial FunctiomsBuild Future Income Statement of Company/1. Introduction to Income Statement Worksheet.mp415.45MB
37. Financial FunctiomsBuild Future Income Statement of Company/2. Linear and Growth Trend Values.mp414.95MB
37. Financial FunctiomsBuild Future Income Statement of Company/3. Projecting Future Value of Sales or Revenue by using Linear Trend Option.mp435.02MB
37. Financial FunctiomsBuild Future Income Statement of Company/4. Projecting Future Value of Sales or Revenue by Inserting a Growth Trend.mp435.44MB
37. Financial FunctiomsBuild Future Income Statement of Company/5. Calculating the Cost of Research and Development.mp424.89MB
37. Financial FunctiomsBuild Future Income Statement of Company/6. Calculating the Cost of Sales and Marketing.mp427.12MB
37. Financial FunctiomsBuild Future Income Statement of Company/7. Calculating the Gross Profit.mp427.59MB
37. Financial FunctiomsBuild Future Income Statement of Company/8. Calculating the Expenses of Company Part 1.mp428.97MB
37. Financial FunctiomsBuild Future Income Statement of Company/9. Calculating the Expenses of Company Part 2.mp439.13MB
37. Financial FunctiomsBuild Future Income Statement of Company/10. Calculating the Expenses of Company Part 3.mp443.69MB
37. Financial FunctiomsBuild Future Income Statement of Company/11. Calculating the Total General Expenses and Initial Earnings.mp442.1MB
37. Financial FunctiomsBuild Future Income Statement of Company/12. Adding Depreciation of an Asset in the Income Statement.mp429.85MB
37. Financial FunctiomsBuild Future Income Statement of Company/13. Calculating Operating Profit in the Income Statement.mp425.96MB
37. Financial FunctiomsBuild Future Income Statement of Company/14. Adding Interest Expenses in the Income Statement.mp440.88MB
37. Financial FunctiomsBuild Future Income Statement of Company/15. Calculating Profit Without Adding Tax.mp420.75MB
37. Financial FunctiomsBuild Future Income Statement of Company/16. Adding Taxes in the Income Statement.mp441.54MB
37. Financial FunctiomsBuild Future Income Statement of Company/17. Calculating Final Profit of the Company in the Income Statement.mp431.41MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/1. Straight Line Depreciation of an Asset Part 1.mp421.75MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/2. Straight Line Depreciation of an Asset Part 2.mp429.64MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/3. Straight Line Depreciation of an Asset Part 3.mp425.74MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/4. Declining Balance Depreciation of an Asset Part 1.mp428.81MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/5. Declining Balance Depreciation of an Asset Part 2.mp444.58MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/6. Calculating Depreciation of an asset by Using SYD Function.mp438.1MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/7. Calculating Depreciation of an asset by Using DDB Function.mp434.28MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/8. Calculating Depreciation of an asset by Using VDB Function.mp444.01MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/9. Calculating Depreciation Value of a Car.mp419.43MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/10. Selecting Method of Depreciation to Calculate Depreciation of an Asset.mp426.7MB
39. Financial FunctionsInvest Money in Company/1. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1.mp414.28MB
39. Financial FunctionsInvest Money in Company/2. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2.mp422.34MB
39. Financial FunctionsInvest Money in Company/3. Calculating Payback Period of an Investment Part 1.mp430.71MB
39. Financial FunctionsInvest Money in Company/4. Calculating Payback Period of an Investment Part 2.mp425.61MB
39. Financial FunctionsInvest Money in Company/5. Calculating Payback Period of an Investment Part 3.mp426.08MB
39. Financial FunctionsInvest Money in Company/6. Calculate Present Value of an Invetment by Using NPV Function Part 1.mp428.95MB
39. Financial FunctionsInvest Money in Company/7. Calculate Present Value of an Invetment by Using NPV Function Part 2.mp422.7MB
39. Financial FunctionsInvest Money in Company/8. Calculate Net Present Value of an Invetment.mp418.01MB
39. Financial FunctionsInvest Money in Company/9. Calculate Internal Rate of Return of an Invetment by Using IRR Function.mp418.39MB
39. Financial FunctionsInvest Money in Company/10. Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons.mp434.06MB
39. Financial FunctionsInvest Money in Company/11. Calculate Equivalent Value of Interest Rate by Using RRI Function.mp419.7MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/1. Calculating the Remaining Amount with 30% Rate.mp422.34MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/2. Calculating the Remaining Amount with 15% and 40% Rate.mp431.93MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/3. Calculating the Percentage of Remaining Amount.mp430.41MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/4. Calculating the Percentage of Savings.mp427.97MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/5. Finding the Value of Actual Amount.mp429.66MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/6. Calculating the Value of Expense,Save and Total Amount.mp437.91MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/7. Calculating the Remaining Profit.mp426.54MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/8. Calculating the Values of Profit and Percentage of Profit.mp424.46MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/9. Calculating the Values of Loss and Percentage of Loss.mp437.92MB