zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
Microsoft Excel 2019 Office 365- Learn Basic to Advanced
magnet:?xt=urn:btih:9611d72caccf62535112f28cdf86f1c814bc8eac&dn=Microsoft Excel 2019 Office 365- Learn Basic to Advanced
磁力链接详情
文件列表详情
9611d72caccf62535112f28cdf86f1c814bc8eac
infohash:
374
文件数量
9.88 GB
文件大小
2021-6-17 10:38
创建日期
2024-11-16 17:25
最后访问
相关分词
Microsoft
Excel
2019
Office
365-
Learn
Basic
to
Advanced
12. Extracting Data from the Website(Power Query,Pivot Table)/2. Combining Queries.mp4 87.01 MB
2. Creating Excel Tables,PivotTables and PivotCharts/1. Freezing Header or Row.mp4 16.41 MB
2. Creating Excel Tables,PivotTables and PivotCharts/2. Converting Data in an Excel Table.mp4 22.82 MB
2. Creating Excel Tables,PivotTables and PivotCharts/3. Adding Records in an Excel Table.mp4 41.76 MB
2. Creating Excel Tables,PivotTables and PivotCharts/4. Renaming and Finding Records in an Excel Table.mp4 28.62 MB
2. Creating Excel Tables,PivotTables and PivotCharts/5. Editing and Deleting Records in an Excel Table.mp4 26.01 MB
2. Creating Excel Tables,PivotTables and PivotCharts/6. Remove Duplicates.mp4 26.95 MB
2. Creating Excel Tables,PivotTables and PivotCharts/7. Sorting Date Column in an Excel Table.mp4 19.59 MB
2. Creating Excel Tables,PivotTables and PivotCharts/8. Sorting Multiple Columns.mp4 22 MB
2. Creating Excel Tables,PivotTables and PivotCharts/9. Filtering Data in an Excel Worksheet and Deleting an Excel Table.mp4 34.52 MB
2. Creating Excel Tables,PivotTables and PivotCharts/10. Filtering Data by Creating Criteria.mp4 30.86 MB
2. Creating Excel Tables,PivotTables and PivotCharts/11. Filtering Data in an Excel Table by Using Slicer.mp4 23.35 MB
2. Creating Excel Tables,PivotTables and PivotCharts/12. Splitting the Worksheet into Panes.mp4 30.6 MB
2. Creating Excel Tables,PivotTables and PivotCharts/13. Calculating Records in an Excel Table.mp4 24.67 MB
2. Creating Excel Tables,PivotTables and PivotCharts/14. Inserting Subtotals.mp4 35.97 MB
2. Creating Excel Tables,PivotTables and PivotCharts/15. Creating and Adding Data in a Pivot Table.mp4 34.72 MB
2. Creating Excel Tables,PivotTables and PivotCharts/16. Filtering Data in a Pivot Table.mp4 26.43 MB
2. Creating Excel Tables,PivotTables and PivotCharts/17. Adding Pivot Chart in a Pivot Table.mp4 19.06 MB
2. Creating Excel Tables,PivotTables and PivotCharts/18. Home Work.mp4 6.7 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/1. Adding Data in Excel Table.mp4 21.97 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/2. Adding and Formatting First Chart in Pivot Table.mp4 35.29 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/3. Adding and Formatting Second Chart in Pivot Table.mp4 29.97 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/4. Adding and Formatting Third Chart in Pivot Table.mp4 29.48 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/5. Adding and Formatting Fourth Chart in Pivot Table.mp4 30.55 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/6. Adding and Formatting Fifth Chart in Pivot Table.mp4 28.39 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/7. Adding and Formatting Sixth Chart in Pivot Table.mp4 21.71 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/8. Adding Chart in Excel Dashboard.mp4 23.34 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/9. Designing Dashboard Layout and Extracting Pivot Tables Data in Text Box.mp4 28.12 MB
3. Analyzing Sales Data in Pivot Tables and Pivot Charts/10. Inserting Slicers in the Dashboard for Analyzing Sales Data.mp4 38.15 MB
4. Data Validation and Inserting Comments/1. Specifying a Validation Rule by Using List.mp4 40.25 MB
4. Data Validation and Inserting Comments/2. Show an Input Message on an Active Cell.mp4 29.78 MB
4. Data Validation and Inserting Comments/3. Displaying Error Alert Message.mp4 29.2 MB
4. Data Validation and Inserting Comments/4. Circle Invalid Data.mp4 7.64 MB
4. Data Validation and Inserting Comments/5. Inserting Comments in a Worksheet.mp4 18.83 MB
4. Data Validation and Inserting Comments/6. Home Work.mp4 4.99 MB
5. Analyzing Data in the Table/1. Introducing and Converting a Range to a Table.mp4 34.2 MB
5. Analyzing Data in the Table/2. Sorting a Table using Different Methods.mp4 38.59 MB
5. Analyzing Data in the Table/3. Filtering a Table using Different Methods.mp4 54.41 MB
5. Analyzing Data in the Table/4. Analyzing Basic Table Operations.mp4 61.39 MB
5. Analyzing Data in the Table/5. Analyzing Table Data using COUNTIF,SUMIF and AVERAGEIF Functions.mp4 68.89 MB
6. Analyzing Data with PivotTables/1. Introducing PivotTables.mp4 18.97 MB
6. Analyzing Data with PivotTables/2. Creating PivotTable.mp4 40.74 MB
6. Analyzing Data with PivotTables/3. Inserting Subtotals In the PivotTable.mp4 31.41 MB
6. Analyzing Data with PivotTables/4. Summarizes Value Field by Changing Functions.mp4 17.51 MB
6. Analyzing Data with PivotTables/5. Adding PivotChart and Slicer in the PivotTable.mp4 30.03 MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/1. Introducing Power Query and Upload CSV File.mp4 18.37 MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/2. Retrieving Power Query Data into an Excel Table and Editing a Query Data.mp4 35.7 MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/3. Adding a New Column and Grouping Values in a Power Query Data.mp4 41.39 MB
7. Analyzing Data with Business Intelligence (Power Queries and Trendlines)/4. Analyzing Revenue Data by Adding Trendlines in the Chart.mp4 39.63 MB
8. Analyzing Data with Business Intelligence (Forecast Sheet)/1. Analyzing Revenue Data by Creating a Forecast Sheet.mp4 48.7 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/1. Introducing Database and Upload Access Database File.mp4 20.64 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/2. Creating the Data Model.mp4 27.21 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/3. Transferring Data in the Power Pivot.mp4 28.92 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/4. Exploring the Data Model in the Diagram View.mp4 11.5 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/5. Managing Table Relationships in the Power Pivot.mp4 18.17 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/6. Creating a PivotTable from the Data Model.mp4 34.61 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/7. Adding a Timeline Slicer in the PivotTable.mp4 16.58 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/8. Drilling down into the Data in the PivotTable.mp4 25.75 MB
9. Analyzing Data with Business Intelligence (Power Pivot,Data Model & Power Map)/9. Visualizing Stores Sale Data with Power Map.mp4 59.51 MB
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 42.27 MB
10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/2. Extracting Population and Area Data into PivotTable.mp4 51.66 MB
10. Extracting Data from the Website(Power Query,Power Pivot,Pivot Table)/3. Merging Two Queries into One query.mp4 43.97 MB
11. Loading Website Data into Power Map(Power Query,Power Map)/1. Loading Website Data into Power Map.mp4 76.14 MB
12. Extracting Data from the Website(Power Query,Pivot Table)/1. Extracting and Transforming User Rating Data from the Website.mp4 60.57 MB
1. Introduction/1. Course Files.mp4 5.76 MB
13. Extracting Football Team Data from the Website(Power Query,Pivot Table)/1. Extracting and Transforming Data from the Website.mp4 51.09 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/1. Cost-Volume-Profit(CVP) Chart Analysis.mp4 19.51 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/2. Find the Break-Even Point by Using Goal Seek.mp4 30.23 MB
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.mp4 9.76 MB
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.mp4 36.86 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/5. Completing the One-Variable Data Table.mp4 24.85 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/6. Creating the CVP Chart of the Data Table.mp4 29.35 MB
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.mp4 28.83 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/8. Creating the Two-Variable Data Table.mp4 55.1 MB
14. Analyzing Business Data by using What-If Analysis Tools(Goal Seek,Data Table)/9. Create a Chart of the Two Variable Data Table.mp4 49.8 MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/1. Define Names for the Income Statement Values.mp4 21.92 MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/2. Adding the Scenarios in the Scenario Manager.mp4 70.11 MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/3. View the Impact of the Reduced Operations Scenario.mp4 40.35 MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/4. Creating the Scenario Summary Report.mp4 22.76 MB
15. Analyzing Business Data by using What-If Analysis Tools(Scenario Manager)/5. Creating the Scenario PivotTable Report.mp4 53.92 MB
16. Analyzing Business Data with Solver/1. Understand Solver with Simple Example.mp4 34.29 MB
16. Analyzing Business Data with Solver/2. Introducing Product Mix and Find an Optimal Solution with Solver Part 1.mp4 48.66 MB
16. Analyzing Business Data with Solver/3. Introducing Product Mix and Find an Optimal Solution with Solver Part 2.mp4 62.82 MB
16. Analyzing Business Data with Solver/4. Creating a Solver Answer Report.mp4 20.51 MB
16. Analyzing Business Data with Solver/5. Saving and Loading Solver Model.mp4 19.85 MB
17. Introduction to Excel/1. Starting With Excel.mp4 9.84 MB
17. Introduction to Excel/2. Excel Tabs,Groups and Commands.mp4 13.15 MB
17. Introduction to Excel/3. Excel Rows and Columns.mp4 16.46 MB
17. Introduction to Excel/4. Changing the Size of Columns and Rows.mp4 18.68 MB
17. Introduction to Excel/5. Entering Text and Numbers in Worksheet.mp4 20.38 MB
17. Introduction to Excel/6. Wrap Text Inside the Cell.mp4 8.6 MB
17. Introduction to Excel/7. Edit Text Within a Cell.mp4 6.97 MB
17. Introduction to Excel/8. Merging and Formatting Cells in a Worksheet.mp4 21.29 MB
17. Introduction to Excel/9. Formatting Header in a Worksheet.mp4 13.17 MB
17. Introduction to Excel/10. Adding Image in a Worksheet.mp4 20.95 MB
17. Introduction to Excel/11. Formatting Date in Excel Worksheet.mp4 19.88 MB
17. Introduction to Excel/12. Working of Undo & Redo Commands in an Excel Worksheet.mp4 14.98 MB
17. Introduction to Excel/13. Home Work.mp4 9.37 MB
18. Calculations With Basic Formulas/1. Introduction to Arithmetic Operators.mp4 8.88 MB
18. Calculations With Basic Formulas/2. Calculations with Arithmetic Operators.mp4 33.64 MB
18. Calculations With Basic Formulas/3. Copy and Paste the Formula.mp4 9.37 MB
18. Calculations With Basic Formulas/4. Auto Complete Formula.mp4 7.69 MB
18. Calculations With Basic Formulas/5. Inserting and Deleting Columns and Rows.mp4 10.38 MB
18. Calculations With Basic Formulas/6. Hide and Unhide Columns and Rows.mp4 7.48 MB
18. Calculations With Basic Formulas/7. Moving a Cell or Range by Drag and Drop Method.mp4 7.29 MB
18. Calculations With Basic Formulas/8. Moving a Cell or Range by Cut and Paste Method.mp4 3.87 MB
18. Calculations With Basic Formulas/9. Relative and Absolute Cell References.mp4 19.86 MB
18. Calculations With Basic Formulas/10. Home Work.mp4 8.83 MB
19. Calculations with Simple Excel Functions/1. Introduction to Function Syntax.mp4 15.11 MB
19. Calculations with Simple Excel Functions/2. Calculating Total Sales by Using SUM Function.mp4 30.74 MB
19. Calculations with Simple Excel Functions/3. Calculating Total Sales Quantities by Using SUM Function.mp4 15.23 MB
19. Calculations with Simple Excel Functions/4. Count Price Items by Using COUNT Function.mp4 16.57 MB
19. Calculations with Simple Excel Functions/5. Count Food Items by Using COUNTA Function.mp4 17.71 MB
19. Calculations with Simple Excel Functions/6. Calculating Average Sales by Using AVERAGE Function.mp4 24 MB
19. Calculations with Simple Excel Functions/7. Calculating Maximum Sales Value of Customer by Using MAX Function.mp4 17.79 MB
19. Calculations with Simple Excel Functions/8. Calculating Minimum Sales Value of Customer by Using MIN Function.mp4 18.04 MB
19. Calculations with Simple Excel Functions/9. Calculating Total Price of Products by Using PRODUCT Function.mp4 22.39 MB
19. Calculations with Simple Excel Functions/10. Calculating Sales Data by Using Auto FUNCTION Button.mp4 22.4 MB
19. Calculations with Simple Excel Functions/11. Calculating a Tax Rate on Total Sales.mp4 29.32 MB
19. Calculations with Simple Excel Functions/12. Home Work.mp4 8.68 MB
20. Formatting a Worksheet/1. Merging Two or More Cells into One Cell.mp4 15.29 MB
20. Formatting a Worksheet/2. Alignment of Cell Text.mp4 15.77 MB
20. Formatting a Worksheet/3. Splitting Text into Multiple Lines.mp4 15.45 MB
20. Formatting a Worksheet/4. Rotating a Cell Text or Numbers.mp4 11.12 MB
20. Formatting a Worksheet/5. Formatting Background Color of Text and Numbers.mp4 23.76 MB
20. Formatting a Worksheet/6. Formatting Font Size and Font Color.mp4 18.1 MB
20. Formatting a Worksheet/7. Adding Border into Cells.mp4 13.05 MB
20. Formatting a Worksheet/8. Formatting Cell Styles.mp4 19.12 MB
20. Formatting a Worksheet/9. Find and Replace Text in a Worksheet.mp4 22.95 MB
20. Formatting a Worksheet/10. Calculating Students Enrollment and Difference Between two Columns Values.mp4 34.1 MB
20. Formatting a Worksheet/11. Calculating Percentage Difference Between two Columns Values.mp4 25.3 MB
20. Formatting a Worksheet/12. Conditionally Formatting Cells in a Worksheet.mp4 27.05 MB
20. Formatting a Worksheet/13. Conditionally Formatting Cells with a Top and Bottom Rules.mp4 16.34 MB
20. Formatting a Worksheet/14. Home Work.mp4 5.53 MB
21. Saving and Printing a Workbook/1. Saving a Workbook.mp4 7.43 MB
21. Saving and Printing a Workbook/2. Worksheet Views,Page Orientation and Scaling.mp4 30.93 MB
21. Saving and Printing a Workbook/3. Setting Margins in a Print Page.mp4 9.97 MB
21. Saving and Printing a Workbook/4. Adding Header and Footer in a Print Page.mp4 32.65 MB
21. Saving and Printing a Workbook/5. Print Preview and Selecting Print Area.mp4 20.86 MB
21. Saving and Printing a Workbook/6. Setting Scaling and Margins in a Print Page(Document 1).mp4 34.23 MB
22. Project Calculations with Operators and Functions/1. Calculating the Area of Field and Plots.mp4 36.46 MB
22. Project Calculations with Operators and Functions/2. Calculating the Grown and Empty Area of Vegetables Field.mp4 17.95 MB
22. Project Calculations with Operators and Functions/3. Calculating the Percentage of Grown and Empty area in Vegetables Field.mp4 15.91 MB
22. Project Calculations with Operators and Functions/4. Calculating Cost of Sales and Weightages of Vegetables.mp4 36.23 MB
22. Project Calculations with Operators and Functions/5. Calculating Profit and Percentage of Profit from Vegetables.mp4 28.52 MB
22. Project Calculations with Operators and Functions/6. Calculating Revenue by Using Sum,Max,Min,Average and Median Functions.mp4 48.27 MB
22. Project Calculations with Operators and Functions/7. Introduction to NESTED Function.mp4 14.47 MB
22. Project Calculations with Operators and Functions/8. Nesting the SUM and MEDIAN Functions within ROUND Function.mp4 17.61 MB
22. Project Calculations with Operators and Functions/9. Home Work.mp4 9.23 MB
23. IF and VLOOKUP Functions/1. Introduction to IF Function and Apply Weather Condition on IF Function.mp4 31.37 MB
23. IF and VLOOKUP Functions/2. Apply Different Conditions on IF Function.mp4 63.48 MB
23. IF and VLOOKUP Functions/3. Introduction to VLOOKUP Function.mp4 27.44 MB
23. IF and VLOOKUP Functions/4. Apply VLOOKUP Function on Data Table.mp4 17.94 MB
23. IF and VLOOKUP Functions/5. Retrieving Values from Data Table by Using VLOOKUP Function.mp4 18.03 MB
23. IF and VLOOKUP Functions/6. Errors in VLOOKUP Function.mp4 16.38 MB
23. IF and VLOOKUP Functions/7. Home Work.mp4 5.75 MB
24. Adding Column and Pie Charts in an Excel worksheet/1. Embed Column Chart in a Worksheet.mp4 20.95 MB
24. Adding Column and Pie Charts in an Excel worksheet/2. Analyzing Data with a Column Chart.mp4 43.43 MB
24. Adding Column and Pie Charts in an Excel worksheet/3. Analyzing Data with a Pie Chart.mp4 30.86 MB
24. Adding Column and Pie Charts in an Excel worksheet/4. Recommended Charts.mp4 26.94 MB
24. Adding Column and Pie Charts in an Excel worksheet/5. Home Work.mp4 4.12 MB
25. Date and Time Functions in an Excel/1. NOW and TIME Functions.mp4 27.1 MB
25. Date and Time Functions in an Excel/2. HOUR,MINUTE and SECOND Functions.mp4 19.91 MB
25. Date and Time Functions in an Excel/3. TODAY,DATE and DAYS Functions.mp4 24.43 MB
25. Date and Time Functions in an Excel/4. YEAR,MONTH and DAY Functions.mp4 28.09 MB
25. Date and Time Functions in an Excel/5. WEEKDAY Function.mp4 21.44 MB
25. Date and Time Functions in an Excel/6. WEEKNUM Function.mp4 12.73 MB
25. Date and Time Functions in an Excel/7. EDATE Function.mp4 17.12 MB
25. Date and Time Functions in an Excel/8. EOMONTH Function.mp4 21.98 MB
25. Date and Time Functions in an Excel/9. Determining Person's Birthday.mp4 14.79 MB
25. Date and Time Functions in an Excel/10. Calculating Age of Person.mp4 17.48 MB
25. Date and Time Functions in an Excel/11. Formatting Date in a Cell.mp4 9.9 MB
25. Date and Time Functions in an Excel/12. DATEVALUE Function.mp4 14 MB
25. Date and Time Functions in an Excel/13. DAYS360 Function.mp4 12.77 MB
25. Date and Time Functions in an Excel/14. ISOWEEKNUM Function.mp4 9.88 MB
25. Date and Time Functions in an Excel/15. NETWORKDAYS Function.mp4 10.44 MB
25. Date and Time Functions in an Excel/16. TIMEVALUE Function.mp4 12.6 MB
25. Date and Time Functions in an Excel/17. YEARFRAC Function.mp4 15.05 MB
26. Logical Functions in an Excel/1. Calculating the Age of Employees and Length of Service.mp4 37.54 MB
26. Logical Functions in an Excel/2. Analyzing Data by Using IF Function.mp4 49.11 MB
26. Logical Functions in an Excel/3. Determining Birthday of Employees.mp4 31.38 MB
26. Logical Functions in an Excel/4. Specifying Day of Birthdate by Nesting DAY Function Within IF Function.mp4 42.92 MB
26. Logical Functions in an Excel/5. Determining Employee Eligibility for Promotion by Using AND Function.mp4 50.8 MB
26. Logical Functions in an Excel/6. Nesting the AND Function Within IF Function.mp4 51.16 MB
26. Logical Functions in an Excel/7. Determining Employee Eligibility for Promotion by Using OR Function.mp4 40.76 MB
26. Logical Functions in an Excel/8. Nesting the OR Function Within IF Function.mp4 57.16 MB
26. Logical Functions in an Excel/9. IFERROR Function.mp4 20.28 MB
26. Logical Functions in an Excel/10. IFNA Function.mp4 42.19 MB
26. Logical Functions in an Excel/11. FALSE Function.mp4 15.48 MB
26. Logical Functions in an Excel/12. IFS Function.mp4 49.92 MB
26. Logical Functions in an Excel/13. NOT Function.mp4 20.77 MB
26. Logical Functions in an Excel/14. SWITCH Function.mp4 27.56 MB
26. Logical Functions in an Excel/15. TRUE Function.mp4 16.54 MB
26. Logical Functions in an Excel/16. XOR Function.mp4 18.12 MB
26. Logical Functions in an Excel/17. Home Work.mp4 5.31 MB
27. Lookup and Reference Functions in an Excel/1. Extracting Value from Data Table by Using VLOOKUP Function.mp4 63.46 MB
27. Lookup and Reference Functions in an Excel/2. Extracting Value from Data Table by Using HLOOKUP Function.mp4 45.75 MB
27. Lookup and Reference Functions in an Excel/3. Calculating Discount and Total Price.mp4 15.25 MB
27. Lookup and Reference Functions in an Excel/4. Calculating Tax Rate on Total Price Value.mp4 9.47 MB
27. Lookup and Reference Functions in an Excel/5. Extracting Value by Using CHOOSE Function.mp4 33.37 MB
27. Lookup and Reference Functions in an Excel/6. Nesting the CHOOSE Function Within Sum Function.mp4 35.63 MB
27. Lookup and Reference Functions in an Excel/7. MATCH Function.mp4 23.72 MB
27. Lookup and Reference Functions in an Excel/8. Extracting Value by Using INDEX Function.mp4 26.81 MB
27. Lookup and Reference Functions in an Excel/9. Nesting the MATCH Function Within an INDEX Function.mp4 28.36 MB
27. Lookup and Reference Functions in an Excel/10. Nesting the VLOOKUP Function Within an IFERROR Function.mp4 34.16 MB
27. Lookup and Reference Functions in an Excel/11. COLUMN Function.mp4 10.3 MB
27. Lookup and Reference Functions in an Excel/12. LOOKUP Function.mp4 50.22 MB
27. Lookup and Reference Functions in an Excel/13. TRANSPOSE Function.mp4 28.49 MB
27. Lookup and Reference Functions in an Excel/14. Home Work.mp4 3 MB
28. Adding Line and Combination Charts in an Excel/1. Adding and Formatting Line Chart.mp4 30.74 MB
28. Adding Line and Combination Charts in an Excel/2. Adding and Formatting Combination Chart.mp4 33.22 MB
29. Text Functions in an Excel/1. BHATTEXT Function.mp4 11.38 MB
29. Text Functions in an Excel/2. CHAR Function.mp4 13.49 MB
29. Text Functions in an Excel/3. CLEAN Function.mp4 8.14 MB
29. Text Functions in an Excel/4. CODE Function.mp4 7.51 MB
29. Text Functions in an Excel/5. CONCAT Function.mp4 23.53 MB
29. Text Functions in an Excel/6. DOLLAR Function.mp4 13.5 MB
29. Text Functions in an Excel/7. EXACT Function.mp4 15.43 MB
29. Text Functions in an Excel/8. FIND Function.mp4 24.1 MB
29. Text Functions in an Excel/9. FIXED Function.mp4 16.74 MB
29. Text Functions in an Excel/10. LEFT Function.mp4 16.62 MB
29. Text Functions in an Excel/11. LEN Function.mp4 11.48 MB
29. Text Functions in an Excel/12. LOWER Function.mp4 12.38 MB
29. Text Functions in an Excel/13. MID Function.mp4 23.19 MB
29. Text Functions in an Excel/14. NUMBERVALUE Function.mp4 17.69 MB
29. Text Functions in an Excel/15. PROPER Function.mp4 8.23 MB
29. Text Functions in an Excel/16. REPLACE Function.mp4 25.02 MB
29. Text Functions in an Excel/17. REPT Function.mp4 25.21 MB
29. Text Functions in an Excel/18. RIGHT Function.mp4 17.56 MB
29. Text Functions in an Excel/19. SEARCH Function.mp4 24.29 MB
29. Text Functions in an Excel/20. SUBSTITUTE Function.mp4 23.09 MB
29. Text Functions in an Excel/21. T Function.mp4 10.19 MB
29. Text Functions in an Excel/22. TEXT Function.mp4 25.34 MB
29. Text Functions in an Excel/23. TEXTJOIN Function.mp4 21.52 MB
29. Text Functions in an Excel/24. TRIM Function.mp4 10.67 MB
29. Text Functions in an Excel/25. UNICHAR Function.mp4 7.42 MB
29. Text Functions in an Excel/26. UNICODE Function.mp4 9.5 MB
29. Text Functions in an Excel/27. UPPER Function.mp4 13.65 MB
29. Text Functions in an Excel/28. VALUE Function.mp4 11.52 MB
30. Math and Trigonometry Functions in an Excel/1. SUM Function.mp4 45.07 MB
30. Math and Trigonometry Functions in an Excel/2. MOD Function.mp4 10.14 MB
30. Math and Trigonometry Functions in an Excel/3. POWER Function.mp4 19.04 MB
30. Math and Trigonometry Functions in an Excel/4. SUBTOTAL Function.mp4 50.82 MB
30. Math and Trigonometry Functions in an Excel/5. SUMIF Function.mp4 58.64 MB
30. Math and Trigonometry Functions in an Excel/6. SUMIFS Function.mp4 60.22 MB
30. Math and Trigonometry Functions in an Excel/7. SUMPRODUCT Function.mp4 31.16 MB
30. Math and Trigonometry Functions in an Excel/8. ROUND Function.mp4 38.12 MB
30. Math and Trigonometry Functions in an Excel/9. ROUNDDOWN Function.mp4 15.69 MB
30. Math and Trigonometry Functions in an Excel/10. ROUNDUP Function.mp4 14.51 MB
30. Math and Trigonometry Functions in an Excel/11. CEILING.MATH Function.mp4 22.15 MB
30. Math and Trigonometry Functions in an Excel/12. FLOOR.MATH Function.mp4 20.16 MB
30. Math and Trigonometry Functions in an Excel/13. EVEN Function.mp4 10.33 MB
30. Math and Trigonometry Functions in an Excel/14. ODD Function.mp4 10.34 MB
30. Math and Trigonometry Functions in an Excel/15. INT Function.mp4 13.69 MB
30. Math and Trigonometry Functions in an Excel/16. TRUNC Function.mp4 20.69 MB
31. Statistical Functions in an Excel/1. AVERAGE Function.mp4 12.76 MB
31. Statistical Functions in an Excel/2. AVERAGEIF Function.mp4 70.08 MB
31. Statistical Functions in an Excel/3. AVERAGEIFS Function.mp4 82.57 MB
31. Statistical Functions in an Excel/4. COUNT and COUNTA Function.mp4 30.96 MB
31. Statistical Functions in an Excel/5. COUNTBLANK Function.mp4 18.5 MB
31. Statistical Functions in an Excel/6. COUNTIF Function.mp4 55.47 MB
31. Statistical Functions in an Excel/7. COUNTIFS Function.mp4 61.71 MB
31. Statistical Functions in an Excel/8. LARGE Function.mp4 29.68 MB
31. Statistical Functions in an Excel/9. SMALL Function.mp4 28.98 MB
31. Statistical Functions in an Excel/10. MAX and MIN Function.mp4 20 MB
31. Statistical Functions in an Excel/11. MEDIAN Function.mp4 20.39 MB
31. Statistical Functions in an Excel/12. MODE.MULT Function.mp4 23.07 MB
31. Statistical Functions in an Excel/13. MODE.SNGL Function.mp4 19.42 MB
32. Engineering Functions in an Excel/1. BIN2DEC Function.mp4 17.98 MB
32. Engineering Functions in an Excel/2. BIN2HEX Function.mp4 21.34 MB
32. Engineering Functions in an Excel/3. BIN2OCT Function.mp4 19.69 MB
32. Engineering Functions in an Excel/4. COMPLEX Function.mp4 22.06 MB
32. Engineering Functions in an Excel/5. CONVERT Function.mp4 29.45 MB
32. Engineering Functions in an Excel/6. DEC2BIN Function.mp4 17.09 MB
32. Engineering Functions in an Excel/7. DEC2HEX Function.mp4 12.01 MB
32. Engineering Functions in an Excel/8. DEC2OCT Function.mp4 11.31 MB
33. Information Functions in an Excel/1. CELL Function.mp4 61.12 MB
33. Information Functions in an Excel/2. ERROR.TYPE Function.mp4 11.98 MB
33. Information Functions in an Excel/3. INFO Function.mp4 18.41 MB
33. Information Functions in an Excel/4. ISBLANK Function.mp4 24.79 MB
33. Information Functions in an Excel/5. ISERR Function.mp4 11.32 MB
33. Information Functions in an Excel/6. ISERROR Function.mp4 22.67 MB
33. Information Functions in an Excel/7. ISEVEN Function.mp4 16.58 MB
33. Information Functions in an Excel/8. ISFORMULA Function.mp4 17.61 MB
33. Information Functions in an Excel/9. ISLOGICAL Function.mp4 19.36 MB
33. Information Functions in an Excel/10. ISNA Function.mp4 18.33 MB
33. Information Functions in an Excel/11. ISNONTEXT Function.mp4 18.13 MB
33. Information Functions in an Excel/12. ISNUMBER Function.mp4 16.12 MB
33. Information Functions in an Excel/13. ISODD Function.mp4 18.38 MB
33. Information Functions in an Excel/14. ISREF Function.mp4 18.23 MB
33. Information Functions in an Excel/15. ISTEXT Function.mp4 18.29 MB
33. Information Functions in an Excel/16. N Function.mp4 20.1 MB
33. Information Functions in an Excel/17. NA Function.mp4 18.31 MB
33. Information Functions in an Excel/18. SHEET Function.mp4 18.36 MB
33. Information Functions in an Excel/19. SHEETS Function.mp4 15.69 MB
33. Information Functions in an Excel/20. TYPE Function.mp4 25.47 MB
34. Database Functions in an Excel/1. DAVERAGE Function.mp4 40.98 MB
34. Database Functions in an Excel/2. DSUM Function.mp4 25.87 MB
34. Database Functions in an Excel/3. DMAX and DMIN Functions.mp4 39.1 MB
34. Database Functions in an Excel/4. DCOUNTA Function.mp4 38.9 MB
35. Financial FunctionsBorrow Money to Bank/1. Calculating a Quarterly Payment of Loan by using the PMT Function.mp4 52.23 MB
35. Financial FunctionsBorrow Money to Bank/2. Calculating a Future Value of Loan by using the FV Function.mp4 42.12 MB
35. Financial FunctionsBorrow Money to Bank/3. Calculating a Payment Period of Loan by using the NPER Function.mp4 30.42 MB
35. Financial FunctionsBorrow Money to Bank/4. Calculating a Present Value of Loan by using the PV Function.mp4 35.4 MB
35. Financial FunctionsBorrow Money to Bank/5. Calculating an Interest Rate of Loan by using the RATE Function.mp4 31.78 MB
35. Financial FunctionsBorrow Money to Bank/6. Positive Cash Flow and Negative Cash Flow.mp4 20.7 MB
35. Financial FunctionsBorrow Money to Bank/7. Calculating the Value of Inflation by Using FV Function.mp4 22.35 MB
35. Financial FunctionsBorrow Money to Bank/8. Calculating a Monthly Car Payment.mp4 28.84 MB
35. Financial FunctionsBorrow Money to Bank/9. Calculating the Interest Payment by using IPMT Function.mp4 40.02 MB
35. Financial FunctionsBorrow Money to Bank/10. Calculating the Principal Payment by using PPMT Function.mp4 26.33 MB
35. Financial FunctionsBorrow Money to Bank/11. Calculating Remaining Principal Amount and Total Payment.mp4 30.91 MB
35. Financial FunctionsBorrow Money to Bank/12. Completing the Amortization Schedule of Loan.mp4 52.23 MB
35. Financial FunctionsBorrow Money to Bank/13. Plotting Interest and Principal Payments.mp4 36 MB
35. Financial FunctionsBorrow Money to Bank/14. Calculating Cumulative Interest Payments by Using CUMIPMT Function.mp4 40.67 MB
35. Financial FunctionsBorrow Money to Bank/15. Calculating Cumulative Principal Payments by Using CUMPRINC Function.mp4 48.66 MB
35. Financial FunctionsBorrow Money to Bank/16. Calculating Remaining Principal,Total Interest and Total Principal Payments.mp4 58.91 MB
35. Financial FunctionsBorrow Money to Bank/17. Calculating Total Loan Amount.mp4 48.39 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/1. Calculating the Compound Interest.mp4 37.39 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/2. Calculating Nominal and Effective Interest Rates Using NOMINAL&EFFECT Functions.mp4 40.57 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/3. Calculating the Future Value of an Investment by Monthly and Initial Deposits.mp4 46.82 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/4. Calculating the Interest Rate of an Investment.mp4 46.14 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/5. Calculating the Total Number of Deposits of an Investment.mp4 46.24 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/6. Calculating the Initial Deposit or Present Value of an investment.mp4 37.58 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/7. Calculating the Value of Deposit Per Month.mp4 34.12 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/8. Calculating the Variable Interest Rates by using FVSCHEDULE Function.mp4 30.12 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/9. Amortization Schedule of an Investment 1.mp4 42.95 MB
36. Financial FunctionsInvest Money in the Bank Saving Account/10. Amortization Schedule of an Investment 2.mp4 47.89 MB
37. Financial FunctiomsBuild Future Income Statement of Company/1. Introduction to Income Statement Worksheet.mp4 15.45 MB
37. Financial FunctiomsBuild Future Income Statement of Company/2. Linear and Growth Trend Values.mp4 14.95 MB
37. Financial FunctiomsBuild Future Income Statement of Company/3. Projecting Future Value of Sales or Revenue by using Linear Trend Option.mp4 35.02 MB
37. Financial FunctiomsBuild Future Income Statement of Company/4. Projecting Future Value of Sales or Revenue by Inserting a Growth Trend.mp4 35.44 MB
37. Financial FunctiomsBuild Future Income Statement of Company/5. Calculating the Cost of Research and Development.mp4 24.89 MB
37. Financial FunctiomsBuild Future Income Statement of Company/6. Calculating the Cost of Sales and Marketing.mp4 27.12 MB
37. Financial FunctiomsBuild Future Income Statement of Company/7. Calculating the Gross Profit.mp4 27.59 MB
37. Financial FunctiomsBuild Future Income Statement of Company/8. Calculating the Expenses of Company Part 1.mp4 28.97 MB
37. Financial FunctiomsBuild Future Income Statement of Company/9. Calculating the Expenses of Company Part 2.mp4 39.13 MB
37. Financial FunctiomsBuild Future Income Statement of Company/10. Calculating the Expenses of Company Part 3.mp4 43.69 MB
37. Financial FunctiomsBuild Future Income Statement of Company/11. Calculating the Total General Expenses and Initial Earnings.mp4 42.1 MB
37. Financial FunctiomsBuild Future Income Statement of Company/12. Adding Depreciation of an Asset in the Income Statement.mp4 29.85 MB
37. Financial FunctiomsBuild Future Income Statement of Company/13. Calculating Operating Profit in the Income Statement.mp4 25.96 MB
37. Financial FunctiomsBuild Future Income Statement of Company/14. Adding Interest Expenses in the Income Statement.mp4 40.88 MB
37. Financial FunctiomsBuild Future Income Statement of Company/15. Calculating Profit Without Adding Tax.mp4 20.75 MB
37. Financial FunctiomsBuild Future Income Statement of Company/16. Adding Taxes in the Income Statement.mp4 41.54 MB
37. Financial FunctiomsBuild Future Income Statement of Company/17. Calculating Final Profit of the Company in the Income Statement.mp4 31.41 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/1. Straight Line Depreciation of an Asset Part 1.mp4 21.75 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/2. Straight Line Depreciation of an Asset Part 2.mp4 29.64 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/3. Straight Line Depreciation of an Asset Part 3.mp4 25.74 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/4. Declining Balance Depreciation of an Asset Part 1.mp4 28.81 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/5. Declining Balance Depreciation of an Asset Part 2.mp4 44.58 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/6. Calculating Depreciation of an asset by Using SYD Function.mp4 38.1 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/7. Calculating Depreciation of an asset by Using DDB Function.mp4 34.28 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/8. Calculating Depreciation of an asset by Using VDB Function.mp4 44.01 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/9. Calculating Depreciation Value of a Car.mp4 19.43 MB
38. Financial FunctionsCalculate Depreciation of an Asset of Company/10. Selecting Method of Depreciation to Calculate Depreciation of an Asset.mp4 26.7 MB
39. Financial FunctionsInvest Money in Company/1. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 1.mp4 14.28 MB
39. Financial FunctionsInvest Money in Company/2. Calculating Yearly Interest Rate of an Investment by Using Rate Function Part 2.mp4 22.34 MB
39. Financial FunctionsInvest Money in Company/3. Calculating Payback Period of an Investment Part 1.mp4 30.71 MB
39. Financial FunctionsInvest Money in Company/4. Calculating Payback Period of an Investment Part 2.mp4 25.61 MB
39. Financial FunctionsInvest Money in Company/5. Calculating Payback Period of an Investment Part 3.mp4 26.08 MB
39. Financial FunctionsInvest Money in Company/6. Calculate Present Value of an Invetment by Using NPV Function Part 1.mp4 28.95 MB
39. Financial FunctionsInvest Money in Company/7. Calculate Present Value of an Invetment by Using NPV Function Part 2.mp4 22.7 MB
39. Financial FunctionsInvest Money in Company/8. Calculate Net Present Value of an Invetment.mp4 18.01 MB
39. Financial FunctionsInvest Money in Company/9. Calculate Internal Rate of Return of an Invetment by Using IRR Function.mp4 18.39 MB
39. Financial FunctionsInvest Money in Company/10. Calculate Net Present Value & Internal Rate of Return using XNPV & XIRR Functons.mp4 34.06 MB
39. Financial FunctionsInvest Money in Company/11. Calculate Equivalent Value of Interest Rate by Using RRI Function.mp4 19.7 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/1. Calculating the Remaining Amount with 30% Rate.mp4 22.34 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/2. Calculating the Remaining Amount with 15% and 40% Rate.mp4 31.93 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/3. Calculating the Percentage of Remaining Amount.mp4 30.41 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/4. Calculating the Percentage of Savings.mp4 27.97 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/5. Finding the Value of Actual Amount.mp4 29.66 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/6. Calculating the Value of Expense,Save and Total Amount.mp4 37.91 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/7. Calculating the Remaining Profit.mp4 26.54 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/8. Calculating the Values of Profit and Percentage of Profit.mp4 24.46 MB
40. Basic Financial Examples(Learn Use of Operators +,-,,)/9. Calculating the Values of Loss and Percentage of Loss.mp4 37.92 MB
其他位置