Introduction to Beginner to Intermediate Excel 2016

Module 1 Practice Workbook

1. Navigating in Excel

2. Entering Information

3. Navigating without the mouse

4. Basic Formatting

5. Dragging & Autofill

6. Copy & Paste

7. Clearing Cells

8. Inserting & Deleting

9. Date Basics

10. Introduction to Formulas

11. Introduction to Formulas: Part 2

12. Introduction to Formulas: Autosum

The 80:20 principle

Long Boring Lists

Finding Information: VLOOKUP

Rule building with IF

Working with Text

Text Functions: PROPER, TRIM & CLEAN

Text Functions: LEN & SEARCH

Introduction to Summarising

Summing

Dynamic Charts

Introduction to Array Formulas

Introduction to VBA & Macros

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

Introduction To Pivot Tables

Workbook for Pivot Tables Lessons

Introduction to Pivot Tables

Pivot Cache

Alltering the Data Source

Summarise Value By

What is Power Query

Unpivot Data To A Long Boring List

Turning useless Data into something useful

Combining Data with a join

Introduction to PowerPivot

Importing Data in to PowerPivot

Create your first Data Model

Managing Your career in the 21st Century

The greatest investment that you can make in your career

Introduction to Marketing Your Excel Skills

How Excel fits in with your overall career

See my Salary over my career and how Excel skills improved it

Excel careers that can earn you a six figure salary

Interviews: Three things you MUST do

How Value Networking will define your success

Why Motivation will kill your success

A System for Growth of the ‘You’ Business