Microsoft Excel 2019 Office 365 Learn Basic to Advanced | 9611D72CACCF62535112F28CDF86F1C814BC8EAC

Microsoft Excel 2019 Office 365 Learn Basic to Advanced

Name	Microsoft Excel 2019 Office 365- Learn Basic to Advanced	DOWNLOAD Copy Link
Total Size	10.6 GB
Total Files	820
Hash	9611D72CACCF62535112F28CDF86F1C814BC8EAC

/12. Extracting Data from the Website(Power Query,Pivot Table)/
2. Combining Queries.mp4	91.2 MB
1. Extracting and Transforming User Rating Data from the Website.mp4	63.5 MB
1. Extracting and Transforming User Rating Data from the Website.vtt	5.9 KB
2. Combining Queries.vtt	6.5 KB
/1. Introduction/
1. Course Files.vtt	0.7 KB
1. Course Files.mp4	6.0 MB
/2. Creating Excel Tables,PivotTables and PivotCharts/
1. Freezing Header or Row.mp4	17.2 MB
1. Freezing Header or Row.vtt	1.3 KB
1.1 Section-9-Creating-excel-tables-and-pivottables-and-pivotcharts.xlsx.xlsx	14.2 KB
2. Converting Data in an Excel Table.mp4	23.9 MB
2. Converting Data in an Excel Table.vtt	1.8 KB
3. Adding Records in an Excel Table.mp4	43.8 MB
3. Adding Records in an Excel Table.vtt	2.3 KB
4. Renaming and Finding Records in an Excel Table.mp4	30.0 MB
4. Renaming and Finding Records in an Excel Table.vtt	1.9 KB
5. Editing and Deleting Records in an Excel Table.mp4	27.3 MB
5. Editing and Deleting Records in an Excel Table.vtt	1.8 KB
6. Remove Duplicates.mp4	28.3 MB
6. Remove Duplicates.vtt	1.7 KB
7. Sorting Date Column in an Excel Table.mp4	20.5 MB
7. Sorting Date Column in an Excel Table.vtt	1.5 KB
8. Sorting Multiple Columns.mp4	23.1 MB
8. Sorting Multiple Columns.vtt	1.6 KB
9. Filtering Data in an Excel Worksheet and Deleting an Excel Table.mp4	36.2 MB
9. Filtering Data in an Excel Worksheet and Deleting an Excel Table.vtt	2.5 KB
10. Filtering Data by Creating Criteria.mp4	32.4 MB
10. Filtering Data by Creating Criteria.vtt	1.9 KB
11. Filtering Data in an Excel Table by Using Slicer.mp4	24.5 MB
11. Filtering Data in an Excel Table by Using Slicer.vtt	1.5 KB
12. Splitting the Worksheet into Panes.mp4	32.1 MB
12. Splitting the Worksheet into Panes.vtt	1.6 KB
13. Calculating Records in an Excel Table.mp4	25.9 MB
13. Calculating Records in an Excel Table.vtt	2.1 KB
14. Inserting Subtotals.mp4	37.7 MB
14. Inserting Subtotals.vtt	2.2 KB
15. Creating and Adding Data in a Pivot Table.mp4	36.4 MB
15. Creating and Adding Data in a Pivot Table.vtt	3.2 KB
16. Filtering Data in a Pivot Table.mp4	27.7 MB
16. Filtering Data in a Pivot Table.vtt	2.2 KB
17. Adding Pivot Chart in a Pivot Table.mp4	20.0 MB
17. Adding Pivot Chart in a Pivot Table.vtt	1.6 KB
18. Home Work.mp4	7.0 MB
18. Home Work.vtt	0.6 KB
18.1 Section-9-Home-Work-Workbook.xlsx.xlsx	11.6 KB
18.2 Section-9-Answer-Home-Work-Workbook.xlsx.xlsx	24.2 KB
/3. Analyzing Sales Data in Pivot Tables and Pivot Charts/
1. Adding Data in Excel Table.mp4	23.0 MB
1. Adding Data in Excel Table.vtt	1.9 KB
1.1 Excel Dashboard.xlsx.xlsx	72.1 KB
1.2 Excel Dashboard - Copy.xlsx.xlsx	11.3 KB
2. Adding and Formatting First Chart in Pivot Table.mp4	37.0 MB
2. Adding and Formatting First Chart in Pivot Table.vtt	2.5 KB
3. Adding and Formatting Second Chart in Pivot Table.mp4	31.4 MB
3. Adding and Formatting Second Chart in Pivot Table.vtt	1.9 KB
4. Adding and Formatting Third Chart in Pivot Table.mp4	30.9 MB
4. Adding and Formatting Third Chart in Pivot Table.vtt	3.1 KB
5. Adding and Formatting Fourth Chart in Pivot Table.mp4	32.0 MB
5. Adding and Formatting Fourth Chart in Pivot Table.vtt	2.3 KB
6. Adding and Formatting Fifth Chart in Pivot Table.mp4	29.8 MB
6. Adding and Formatting Fifth Chart in Pivot Table.vtt	2.0 KB
7. Adding and Formatting Sixth Chart in Pivot Table.mp4	22.8 MB
7. Adding and Formatting Sixth Chart in Pivot Table.vtt	2.0 KB
8. Adding Chart in Excel Dashboard.mp4	24.5 MB
8. Adding Chart in Excel Dashboard.vtt	1.9 KB
9. Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box.mp4	29.5 MB
9. Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box.vtt	1.6 KB
10. Inserting Slicers in the Dashboard for Analyzing Sales Data.mp4	40.0 MB
10. Inserting Slicers in the Dashboard for Analyzing Sales Data.vtt	2.5 KB
/4. Data Validation and Inserting Comments/
1. Specifying a Validation Rule by Using List.mp4	42.2 MB
1. Specifying a Validation Rule by Using List.vtt	2.8 KB
1.1 Section-11-Data-validation-and-inserting-comments.xlsx.xlsx	10.5 KB
2. Show an Input Message on an Active Cell.mp4	31.2 MB
2. Show an Input Message on an Active Cell.vtt	2.2 KB
3. Displaying Error Alert Message.mp4	30.6 MB
3. Displaying Error Alert Message.vtt	2.3 KB
4. Circle Invalid Data.mp4	8.0 MB
4. Circle Invalid Data.vtt	0.9 KB
5. Inserting Comments in a Worksheet.mp4	19.7 MB
5. Inserting Comments in a Worksheet.vtt	1.9 KB
6. Home Work.mp4	5.2 MB
6. Home Work.vtt	0.6 KB
6.1 Section-11-Home-Work-Workbook.xlsx.xlsx	12.0 KB
6.2 Section-11-Answer-Home-Work-Workbook.xlsx.xlsx	13.3 KB
/5. Analyzing Data in the Table/
1. Introducing and Converting a Range to a Table.mp4	35.9 MB
1. Introducing and Converting a Range to a Table.vtt	2.1 KB
1.1 Excel-Table.xlsx.xlsx	32.8 KB
2. Sorting a Table using Different Methods.mp4	40.5 MB
2. Sorting a Table using Different Methods.vtt	2.6 KB
3. Filtering a Table using Different Methods.mp4	57.1 MB
3. Filtering a Table using Different Methods.vtt	4.6 KB
4. Analyzing Basic Table Operations.mp4	64.4 MB
4. Analyzing Basic Table Operations.vtt	3.9 KB
5. Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions.mp4	72.2 MB
5. Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions.vtt	4.6 KB
/6. Analyzing Data with PivotTables/
1. Introducing PivotTables.mp4	19.9 MB
1. Introducing PivotTables.vtt	1.7 KB
1.1 Excel-Table 1.xlsx.xlsx	32.8 KB
2. Creating PivotTable.mp4	42.7 MB
2. Creating PivotTable.vtt	3.7 KB
3. Inserting Subtotals In the PivotTable.mp4	32.9 MB
3. Inserting Subtotals In the PivotTable.vtt	2.5 KB
4. Summarizes Value Field by Changing Functions.mp4	18.4 MB
4. Summarizes Value Field by Changing Functions.vtt	1.7 KB
5. Adding PivotChart and Slicer in the PivotTable.mp4	31.5 MB
5. Adding PivotChart and Slicer in the PivotTable.vtt	2.4 KB
/7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/
1. Introducing Power Query and Upload CSV File.mp4	19.3 MB
1. Introducing Power Query and Upload CSV File.vtt	2.8 KB
1.1 Stores-Detail.csv.csv	10.2 KB
1.2 Monthly-Revenue.csv.csv	6.2 KB
1.3 Products-Purchased.csv.csv	7.1 KB
1.4 Business-History.csv.csv	0.9 KB
1.5 Customers-Order-Detail.csv.csv	18.6 KB
2. Retrieving Power Query Data into an Excel Table and Editing a Query Data.mp4	37.4 MB
2. Retrieving Power Query Data into an Excel Table and Editing a Query Data.vtt	3.5 KB
3. Adding a New Column and Grouping Values in a Power Query Data.mp4	43.4 MB
3. Adding a New Column and Grouping Values in a Power Query Data.vtt	4.3 KB
4. Analyzing Revenue Data by Adding Trendlines in the Chart.mp4	41.6 MB
4. Analyzing Revenue Data by Adding Trendlines in the Chart.vtt	3.4 KB
/8. Analyzing Data with Business Intelligence (Forecast Sheet)/
1. Analyzing Revenue Data by Creating a Forecast Sheet.mp4	51.1 MB
1. Analyzing Revenue Data by Creating a Forecast Sheet.vtt	4.3 KB
/9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/
1. Introducing Database and Upload Access Database File.mp4	21.6 MB
1. Introducing Database and Upload Access Database File.vtt	3.0 KB
1.1 Access Database File.html	0.1 KB
2. Creating the Data Model.mp4	28.5 MB
2. Creating the Data Model.vtt	3.1 KB
3. Transferring Data in the Power Pivot.mp4	30.3 MB
3. Transferring Data in the Power Pivot.vtt	2.7 KB
4. Exploring the Data Model in the Diagram View.mp4	12.1 MB
4. Exploring the Data Model in the Diagram View.vtt	1.4 KB
5. Managing Table Relationships in the Power Pivot.mp4	19.0 MB
5. Managing Table Relationships in the Power Pivot.vtt	3.2 KB
6. Creating a PivotTable from the Data Model.mp4	36.3 MB
6. Creating a PivotTable from the Data Model.vtt	4.1 KB
7. Adding a Timeline Slicer in the PivotTable.mp4	17.4 MB
7. Adding a Timeline Slicer in the PivotTable.vtt	2.0 KB
8. Drilling down into the Data in the PivotTable.mp4	27.0 MB
8. Drilling down into the Data in the PivotTable.vtt	2.9 KB
9. Visualizing Stores Sale Data with Power Map.mp4	62.4 MB
9. Visualizing Stores Sale Data with Power Map.vtt	4.5 KB
/10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/
1. Importing Population and Area Data from the Website and Creating Queries.mp4	44.3 MB
1. Importing Population and Area Data from the Website and Creating Queries.vtt	3.6 KB
2. Extracting Population and Area Data into PivotTable.mp4	54.2 MB
2. Extracting Population and Area Data into PivotTable.vtt	4.6 KB
3. Merging Two Queries into One query.mp4	46.1 MB
3. Merging Two Queries into One query.vtt	5.1 KB
/11. Loading Website Data into Power Map(Power Query,Power Map)/
1. Loading Website Data into Power Map.mp4	79.8 MB
1. Loading Website Data into Power Map.vtt	4.8 KB
/13. Extracting Football Team Data from the Website(Power Query,Pivot Table)/
1. Extracting and Transforming Data from the Website.mp4	53.6 MB
1. Extracting and Transforming Data from the Website.vtt	4.7 KB
/14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/
1. Cost-Volume-Profit(CVP) Chart Analysis.mp4	20.5 MB
1. Cost-Volume-Profit(CVP) Chart Analysis.vtt	2.2 KB
1.1 what-if-analaysis.xlsx.xlsx	83.6 KB
2. Find the Break-Even Point by Using Goal Seek.mp4	31.7 MB
2. Find the Break-Even Point by Using Goal Seek.vtt	3.0 KB
3. Generate $30000 Net Income of Company by using Goal Seek Tool.mp4	10.2 MB
3. Generate $30000 Net Income of Company by using Goal Seek Tool.vtt	0.8 KB
4. Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume.mp4	38.7 MB
4. Creating One-Variable Data Table to Examine the Impact of Changing Sales Volume.vtt	3.7 KB
5. Completing the One-Variable Data Table.mp4	26.1 MB
5. Completing the One-Variable Data Table.vtt	2.0 KB
6. Creating the CVP Chart of the Data Table.mp4	30.8 MB
6. Creating the CVP Chart of the Data Table.vtt	2.1 KB
7. Viewing the Impact of Changing the Sales Price in the Data Table.mp4	30.2 MB
7. Viewing the Impact of Changing the Sales Price in the Data Table.vtt	2.0 KB
8. Creating the Two-Variable Data Table.mp4	57.8 MB
8. Creating the Two-Variable Data Table.vtt	3.8 KB
9. Create a Chart of the Two Variable Data Table.mp4	52.2 MB
9. Create a Chart of the Two Variable Data Table.vtt	3.1 KB
/15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/
1. Define Names for the Income Statement Values.mp4	23.0 MB
1. Define Names for the Income Statement Values.vtt	1.8 KB
1.1 Scenario-Manager.xlsx.xlsx	12.2 KB
2. Adding the Scenarios in the Scenario Manager.mp4	73.5 MB
2. Adding the Scenarios in the Scenario Manager.vtt	4.7 KB
3. View the Impact of the Reduced Operations Scenario.mp4	42.3 MB
3. View the Impact of the Reduced Operations Scenario.vtt	3.3 KB
4. Creating the Scenario Summary Report.mp4	23.9 MB
4. Creating the Scenario Summary Report.vtt	2.1 KB
5. Creating the Scenario PivotTable Report.mp4	56.5 MB
5. Creating the Scenario PivotTable Report.vtt	4.7 KB
/16. Analyzing Business Data with Solver/
1. Understand Solver with Simple Example.mp4	36.0 MB
1. Understand Solver with Simple Example.vtt	4.3 KB
1.1 Solver-Copy.xlsx.xlsx	13.3 KB
2. Introducing Product Mix and Find an Optimal Solution with Solver Part 1.mp4	51.0 MB
2. Introducing Product Mix and Find an Optimal Solution with Solver Part 1.vtt	3.7 KB
3. Introducing Product Mix and Find an Optimal Solution with Solver Part 2.mp4	65.9 MB
3. Introducing Product Mix and Find an Optimal Solution with Solver Part 2.vtt	4.6 KB
4. Creating a Solver Answer Report.mp4	21.5 MB
4. Creating a Solver Answer Report.vtt	2.0 KB
5. Saving and Loading Solver Model.mp4	20.8 MB
5. Saving and Loading Solver Model.vtt	1.8 KB
/17. Introduction to Excel/
1. Starting With Excel.mp4	10.3 MB
1. Starting With Excel.vtt	1.6 KB
1.1 Excel-shortcut-keys.pdf.pdf	95.1 KB
1.2 Section 1-Introduction to Excel.xlsx.xlsx	326.9 KB
1.3 Excel-shortcut-keys.xlsx.xlsx	11.2 KB
2. Excel Tabs,Groups and Commands.mp4	13.8 MB
2. Excel Tabs,Groups and Commands.vtt	1.9 KB
3. Excel Rows and Columns.mp4	17.3 MB
3. Excel Rows and Columns.vtt	2.9 KB
4. Changing the Size of Columns and Rows.mp4	19.6 MB
4. Changing the Size of Columns and Rows.vtt	1.4 KB
5. Entering Text and Numbers in Worksheet.mp4	21.4 MB
5. Entering Text and Numbers in Worksheet.vtt	2.2 KB
6. Wrap Text Inside the Cell.mp4	9.0 MB
6. Wrap Text Inside the Cell.vtt	0.6 KB
7. Edit Text Within a Cell.mp4	7.3 MB
7. Edit Text Within a Cell.vtt	0.4 KB
8. Merging and Formatting Cells in a Worksheet.mp4	22.3 MB
8. Merging and Formatting Cells in a Worksheet.vtt	1.6 KB
9. Formatting Header in a Worksheet.mp4	13.8 MB
9. Formatting Header in a Worksheet.vtt	0.9 KB
10. Adding Image in a Worksheet.mp4	22.0 MB
10. Adding Image in a Worksheet.vtt	1.3 KB
11. Formatting Date in Excel Worksheet.mp4	20.8 MB
11. Formatting Date in Excel Worksheet.vtt	1.1 KB
12. Working of Undo & Redo Commands in an Excel Worksheet.mp4	15.7 MB
12. Working of Undo & Redo Commands in an Excel Worksheet.vtt	0.9 KB
13. Home Work.mp4	9.8 MB
13. Home Work.vtt	0.6 KB
13.1 Section1-Home Work Workbook.xlsx.xlsx	12.7 KB
13.2 Section1-Answer Home Work Workbook.xlsx.xlsx	174.2 KB
14. Introduction to Excel Quiz.html	0.2 KB
/18. Calculations With Basic Formulas/
1. Introduction to Arithmetic Operators.mp4	9.3 MB
1. Introduction to Arithmetic Operators.vtt	1.5 KB
1.1 Section 2-Calculations with Basic Formulas.xlsx.xlsx	11.1 KB
2. Calculations with Arithmetic Operators.mp4	35.3 MB
2. Calculations with Arithmetic Operators.vtt	4.9 KB
3. Copy and Paste the Formula.mp4	9.8 MB
3. Copy and Paste the Formula.vtt	1.4 KB
4. Auto Complete Formula.mp4	8.1 MB
4. Auto Complete Formula.vtt	1.3 KB
5. Inserting and Deleting Columns and Rows.mp4	10.9 MB
5. Inserting and Deleting Columns and Rows.vtt	1.5 KB
6. Hide and Unhide Columns and Rows.mp4	7.8 MB
6. Hide and Unhide Columns and Rows.vtt	1.2 KB
7. Moving a Cell or Range by Drag and Drop Method.mp4	7.6 MB
7. Moving a Cell or Range by Drag and Drop Method.vtt	1.1 KB
8. Moving a Cell or Range by Cut and Paste Method.mp4	4.1 MB
8. Moving a Cell or Range by Cut and Paste Method.vtt	0.5 KB
9. Relative and Absolute Cell References.mp4	20.8 MB
9. Relative and Absolute Cell References.vtt	2.8 KB
10. Home Work.mp4	9.3 MB
10. Home Work.vtt	0.8 KB
10.1 Section2-Home Work Answer WorkBook.xlsx.xlsx	17.0 KB
10.2 Section2-Home Work Workbook.xlsx.xlsx	28.1 KB
11. Calculations With Basic Formulas Quiz.html	0.2 KB
/19. Calculations with Simple Excel Functions/
1. Introduction to Function Syntax.mp4	15.8 MB
1. Introduction to Function Syntax.vtt	2.0 KB
1.1 Section 3-Sales Data.xlsx.xlsx	13.1 KB
2. Calculating Total Sales by Using SUM Function.mp4	32.2 MB
2. Calculating Total Sales by Using SUM Function.vtt	2.6 KB
3. Calculating Total Sales Quantities by Using SUM Function.mp4	16.0 MB
3. Calculating Total Sales Quantities by Using SUM Function.vtt	1.2 KB
4. Count Price Items by Using COUNT Function.mp4	17.4 MB
4. Count Price Items by Using COUNT Function.vtt	1.5 KB
5. Count Food Items by Using COUNTA Function.mp4	18.6 MB
5. Count Food Items by Using COUNTA Function.vtt	1.3 KB
6. Calculating Average Sales by Using AVERAGE Function.mp4	25.2 MB
6. Calculating Average Sales by Using AVERAGE Function.vtt	2.0 KB
7. Calculating Maximum Sales Value of Customer by Using MAX Function.mp4	18.7 MB
7. Calculating Maximum Sales Value of Customer by Using MAX Function.vtt	1.1 KB
8. Calculating Minimum Sales Value of Customer by Using MIN Function.mp4	18.9 MB
8. Calculating Minimum Sales Value of Customer by Using MIN Function.vtt	1.2 KB
9. Calculating Total Price of Products by Using PRODUCT Function.mp4	23.5 MB
9. Calculating Total Price of Products by Using PRODUCT Function.vtt	1.8 KB
10. Calculating Sales Data by Using Auto FUNCTION Button.mp4	23.5 MB
10. Calculating Sales Data by Using Auto FUNCTION Button.vtt	1.2 KB
11. Calculating a Tax Rate on Total Sales.mp4	30.7 MB
11. Calculating a Tax Rate on Total Sales.vtt	2.5 KB
12. Home Work.mp4	9.1 MB
12. Home Work.vtt	0.7 KB
12.1 Section 12-Answer Home Work Workbook.xlsx.xlsx	14.4 KB
12.2 Section 3-Home Work Workbook.xlsx.xlsx	31.5 KB
13. Calculations with Simple Excel Functions Quiz.html	0.2 KB
/20. Formatting a Worksheet/
1. Merging Two or More Cells into One Cell.mp4	16.0 MB
1. Merging Two or More Cells into One Cell.vtt	1.4 KB
1.1 Section 4-Formatting Workbook.xlsx.xlsx	21.0 KB
2. Alignment of Cell Text.mp4	16.5 MB
2. Alignment of Cell Text.vtt	1.6 KB
3. Splitting Text into Multiple Lines.mp4	16.2 MB
3. Splitting Text into Multiple Lines.vtt	1.5 KB
4. Rotating a Cell Text or Numbers.mp4	11.7 MB
4. Rotating a Cell Text or Numbers.vtt	1.1 KB
5. Formatting Background Color of Text and Numbers.mp4	24.9 MB
5. Formatting Background Color of Text and Numbers.vtt	1.9 KB
6. Formatting Font Size and Font Color.mp4	19.0 MB
6. Formatting Font Size and Font Color.vtt	1.8 KB
7. Adding Border into Cells.mp4	13.7 MB
7. Adding Border into Cells.vtt	1.1 KB
8. Formatting Cell Styles.mp4	20.0 MB
8. Formatting Cell Styles.vtt	1.5 KB
9. Find and Replace Text in a Worksheet.mp4	24.1 MB
9. Find and Replace Text in a Worksheet.vtt	1.9 KB
10. Calculating Students Enrollment and Difference Between two Columns Values.mp4	35.8 MB
10. Calculating Students Enrollment and Difference Between two Columns Values.vtt	3.1 KB
11. Calculating Percentage Difference Between two Columns Values.mp4	26.5 MB
11. Calculating Percentage Difference Between two Columns Values.vtt	1.9 KB
12. Conditionally Formatting Cells in a Worksheet.mp4	28.4 MB
12. Conditionally Formatting Cells in a Worksheet.vtt	2.0 KB
13. Conditionally Formatting Cells with a Top and Bottom Rules.mp4	17.1 MB
13. Conditionally Formatting Cells with a Top and Bottom Rules.vtt	1.1 KB
14. Home Work.mp4	5.8 MB
14. Home Work.vtt	0.5 KB
14.1 Section 4-Home Work Answer Workbook.xlsx.xlsx	12.7 KB
14.2 Section 4-Home Work Workbook.xlsx.xlsx	14.1 KB
15. Formatting a Worksheet Quiz.html	0.2 KB
/21. Saving and Printing a Workbook/
1. Saving a Workbook.mp4	7.8 MB
1. Saving a Workbook.vtt	0.8 KB
1.1 Section 5-Formatting Workbook.xlsx.xlsx	12.6 KB
2. Worksheet Views,Page Orientation and Scaling.mp4	32.4 MB
2. Worksheet Views,Page Orientation and Scaling.vtt	2.6 KB
3. Setting Margins in a Print Page.mp4	10.4 MB
3. Setting Margins in a Print Page.vtt	1.2 KB
4. Adding Header and Footer in a Print Page.mp4	34.2 MB
4. Adding Header and Footer in a Print Page.vtt	2.6 KB
5. Print Preview and Selecting Print Area.mp4	21.9 MB
5. Print Preview and Selecting Print Area.vtt	2.5 KB
6. Setting Scaling and Margins in a Print Page(Document 1).mp4	35.9 MB
6. Setting Scaling and Margins in a Print Page(Document 1).vtt	1.9 KB
6.1 Logical-Functions.xlsx.xlsx	19.8 KB
7. Saving and Printing a Workbook Quiz.html	0.2 KB
/22. Project Calculations with Operators and Functions/
1. Calculating the Area of Field and Plots.mp4	38.2 MB
1. Calculating the Area of Field and Plots.vtt	2.5 KB
1.1 Section 6-Vegetables Field.xlsx.xlsx	222.0 KB
2. Calculating the Grown and Empty Area of Vegetables Field.mp4	18.8 MB
2. Calculating the Grown and Empty Area of Vegetables Field.vtt	1.5 KB
3. Calculating the Percentage of Grown and Empty area in Vegetables Field.mp4	16.7 MB
3. Calculating the Percentage of Grown and Empty area in Vegetables Field.vtt	1.9 KB
4. Calculating Cost of Sales and Weightages of Vegetables.mp4	38.0 MB
4. Calculating Cost of Sales and Weightages of Vegetables.vtt	2.8 KB
5. Calculating Profit and Percentage of Profit from Vegetables.mp4	29.9 MB
5. Calculating Profit and Percentage of Profit from Vegetables.vtt	3.0 KB
6. Calculating Revenue by Using Sum,Max,Min,Average and Median Functions.mp4	50.6 MB
6. Calculating Revenue by Using Sum,Max,Min,Average and Median Functions.vtt	3.4 KB
7. Introduction to NESTED Function.mp4	15.2 MB
7. Introduction to NESTED Function.vtt	1.4 KB
8. Nesting the SUM and MEDIAN Functions within ROUND Function.mp4	18.5 MB
8. Nesting the SUM and MEDIAN Functions within ROUND Function.vtt	1.3 KB
9. Home Work.mp4	9.7 MB
9. Home Work.vtt	0.8 KB
9.1 Setion-6-Answer-Home-Work-Workbook.xlsx.xlsx	218.7 KB
9.2 Setion-6-Home-Work-Workbook.xlsx.xlsx	221.6 KB
10. Project Calculations with Operators and Functions Quiz.html	0.2 KB
/23. IF and VLOOKUP Functions/
1. Introduction to IF Function and Apply Weather Condition on IF Function.mp4	32.9 MB
1. Introduction to IF Function and Apply Weather Condition on IF Function.vtt	3.2 KB
1.1 Section-7-If-and-vlookup-Functions.xlsx.xlsx	20.6 KB
2. Apply Different Conditions on IF Function.mp4	66.6 MB
2. Apply Different Conditions on IF Function.vtt	5.3 KB
3. Introduction to VLOOKUP Function.mp4	28.8 MB
3. Introduction to VLOOKUP Function.vtt	2.5 KB
4. Apply VLOOKUP Function on Data Table.mp4	18.8 MB
4. Apply VLOOKUP Function on Data Table.vtt	1.3 KB
5. Retrieving Values from Data Table by Using VLOOKUP Function.mp4	18.9 MB
5. Retrieving Values from Data Table by Using VLOOKUP Function.vtt	1.5 KB
6. Errors in VLOOKUP Function.mp4	17.2 MB
6. Errors in VLOOKUP Function.vtt	1.8 KB
7. Home Work.mp4	6.0 MB
7. Home Work.vtt	0.7 KB
7.1 Section-7-Home-Work-Workbook.xlsx.xlsx	15.5 KB
7.2 Section-7-Answer-Home-Work-Workbook.xlsx.xlsx	12.9 KB
/24. Adding Column and Pie Charts in an Excel worksheet/
1. Embed Column Chart in a Worksheet.mp4	22.0 MB
1. Embed Column Chart in a Worksheet.vtt	2.3 KB
1.1 Section-8-Analyzing-data-with-a-chart.xlsx.xlsx	9.9 KB
2. Analyzing Data with a Column Chart.mp4	45.5 MB
2. Analyzing Data with a Column Chart.vtt	3.8 KB
3. Analyzing Data with a Pie Chart.mp4	32.4 MB
3. Analyzing Data with a Pie Chart.vtt	3.0 KB
4. Recommended Charts.mp4	28.3 MB
4. Recommended Charts.vtt	2.2 KB
5. Home Work.mp4	4.3 MB
5. Home Work.vtt	0.5 KB
5.1 Section-8-Home-Work-Workbook.xlsx.xlsx	13.7 KB
5.2 Section-8-Answer-Home-Work-Workbook.xlsx.xlsx	22.9 KB
/25. Date and Time Functions in an Excel/
1. NOW and TIME Functions.mp4	28.4 MB
1. NOW and TIME Functions.vtt	2.6 KB
1.1 Date-and-Time-Functions.xlsx.xlsx	31.2 KB
2. HOUR,MINUTE and SECOND Functions.mp4	20.9 MB
2. HOUR,MINUTE and SECOND Functions.vtt	2.5 KB
3. TODAY,DATE and DAYS Functions.mp4	25.6 MB
3. TODAY,DATE and DAYS Functions.vtt	2.9 KB
4. YEAR,MONTH and DAY Functions.mp4	29.5 MB
4. YEAR,MONTH and DAY Functions.vtt	3.0 KB
5. WEEKDAY Function.mp4	22.5 MB
5. WEEKDAY Function.vtt	1.9 KB
6. WEEKNUM Function.mp4	13.3 MB
6. WEEKNUM Function.vtt	1.4 KB
7. EDATE Function.mp4	18.0 MB
7. EDATE Function.vtt	1.8 KB
8. EOMONTH Function.mp4	23.0 MB
8. EOMONTH Function.vtt	2.2 KB
9. Determining Person's Birthday.mp4	15.5 MB
9. Determining Person's Birthday.vtt	1.3 KB
10. Calculating Age of Person.mp4	18.3 MB
10. Calculating Age of Person.vtt	1.6 KB
11. Formatting Date in a Cell.mp4	10.4 MB
11. Formatting Date in a Cell.vtt	1.2 KB
12. DATEVALUE Function.mp4	14.7 MB
12. DATEVALUE Function.vtt	1.5 KB
13. DAYS360 Function.mp4	13.4 MB
13. DAYS360 Function.vtt	1.5 KB
14. ISOWEEKNUM Function.mp4	10.4 MB
14. ISOWEEKNUM Function.vtt	1.2 KB
15. NETWORKDAYS Function.mp4	10.9 MB
15. NETWORKDAYS Function.vtt	1.1 KB
16. TIMEVALUE Function.mp4	13.2 MB
16. TIMEVALUE Function.vtt	1.5 KB
17. YEARFRAC Function.mp4	15.8 MB
17. YEARFRAC Function.vtt	2.0 KB
/26. Logical Functions in an Excel/
1. Calculating the Age of Employees and Length of Service.mp4	39.4 MB
1. Calculating the Age of Employees and Length of Service.vtt	2.2 KB
1.1 Logical-Functions-Copy.xlsx.xlsx	27.4 KB
2. Analyzing Data by Using IF Function.mp4	51.5 MB
2. Analyzing Data by Using IF Function.vtt	3.5 KB
3. Determining Birthday of Employees.mp4	32.9 MB
3. Determining Birthday of Employees.vtt	1.5 KB
4. Specifying Day of Birthdate by Nesting DAY Function Within IF Function.mp4	45.0 MB
4. Specifying Day of Birthdate by Nesting DAY Function Within IF Function.vtt	2.2 KB
5. Determining Employee Eligibility for Promotion by Using AND Function.mp4	53.3 MB
5. Determining Employee Eligibility for Promotion by Using AND Function.vtt	3.3 KB
6. Nesting the AND Function Within IF Function.mp4	53.6 MB
6. Nesting the AND Function Within IF Function.vtt	2.9 KB
7. Determining Employee Eligibility for Promotion by Using OR Function.mp4	42.7 MB
7. Determining Employee Eligibility for Promotion by Using OR Function.vtt	2.7 KB
8. Nesting the OR Function Within IF Function.mp4	59.9 MB
8. Nesting the OR Function Within IF Function.vtt	3.0 KB
9. IFERROR Function.mp4	21.3 MB
9. IFERROR Function.vtt	2.1 KB
10. IFNA Function.mp4	44.2 MB
10. IFNA Function.vtt	3.3 KB
11. FALSE Function.mp4	16.2 MB
11. FALSE Function.vtt	1.9 KB
12. IFS Function.mp4	52.3 MB
12. IFS Function.vtt	3.2 KB
13. NOT Function.mp4	21.8 MB
13. NOT Function.vtt	2.4 KB
14. SWITCH Function.mp4	28.9 MB
14. SWITCH Function.vtt	2.9 KB
15. TRUE Function.mp4	17.3 MB
15. TRUE Function.vtt	2.1 KB
16. XOR Function.mp4	19.0 MB
16. XOR Function.vtt	2.1 KB
17. Home Work.mp4	5.6 MB
17. Home Work.vtt	0.4 KB
17.1 Section-12-Home-Work-Workbook.xlsx.xlsx	15.5 KB
17.2 Section-12-Answer-Home-Work-Workbook.xlsx.xlsx	14.4 KB
/27. Lookup and Reference Functions in an Excel/
1. Extracting Value from Data Table by Using VLOOKUP Function.mp4	66.5 MB
1. Extracting Value from Data Table by Using VLOOKUP Function.vtt	5.1 KB
1.1 Lookup-and-Reference-Functions-Copy.xlsx.xlsx	29.5 KB
2. Extracting Value from Data Table by Using HLOOKUP Function.mp4	48.0 MB
2. Extracting Value from Data Table by Using HLOOKUP Function.vtt	3.6 KB
3. Calculating Discount and Total Price.mp4	16.0 MB
3. Calculating Discount and Total Price.vtt	1.5 KB
4. Calculating Tax Rate on Total Price Value.mp4	9.9 MB
4. Calculating Tax Rate on Total Price Value.vtt	1.0 KB
5. Extracting Value by Using CHOOSE Function.mp4	35.0 MB
5. Extracting Value by Using CHOOSE Function.vtt	2.5 KB
6. Nesting the CHOOSE Function Within Sum Function.mp4	37.4 MB
6. Nesting the CHOOSE Function Within Sum Function.vtt	2.7 KB
7. MATCH Function.mp4	24.9 MB
7. MATCH Function.vtt	2.3 KB
8. Extracting Value by Using INDEX Function.mp4	28.1 MB
8. Extracting Value by Using INDEX Function.vtt	2.2 KB
9. Nesting the MATCH Function Within an INDEX Function.mp4	29.7 MB
9. Nesting the MATCH Function Within an INDEX Function.vtt	2.0 KB
10. Nesting the VLOOKUP Function Within an IFERROR Function.mp4	35.8 MB
10. Nesting the VLOOKUP Function Within an IFERROR Function.vtt	2.7 KB
11. COLUMN Function.mp4	10.8 MB
11. COLUMN Function.vtt	1.3 KB
12. LOOKUP Function.mp4	52.7 MB
12. LOOKUP Function.vtt	4.3 KB
13. TRANSPOSE Function.mp4	29.9 MB
13. TRANSPOSE Function.vtt	2.3 KB
14. Home Work.mp4	3.2 MB
14. Home Work.vtt	0.3 KB
14.1 Section-14-Answer-Home-Work-Workbook.xlsx.xlsx	14.0 KB
14.2 Section-14-Home-Work-Workbook.xlsx.xlsx	14.3 KB
/28. Adding Line and Combination Charts in an Excel/
1. Adding and Formatting Line Chart.mp4	32.2 MB
1. Adding and Formatting Line Chart.vtt	2.2 KB
1.1 Adding-Line-and-Combination-Chart-in-an-Excel.xlsx.xlsx	26.5 KB
2. Adding and Formatting Combination Chart.mp4	34.8 MB
2. Adding and Formatting Combination Chart.vtt	2.8 KB
/29. Text Functions in an Excel/
1. BHATTEXT Function.mp4	11.9 MB
1. BHATTEXT Function.vtt	1.6 KB
1.1 Text-Functions-in-an-Excel-Copy.xlsx.xlsx	40.2 KB
2. CHAR Function.mp4	14.1 MB
2. CHAR Function.vtt	1.9 KB
3. CLEAN Function.mp4	8.5 MB
3. CLEAN Function.vtt	1.2 KB
4. CODE Function.mp4	7.9 MB
4. CODE Function.vtt	1.0 KB
5. CONCAT Function.mp4	24.7 MB
5. CONCAT Function.vtt	1.9 KB
6. DOLLAR Function.mp4	14.2 MB
6. DOLLAR Function.vtt	1.8 KB
7. EXACT Function.mp4	16.2 MB
7. EXACT Function.vtt	1.9 KB
8. FIND Function.mp4	25.3 MB
8. FIND Function.vtt	2.9 KB
9. FIXED Function.mp4	17.6 MB
9. FIXED Function.vtt	2.0 KB
10. LEFT Function.mp4	17.4 MB
10. LEFT Function.vtt	2.2 KB
11. LEN Function.mp4	12.0 MB
11. LEN Function.vtt	1.4 KB
12. LOWER Function.mp4	13.0 MB
12. LOWER Function.vtt	2.0 KB
13. MID Function.mp4	24.3 MB
13. MID Function.vtt	3.0 KB
14. NUMBERVALUE Function.mp4	18.6 MB
14. NUMBERVALUE Function.vtt	2.1 KB
15. PROPER Function.mp4	8.6 MB
15. PROPER Function.vtt	1.2 KB
16. REPLACE Function.mp4	26.2 MB
16. REPLACE Function.vtt	2.8 KB
17. REPT Function.mp4	26.4 MB
17. REPT Function.vtt	2.5 KB
18. RIGHT Function.mp4	18.4 MB
18. RIGHT Function.vtt	2.3 KB
19. SEARCH Function.mp4	25.5 MB
19. SEARCH Function.vtt	2.5 KB
20. SUBSTITUTE Function.mp4	24.2 MB
20. SUBSTITUTE Function.vtt	2.5 KB
21. T Function.mp4	10.7 MB
21. T Function.vtt	1.2 KB
22. TEXT Function.mp4	26.6 MB
22. TEXT Function.vtt	2.8 KB
23. TEXTJOIN Function.mp4	22.6 MB
23. TEXTJOIN Function.vtt	2.3 KB
24. TRIM Function.mp4	11.2 MB
24. TRIM Function.vtt	1.4 KB
25. UNICHAR Function.mp4	7.8 MB
25. UNICHAR Function.vtt	0.9 KB
26. UNICODE Function.mp4	10.0 MB
26. UNICODE Function.vtt	1.3 KB
27. UPPER Function.mp4	14.3 MB
27. UPPER Function.vtt	1.9 KB
28. VALUE Function.mp4	12.1 MB
28. VALUE Function.vtt	1.4 KB
/30. Math and Trigonometry Functions in an Excel/
1. SUM Function.mp4	47.3 MB
1. SUM Function.vtt	3.9 KB
1.1 Math-and-Trignometry-Functions-Copy.xlsx.xlsx	27.8 KB
2. MOD Function.mp4	10.6 MB
2. MOD Function.vtt	1.3 KB
3. POWER Function.mp4	20.0 MB
3. POWER Function.vtt	2.1 KB
4. SUBTOTAL Function.mp4	53.3 MB
4. SUBTOTAL Function.vtt	4.6 KB
5. SUMIF Function.mp4	61.5 MB
5. SUMIF Function.vtt	4.5 KB
6. SUMIFS Function.mp4	63.1 MB
6. SUMIFS Function.vtt	5.1 KB
7. SUMPRODUCT Function.mp4	32.7 MB
7. SUMPRODUCT Function.vtt	2.9 KB
8. ROUND Function.mp4	40.0 MB
8. ROUND Function.vtt	4.5 KB
9. ROUNDDOWN Function.mp4	16.5 MB
9. ROUNDDOWN Function.vtt	1.6 KB
10. ROUNDUP Function.mp4	15.2 MB
10. ROUNDUP Function.vtt	1.5 KB
11. CEILING.MATH Function.mp4	23.2 MB
11. CEILING.MATH Function.vtt	2.5 KB
12. FLOOR.MATH Function.mp4	21.1 MB
12. FLOOR.MATH Function.vtt	2.2 KB
13. EVEN Function.mp4	10.8 MB
13. EVEN Function.vtt	1.2 KB
14. ODD Function.mp4	10.8 MB
14. ODD Function.vtt	1.2 KB
15. INT Function.mp4	14.4 MB
15. INT Function.vtt	1.7 KB
16. TRUNC Function.mp4	21.7 MB
16. TRUNC Function.vtt	2.1 KB
/31. Statistical Functions in an Excel/
1. AVERAGE Function.mp4	13.4 MB
1. AVERAGE Function.vtt	1.3 KB
1.1 Statistical-Functions-Copy.xlsx.xlsx	23.4 KB
2. AVERAGEIF Function.mp4	73.5 MB
2. AVERAGEIF Function.vtt	5.0 KB
3. AVERAGEIFS Function.mp4	86.6 MB
3. AVERAGEIFS Function.vtt	5.9 KB
4. COUNT and COUNTA Function.mp4	32.5 MB
4. COUNT and COUNTA Function.vtt	3.7 KB
5. COUNTBLANK Function.mp4	19.4 MB
5. COUNTBLANK Function.vtt	1.9 KB
6. COUNTIF Function.mp4	58.2 MB
6. COUNTIF Function.vtt	4.2 KB
7. COUNTIFS Function.mp4	64.7 MB
7. COUNTIFS Function.vtt	4.9 KB
8. LARGE Function.mp4	31.1 MB
8. LARGE Function.vtt	2.5 KB
9. SMALL Function.mp4	30.4 MB
9. SMALL Function.vtt	2.7 KB
10. MAX and MIN Function.mp4	21.0 MB
10. MAX and MIN Function.vtt	2.1 KB
11. MEDIAN Function.mp4	21.4 MB
11. MEDIAN Function.vtt	1.8 KB
12. MODE.MULT Function.mp4	24.2 MB
12. MODE.MULT Function.vtt	2.6 KB
13. MODE.SNGL Function.mp4	20.4 MB
13. MODE.SNGL Function.vtt	1.9 KB
/32. Engineering Functions in an Excel/
1. BIN2DEC Function.mp4	18.9 MB
1. BIN2DEC Function.vtt	1.8 KB
1.1 Engineering-Functions-in-an-Excel-Copy-1.xlsx.xlsx	15.9 KB
2. BIN2HEX Function.mp4	22.4 MB
2. BIN2HEX Function.vtt	2.0 KB
3. BIN2OCT Function.mp4	20.6 MB
3. BIN2OCT Function.vtt	1.9 KB
4. COMPLEX Function.mp4	23.1 MB
4. COMPLEX Function.vtt	2.3 KB
5. CONVERT Function.mp4	30.9 MB
5. CONVERT Function.vtt	2.9 KB
6. DEC2BIN Function.mp4	17.9 MB
6. DEC2BIN Function.vtt	1.8 KB
7. DEC2HEX Function.mp4	12.6 MB
7. DEC2HEX Function.vtt	1.3 KB
8. DEC2OCT Function.mp4	11.9 MB
8. DEC2OCT Function.vtt	1.2 KB
/33. Information Functions in an Excel/
1. CELL Function.mp4	64.1 MB
1. CELL Function.vtt	4.7 KB
1.1 Information-Functions-in-an-excel-Copy.xlsx.xlsx	38.9 KB
2. ERROR.TYPE Function.mp4	12.6 MB
2. ERROR.TYPE Function.vtt	1.4 KB
3. INFO Function.mp4	19.3 MB
3. INFO Function.vtt	2.3 KB
4. ISBLANK Function.mp4	26.0 MB
4. ISBLANK Function.vtt	2.6 KB
5. ISERR Function.mp4	11.9 MB
5. ISERR Function.vtt	1.5 KB
6. ISERROR Function.mp4	23.8 MB
6. ISERROR Function.vtt	2.4 KB
7. ISEVEN Function.mp4	17.4 MB
7. ISEVEN Function.vtt	1.9 KB
8. ISFORMULA Function.mp4	18.5 MB
8. ISFORMULA Function.vtt	1.8 KB
9. ISLOGICAL Function.mp4	20.3 MB
9. ISLOGICAL Function.vtt	2.1 KB
10. ISNA Function.mp4	19.2 MB
10. ISNA Function.vtt	1.9 KB
11. ISNONTEXT Function.mp4	19.0 MB
11. ISNONTEXT Function.vtt	2.1 KB
12. ISNUMBER Function.mp4	16.9 MB
12. ISNUMBER Function.vtt	2.0 KB
13. ISODD Function.mp4	19.3 MB
13. ISODD Function.vtt	2.1 KB
14. ISREF Function.mp4	19.1 MB
14. ISREF Function.vtt	2.1 KB
15. ISTEXT Function.mp4	19.2 MB
15. ISTEXT Function.vtt	2.1 KB
16. N Function.mp4	21.1 MB
16. N Function.vtt	2.1 KB
17. NA Function.mp4	19.2 MB
17. NA Function.vtt	1.8 KB
18. SHEET Function.mp4	19.2 MB
18. SHEET Function.vtt	1.9 KB
19. SHEETS Function.mp4	16.4 MB
19. SHEETS Function.vtt	1.8 KB
20. TYPE Function.mp4	26.7 MB
20. TYPE Function.vtt	2.1 KB
/34. Database Functions in an Excel/
1. DAVERAGE Function.mp4	43.0 MB
1. DAVERAGE Function.vtt	3.2 KB
1.1 Database-Functions-Copy.xlsx.xlsx	14.0 KB
2. DSUM Function.mp4	27.1 MB
2. DSUM Function.vtt	1.6 KB
3. DMAX and DMIN Functions.mp4	41.0 MB
3. DMAX and DMIN Functions.vtt	2.7 KB
4. DCOUNTA Function.mp4	40.8 MB
4. DCOUNTA Function.vtt	2.6 KB
/35. Financial FunctionsBorrow Money to Bank/
1. Calculating a Quarterly Payment of Loan by using the PMT Function.mp4	54.8 MB
1. Calculating a Quarterly Payment of Loan by using the PMT Function.vtt	5.0 KB
1.1 Calculating-Loans-Costs-Copy.xlsx.xlsx	20.3 KB
1.2 Cumulative-interest-and-principal-payments-Copy.xlsx.xlsx	15.9 KB
1.3 IPMT-PPMT-and-Amortization-Copy.xlsx.xlsx	34.4 KB
2. Calculating a Future Value of Loan by using the FV Function.mp4	44.2 MB
2. Calculating a Future Value of Loan by using the FV Function.vtt	4.1 KB
3. Calculating a Payment Period of Loan by using the NPER Function.mp4	31.9 MB
3. Calculating a Payment Period of Loan by using the NPER Function.vtt	3.0 KB
4. Calculating a Present Value of Loan by using the PV Function.mp4	37.1 MB
4. Calculating a Present Value of Loan by using the PV Function.vtt	3.3 KB
5. Calculating an Interest Rate of Loan by using the RATE Function.mp4	33.3 MB
5. Calculating an Interest Rate of Loan by using the RATE Function.vtt	2.9 KB
6. Positive Cash Flow and Negative Cash Flow.mp4	21.7 MB
6. Positive Cash Flow and Negative Cash Flow.vtt	2.5 KB
7. Calculating the Value of Inflation by Using FV Function.mp4	23.4 MB
7. Calculating the Value of Inflation by Using FV Function.vtt	2.1 KB
8. Calculating a Monthly Car Payment.mp4	30.2 MB
8. Calculating a Monthly Car Payment.vtt	3.1 KB
9. Calculating the Interest Payment by using IPMT Function.mp4	42.0 MB
9. Calculating the Interest Payment by using IPMT Function.vtt	3.6 KB
10. Calculating the Principal Payment by using PPMT Function.mp4	27.6 MB
10. Calculating the Principal Payment by using PPMT Function.vtt	2.1 KB
11. Calculating Remaining Principal Amount and Total Payment.mp4	32.4 MB
11. Calculating Remaining Principal Amount and Total Payment.vtt	2.8 KB
12. Completing the Amortization Schedule of Loan.mp4	54.8 MB
12. Completing the Amortization Schedule of Loan.vtt	4.4 KB
13. Plotting Interest and Principal Payments.mp4	37.7 MB
13. Plotting Interest and Principal Payments.vtt	2.1 KB
14. Calculating Cumulative Interest Payments by Using CUMIPMT Function.mp4	42.6 MB
14. Calculating Cumulative Interest Payments by Using CUMIPMT Function.vtt	3.4 KB
15. Calculating Cumulative Principal Payments by Using CUMPRINC Function.mp4	51.0 MB
15. Calculating Cumulative Principal Payments by Using CUMPRINC Function.vtt	3.5 KB
16. Calculating Remaining Principal,Total Interest and Total Principal Payments.mp4	61.8 MB
16. Calculating Remaining Principal,Total Interest and Total Principal Payments.vtt	4.1 KB
17. Calculating Total Loan Amount.mp4	50.7 MB
17. Calculating Total Loan Amount.vtt	3.3 KB
/36. Financial FunctionsInvest Money in the Bank Saving Account/
1. Calculating the Compound Interest.mp4	39.2 MB
1. Calculating the Compound Interest.vtt	4.1 KB
1.1 -Calculating-Investments-Costs-FV-RATE-NPER-PV-PMT-Schedules-Copy.xlsx.xlsx	20.0 KB
1.2 -Calculating-Investments-Costs-Compound-Interest-Effective-Interest-Rate-and-Nominal-Interest-Rate-Copy.xlsx.xlsx	14.5 KB
2. Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions.mp4	42.5 MB
2. Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions.vtt	4.4 KB
3. Calculating the Future Value of an Investment by Monthly and Initial Deposits.mp4	49.1 MB
3. Calculating the Future Value of an Investment by Monthly and Initial Deposits.vtt	4.6 KB
4. Calculating the Interest Rate of an Investment.mp4	48.4 MB
4. Calculating the Interest Rate of an Investment.vtt	4.2 KB
5. Calculating the Total Number of Deposits of an Investment.mp4	48.5 MB
5. Calculating the Total Number of Deposits of an Investment.vtt	4.7 KB
6. Calculating the Initial Deposit or Present Value of an investment.mp4	39.4 MB
6. Calculating the Initial Deposit or Present Value of an investment.vtt	3.3 KB
7. Calculating the Value of Deposit Per Month.mp4	35.8 MB
7. Calculating the Value of Deposit Per Month.vtt	2.9 KB
8. Calculating the Variable Interest Rates by using FVSCHEDULE Function.mp4	31.6 MB
8. Calculating the Variable Interest Rates by using FVSCHEDULE Function.vtt	3.6 KB
9. Amortization Schedule of an Investment 1.mp4	45.0 MB
9. Amortization Schedule of an Investment 1.vtt	3.6 KB
10. Amortization Schedule of an Investment 2.mp4	50.2 MB
10. Amortization Schedule of an Investment 2.vtt	3.4 KB
/37. Financial FunctiomsBuild Future Income Statement of Company/
1. Introduction to Income Statement Worksheet.mp4	16.2 MB
1. Introduction to Income Statement Worksheet.vtt	1.7 KB
1.1 Income-Statement-and-depreciation-of-assets-Copy.xlsx.xlsx	25.7 KB
2. Linear and Growth Trend Values.mp4	15.7 MB
2. Linear and Growth Trend Values.vtt	1.5 KB
3. Projecting Future Value of Sales or Revenue by using Linear Trend Option.mp4	36.7 MB
3. Projecting Future Value of Sales or Revenue by using Linear Trend Option.vtt	3.7 KB
4. Projecting Future Value of Sales or Revenue by Inserting a Growth Trend.mp4	37.2 MB
4. Projecting Future Value of Sales or Revenue by Inserting a Growth Trend.vtt	3.4 KB
5. Calculating the Cost of Research and Development.mp4	26.1 MB
5. Calculating the Cost of Research and Development.vtt	2.5 KB
6. Calculating the Cost of Sales and Marketing.mp4	28.4 MB
6. Calculating the Cost of Sales and Marketing.vtt	2.6 KB
7. Calculating the Gross Profit.mp4	28.9 MB
7. Calculating the Gross Profit.vtt	2.3 KB
8. Calculating the Expenses of Company Part 1.mp4	30.4 MB
8. Calculating the Expenses of Company Part 1.vtt	2.3 KB
9. Calculating the Expenses of Company Part 2.mp4	41.0 MB
9. Calculating the Expenses of Company Part 2.vtt	2.9 KB
10. Calculating the Expenses of Company Part 3.mp4	45.8 MB
10. Calculating the Expenses of Company Part 3.vtt	3.3 KB
11. Calculating the Total General Expenses and Initial Earnings.mp4	44.1 MB
11. Calculating the Total General Expenses and Initial Earnings.vtt	2.8 KB
12. Adding Depreciation of an Asset in the Income Statement.mp4	31.3 MB
12. Adding Depreciation of an Asset in the Income Statement.vtt	2.3 KB
13. Calculating Operating Profit in the Income Statement.mp4	27.2 MB
13. Calculating Operating Profit in the Income Statement.vtt	2.0 KB
14. Adding Interest Expenses in the Income Statement.mp4	42.9 MB
14. Adding Interest Expenses in the Income Statement.vtt	2.8 KB
15. Calculating Profit Without Adding Tax.mp4	21.8 MB
15. Calculating Profit Without Adding Tax.vtt	1.4 KB
16. Adding Taxes in the Income Statement.mp4	43.6 MB
16. Adding Taxes in the Income Statement.vtt	2.9 KB
17. Calculating Final Profit of the Company in the Income Statement.mp4	32.9 MB
17. Calculating Final Profit of the Company in the Income Statement.vtt	2.1 KB
/38. Financial FunctionsCalculate Depreciation of an Asset of Company/
1. Straight Line Depreciation of an Asset Part 1.mp4	22.8 MB
1. Straight Line Depreciation of an Asset Part 1.vtt	2.5 KB
2. Straight Line Depreciation of an Asset Part 2.mp4	31.1 MB
2. Straight Line Depreciation of an Asset Part 2.vtt	3.1 KB
3. Straight Line Depreciation of an Asset Part 3.mp4	27.0 MB
3. Straight Line Depreciation of an Asset Part 3.vtt	2.4 KB
4. Declining Balance Depreciation of an Asset Part 1.mp4	30.2 MB
4. Declining Balance Depreciation of an Asset Part 1.vtt	2.9 KB
5. Declining Balance Depreciation of an Asset Part 2.mp4	46.8 MB
5. Declining Balance Depreciation of an Asset Part 2.vtt	3.9 KB
6. Calculating Depreciation of an asset by Using SYD Function.mp4	40.0 MB
6. Calculating Depreciation of an asset by Using SYD Function.vtt	3.5 KB
7. Calculating Depreciation of an asset by Using DDB Function.mp4	35.9 MB
7. Calculating Depreciation of an asset by Using DDB Function.vtt	3.0 KB
8. Calculating Depreciation of an asset by Using VDB Function.mp4	46.1 MB
8. Calculating Depreciation of an asset by Using VDB Function.vtt	3.9 KB
9. Calculating Depreciation Value of a Car.mp4	20.4 MB
9. Calculating Depreciation Value of a Car.vtt	1.9 KB
10. Selecting Method of Depreciation to Calculate Depreciation of an Asset.mp4	28.0 MB
10. Selecting Method of Depreciation to Calculate Depreciation of an Asset.vtt	1.7 KB
/39. Financial FunctionsInvest Money in Company/
1. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1.mp4	15.0 MB
1. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1.vtt	1.9 KB
1.1 Invest-in-Company-Copy.xlsx.xlsx	15.2 KB
2. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2.mp4	23.4 MB
2. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2.vtt	2.3 KB
3. Calculating Payback Period of an Investment Part 1.mp4	32.2 MB
3. Calculating Payback Period of an Investment Part 1.vtt	3.2 KB
4. Calculating Payback Period of an Investment Part 2.mp4	26.9 MB
4. Calculating Payback Period of an Investment Part 2.vtt	1.6 KB
5. Calculating Payback Period of an Investment Part 3.mp4	27.3 MB
5. Calculating Payback Period of an Investment Part 3.vtt	1.7 KB
6. Calculate Present Value of an Invetment by Using NPV Function Part 1.mp4	30.4 MB
6. Calculate Present Value of an Invetment by Using NPV Function Part 1.vtt	2.4 KB
7. Calculate Present Value of an Invetment by Using NPV Function Part 2.mp4	23.8 MB
7. Calculate Present Value of an Invetment by Using NPV Function Part 2.vtt	2.0 KB
8. Calculate Net Present Value of an Invetment.mp4	18.9 MB
8. Calculate Net Present Value of an Invetment.vtt	1.5 KB
9. Calculate Internal Rate of Return of an Invetment by Using IRR Function.mp4	19.3 MB
9. Calculate Internal Rate of Return of an Invetment by Using IRR Function.vtt	1.5 KB
10. Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons.mp4	35.7 MB
10. Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons.vtt	2.3 KB
11. Calculate Equivalent Value of Interest Rate by Using RRI Function.mp4	20.7 MB
11. Calculate Equivalent Value of Interest Rate by Using RRI Function.vtt	2.2 KB
/40. Basic Financial Examples(Learn Use of Operators +,-,,)/
1. Calculating the Remaining Amount with 30% Rate.mp4	23.4 MB
1. Calculating the Remaining Amount with 30% Rate.vtt	2.3 KB
1.1 Financial-Examples-Series-1-Copy.xlsx.xlsx	19.9 KB
2. Calculating the Remaining Amount with 15% and 40% Rate.mp4	33.5 MB
2. Calculating the Remaining Amount with 15% and 40% Rate.vtt	2.8 KB
3. Calculating the Percentage of Remaining Amount.mp4	31.9 MB
3. Calculating the Percentage of Remaining Amount.vtt	3.0 KB
4. Calculating the Percentage of Savings.mp4	29.3 MB
4. Calculating the Percentage of Savings.vtt	2.6 KB
5. Finding the Value of Actual Amount.mp4	31.1 MB
5. Finding the Value of Actual Amount.vtt	3.1 KB
6. Calculating the Value of Expense,Save and Total Amount.mp4	39.7 MB
6. Calculating the Value of Expense,Save and Total Amount.vtt	3.4 KB
7. Calculating the Remaining Profit.mp4	27.8 MB
7. Calculating the Remaining Profit.vtt	2.8 KB
8. Calculating the Values of Profit and Percentage of Profit.mp4	25.7 MB
8. Calculating the Values of Profit and Percentage of Profit.vtt	2.3 KB
9. Calculating the Values of Loss and Percentage of Loss.mp4	39.8 MB
9. Calculating the Values of Loss and Percentage of Loss.vtt	2.8 KB
Total files 820