Udemy - Microsoft Excel 2016 Advanced Training Master Class

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 3.0 GB
  • Uploaded By freecoursewb
  • Downloads 248
  • Last checked 9 hours ago
  • Date uploaded 3 years ago
  • Seeders 9
  • Leechers 4

Infohash : 134216C14F96B0C5F77FB86BAD4C2A87A5084966



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.

Files:

[ DevCourseWeb.com ] Udemy - Microsoft Excel 2016 Advanced Training Master Class
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction to Excel 2016 Advanced Course
    • 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)
    • 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)
    • 3 - DOWNLOAD ME Excel 2016 Advanced Course Exercise Files.html (0.9 KB)
    • 4 - DOWNLOAD ME Excel 2016 Advanced Course Demo Files.html (0.9 KB)
    • 5 - Downloadable Course Transcripts.html (0.7 KB)
    • 5 - Microsoft-Excel-2016-Advanced-Training-Master-Class-by-Simon-Sez-IT.pdf (1.3 MB)
    • 6 - Course Structure English.vtt (6.8 KB)
    • 6 - Course Structure.mp4 (15.5 MB)
      • Excel 2016 Advanced Course Files
      • ImportText1.txt (1.0 KB)
      • SimonSezIT_Access_Database_Connection.xlsx (363.0 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.0 KB)
      • SimonSezIT_Depreciation.xlsx (10.3 KB)
      • SimonSezIT_EspritDeTour21.accdb (6.2 MB)
      • SimonSezIT_Excel2016Advanced_Tables_1.xlsx (18.8 KB)
      • SimonSezIT_Financial_Functions_1.xlsx (10.2 KB)
      • SimonSezIT_Get_and_Transform.xlsx (18.0 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.0 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.0 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 (0.2 KB)
      Excel 2016 Advanced Exercise Files
      • 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.0 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.0 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)
      10 - Tables
      • 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)
      • 40 - Table Styles English.vtt (6.4 KB)
      • 40 - Table Styles.mp4 (13.1 MB)
      • 41 - Exercise 06 English.vtt (2.0 KB)
      • 41 - Exercise 06.mp4 (3.9 MB)
      11 - Pivot Tables
      • 42 - Introduction to Pivot Tables English.vtt (14.0 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)
      12 - Data Analysis
      • 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)
      • 50 - Solver English.vtt (14.7 KB)
      • 50 - Solver.mp4 (33.1 MB)
      • 51 - Exercise 08 English.vtt (2.0 KB)
      • 51 - Exercise 08.mp4 (4.8 MB)
      13 - Graphs and Charts
      • 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.0 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)
      14 - Excel Web App
      • 59 - Web App Part 1 English.vtt (13.1 KB)
      • 59 - Web App Part 1.mp4 (28.0 MB)
      • 60 - Web App Part 2 English.vtt (14.0 KB)
      • 60 - Web App Part 2.mp4 (28.2 MB)
      15 - Conclusion
      • 61 - Closing Message English.vtt (1.1 KB)
      • 61 - Closing Message.mp4 (1.5 MB)
      16 - Extras
      • 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.0 KB)
      • 63 - PC-Excel-Most-Used.pdf (2.2 MB)
      17 - Bonuses
      • 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)
      2 - Functions
      • 7 - Functions Part 1 English.vtt (19.3 KB)
      • 7 - Functions Part 1.mp4 (40.6 MB)
      • 8 - Functions Part 2 English.vtt (7.0 KB)
      • 8 - Functions Part 2.mp4 (27.9 MB)
      • 9 - Autosum English.vtt (6.6 KB)
      • 9 - Autosum.mp4 (15.8 MB)
      3 - Date and Time Functions
      • 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)
      4 - Text Functions
      • 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)
      5 - Logical Functions
      • 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)
      6 - Lookup Functions
      • 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)
      7 - Financial Functions
      • 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)
      8 - Statistical Functions
      • 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)
      • 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)
      9 - Connecting to External Data
      • 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)
      • Bonus Resources.txt (0.4 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce
EDGE-CACHE ⚡ EC (hit) 📄 torrent 🕐 22 Jan 2026, 06:45:40 pm IST ⏰ 16 Feb 2026, 06:45:39 pm IST ✅ Valid for 19d 7h 🔄 Refresh Cache