|
|
1 - Prerequisites of the Course and Version of Excel English.vtt
|
VTT
|
11.1 KB
|
|
|
1 - Prerequisites of the Course and Version of Excel.mp4
|
MP4
|
20.7 MB
|
|
|
1 - Section 2 Quiz.html
|
HTML
|
0 B
|
|
|
10 - How Date and Time Works English.vtt
|
VTT
|
13 KB
|
|
|
10 - How Date and Time Works.mp4
|
MP4
|
23.6 MB
|
|
|
10 - Section 11 Quiz.html
|
HTML
|
0 B
|
|
|
11 - Basic Date and Time Functions English.vtt
|
VTT
|
12.9 KB
|
|
|
11 - Basic Date and Time Functions.mp4
|
MP4
|
23.2 MB
|
|
|
11 - Section 12 Quiz.html
|
HTML
|
0 B
|
|
|
12 - Complex Date and Time Functions English.vtt
|
VTT
|
17.3 KB
|
|
|
12 - Complex Date and Time Functions.mp4
|
MP4
|
31.9 MB
|
|
|
12 - Section 13 Quiz.html
|
HTML
|
0 B
|
|
|
13 - Section 14 Quiz.html
|
HTML
|
0 B
|
|
|
13 - Using Text Functions English.vtt
|
VTT
|
16.8 KB
|
|
|
13 - Using Text Functions Part 1.mp4
|
MP4
|
34.4 MB
|
|
|
14 - Using Text Functions English.vtt
|
VTT
|
15.3 KB
|
|
|
14 - Using Text Functions Part 2.mp4
|
MP4
|
40.8 MB
|
|
|
15 - Using Logical Functions English.vtt
|
VTT
|
11.4 KB
|
|
|
15 - Using Logical Functions.mp4
|
MP4
|
23.7 MB
|
|
|
16 - Exercise 01 English.vtt
|
VTT
|
2.7 KB
|
|
|
16 - Exercise 01.mp4
|
MP4
|
4.3 MB
|
|
|
17 - HLOOKUP Function English.vtt
|
VTT
|
17.1 KB
|
|
|
17 - HLOOKUP Function.mp4
|
MP4
|
35.1 MB
|
|
|
18 - VLOOKUP Function English.vtt
|
VTT
|
10.2 KB
|
|
|
18 - VLOOKUP Function.mp4
|
MP4
|
23.9 MB
|
|
|
19 - Exercise 02 English.vtt
|
VTT
|
7.4 KB
|
|
|
19 - Exercise 02.mp4
|
MP4
|
14.2 MB
|
|
|
2 - Section 3 Quiz.html
|
HTML
|
0 B
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience English.vtt
|
VTT
|
1.7 KB
|
|
|
2 - WATCH ME Essential Information for a Successful Training Experience.mp4
|
MP4
|
37.9 MB
|
|
|
20 - Financial Functions and Terminology English.vtt
|
VTT
|
13.8 KB
|
|
|
20 - Financial Functions and Terminology.mp4
|
MP4
|
24 MB
|
|
|
21 - Personal Financial Functions English.vtt
|
VTT
|
12.4 KB
|
|
|
21 - Personal Financial Functions.mp4
|
MP4
|
25.2 MB
|
|
|
22 - Professional Financial Functions English.vtt
|
VTT
|
8.2 KB
|
|
|
22 - Professional Financial Functions.mp4
|
MP4
|
18 MB
|
|
|
23 - Depreciation English.vtt
|
VTT
|
5.2 KB
|
|
|
23 - Depreciation.mp4
|
MP4
|
11.9 MB
|
|
|
24 - Exercise 03 English.vtt
|
VTT
|
2.2 KB
|
|
|
24 - Exercise 03.mp4
|
MP4
|
4.5 MB
|
|
|
25 - Statistical Functions for Description English.vtt
|
VTT
|
16.2 KB
|
|
|
25 - Statistical Functions for Description Part 1.mp4
|
MP4
|
33.2 MB
|
|
|
26 - Statistical Functions for Description English.vtt
|
VTT
|
16.1 KB
|
|
|
26 - Statistical Functions for Description Part 2.mp4
|
MP4
|
32.3 MB
|
|
|
27 - Statistical Functions for Forecasting English.vtt
|
VTT
|
11.3 KB
|
|
|
27 - Statistical Functions for Forecasting Part 1.mp4
|
MP4
|
23.8 MB
|
|
|
28 - Statistical Functions for Forecasting English.vtt
|
VTT
|
14.8 KB
|
|
|
28 - Statistical Functions for Forecasting Part 2.mp4
|
MP4
|
29.2 MB
|
|
|
29 - Exercise 04 English.vtt
|
VTT
|
2.1 KB
|
|
|
29 - Exercise 04.mp4
|
MP4
|
3.6 MB
|
|
|
3 - DOWNLOAD ME Excel 2016 Advanced Course Exercise Files.html
|
HTML
|
921.6 B
|
|
|
3 - Section 4 Quiz.html
|
HTML
|
0 B
|
|
|
30 - One Click Forecasting English.vtt
|
VTT
|
11.7 KB
|
|
|
30 - One Click Forecasting.mp4
|
MP4
|
20.4 MB
|
|
|
31 - Statistical Functions for Inference English.vtt
|
VTT
|
12.8 KB
|
|
|
31 - Statistical Functions for Inference.mp4
|
MP4
|
26.8 MB
|
|
|
32 - Connecting to Other Workbooks English.vtt
|
VTT
|
18.3 KB
|
|
|
32 - Connecting to Other Workbooks.mp4
|
MP4
|
36.5 MB
|
|
|
33 - Connecting to Access Databases English.vtt
|
VTT
|
18.1 KB
|
|
|
33 - Connecting to Access Databases.mp4
|
MP4
|
33 MB
|
|
|
34 - Connecting to Web Data Sources English.vtt
|
VTT
|
12.3 KB
|
|
|
34 - Connecting to Web Data Sources.mp4
|
MP4
|
23.4 MB
|
|
|
35 - Get and Transform English.vtt
|
VTT
|
18.9 KB
|
|
|
35 - Get and Transform.mp4
|
MP4
|
32.3 MB
|
|
|
36 - Exercise 05 English.vtt
|
VTT
|
7.9 KB
|
|
|
36 - Exercise 05.mp4
|
MP4
|
12.9 MB
|
|
|
37 - Introduction to Tables English.vtt
|
VTT
|
15.6 KB
|
|
|
37 - Introduction to Tables.mp4
|
MP4
|
28.2 MB
|
|
|
38 - Working with Tables English.vtt
|
VTT
|
13 KB
|
|
|
38 - Working with Tables.mp4
|
MP4
|
23.7 MB
|
|
|
39 - Table References English.vtt
|
VTT
|
9.1 KB
|
|
|
39 - Table References.mp4
|
MP4
|
19.6 MB
|
|
|
4 - DOWNLOAD ME Excel 2016 Advanced Course Demo Files.html
|
HTML
|
921.6 B
|
|
|
4 - Section 5 Quiz.html
|
HTML
|
0 B
|
|
|
40 - Table Styles English.vtt
|
VTT
|
6.2 KB
|
|
|
40 - Table Styles.mp4
|
MP4
|
10.8 MB
|
|
|
41 - Exercise 06 English.vtt
|
VTT
|
1.9 KB
|
|
|
41 - Exercise 06.mp4
|
MP4
|
3.4 MB
|
|
|
42 - Introduction to Pivot Tables English.vtt
|
VTT
|
13.4 KB
|
|
|
42 - Introduction to Pivot Tables.mp4
|
MP4
|
24.1 MB
|
|
|
43 - Working with Pivot Tables English.vtt
|
VTT
|
17.6 KB
|
|
|
43 - Working with Pivot Tables.mp4
|
MP4
|
34.3 MB
|
|
|
44 - Filters and Slicers English.vtt
|
VTT
|
17.7 KB
|
|
|
44 - Filters and Slicers.mp4
|
MP4
|
33.4 MB
|
|
|
45 - Pivot Charts English.vtt
|
VTT
|
10.8 KB
|
|
|
45 - Pivot Charts.mp4
|
MP4
|
19.5 MB
|
|
|
46 - Exercise 07 English.vtt
|
VTT
|
3.3 KB
|
|
|
46 - Exercise 07.mp4
|
MP4
|
6.1 MB
|
|
|
47 - What If Analysis English.vtt
|
VTT
|
15.9 KB
|
|
|
47 - What If Analysis.mp4
|
MP4
|
29.2 MB
|
|
|
48 - Scenario Manager English.vtt
|
VTT
|
12.3 KB
|
|
|
48 - Scenario Manager.mp4
|
MP4
|
33.5 MB
|
|
|
49 - Goal Seek English.vtt
|
VTT
|
8.2 KB
|
|
|
49 - Goal Seek.mp4
|
MP4
|
14.7 MB
|
|
|
5 - Downloadable Course Transcripts.html
|
HTML
|
716.8 B
|
|
|
5 - MicrosoftExcel2016AdvancedTrainingMasterClassbySimonSezIT.pdf
|
PDF
|
1.3 MB
|
|
|
5 - Section 6 Quiz.html
|
HTML
|
0 B
|
|
|
50 - Solver English.vtt
|
VTT
|
14.1 KB
|
|
|
50 - Solver.mp4
|
MP4
|
27.8 MB
|
|
|
51 - Exercise 08 English.vtt
|
VTT
|
1.9 KB
|
|
|
51 - Exercise 08.mp4
|
MP4
|
4.1 MB
|
|
|
52 - Area Charts English.vtt
|
VTT
|
8.4 KB
|
|
|
52 - Area Charts.mp4
|
MP4
|
20 MB
|
|
|
53 - Surface Charts English.vtt
|
VTT
|
5.6 KB
|
|
|
53 - Surface Charts.mp4
|
MP4
|
10.9 MB
|
|
|
54 - Radar Charts English.vtt
|
VTT
|
6.4 KB
|
|
|
54 - Radar Charts.mp4
|
MP4
|
11.9 MB
|
|
|
55 - Bubble Charts English.vtt
|
VTT
|
8.5 KB
|
|
|
55 - Bubble Charts.mp4
|
MP4
|
14.8 MB
|
|
|
56 - Sparklines English.vtt
|
VTT
|
11.3 KB
|
|
|
56 - Sparklines.mp4
|
MP4
|
35.9 MB
|
|
|
57 - Stock Charts English.vtt
|
VTT
|
12.6 KB
|
|
|
57 - Stock Charts.mp4
|
MP4
|
30.8 MB
|
|
|
58 - Exercise 09 English.vtt
|
VTT
|
5.2 KB
|
|
|
58 - Exercise 09.mp4
|
MP4
|
12.3 MB
|
|
|
59 - Web App English.vtt
|
VTT
|
12.6 KB
|
|
|
59 - Web App Part 1.mp4
|
MP4
|
23.3 MB
|
|
|
6 - Course Structure English.vtt
|
VTT
|
6.6 KB
|
|
|
6 - Course Structure.mp4
|
MP4
|
12.4 MB
|
|
|
6 - Section 7 Quiz.html
|
HTML
|
0 B
|
|
|
60 - Web App English.vtt
|
VTT
|
13.4 KB
|
|
|
60 - Web App Part 2.mp4
|
MP4
|
23.9 MB
|
|
|
61 - Closing Message English.vtt
|
VTT
|
1 KB
|
|
|
61 - Closing Message.mp4
|
MP4
|
1.4 MB
|
|
|
62 - EXTRA LESSON Getting Started with Power Pivot and Power Query in Excel Webinar English.vtt
|
VTT
|
72.9 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 - PCExcelMostUsed.pdf
|
PDF
|
2.2 MB
|
|
|
7 - Functions English.vtt
|
VTT
|
18.5 KB
|
|
|
7 - Functions Part 1.mp4
|
MP4
|
33.3 MB
|
|
|
7 - Section 8 Quiz.html
|
HTML
|
0 B
|
|
|
8 - Functions English.vtt
|
VTT
|
6.8 KB
|
|
|
8 - Functions Part 2.mp4
|
MP4
|
23.6 MB
|
|
|
8 - Section 9 Quiz.html
|
HTML
|
0 B
|
|
|
9 - Autosum English.vtt
|
VTT
|
6.4 KB
|
|
|
9 - Autosum.mp4
|
MP4
|
13.7 MB
|
|
|
9 - Section 10 Quiz.html
|
HTML
|
0 B
|
|
|
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
|
