| 1. AND and OR-en_US.srt | 8.4 KB | ||
| 1. AND and OR.mp4 | 20.9 MB | ||
| 1. Advanced Sort-en_US.srt | 6.5 KB | ||
| 1. Advanced Sort.mp4 | 22.6 MB | ||
| 1. Advanced page setup - page-en_US.srt | 6.6 KB | ||
| 1. Advanced page setup - page.mp4 | 18.4 MB | ||
| 1. Calculation options-en_US.srt | 3.6 KB | ||
| 1. Calculation options.mp4 | 8.4 MB | ||
| 1. Column and bar charts-en_US.srt | 8 KB | ||
| 1. Column and bar charts.mp4 | 28.4 MB | ||
| 1. Conditional formatting - format cell fonts-en_US.srt | 7.1 KB | ||
| 1. Conditional formatting - format cell fonts.mp4 | 18.1 MB | ||
| 1. Functions-en_US.srt | 2.6 KB | ||
| 1. Functions.mp4 | 9.2 MB | ||
| 1. General concepts about Formulas-en_US.srt | 5 KB | ||
| 1. General concepts about Formulas.mp4 | 13.7 MB | ||
| 1. General-en_US.srt | 8.4 KB | ||
| 1. General.mp4 | 23.7 MB | ||
| 1. Introduction-en_US.srt | 2.2 KB | ||
| 1. Introduction.mp4 | 29.2 MB | ||
| 1. Overview of formulas-en_US.srt | 1.6 KB | ||
| 1. Overview of formulas.mp4 | 3.4 MB | ||
| 1. Overview of the most popular and unknown Excel shortcuts-en_US.srt | 8.6 KB | ||
| 1. Overview of the most popular and unknown Excel shortcuts.mp4 | 22.8 MB | ||
| 1. Overview-en_US.srt | 1.5 KB | ||
| 1. Overview.mp4 | 3.1 MB | ||
| 1. Pivot tables-en_US.srt | 10.8 KB | ||
| 1. Pivot tables.mp4 | 40.5 MB | ||
| 1. Proofing options-en_US.srt | 3.3 KB | ||
| 1. Proofing options.mp4 | 8.7 MB | ||
| 1. Protect a Workbook-en_US.srt | 9 KB | ||
| 1. Protect a Workbook.mp4 | 21 MB | ||
| 1. The ADDRESS formula-en_US.srt | 4.2 KB | ||
| 1. The ADDRESS formula.mp4 | 12.5 MB | ||
| 1. The DATE formula-en_US.srt | 2.5 KB | ||
| 1. The DATE formula.mp4 | 6.7 MB | ||
| 1. The Excel errors-en_US.srt | 4.4 KB | ||
| 1. The Excel errors.mp4 | 13.5 MB | ||
| 1. Workbook views-en_US.srt | 2.4 KB | ||
| 1. Workbook views.mp4 | 5.9 MB | ||
| 10. Customize Ribbons-en_US.srt | 6.9 KB | ||
| 10. Customize Ribbons.mp4 | 18.5 MB | ||
| 10. Manage styles-en_US.srt | 4.5 KB | ||
| 10. Manage styles.mp4 | 16.9 MB | ||
| 10. The HOUR, MINUTE and SECOND formulas-en_US.srt | 2.6 KB | ||
| 10. The HOUR, MINUTE and SECOND formulas.mp4 | 7.6 MB | ||
| 10. The OFFSET formula-en_US.srt | 1.5 KB | ||
| 10. The OFFSET formula.mp4 | 3.6 MB | ||
| 10. Work with substrings LEFT, RIGHT, TRIM, LEN, LOWER, UPPER, MID-en_US.srt | 8.1 KB | ||
| 10. Work with substrings LEFT, RIGHT, TRIM, LEN, LOWER, UPPER, MID.mp4 | 20.8 MB | ||
| 11. Customize the Quick Access Toolbar-en_US.srt | 3.6 KB | ||
| 11. Customize the Quick Access Toolbar.mp4 | 10.7 MB | ||
| 11. PROPER, REPLACE, REPT, VALUE-en_US.srt | 3.8 KB | ||
| 11. PROPER, REPLACE, REPT, VALUE.mp4 | 10.8 MB | ||
| 11. The HYPERLINK formula-en_US.srt | 1.4 KB | ||
| 11. The HYPERLINK formula.mp4 | 3.5 MB | ||
| 11. The TIME formula-en_US.srt | 512 B | ||
| 11. The TIME formula.mp4 | 1.3 MB | ||
| 12. Manage Add-ins-en_US.srt | 2.8 KB | ||
| 12. Manage Add-ins.mp4 | 8.2 MB | ||
| 12. The REPLACE formula-en_US.srt | 1.3 KB | ||
| 12. The REPLACE formula.mp4 | 3.8 MB | ||
| 12. The TRANSPOSE formula-en_US.srt | 1.3 KB | ||
| 12. The TRANSPOSE formula.mp4 | 3.2 MB | ||
| 12. the TIMEVALUE formula-en_US.srt | 3.4 KB | ||
| 12. the TIMEVALUE formula.mp4 | 11.6 MB | ||
| 13. The GETPIVOTDATA formula-en_US.srt | 6.2 KB | ||
| 13. The GETPIVOTDATA formula.mp4 | 20.1 MB | ||
| 13. The SEARCH formula-en_US.srt | 1.5 KB | ||
| 13. The SEARCH formula.mp4 | 4.8 MB | ||
| 13. The TODAY formula-en_US.srt | 614.4 B | ||
| 13. The TODAY formula.mp4 | 1.8 MB | ||
| 13. The Trust Center-en_US.srt | 4.1 KB | ||
| 13. The Trust Center.mp4 | 7.7 MB | ||
| 14. Examples of use of LOOKUP formulas-en_US.srt | 8.2 KB | ||
| 14. Examples of use of LOOKUP formulas.mp4 | 31.1 MB | ||
| 14. The SUBSTITUTE formula-en_US.srt | 3.2 KB | ||
| 14. The SUBSTITUTE formula.mp4 | 9 MB | ||
| 14. The WEEKDAY formula-en_US.srt | 1.2 KB | ||
| 14. The WEEKDAY formula.mp4 | 3.4 MB | ||
| 15. The T formula-en_US.srt | 1.1 KB | ||
| 15. The T formula.mp4 | 3.4 MB | ||
| 15. The WORKDAY.INTL formula-en_US.srt | 2.7 KB | ||
| 15. The WORKDAY.INTL formula.mp4 | 8.5 MB | ||
| 16. Summary of Date & Time formulas Applications for calendars-en_US.srt | 1.8 KB | ||
| 16. Summary of Date & Time formulas Applications for calendars.mp4 | 4.1 MB | ||
| 16. The TEXT formula-en_US.srt | 4 KB | ||
| 16. The TEXT formula.mp4 | 10.1 MB | ||
| 17. The TEXTJOIN formula-en_US.srt | 1.1 KB | ||
| 17. The TEXTJOIN formula.mp4 | 3.3 MB | ||
| 17. The WEEKNUM formula-en_US.srt | 2.2 KB | ||
| 17. The WEEKNUM formula.mp4 | 5.6 MB | ||
| 18. The ISOWEEKNUM formula-en_US.srt | 1.3 KB | ||
| 18. The ISOWEEKNUM formula.mp4 | 4.4 MB | ||
| 18. The UNICHAR formula-en_US.srt | 819.2 B | ||
| 18. The UNICHAR formula.mp4 | 2.5 MB | ||
| 19. The NETWORKDAYS and NETWORKDAYS.INTL formulas-en_US.srt | 5 KB | ||
| 19. The NETWORKDAYS and NETWORKDAYS.INTL formulas.mp4 | 14.5 MB | ||
| 19. The UNICODE formula-en_US.srt | 1.4 KB | ||
| 19. The UNICODE formula.mp4 | 3.5 MB | ||
| 2. Accessibility-en_US.srt | 2.3 KB | ||
| 2. Accessibility.mp4 | 7.4 MB | ||
| 2. Advanced Filters-en_US.srt | 4.3 KB | ||
| 2. Advanced Filters.mp4 | 16.6 MB | ||
| 2. Advanced page setup - margins-en_US.srt | 3.2 KB | ||
| 2. Advanced page setup - margins.mp4 | 7.3 MB | ||
| 2. Conditional formatting - format cell properties-en_US.srt | 1.1 KB | ||
| 2. Conditional formatting - format cell properties.mp4 | 3.5 MB | ||
| 2. Fill-en_US.srt | 4.1 KB | ||
| 2. Fill.mp4 | 13.1 MB | ||
| 2. Format a chart-en_US.srt | 6.9 KB | ||
| 2. Format a chart.mp4 | 25.8 MB | ||
| 2. Formulas - Calculation options-en_US.srt | 6.4 KB | ||
| 2. Formulas - Calculation options.mp4 | 18.4 MB | ||
| 2. IRR-en_US.srt | 4.3 KB | ||
| 2. IRR.mp4 | 12.5 MB | ||
| 2. Inspect a Workbook-en_US.srt | 4.3 KB | ||
| 2. Inspect a Workbook.mp4 | 10.2 MB | ||
| 2. Manage the Excel errors-en_US.srt | 3.2 KB | ||
| 2. Manage the Excel errors.mp4 | 12.5 MB | ||
| 2. NOT, XOR,FALSE, TRUE-en_US.srt | 3.3 KB | ||
| 2. NOT, XOR,FALSE, TRUE.mp4 | 9.4 MB | ||
| 2. Reference to cells in formulas-en_US.srt | 6 KB | ||
| 2. Reference to cells in formulas.mp4 | 15.3 MB | ||
| 2. Show and Zoom-en_US.srt | 2 KB | ||
| 2. Show and Zoom.mp4 | 6.5 MB | ||
| 2. Suggested piviot tables and format pivot tables-en_US.srt | 4 KB | ||
| 2. Suggested piviot tables and format pivot tables.mp4 | 18.6 MB | ||
| 2. The AREAS formula-en_US.srt | 3.9 KB | ||
| 2. The AREAS formula.mp4 | 8.8 MB | ||
| 2. The CONCAT formula-en_US.srt | 1.1 KB | ||
| 2. The CONCAT formula.mp4 | 2.6 MB | ||
| 2. The DATEVALUE formula-en_US.srt | 1.4 KB | ||
| 2. The DATEVALUE formula.mp4 | 3.5 MB | ||
| 20. The NOW formula-en_US.srt | 819.2 B | ||
| 20. The NOW formula.mp4 | 2.3 MB | ||
| 21. The YEARFRAC formula-en_US.srt | 1.6 KB | ||
| 21. The YEARFRAC formula.mp4 | 5.4 MB | ||
| 3. Advanced page setup - header and footer-en_US.srt | 10.5 KB | ||
| 3. Advanced page setup - header and footer.mp4 | 28.2 MB | ||
| 3. Clear and Reapply Filters-en_US.srt | 1.3 KB | ||
| 3. Clear and Reapply Filters.mp4 | 4.2 MB | ||
| 3. Clear-en_US.srt | 1.4 KB | ||
| 3. Clear.mp4 | 4.4 MB | ||
| 3. Comments-en_US.srt | 3.1 KB | ||
| 3. Comments.mp4 | 8.8 MB | ||
| 3. Conditional formatting - TopBottom Rules-en_US.srt | 716.8 B | ||
| 3. Conditional formatting - TopBottom Rules.mp4 | 3.9 MB | ||
| 3. Format data series in bar charts-en_US.srt | 3.3 KB | ||
| 3. Format data series in bar charts.mp4 | 14 MB | ||
| 3. Formulas -Working with formulas-en_US.srt | 4.8 KB | ||
| 3. Formulas -Working with formulas.mp4 | 13 MB | ||
| 3. Manage Workbook & Browser View Options-en_US.srt | 4.6 KB | ||
| 3. Manage Workbook & Browser View Options.mp4 | 13 MB | ||
| 3. Pivot tables and graphs-en_US.srt | 4.7 KB | ||
| 3. Pivot tables and graphs.mp4 | 17.8 MB | ||
| 3. Range names, table names, object names-en_US.srt | 10.1 KB | ||
| 3. Range names, table names, object names.mp4 | 27.9 MB | ||
| 3. Rate-en_US.srt | 1.8 KB | ||
| 3. Rate.mp4 | 4.9 MB | ||
| 3. The CHOOSE formula-en_US.srt | 8.6 KB | ||
| 3. The CHOOSE formula.mp4 | 22.3 MB | ||
| 3. The DAY formula-en_US.srt | 1.1 KB | ||
| 3. The DAY formula.mp4 | 2.4 MB | ||
| 3. The DOLLAR formula-en_US.srt | 3.3 KB | ||
| 3. The DOLLAR formula.mp4 | 8.5 MB | ||
| 3. The Information formulas-en_US.srt | 4.3 KB | ||
| 3. The Information formulas.mp4 | 14.9 MB | ||
| 3. The SWITCH formula-en_US.srt | 4.8 KB | ||
| 3. The SWITCH formula.mp4 | 11.9 MB | ||
| 3. Window-en_US.srt | 3.9 KB | ||
| 3. Window.mp4 | 19.1 MB | ||
| 4. Advanced page setup - sheet-en_US.srt | 8.2 KB | ||
| 4. Advanced page setup - sheet.mp4 | 26 MB | ||
| 4. Changes allow users to edit ranges-en_US.srt | 1.8 KB | ||
| 4. Changes allow users to edit ranges.mp4 | 4.9 MB | ||
| 4. Combined Filters-en_US.srt | 6.1 KB | ||
| 4. Combined Filters.mp4 | 19.3 MB | ||
| 4. Conditional formatting - Color scales and Icon sets-en_US.srt | 3.1 KB | ||
| 4. Conditional formatting - Color scales and Icon sets.mp4 | 11.6 MB | ||
| 4. Create range names from selected ranges-en_US.srt | 3.4 KB | ||
| 4. Create range names from selected ranges.mp4 | 9.4 MB | ||
| 4. Format data series in line charts lines and markers-en_US.srt | 2.7 KB | ||
| 4. Format data series in line charts lines and markers.mp4 | 13.6 MB | ||
| 4. Formulas - Error checking-en_US.srt | 2.5 KB | ||
| 4. Formulas - Error checking.mp4 | 9.5 MB | ||
| 4. Future Value-en_US.srt | 1.8 KB | ||
| 4. Future Value.mp4 | 4.4 MB | ||
| 4. Sort-en_US.srt | 9.3 KB | ||
| 4. Sort.mp4 | 29.9 MB | ||
| 4. Tables-en_US.srt | 3.9 KB | ||
| 4. Tables.mp4 | 17.9 MB | ||
| 4. The CHAR formula-en_US.srt | 1.1 KB | ||
| 4. The CHAR formula.mp4 | 3.3 MB | ||
| 4. The DAYS formula-en_US.srt | 921.6 B | ||
| 4. The DAYS formula.mp4 | 2.7 MB | ||
| 4. The IF formula-en_US.srt | 6.5 KB | ||
| 4. The IF formula.mp4 | 19.4 MB | ||
| 4. The ROW, COLUMN, ROWS and COLUMNS formula-en_US.srt | 2.9 KB | ||
| 4. The ROW, COLUMN, ROWS and COLUMNS formula.mp4 | 8.5 MB | ||
| 5. Changes protect a worksheet-en_US.srt | 4.5 KB | ||
| 5. Changes protect a worksheet.mp4 | 13.8 MB | ||
| 5. Conditional formatting - Clean rules-en_US.srt | 409.6 B | ||
| 5. Conditional formatting - Clean rules.mp4 | 1.7 MB | ||
| 5. Data tools - Text to Columns-en_US.srt | 11.5 KB | ||
| 5. Data tools - Text to Columns.mp4 | 30.7 MB | ||
| 5. Filter-en_US.srt | 3.3 KB | ||
| 5. Filter.mp4 | 11.2 MB | ||
| 5. Formatmodify tables-en_US.srt | 8.2 KB | ||
| 5. Formatmodify tables.mp4 | 41.7 MB | ||
| 5. Formulas - Error checking rules-en_US.srt | 8.3 KB | ||
| 5. Formulas - Error checking rules.mp4 | 31.6 MB | ||
| 5. IFS, IFNA, IFERROR-en_US.srt | 6.8 KB | ||
| 5. IFS, IFNA, IFERROR.mp4 | 18.3 MB | ||
| 5. Line and area charts-en_US.srt | 8.6 KB | ||
| 5. Line and area charts.mp4 | 37 MB | ||
| 5. Reference to ranges and tables in formulas-multirange elements-en_US.srt | 3.6 KB | ||
| 5. Reference to ranges and tables in formulas-multirange elements.mp4 | 11.5 MB | ||
| 5. The BATHTEXT formula-en_US.srt | 512 B | ||
| 5. The BATHTEXT formula.mp4 | 1.7 MB | ||
| 5. The DAYS360 formula-en_US.srt | 2.3 KB | ||
| 5. The DAYS360 formula.mp4 | 7.8 MB | ||
| 5. The HLOOKUP, VLOOKUP and LOOKUP formulas-en_US.srt | 10.8 KB | ||
| 5. The HLOOKUP, VLOOKUP and LOOKUP formulas.mp4 | 31 MB | ||
| 5. XIRR-en_US.srt | 2.2 KB | ||
| 5. XIRR.mp4 | 6.2 MB | ||
| 6. Changes protect a workbook-en_US.srt | 3.5 KB | ||
| 6. Changes protect a workbook.mp4 | 11.7 MB | ||
| 6. Complex filters-en_US.srt | 3.2 KB | ||
| 6. Complex filters.mp4 | 13.9 MB | ||
| 6. Conditional formatting - Recap of the benefits-en_US.srt | 1.3 KB | ||
| 6. Conditional formatting - Recap of the benefits.mp4 | 4.2 MB | ||
| 6. Data tools - Data validation-en_US.srt | 8.7 KB | ||
| 6. Data tools - Data validation.mp4 | 24.1 MB | ||
| 6. Pie charts-en_US.srt | 6.8 KB | ||
| 6. Pie charts.mp4 | 33.2 MB | ||
| 6. Proofing-en_US.srt | 11.3 KB | ||
| 6. Proofing.mp4 | 23.8 MB | ||
| 6. The CLEAN formula-en_US.srt | 1.4 KB | ||
| 6. The CLEAN formula.mp4 | 3.6 MB | ||
| 6. The FORMULATEXT formula-en_US.srt | 614.4 B | ||
| 6. The FORMULATEXT formula.mp4 | 2 MB | ||
| 6. The MONTH formula-en_US.srt | 512 B | ||
| 6. The MONTH formula.mp4 | 1.2 MB | ||
| 6. Understand the concept of formula-en_US.srt | 10.3 KB | ||
| 6. Understand the concept of formula.mp4 | 24.3 MB | ||
| 7. Conditional formatting create new rules-en_US.srt | 4.9 KB | ||
| 7. Conditional formatting create new rules.mp4 | 18.4 MB | ||
| 7. Find & Select-en_US.srt | 6.4 KB | ||
| 7. Find & Select.mp4 | 26.3 MB | ||
| 7. Group Data-en_US.srt | 6.1 KB | ||
| 7. Group Data.mp4 | 19.7 MB | ||
| 7. Modify charts-en_US.srt | 8.6 KB | ||
| 7. Modify charts.mp4 | 41 MB | ||
| 7. Save-en_US.srt | 4.9 KB | ||
| 7. Save.mp4 | 10.9 MB | ||
| 7. The CODE formula-en_US.srt | 1.4 KB | ||
| 7. The CODE formula.mp4 | 4.5 MB | ||
| 7. The INDEX formula-en_US.srt | 1 KB | ||
| 7. The INDEX formula.mp4 | 2.9 MB | ||
| 7. The YEAR formula-en_US.srt | 614.4 B | ||
| 7. The YEAR formula.mp4 | 1.8 MB | ||
| 8. Conditional formatting customize formats-en_US.srt | 5.2 KB | ||
| 8. Conditional formatting customize formats.mp4 | 17.9 MB | ||
| 8. Find & Select Advanced-en_US.srt | 8.2 KB | ||
| 8. Find & Select Advanced.mp4 | 31.6 MB | ||
| 8. Generate Subtotals-en_US.srt | 5.6 KB | ||
| 8. Generate Subtotals.mp4 | 19 MB | ||
| 8. Language-en_US.srt | 2.6 KB | ||
| 8. Language.mp4 | 4.7 MB | ||
| 8. Tables and charts-en_US.srt | 6.2 KB | ||
| 8. Tables and charts.mp4 | 25.1 MB | ||
| 8. The EDATE formula-en_US.srt | 2.2 KB | ||
| 8. The EDATE formula.mp4 | 6.3 MB | ||
| 8. The FIND formula-en_US.srt | 2 KB | ||
| 8. The FIND formula.mp4 | 4.9 MB | ||
| 8. The INDIRECT formula-en_US.srt | 819.2 B | ||
| 8. The INDIRECT formula.mp4 | 2.6 MB | ||
| 9. Advanced options-en_US.srt | 11.6 KB | ||
| 9. Advanced options.mp4 | 37.6 MB | ||
| 9. Format Tables-en_US.srt | 9.2 KB | ||
| 9. Format Tables.mp4 | 41.7 MB | ||
| 9. Overview of other chart types-en_US.srt | 6.9 KB | ||
| 9. Overview of other chart types.mp4 | 26.7 MB | ||
| 9. The EOMONTH formula-en_US.srt | 2.1 KB | ||
| 9. The EOMONTH formula.mp4 | 6.1 MB | ||
| 9. The FIXED and NUMBERVALUE formulas-en_US.srt | 4.1 KB | ||
| 9. The FIXED and NUMBERVALUE formulas.mp4 | 11.2 MB | ||
| 9. The MATCH formula-en_US.srt | 512 B | ||
| 9. The MATCH formula.mp4 | 1.3 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Exercise #1.html | 2.8 KB | ||
| Exercise #2.html | 7.6 KB | ||
| Exercise #3.html | 2 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| excel-example-udemy-training-8.xlsx | 333.3 KB | ||
| ▲ 296 total files | |||
Excel: the next level. Expert with formulas and charts
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.89 GB | Duration: 11h 7m
Learn how to use Excel formulas and functions, create complex pivot tables and charts, generate reports with charts
What you'll learn
Students will be able to create complex Excel reports with formulas and charts
Students will be able to dominate Microsoft Excel
Students will be able to generate reports in many business sectors: scientific, finance, business management, business administration, project management
Requirements
Know how to use the computer (Windows, Mac)
Have basic knowledge of Microsoft Excel
Description
This is a course for those who are already familiar with Microsoft Excel but need to move to the next level and understand how to create professional reports which require strong calculations and graphical representations of the data and data flow.
The students get a first overview of the Info and Options areas where a lot of information and configuration is done in order to setup your files and report in the correct way.
The course includes then:
An overview of the functionalities and options of the different ribbons
information about how to create advanced formatting using the conditional formatting functionalities
instructions about how to define data validation for set of cells and ranges
explanations of the main formulas and functions, especially about text, lookup & reference, information, logical, and more
instructions about how to create and format charts will different set of data
tutorial on how to create and manage pivot tables and charts
instructions to protect a worksheet (entirely or partially) and a workbook
At the end the students will be able to generate complex report, separating data from formulas, formatting tables, generate easily charts and modify them at a glance is a few clicks.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 272 MB | freecoursewb | 4 weeks | 19 | 6 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 1 month | 10 | 7 |
| 2.7 GB | freecoursewb | 2 months | 12 | 1 | |
| 2.7 GB | freecoursewb | 2 months | 18 | 1 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 2 months | 9 | 5 |
All Comments