|
|
1 - Prerequisites of the Course and Version of Excel English.vtt
|
VTT
|
11.5 KB
|
|
|
1 - Prerequisites of the Course and Version of Excel.mp4
|
MP4
|
26.2 MB
|
|
|
10 - How Date and Time Works English.vtt
|
VTT
|
13.5 KB
|
|
|
10 - How Date and Time Works.mp4
|
MP4
|
28.5 MB
|
|
|
11 - Basic Date and Time Functions English.vtt
|
VTT
|
13.5 KB
|
|
|
11 - Basic Date and Time Functions.mp4
|
MP4
|
26.6 MB
|
|
|
12 - Complex Date and Time Functions English.vtt
|
VTT
|
17.9 KB
|
|
|
12 - Complex Date and Time Functions.mp4
|
MP4
|
37.6 MB
|
|
|
13 - Using Text Functions Part 1 English.vtt
|
VTT
|
17.5 KB
|
|
|
13 - Using Text Functions Part 1.mp4
|
MP4
|
43.1 MB
|
|
|
14 - Using Text Functions Part 2 English.vtt
|
VTT
|
15.8 KB
|
|
|
14 - Using Text Functions Part 2.mp4
|
MP4
|
53.5 MB
|
|
|
15 - Using Logical Functions English.vtt
|
VTT
|
11.9 KB
|
|
|
15 - Using Logical Functions.mp4
|
MP4
|
26.8 MB
|
|
|
16 - Exercise 01 English.vtt
|
VTT
|
2.9 KB
|
|
|
16 - Exercise 01.mp4
|
MP4
|
4.7 MB
|
|
|
17 - HLOOKUP Function English.vtt
|
VTT
|
17.7 KB
|
|
|
17 - HLOOKUP Function.mp4
|
MP4
|
43.4 MB
|
|
|
18 - VLOOKUP Function English.vtt
|
VTT
|
10.6 KB
|
|
|
18 - VLOOKUP Function.mp4
|
MP4
|
30.6 MB
|
|
|
19 - Exercise 02 English.vtt
|
VTT
|
7.7 KB
|
|
|
19 - Exercise 02.mp4
|
MP4
|
17.5 MB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience English.vtt
|
VTT
|
1.8 KB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
37.9 MB
|
|
|
20 - Financial Functions and Terminology English.vtt
|
VTT
|
14.3 KB
|
|
|
20 - Financial Functions and Terminology.mp4
|
MP4
|
28.3 MB
|
|
|
21 - Personal Financial Functions English.vtt
|
VTT
|
12.9 KB
|
|
|
21 - Personal Financial Functions.mp4
|
MP4
|
30.9 MB
|
|
|
22 - Professional Financial Functions English.vtt
|
VTT
|
8.5 KB
|
|
|
22 - Professional Financial Functions.mp4
|
MP4
|
21.9 MB
|
|
|
23 - Depreciation English.vtt
|
VTT
|
5.4 KB
|
|
|
23 - Depreciation.mp4
|
MP4
|
14.4 MB
|
|
|
24 - Exercise 03 English.vtt
|
VTT
|
2.3 KB
|
|
|
24 - Exercise 03.mp4
|
MP4
|
5.3 MB
|
|
|
25 - Statistical Functions for Description Part 1 English.vtt
|
VTT
|
16.8 KB
|
|
|
25 - Statistical Functions for Description Part 1.mp4
|
MP4
|
39.8 MB
|
|
|
26 - Statistical Functions for Description Part 2 English.vtt
|
VTT
|
16.6 KB
|
|
|
26 - Statistical Functions for Description Part 2.mp4
|
MP4
|
38.3 MB
|
|
|
27 - Statistical Functions for Forecasting Part 1 English.vtt
|
VTT
|
11.7 KB
|
|
|
27 - Statistical Functions for Forecasting Part 1.mp4
|
MP4
|
27.2 MB
|
|
|
28 - Statistical Functions for Forecasting Part 2 English.vtt
|
VTT
|
15.4 KB
|
|
|
28 - Statistical Functions for Forecasting Part 2.mp4
|
MP4
|
36.3 MB
|
|
|
29 - Exercise 04 English.vtt
|
VTT
|
2.2 KB
|
|
|
29 - Exercise 04.mp4
|
MP4
|
4.2 MB
|
|
|
3 - DOWNLOAD ME Excel 2016 Advanced Course Exercise Files.html
|
HTML
|
921.6 B
|
|
|
30 - One Click Forecasting English.vtt
|
VTT
|
12.1 KB
|
|
|
30 - One Click Forecasting.mp4
|
MP4
|
24.7 MB
|
|
|
31 - Statistical Functions for Inference English.vtt
|
VTT
|
13.2 KB
|
|
|
31 - Statistical Functions for Inference.mp4
|
MP4
|
31.8 MB
|
|
|
32 - Connecting to Other Workbooks English.vtt
|
VTT
|
19.1 KB
|
|
|
32 - Connecting to Other Workbooks.mp4
|
MP4
|
43.4 MB
|
|
|
33 - Connecting to Access Databases English.vtt
|
VTT
|
18.8 KB
|
|
|
33 - Connecting to Access Databases.mp4
|
MP4
|
40.1 MB
|
|
|
34 - Connecting to Web Data Sources English.vtt
|
VTT
|
12.8 KB
|
|
|
34 - Connecting to Web Data Sources.mp4
|
MP4
|
29.4 MB
|
|
|
35 - Get and Transform English.vtt
|
VTT
|
19.6 KB
|
|
|
35 - Get and Transform.mp4
|
MP4
|
39.2 MB
|
|
|
36 - Exercise 05 English.vtt
|
VTT
|
8.2 KB
|
|
|
36 - Exercise 05.mp4
|
MP4
|
15.4 MB
|
|
|
37 - Introduction to Tables English.vtt
|
VTT
|
16.2 KB
|
|
|
37 - Introduction to Tables.mp4
|
MP4
|
33.5 MB
|
|
|
38 - Working with Tables English.vtt
|
VTT
|
13.6 KB
|
|
|
38 - Working with Tables.mp4
|
MP4
|
28.1 MB
|
|
|
39 - Table References English.vtt
|
VTT
|
9.5 KB
|
|
|
39 - Table References.mp4
|
MP4
|
24.4 MB
|
|
|
4 - DOWNLOAD ME Excel 2016 Advanced Course Demo Files.html
|
HTML
|
921.6 B
|
|
|
40 - Table Styles English.vtt
|
VTT
|
6.4 KB
|
|
|
40 - Table Styles.mp4
|
MP4
|
13.1 MB
|
|
|
41 - Exercise 06 English.vtt
|
VTT
|
2 KB
|
|
|
41 - Exercise 06.mp4
|
MP4
|
3.9 MB
|
|
|
42 - Introduction to Pivot Tables English.vtt
|
VTT
|
14 KB
|
|
|
42 - Introduction to Pivot Tables.mp4
|
MP4
|
27.9 MB
|
|
|
43 - Working with Pivot Tables English.vtt
|
VTT
|
18.3 KB
|
|
|
43 - Working with Pivot Tables.mp4
|
MP4
|
40.2 MB
|
|
|
44 - Filters and Slicers English.vtt
|
VTT
|
18.4 KB
|
|
|
44 - Filters and Slicers.mp4
|
MP4
|
38.7 MB
|
|
|
45 - Pivot Charts English.vtt
|
VTT
|
11.2 KB
|
|
|
45 - Pivot Charts.mp4
|
MP4
|
22.4 MB
|
|
|
46 - Exercise 07 English.vtt
|
VTT
|
3.4 KB
|
|
|
46 - Exercise 07.mp4
|
MP4
|
6.9 MB
|
|
|
47 - What If Analysis English.vtt
|
VTT
|
16.5 KB
|
|
|
47 - What If Analysis.mp4
|
MP4
|
35.1 MB
|
|
|
48 - Scenario Manager English.vtt
|
VTT
|
12.8 KB
|
|
|
48 - Scenario Manager.mp4
|
MP4
|
41.2 MB
|
|
|
49 - Goal Seek English.vtt
|
VTT
|
8.5 KB
|
|
|
49 - Goal Seek.mp4
|
MP4
|
17.5 MB
|
|
|
5 - Downloadable Course Transcripts.html
|
HTML
|
716.8 B
|
|
|
5 - Microsoft-Excel-2016-Advanced-Training-Master-Class-by-Simon-Sez-IT.pdf
|
PDF
|
1.3 MB
|
|
|
50 - Solver English.vtt
|
VTT
|
14.7 KB
|
|
|
50 - Solver.mp4
|
MP4
|
33.1 MB
|
|
|
51 - Exercise 08 English.vtt
|
VTT
|
2 KB
|
|
|
51 - Exercise 08.mp4
|
MP4
|
4.8 MB
|
|
|
52 - Area Charts English.vtt
|
VTT
|
8.7 KB
|
|
|
52 - Area Charts.mp4
|
MP4
|
26.2 MB
|
|
|
53 - Surface Charts English.vtt
|
VTT
|
5.8 KB
|
|
|
53 - Surface Charts.mp4
|
MP4
|
13.3 MB
|
|
|
54 - Radar Charts English.vtt
|
VTT
|
6.6 KB
|
|
|
54 - Radar Charts.mp4
|
MP4
|
14.4 MB
|
|
|
55 - Bubble Charts English.vtt
|
VTT
|
8.8 KB
|
|
|
55 - Bubble Charts.mp4
|
MP4
|
17.3 MB
|
|
|
56 - Sparklines English.vtt
|
VTT
|
11.7 KB
|
|
|
56 - Sparklines.mp4
|
MP4
|
49 MB
|
|
|
57 - Stock Charts English.vtt
|
VTT
|
13.2 KB
|
|
|
57 - Stock Charts.mp4
|
MP4
|
41.8 MB
|
|
|
58 - Exercise 09 English.vtt
|
VTT
|
5.4 KB
|
|
|
58 - Exercise 09.mp4
|
MP4
|
14.6 MB
|
|
|
59 - Web App Part 1 English.vtt
|
VTT
|
13.1 KB
|
|
|
59 - Web App Part 1.mp4
|
MP4
|
28 MB
|
|
|
6 - Course Structure English.vtt
|
VTT
|
6.8 KB
|
|
|
6 - Course Structure.mp4
|
MP4
|
15.5 MB
|
|
|
60 - Web App Part 2 English.vtt
|
VTT
|
14 KB
|
|
|
60 - Web App Part 2.mp4
|
MP4
|
28.2 MB
|
|
|
61 - Closing Message English.vtt
|
VTT
|
1.1 KB
|
|
|
61 - Closing Message.mp4
|
MP4
|
1.5 MB
|
|
|
62 - EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar English.vtt
|
VTT
|
75.3 KB
|
|
|
62 - EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar.mp4
|
MP4
|
555.4 MB
|
|
|
63 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html
|
HTML
|
0 B
|
|
|
63 - PC-Excel-Most-Used.pdf
|
PDF
|
2.2 MB
|
|
|
64 - Ten Excel Tips and Tricks Part 1 English.vtt
|
VTT
|
55.1 KB
|
|
|
64 - Ten Excel Tips and Tricks Part 1.mp4
|
MP4
|
336.7 MB
|
|
|
65 - Ten Excel Tips and Tricks Part 2 English.vtt
|
VTT
|
52.2 KB
|
|
|
65 - Ten Excel Tips and Tricks Part 2.mp4
|
MP4
|
293.8 MB
|
|
|
66 - Ten Excel Tips and Tricks Part 3 English.vtt
|
VTT
|
41.9 KB
|
|
|
66 - Ten Excel Tips and Tricks Part 3.mp4
|
MP4
|
317.7 MB
|
|
|
7 - Functions Part 1 English.vtt
|
VTT
|
19.3 KB
|
|
|
7 - Functions Part 1.mp4
|
MP4
|
40.6 MB
|
|
|
8 - Functions Part 2 English.vtt
|
VTT
|
7 KB
|
|
|
8 - Functions Part 2.mp4
|
MP4
|
27.9 MB
|
|
|
9 - Autosum English.vtt
|
VTT
|
6.6 KB
|
|
|
9 - Autosum.mp4
|
MP4
|
15.8 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
ImportText1.txt
|
TXT
|
1 KB
|
|
|
SimonSezIT_Access_Database_Connection.xlsx
|
XLSX
|
363 KB
|
|
|
SimonSezIT_Bubble_Charts_1.xlsx
|
XLSX
|
15.4 KB
|
|
|
SimonSezIT_Connecting_to_Web_Data.xlsx
|
XLSX
|
11.6 KB
|
|
|
SimonSezIT_Date_Functions_1.xlsx
|
XLSX
|
9.9 KB
|
|
|
SimonSezIT_Date_Functions_2.xlsx
|
XLSX
|
10 KB
|
|
|
SimonSezIT_Depreciation.xlsx
|
XLSX
|
10.3 KB
|
|
|
SimonSezIT_EspritDeTour21.accdb
|
ACCDB
|
6.2 MB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_01_Answer.xlsx
|
XLSX
|
8.9 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_02.xlsx
|
XLSX
|
16.1 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_02_Answer.xlsx
|
XLSX
|
16.6 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_03.xlsx
|
XLSX
|
10.6 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_03_Answer.xlsx
|
XLSX
|
11 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_04.xlsx
|
XLSX
|
9.9 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_04_Answer.xlsx
|
XLSX
|
10.6 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_05_Answer.xlsx
|
XLSX
|
23.3 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_06.xlsx
|
XLSX
|
19.3 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_06_Answer.xlsx
|
XLSX
|
19.3 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_07.xlsx
|
XLSX
|
718.4 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_07_Answer.xlsx
|
XLSX
|
995.3 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_08.xlsx
|
XLSX
|
9 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_08_Answer.xlsx
|
XLSX
|
9.7 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_09.csv
|
CSV
|
483.3 KB
|
|
|
SimonSezIT_Excel2016Advanced_Exercise_09_Answer.xlsx
|
XLSX
|
418.5 KB
|
|
|
SimonSezIT_Excel2016Advanced_Tables_1.xlsx
|
XLSX
|
18.8 KB
|
|
|
SimonSezIT_Financial_Functions_1.xlsx
|
XLSX
|
10.2 KB
|
|
|
SimonSezIT_Get_and_Transform.xlsx
|
XLSX
|
18 KB
|
|
|
SimonSezIT_Goal_Seek_1.xlsx
|
XLSX
|
8.7 KB
|
|
|
SimonSezIT_Goal_Seek_2.xlsx
|
XLSX
|
8.8 KB
|
|
|
SimonSezIT_Logical_Functions_1.xlsx
|
XLSX
|
8.8 KB
|
|
|
SimonSezIT_Logical_Functions_2.xlsx
|
XLSX
|
16.4 KB
|
|
|
SimonSezIT_Lookup_Functions_1.xlsx
|
XLSX
|
9.3 KB
|
|
|
SimonSezIT_Lookup_Functions_2.xlsx
|
XLSX
|
10.5 KB
|
|
|
SimonSezIT_Lookup_Functions_3.xlsx
|
XLSX
|
16 KB
|
|
|
SimonSezIT_One_Click_Forecasting.xlsx
|
XLSX
|
17.7 KB
|
|
|
SimonSezIT_Personal_Financial_Functions_1.xlsx
|
XLSX
|
9.1 KB
|
|
|
SimonSezIT_Personal_Financial_Functions_2.xlsx
|
XLSX
|
10.3 KB
|
|
|
SimonSezIT_Policy_Sales_1.xlsm
|
XLSM
|
56.2 KB
|
|
|
SimonSezIT_Policy_Sales_2.xlsm
|
XLSM
|
55.9 KB
|
|
|
SimonSezIT_Policy_Sales_3.xlsm
|
XLSM
|
57.8 KB
|
|
|
SimonSezIT_Policy_Sales_4.xlsm
|
XLSM
|
56.9 KB
|
|
|
SimonSezIT_Policy_Sales_5.xlsm
|
XLSM
|
58.8 KB
|
|
|
SimonSezIT_Principal_and_Interest.xlsx
|
XLSX
|
19.3 KB
|
|
|
SimonSezIT_Radar_Charts_1.xlsx
|
XLSX
|
13.7 KB
|
|
|
SimonSezIT_Regression_Functions_1.xlsx
|
XLSX
|
9.1 KB
|
|
|
SimonSezIT_Regression_Functions_2.xlsx
|
XLSX
|
10.1 KB
|
|
|
SimonSezIT_Regression_Functions_3.xlsx
|
XLSX
|
10 KB
|
|
|
SimonSezIT_Regression_Functions_4.xlsx
|
XLSX
|
10.3 KB
|
|
|
SimonSezIT_Scenario_Manager_1.xlsx
|
XLSX
|
13.5 KB
|
|
|
SimonSezIT_Solver_1.xlsx
|
XLSX
|
9.9 KB
|
|
|
SimonSezIT_South_American_Branch_Sales_1.xlsx
|
XLSX
|
10.3 KB
|
|
|
SimonSezIT_South_American_Branch_Sales_Bogota.xlsx
|
XLSX
|
8.8 KB
|
|
|
SimonSezIT_South_American_Branch_Sales_Lima.xlsx
|
XLSX
|
9.9 KB
|
|
|
SimonSezIT_South_American_Branch_Sales_Summary.xlsx
|
XLSX
|
10.4 KB
|
|
|
SimonSezIT_Sparklines.xlsx
|
XLSX
|
267.7 KB
|
|
|
SimonSezIT_Statistical_Inference_1.xlsx
|
XLSX
|
9.6 KB
|
|
|
SimonSezIT_Stock_Charts_1.xlsx
|
XLSX
|
16.2 KB
|
|
|
SimonSezIT_Store_Data_1.xlsx
|
XLSX
|
834.2 KB
|
|
|
SimonSezIT_Store_Data_2.xlsx
|
XLSX
|
841.8 KB
|
|
|
SimonSezIT_Store_Data_3.xlsx
|
XLSX
|
842.5 KB
|
|
|
SimonSezIT_Store_Data_4.xlsx
|
XLSX
|
846.1 KB
|
|
|
SimonSezIT_Surface_Charts_1.xlsx
|
XLSX
|
14.1 KB
|
|
|
SimonSezIT_Tables_2.xlsx
|
XLSX
|
18.8 KB
|
|
|
SimonSezIT_Tables_3.xlsx
|
XLSX
|
18.9 KB
|
|
|
SimonSezIT_Team_Monthly_Sales.xlsx
|
XLSX
|
273.1 KB
|
|
|
SimonSezIT_Text_Functions_1.xlsx
|
XLSX
|
12.2 KB
|
|
|
SimonSezIT_Text_Functions_2.xlsx
|
XLSX
|
16.1 KB
|
|
|
SimonSezIT_What-If_1.xlsx
|
XLSX
|
11.3 KB
|
|
|
~$SimonSezIT_Store_Data_2.xlsx
|
XLSX
|
204.8 B
|
