|
|
1. Equals and Targeting cells.mp4
|
MP4
|
12.1 MB
|
|
|
1. Opening a Workbook.mp4
|
MP4
|
10.5 MB
|
|
|
1. What data really looks like.mp4
|
MP4
|
8.5 MB
|
|
|
1. What you can do with a VLOOKUP.mp4
|
MP4
|
20.6 MB
|
|
|
1. Why use a table.mp4
|
MP4
|
15.7 MB
|
|
|
1.1 Double click to open.xlsx
|
XLSX
|
8.4 KB
|
|
|
1.1 Equals and Targeting cells.xlsx
|
XLSX
|
13 KB
|
|
|
1.1 What data really looks like.xlsx
|
XLSX
|
9.9 KB
|
|
|
1.1 What you can do with a VLOOKUP.xlsx
|
XLSX
|
16.5 KB
|
|
|
1.1 Why use a table.xlsx
|
XLSX
|
22.2 KB
|
|
|
10. Insert a shape of any type.mp4
|
MP4
|
15.2 MB
|
|
|
10. ROUND, ROUNDUP and ROUNDDOWN Functions.mp4
|
MP4
|
13.7 MB
|
|
|
10. VLOOKUP - Quiz.html
|
HTML
|
102.4 B
|
|
|
10. Working with Dates & Times.mp4
|
MP4
|
15.2 MB
|
|
|
10.1 Insert a shape of any type.xlsx
|
XLSX
|
14.2 KB
|
|
|
10.1 ROUND, ROUNDUP and ROUNDDOWN Functions.xlsx
|
XLSX
|
10.6 KB
|
|
|
10.1 Working with Dates & Times.xlsx
|
XLSX
|
11 KB
|
|
|
11. Adding notes and comments.mp4
|
MP4
|
9.8 MB
|
|
|
11. Advanced Manipulation of SmartArt.mp4
|
MP4
|
9.7 MB
|
|
|
11. LEFT and RIGHT functions.mp4
|
MP4
|
11.9 MB
|
|
|
11.1 Adding comments2.xlsm
|
XLSM
|
12.8 KB
|
|
|
11.1 LEFT and RIGHT Functions.xlsx
|
XLSX
|
11.7 KB
|
|
|
11.1 SmartArt.xlsx
|
XLSX
|
7.7 KB
|
|
|
12. Insert symbols and equations.mp4
|
MP4
|
11.3 MB
|
|
|
12. MID function.mp4
|
MP4
|
9.6 MB
|
|
|
12. Simple Formulas (Totals & Averages).mp4
|
MP4
|
11.6 MB
|
|
|
12.1 Insert Symbols and Equations.xlsx
|
XLSX
|
8.9 KB
|
|
|
12.1 MID Function.xlsx
|
XLSX
|
11.6 KB
|
|
|
12.1 Simple Formulas (Totals and Averages).xlsm
|
XLSM
|
10.4 KB
|
|
|
13. Errors in Functions.mp4
|
MP4
|
16 MB
|
|
|
13. Formatting Rows & Columns.mp4
|
MP4
|
13.3 MB
|
|
|
13. Formatting a graphic object.mp4
|
MP4
|
12.3 MB
|
|
|
13.1 Errors in Functions.xlsx
|
XLSX
|
12.1 KB
|
|
|
13.1 Formatting Rows & Columns - Worksheet.xlsx
|
XLSX
|
12 KB
|
|
|
13.1 Formatting a graphic object.xlsx
|
XLSX
|
7.8 KB
|
|
|
14. CONCATENATE Function.mp4
|
MP4
|
11.8 MB
|
|
|
14. Change the shape of a graphic object.mp4
|
MP4
|
7.2 MB
|
|
|
14. Inserting pictures and shapes into Excel.mp4
|
MP4
|
18.8 MB
|
|
|
14.1 Change the shape of a graphic object.xlsx
|
XLSX
|
10.7 KB
|
|
|
14.1 Concatenate Function.xlsx
|
XLSX
|
10.1 KB
|
|
|
14.1 Inserting pictures and shapes into Excel.xlsx
|
XLSX
|
20.8 KB
|
|
|
14.2 Your Logo.png
|
PNG
|
28.1 KB
|
|
|
15. Selection pane.mp4
|
MP4
|
7.9 MB
|
|
|
15. UPPER, LOWER and PROPER Functions.mp4
|
MP4
|
9.2 MB
|
|
|
15. Working with Themes.mp4
|
MP4
|
17.3 MB
|
|
|
15.1 Selection pane.xlsx
|
XLSX
|
42.6 KB
|
|
|
15.1 UPPER, LOWER and PROPER Functions.xlsx
|
XLSX
|
10.3 KB
|
|
|
15.1 Working with Themes.xlsx
|
XLSX
|
19.4 KB
|
|
|
16. Core Functions - Quiz.html
|
HTML
|
102.4 B
|
|
|
16. Freeze Panes.mp4
|
MP4
|
25.2 MB
|
|
|
16. Object Arrangement.mp4
|
MP4
|
7.7 MB
|
|
|
16.1 Freeze Panes.xlsx
|
XLSX
|
40.7 KB
|
|
|
16.1 Object Arrangement.xlsx
|
XLSX
|
29.7 KB
|
|
|
17. Getting your sheet ready for printing.mp4
|
MP4
|
15.8 MB
|
|
|
17. Perform multi-criteria sorts and customized sorts.mp4
|
MP4
|
17.8 MB
|
|
|
17.1 Getting your sheet ready for printing.xlsx
|
XLSX
|
12.3 KB
|
|
|
17.1 Perform multi-criteria sorts.xlsx
|
XLSX
|
15.3 KB
|
|
|
18. Inputting in multiple cells.mp4
|
MP4
|
11.5 MB
|
|
|
18. Page break preview.mp4
|
MP4
|
14.4 MB
|
|
|
18.1 Inputting in multiple cells.xlsx
|
XLSX
|
9.1 KB
|
|
|
18.1 Page break preview.xlsx
|
XLSX
|
12.3 KB
|
|
|
19. Advanced knowledge of custom lists.mp4
|
MP4
|
10.5 MB
|
|
|
19. Spell checker.mp4
|
MP4
|
13.3 MB
|
|
|
19.1 Advanced knowledge of custom lists.xlsx
|
XLSX
|
8.5 KB
|
|
|
19.1 Spell Checker.docx
|
DOCX
|
12.1 KB
|
|
|
19.2 Spell Checker.xlsx
|
XLSX
|
9.6 KB
|
|
|
2. Applying formatting to a cell.mp4
|
MP4
|
12.2 MB
|
|
|
2. Functions vs Formulas.mp4
|
MP4
|
10.1 MB
|
|
|
2. Saving a workbook.mp4
|
MP4
|
12.6 MB
|
|
|
2. The components of a table.mp4
|
MP4
|
15.6 MB
|
|
|
2. The correct dataset structure.mp4
|
MP4
|
14.4 MB
|
|
|
2.1 Applying formatting to a cell.xlsx
|
XLSX
|
9.4 KB
|
|
|
2.1 Functions vs Formulas.xlsx
|
XLSX
|
11.3 KB
|
|
|
2.1 Saving workbooks.xlsx
|
XLSX
|
12.6 KB
|
|
|
2.1 The components of a table.xlsx
|
XLSX
|
17.3 KB
|
|
|
2.1 The correct dataset structure.xlsx
|
XLSX
|
14 KB
|
|
|
20. Advanced knowledge of Hypertext links.mp4
|
MP4
|
14.7 MB
|
|
|
20. Clear all Button.mp4
|
MP4
|
9.6 MB
|
|
|
20.1 Advanced knowledge of Hypertext links.xlsx
|
XLSX
|
16.2 KB
|
|
|
20.1 Clear All Button.xlsx
|
XLSX
|
11.7 KB
|
|
|
20.2 How to link an external document into your excel sheet.pdf
|
PDF
|
98.7 KB
|
|
|
20.3 Word document.docx
|
DOCX
|
11.5 KB
|
|
|
21. Create and edit a form - Part 1.mp4
|
MP4
|
10.1 MB
|
|
|
21. Find and Replace.mp4
|
MP4
|
18.2 MB
|
|
|
21.1 Create and Edit a form.xlsm
|
XLSM
|
19 KB
|
|
|
21.1 Find and Replace.xlsx
|
XLSX
|
15.5 KB
|
|
|
22. Create and edit a form - Part 2.mp4
|
MP4
|
12.2 MB
|
|
|
22. Merge Cells.mp4
|
MP4
|
12.9 MB
|
|
|
22.1 Create and Edit a form.xlsm
|
XLSM
|
17.5 KB
|
|
|
22.1 Merge Cells.xlsx
|
XLSX
|
12.9 KB
|
|
|
23. Formatting Quiz.html
|
HTML
|
102.4 B
|
|
|
23. Microsoft Templates.mp4
|
MP4
|
11.9 MB
|
|
|
23.1 Microsoft Template.xlsx
|
XLSX
|
61.4 KB
|
|
|
24. Excel Essential Quiz.html
|
HTML
|
102.4 B
|
|
|
3. Adding, subtracting, multiplication and division.mp4
|
MP4
|
11.6 MB
|
|
|
3. Doing a VLOOKUP.mp4
|
MP4
|
14.8 MB
|
|
|
3. Formatting of a Table.mp4
|
MP4
|
14.8 MB
|
|
|
3. Managing the Backstage View.mp4
|
MP4
|
10.7 MB
|
|
|
3. Text vs Numerical Data.mp4
|
MP4
|
14.5 MB
|
|
|
3.1 Adding, subtracting, Multiplication and Division.xlsx
|
XLSX
|
12.6 KB
|
|
|
3.1 Doing a VLOOKUP.xlsx
|
XLSX
|
13.4 KB
|
|
|
3.1 Formatting of a table.xlsx
|
XLSX
|
13.2 KB
|
|
|
3.1 Text vs Numerical Data.xlsx
|
XLSX
|
10.9 KB
|
|
|
4. Common problems with VLOOKUP.mp4
|
MP4
|
16.1 MB
|
|
|
4. Components of a Function.mp4
|
MP4
|
13.3 MB
|
|
|
4. Familiarity with file formats.mp4
|
MP4
|
15.3 MB
|
|
|
4. Formatting Dates.mp4
|
MP4
|
15.9 MB
|
|
|
4. Using autofilter.mp4
|
MP4
|
20.5 MB
|
|
|
4.1 Comma Separated Values.csv
|
CSV
|
102.4 B
|
|
|
4.1 Common problems with a VLOOKUP.xlsx
|
XLSX
|
13.6 KB
|
|
|
4.1 Components of a Function.xlsx
|
XLSX
|
11.8 KB
|
|
|
4.1 Formatting Dates.xlsx
|
XLSX
|
10.3 KB
|
|
|
4.1 Using Autofilter.xlsx
|
XLSX
|
17.2 KB
|
|
|
5. Comprehensive knowledge of the ribbon tabs.mp4
|
MP4
|
17.4 MB
|
|
|
5. Exact or Approximate match.mp4
|
MP4
|
18.8 MB
|
|
|
5. Slicers with tables.mp4
|
MP4
|
11.9 MB
|
|
|
5. Sum and Average Function.mp4
|
MP4
|
15.6 MB
|
|
|
5. Working with Currencies.mp4
|
MP4
|
15 MB
|
|
|
5.1 Comprehensive knowledge of the ribbon tabs.xlsx
|
XLSX
|
16.5 KB
|
|
|
5.1 Exact or Approximate match.xlsx
|
XLSX
|
15.8 KB
|
|
|
5.1 Slicers with Tables.xlsx
|
XLSX
|
21 KB
|
|
|
5.1 Sum and Average Function.xlsx
|
XLSX
|
11 KB
|
|
|
5.1 Working with Currencies.xlsx
|
XLSX
|
10.8 KB
|
|
|
6. Advanced Sorting.mp4
|
MP4
|
20.2 MB
|
|
|
6. Comparing two sheets with a VLOOKUP.mp4
|
MP4
|
14.2 MB
|
|
|
6. Customize the Quick Access Tool Bar.mp4
|
MP4
|
19.5 MB
|
|
|
6. Formatting Percentages.mp4
|
MP4
|
9.2 MB
|
|
|
6. More than one function in a cell.mp4
|
MP4
|
7.8 MB
|
|
|
6.1 Advanced Sorting.xlsx
|
XLSX
|
16.6 KB
|
|
|
6.1 Comparing two sheets with a VLOOKUP.xlsx
|
XLSX
|
16.3 KB
|
|
|
6.1 Customize the Quick Access Tool Bar.xlsx
|
XLSX
|
11.4 KB
|
|
|
6.1 Formatting Percentages.xlsx
|
XLSX
|
10.4 KB
|
|
|
6.1 More than one function in a cell.xlsx
|
XLSX
|
9.8 KB
|
|
|
7. Absolute References ($ signs).mp4
|
MP4
|
20.7 MB
|
|
|
7. Calculating totals on a table.mp4
|
MP4
|
15 MB
|
|
|
7. Excel Interface Overview.mp4
|
MP4
|
13.7 MB
|
|
|
7. Format Painter.mp4
|
MP4
|
12.9 MB
|
|
|
7. Matching on more than one criteria.mp4
|
MP4
|
17.9 MB
|
|
|
7.1 Absolute references.xlsx
|
XLSX
|
11.9 KB
|
|
|
7.1 Calculating totals on a table.xlsx
|
XLSX
|
21.1 KB
|
|
|
7.1 Excel Interface Overview.xlsx
|
XLSX
|
12.9 KB
|
|
|
7.1 Format Painter.xlsx
|
XLSX
|
10.1 KB
|
|
|
7.1 Matching on more than one criteria.xlsx
|
XLSX
|
13.2 KB
|
|
|
8. Conditional Formatting with a formula.mp4
|
MP4
|
23 MB
|
|
|
8. Data entry and editing techniques.mp4
|
MP4
|
8.6 MB
|
|
|
8. HLOOKUP function.mp4
|
MP4
|
10.8 MB
|
|
|
8. Look for - Help with Functions.mp4
|
MP4
|
15.8 MB
|
|
|
8. Referencing within a table.mp4
|
MP4
|
15.8 MB
|
|
|
8.1 Conditional Formatting with a formula.xlsx
|
XLSX
|
12.1 KB
|
|
|
8.1 Data Entry and Editing Techniques.xlsx
|
XLSX
|
9.1 KB
|
|
|
8.1 HLOOKUP Function.xlsx
|
XLSX
|
16 KB
|
|
|
8.1 Look for and help with Functions.xlsx
|
XLSX
|
10 KB
|
|
|
8.1 Referencing within a table.xlsx
|
XLSX
|
15.6 KB
|
|
|
9. COUNT Function.mp4
|
MP4
|
9.5 MB
|
|
|
9. Data Autofill.mp4
|
MP4
|
10.1 MB
|
|
|
9. Error Handling - IFERROR function.mp4
|
MP4
|
14.9 MB
|
|
|
9. Insert a screenshot.mp4
|
MP4
|
17.2 MB
|
|
|
9. Working with Tables - Quiz.html
|
HTML
|
102.4 B
|
|
|
9.1 COUNT Function.xlsx
|
XLSX
|
10.4 KB
|
|
|
9.1 Data Autofill.xlsx
|
XLSX
|
13 KB
|
|
|
9.1 Error handling - IFERROR function.xlsx
|
XLSX
|
14.3 KB
|
|
|
9.1 Insert a screenshot - destination.xlsx
|
XLSX
|
11.7 KB
|
|
|
9.2 Insert a screenshot.xlsx
|
XLSX
|
12.6 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
