FREE Excel Course

1. Cells and Ranges
2. Copy And Paste
3. Controlling Fonts And Colouring Cells
4. Multiple Lines, Clearing And Column Widths
5. Building Logic With If
6. Building Logic With Select Case
7. The Importance Of Loops
8. Introduction To Automation
9. Loops And Selecting Ranges
10. Maneuvering And Macros
11. Constants And Variables
12. The Most Important Line In VBA You Need To Know!
13. Putting Together Everything So Far To Demonstrate Automation

1. Macro File Formats
2. Developer Tab And Macro Security
3. Modules, Macros And Relative References
4. A First Look At Buttons
5. Charting Driven By Macros
6. Why Macros Can Go Wrong And What To Do About It
7. Handling Errors And Sheet Issues
8. Dynamic Charting: Part 1
9. Dynamic Charting: Part 2
10. Dynamic Charting: Part 3
11. End With
12. Controlling Autofilters
13. Controlling Formulas

1. The 80:20 principle applied to Excel
2. Long Boring Lists​
3. Finding Information: VLOOKUP
4. Rule building with IF
5. Working with Text
6. Text Functions: PROPER, TRIM & CLEAN
7. Text Functions: LEN & SEARCH
8. Introduction to Summarising
9. Summing
10. Dynamic Charts

1. Introduction to Array Formulas
2. Introduction to VBA & Macros
3. 1. Cells and Ranges
4. 2. Copy and Paste
5. 3. Controlling Fonts and Colouring Cells
6. 4. Multiple Lines, Clearing and Column Widths
7. 5. Building Logic with IF
8. 6. Building Logic with Select Case

1. Introduction To Pivot Tables
2. Workbook for Pivot Tables Lessons
3. Introduction to Pivot Tables
4. Pivot Cache
5. Altering the Data Source
6. Summarise Value By
7. What is Power Query
8. Unpivot Data To A Long Boring List
9. Turning useless Data into something useful
10. Combining Data with a join
11. Introduction to PowerPivot
12. Importing Data in to PowerPivot
13. Create your first Data Model

1. Managing Your career in the 21st Century
2. The greatest investment that you can make in your career​
3. Introduction to Marketing Your Excel Skills​
4. How Excel fits in with your overall career
5. See my Salary over my career and how Excel skills improved it
6. Excel careers that can earn you a six figure salary
7. Interviews: Three things you MUST do
8. How Value Networking will define your success
9. Why Motivation will kill your success
10. A System for Growth of the ‘You’ Business