| 1 - Prerequisites of the Course and Version of Excel English.vtt | 11.5 KB | ||
| 1 - Prerequisites of the Course and Version of Excel.mp4 | 26.2 MB | ||
| 10 - How Date and Time Works English.vtt | 13.5 KB | ||
| 10 - How Date and Time Works.mp4 | 28.5 MB | ||
| 11 - Basic Date and Time Functions English.vtt | 13.5 KB | ||
| 11 - Basic Date and Time Functions.mp4 | 26.6 MB | ||
| 12 - Complex Date and Time Functions English.vtt | 17.9 KB | ||
| 12 - Complex Date and Time Functions.mp4 | 37.6 MB | ||
| 13 - Using Text Functions Part 1 English.vtt | 17.5 KB | ||
| 13 - Using Text Functions Part 1.mp4 | 43.1 MB | ||
| 14 - Using Text Functions Part 2 English.vtt | 15.8 KB | ||
| 14 - Using Text Functions Part 2.mp4 | 53.5 MB | ||
| 15 - Using Logical Functions English.vtt | 11.9 KB | ||
| 15 - Using Logical Functions.mp4 | 26.8 MB | ||
| 16 - Exercise 01 English.vtt | 2.9 KB | ||
| 16 - Exercise 01.mp4 | 4.7 MB | ||
| 17 - HLOOKUP Function English.vtt | 17.7 KB | ||
| 17 - HLOOKUP Function.mp4 | 43.4 MB | ||
| 18 - VLOOKUP Function English.vtt | 10.6 KB | ||
| 18 - VLOOKUP Function.mp4 | 30.6 MB | ||
| 19 - Exercise 02 English.vtt | 7.7 KB | ||
| 19 - Exercise 02.mp4 | 17.5 MB | ||
| 2 - WATCH ME Essential Information for a Successful Training Experience English.vtt | 1.8 KB | ||
| 2 - WATCH ME Essential Information for a Successful Training Experience.mp4 | 37.9 MB | ||
| 20 - Financial Functions and Terminology English.vtt | 14.3 KB | ||
| 20 - Financial Functions and Terminology.mp4 | 28.3 MB | ||
| 21 - Personal Financial Functions English.vtt | 12.9 KB | ||
| 21 - Personal Financial Functions.mp4 | 30.9 MB | ||
| 22 - Professional Financial Functions English.vtt | 8.5 KB | ||
| 22 - Professional Financial Functions.mp4 | 21.9 MB | ||
| 23 - Depreciation English.vtt | 5.4 KB | ||
| 23 - Depreciation.mp4 | 14.4 MB | ||
| 24 - Exercise 03 English.vtt | 2.3 KB | ||
| 24 - Exercise 03.mp4 | 5.3 MB | ||
| 25 - Statistical Functions for Description Part 1 English.vtt | 16.8 KB | ||
| 25 - Statistical Functions for Description Part 1.mp4 | 39.8 MB | ||
| 26 - Statistical Functions for Description Part 2 English.vtt | 16.6 KB | ||
| 26 - Statistical Functions for Description Part 2.mp4 | 38.3 MB | ||
| 27 - Statistical Functions for Forecasting Part 1 English.vtt | 11.7 KB | ||
| 27 - Statistical Functions for Forecasting Part 1.mp4 | 27.2 MB | ||
| 28 - Statistical Functions for Forecasting Part 2 English.vtt | 15.4 KB | ||
| 28 - Statistical Functions for Forecasting Part 2.mp4 | 36.3 MB | ||
| 29 - Exercise 04 English.vtt | 2.2 KB | ||
| 29 - Exercise 04.mp4 | 4.2 MB | ||
| 3 - DOWNLOAD ME Excel 2016 Advanced Course Exercise Files.html | 921.6 B | ||
| 30 - One Click Forecasting English.vtt | 12.1 KB | ||
| 30 - One Click Forecasting.mp4 | 24.7 MB | ||
| 31 - Statistical Functions for Inference English.vtt | 13.2 KB | ||
| 31 - Statistical Functions for Inference.mp4 | 31.8 MB | ||
| 32 - Connecting to Other Workbooks English.vtt | 19.1 KB | ||
| 32 - Connecting to Other Workbooks.mp4 | 43.4 MB | ||
| 33 - Connecting to Access Databases English.vtt | 18.8 KB | ||
| 33 - Connecting to Access Databases.mp4 | 40.1 MB | ||
| 34 - Connecting to Web Data Sources English.vtt | 12.8 KB | ||
| 34 - Connecting to Web Data Sources.mp4 | 29.4 MB | ||
| 35 - Get and Transform English.vtt | 19.6 KB | ||
| 35 - Get and Transform.mp4 | 39.2 MB | ||
| 36 - Exercise 05 English.vtt | 8.2 KB | ||
| 36 - Exercise 05.mp4 | 15.4 MB | ||
| 37 - Introduction to Tables English.vtt | 16.2 KB | ||
| 37 - Introduction to Tables.mp4 | 33.5 MB | ||
| 38 - Working with Tables English.vtt | 13.6 KB | ||
| 38 - Working with Tables.mp4 | 28.1 MB | ||
| 39 - Table References English.vtt | 9.5 KB | ||
| 39 - Table References.mp4 | 24.4 MB | ||
| 4 - DOWNLOAD ME Excel 2016 Advanced Course Demo Files.html | 921.6 B | ||
| 40 - Table Styles English.vtt | 6.4 KB | ||
| 40 - Table Styles.mp4 | 13.1 MB | ||
| 41 - Exercise 06 English.vtt | 2 KB | ||
| 41 - Exercise 06.mp4 | 3.9 MB | ||
| 42 - Introduction to Pivot Tables English.vtt | 14 KB | ||
| 42 - Introduction to Pivot Tables.mp4 | 27.9 MB | ||
| 43 - Working with Pivot Tables English.vtt | 18.3 KB | ||
| 43 - Working with Pivot Tables.mp4 | 40.2 MB | ||
| 44 - Filters and Slicers English.vtt | 18.4 KB | ||
| 44 - Filters and Slicers.mp4 | 38.7 MB | ||
| 45 - Pivot Charts English.vtt | 11.2 KB | ||
| 45 - Pivot Charts.mp4 | 22.4 MB | ||
| 46 - Exercise 07 English.vtt | 3.4 KB | ||
| 46 - Exercise 07.mp4 | 6.9 MB | ||
| 47 - What If Analysis English.vtt | 16.5 KB | ||
| 47 - What If Analysis.mp4 | 35.1 MB | ||
| 48 - Scenario Manager English.vtt | 12.8 KB | ||
| 48 - Scenario Manager.mp4 | 41.2 MB | ||
| 49 - Goal Seek English.vtt | 8.5 KB | ||
| 49 - Goal Seek.mp4 | 17.5 MB | ||
| 5 - Downloadable Course Transcripts.html | 716.8 B | ||
| 5 - Microsoft-Excel-2016-Advanced-Training-Master-Class-by-Simon-Sez-IT.pdf | 1.3 MB | ||
| 50 - Solver English.vtt | 14.7 KB | ||
| 50 - Solver.mp4 | 33.1 MB | ||
| 51 - Exercise 08 English.vtt | 2 KB | ||
| 51 - Exercise 08.mp4 | 4.8 MB | ||
| 52 - Area Charts English.vtt | 8.7 KB | ||
| 52 - Area Charts.mp4 | 26.2 MB | ||
| 53 - Surface Charts English.vtt | 5.8 KB | ||
| 53 - Surface Charts.mp4 | 13.3 MB | ||
| 54 - Radar Charts English.vtt | 6.6 KB | ||
| 54 - Radar Charts.mp4 | 14.4 MB | ||
| 55 - Bubble Charts English.vtt | 8.8 KB | ||
| 55 - Bubble Charts.mp4 | 17.3 MB | ||
| 56 - Sparklines English.vtt | 11.7 KB | ||
| 56 - Sparklines.mp4 | 49 MB | ||
| 57 - Stock Charts English.vtt | 13.2 KB | ||
| 57 - Stock Charts.mp4 | 41.8 MB | ||
| 58 - Exercise 09 English.vtt | 5.4 KB | ||
| 58 - Exercise 09.mp4 | 14.6 MB | ||
| 59 - Web App Part 1 English.vtt | 13.1 KB | ||
| 59 - Web App Part 1.mp4 | 28 MB | ||
| 6 - Course Structure English.vtt | 6.8 KB | ||
| 6 - Course Structure.mp4 | 15.5 MB | ||
| 60 - Web App Part 2 English.vtt | 14 KB | ||
| 60 - Web App Part 2.mp4 | 28.2 MB | ||
| 61 - Closing Message English.vtt | 1.1 KB | ||
| 61 - Closing Message.mp4 | 1.5 MB | ||
| 62 - EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar English.vtt | 75.3 KB | ||
| 62 - EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4 | 555.4 MB | ||
| 63 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html | 0 B | ||
| 63 - PC-Excel-Most-Used.pdf | 2.2 MB | ||
| 64 - Ten Excel Tips and Tricks Part 1 English.vtt | 55.1 KB | ||
| 64 - Ten Excel Tips and Tricks Part 1.mp4 | 336.7 MB | ||
| 65 - Ten Excel Tips and Tricks Part 2 English.vtt | 52.2 KB | ||
| 65 - Ten Excel Tips and Tricks Part 2.mp4 | 293.8 MB | ||
| 66 - Ten Excel Tips and Tricks Part 3 English.vtt | 41.9 KB | ||
| 66 - Ten Excel Tips and Tricks Part 3.mp4 | 317.7 MB | ||
| 7 - Functions Part 1 English.vtt | 19.3 KB | ||
| 7 - Functions Part 1.mp4 | 40.6 MB | ||
| 8 - Functions Part 2 English.vtt | 7 KB | ||
| 8 - Functions Part 2.mp4 | 27.9 MB | ||
| 9 - Autosum English.vtt | 6.6 KB | ||
| 9 - Autosum.mp4 | 15.8 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ImportText1.txt | 1 KB | ||
| SimonSezIT_Access_Database_Connection.xlsx | 363 KB | ||
| SimonSezIT_Bubble_Charts_1.xlsx | 15.4 KB | ||
| SimonSezIT_Connecting_to_Web_Data.xlsx | 11.6 KB | ||
| SimonSezIT_Date_Functions_1.xlsx | 9.9 KB | ||
| SimonSezIT_Date_Functions_2.xlsx | 10 KB | ||
| SimonSezIT_Depreciation.xlsx | 10.3 KB | ||
| SimonSezIT_EspritDeTour21.accdb | 6.2 MB | ||
| SimonSezIT_Excel2016Advanced_Exercise_01_Answer.xlsx | 8.9 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_02.xlsx | 16.1 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_02_Answer.xlsx | 16.6 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_03.xlsx | 10.6 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_03_Answer.xlsx | 11 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_04.xlsx | 9.9 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_04_Answer.xlsx | 10.6 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_05_Answer.xlsx | 23.3 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_06.xlsx | 19.3 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_06_Answer.xlsx | 19.3 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_07.xlsx | 718.4 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_07_Answer.xlsx | 995.3 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_08.xlsx | 9 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_08_Answer.xlsx | 9.7 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_09.csv | 483.3 KB | ||
| SimonSezIT_Excel2016Advanced_Exercise_09_Answer.xlsx | 418.5 KB | ||
| SimonSezIT_Excel2016Advanced_Tables_1.xlsx | 18.8 KB | ||
| SimonSezIT_Financial_Functions_1.xlsx | 10.2 KB | ||
| SimonSezIT_Get_and_Transform.xlsx | 18 KB | ||
| SimonSezIT_Goal_Seek_1.xlsx | 8.7 KB | ||
| SimonSezIT_Goal_Seek_2.xlsx | 8.8 KB | ||
| SimonSezIT_Logical_Functions_1.xlsx | 8.8 KB | ||
| SimonSezIT_Logical_Functions_2.xlsx | 16.4 KB | ||
| SimonSezIT_Lookup_Functions_1.xlsx | 9.3 KB | ||
| SimonSezIT_Lookup_Functions_2.xlsx | 10.5 KB | ||
| SimonSezIT_Lookup_Functions_3.xlsx | 16 KB | ||
| SimonSezIT_One_Click_Forecasting.xlsx | 17.7 KB | ||
| SimonSezIT_Personal_Financial_Functions_1.xlsx | 9.1 KB | ||
| SimonSezIT_Personal_Financial_Functions_2.xlsx | 10.3 KB | ||
| SimonSezIT_Policy_Sales_1.xlsm | 56.2 KB | ||
| SimonSezIT_Policy_Sales_2.xlsm | 55.9 KB | ||
| SimonSezIT_Policy_Sales_3.xlsm | 57.8 KB | ||
| SimonSezIT_Policy_Sales_4.xlsm | 56.9 KB | ||
| SimonSezIT_Policy_Sales_5.xlsm | 58.8 KB | ||
| SimonSezIT_Principal_and_Interest.xlsx | 19.3 KB | ||
| SimonSezIT_Radar_Charts_1.xlsx | 13.7 KB | ||
| SimonSezIT_Regression_Functions_1.xlsx | 9.1 KB | ||
| SimonSezIT_Regression_Functions_2.xlsx | 10.1 KB | ||
| SimonSezIT_Regression_Functions_3.xlsx | 10 KB | ||
| SimonSezIT_Regression_Functions_4.xlsx | 10.3 KB | ||
| SimonSezIT_Scenario_Manager_1.xlsx | 13.5 KB | ||
| SimonSezIT_Solver_1.xlsx | 9.9 KB | ||
| SimonSezIT_South_American_Branch_Sales_1.xlsx | 10.3 KB | ||
| SimonSezIT_South_American_Branch_Sales_Bogota.xlsx | 8.8 KB | ||
| SimonSezIT_South_American_Branch_Sales_Lima.xlsx | 9.9 KB | ||
| SimonSezIT_South_American_Branch_Sales_Summary.xlsx | 10.4 KB | ||
| SimonSezIT_Sparklines.xlsx | 267.7 KB | ||
| SimonSezIT_Statistical_Inference_1.xlsx | 9.6 KB | ||
| SimonSezIT_Stock_Charts_1.xlsx | 16.2 KB | ||
| SimonSezIT_Store_Data_1.xlsx | 834.2 KB | ||
| SimonSezIT_Store_Data_2.xlsx | 841.8 KB | ||
| SimonSezIT_Store_Data_3.xlsx | 842.5 KB | ||
| SimonSezIT_Store_Data_4.xlsx | 846.1 KB | ||
| SimonSezIT_Surface_Charts_1.xlsx | 14.1 KB | ||
| SimonSezIT_Tables_2.xlsx | 18.8 KB | ||
| SimonSezIT_Tables_3.xlsx | 18.9 KB | ||
| SimonSezIT_Team_Monthly_Sales.xlsx | 273.1 KB | ||
| SimonSezIT_Text_Functions_1.xlsx | 12.2 KB | ||
| SimonSezIT_Text_Functions_2.xlsx | 16.1 KB | ||
| SimonSezIT_What-If_1.xlsx | 11.3 KB | ||
| ~$SimonSezIT_Store_Data_2.xlsx | 204.8 B | ||
| ▲ 201 total files | |||
Microsoft Excel 2016 Advanced Training Master Class
https://DevCourseWeb.com
Last updated 12/2022
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.00 GB | Duration: 12h 7m
The ultimate next step for anyone interested in supercharging their MS Excel and data analysis skills
What you'll learn
Working with dates and times
Averages, percentiles, and LINEST functions
Calculating depreciation
Inserting and formatting tables
Sparklines and data bars
Pivot charts
How to import and export data to and from Excel
Create and effectively use pivot tables
How to use Excel for data analysis
Discover practical methods for financial & statistical Functions
Using financial functions to determine payments
Practice what you learned with included exercise files
Requirements
Microsoft Excel 2016 desktop version for Windows installed and ready to use on your computer.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 2 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 3 weeks | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 3 weeks | 9 | 5 |
| 999.5 MB | freecoursewb | 3 weeks | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 3 weeks | 6 | 1 |
All Comments