MuerBT磁力搜索 BT种子搜索利器 免费下载BT种子,超5000万条种子数据

Microsoft Excel 2019 Office 365- Learn Basic to Advanced

磁力链接/BT种子名称

Microsoft Excel 2019 Office 365- Learn Basic to Advanced

磁力链接/BT种子简介

种子哈希:9611d72caccf62535112f28cdf86f1c814bc8eac
文件大小: 9.88G
已经下载:417次
下载速度:极快
收录时间:2021-05-19
最近下载:2025-08-21

移花宫入口

移花宫.com邀月.com怜星.com花无缺.comyhgbt.icuyhgbt.top

磁力链接下载

magnet:?xt=urn:btih:9611D72CACCF62535112F28CDF86F1C814BC8EAC
推荐使用PIKPAK网盘下载资源,10TB超大空间,不限制资源,无限次数离线下载,视频在线观看

下载BT种子文件

磁力链接 迅雷下载 PIKPAK在线播放 世界之窗 91视频 含羞草 欲漫涩 逼哩逼哩 成人快手 51品茶 抖阴破解版 极乐禁地 91短视频 她趣 TikTok成人版 PornHub 听泉鉴鲍 草榴社区 哆哔涩漫 呦乐园 萝莉岛

最近搜索

极品外围女神 极品胸 精哥 白露 偷情 电话 taylor swift 被4p 美山 内射 丝 子柔 短裙 arabelle.raphael autocad 女战士 香蕉 美少女 まご 夫婦 香逼 赤月 金金 剧情片 出彩 天堂 圆床 阴道按摩 骑乘自慰 part2 奶柔 女社长

文件列表

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

随机展示

相关说明

本站不存储任何资源内容,只收集BT种子元数据(例如文件名和文件大小)和磁力链接(BT种子标识符),并提供查询服务,是一个完全合法的搜索引擎系统。 网站不提供种子下载服务,用户可以通过第三方链接或磁力链接获取到相关的种子资源。本站也不对BT种子真实性及合法性负责,请用户注意甄别!