Sheet 1: About

	
	
	
	

		
Back to Table of Contents
		


		


	
	

		


		


		


	
	

		


		
Information about this Workbook
		


	
	

		


		


		


	
	

		


		
Author:
		
Ben Currier
	
	

		


		
Website:
		
ExcelExposure.com
	
	

		


		


		


	
	

		


		
Relevant Links:
		
University of Reddit Class Page
	
	

		


		


		


	
	

		


		
Contact:
		
Ben@ExcelExposure.com
	



Sheet 2: Table of Contents

	
	
	
	
	
	

		
ExcelExposure.com - Master Lesson Workbook
		


		


		
Version:
		
4/30/2013
	
	

		
Note: This workbook is a work-in-progress and will be updated as new lessons and information is added.
		


		


		


		


	
	

		
Check back at ExcelExposure.com for the latest version of this file.
		


		


		


		


	
	

		


		


		


		


		


	
	

		
Excel Lesson Workbook - Table of Contents
		


		


		


		


	
	

		


		


		


		


		


	
	

		


		
Sheet Ref.
		
Description
		


		


	
	

		


		
1
		
Lesson Plan (w/ Links)
		


		


	
	

		


		


		


		


		


	
	

		


		
2
		
List of All Excel Functions
		


		


	
	

		


		


		


		


		


	
	

		


		
3
		
List of All Excel Shortcuts
		


		


	
	

		


		


		


		


		


	
	

		


		
4
		
Experience Level 1 Function Examples
		


		


	
	

		


		


		


		


		


	
	

		


		
5
		
Pivot Table Examples - Underlying Data
		


		


	
	

		


		


		


		


		


	
	

		


		
6
		
Pivot Table Example 1
		


		


	
	

		


		


		


		


		


	
	

		


		
7
		
Pivot Table Example 2
		


		


	
	

		


		


		


		


		


	
	

		


		
8
		
AutoFill Demonstration
		


		


	
	

		


		


		


		


		


	
	

		


		
9
		
Referencing Related Example
		


		


	
	

		


		


		


		


		


	
	

		


		
10
		
Data Validation
		


		


	
	

		


		


		


		


		


	
	

		


		
11
		
Advanced Filtering
		


		


	
	

		


		


		


		


		


	
	

		


		
12
		
Conditional Formatting
		


		


	
	

		


		


		


		


		


	
	

		


		
13
		
Advanced Lookup - Index & Match
		


		


	
	

		


		


		


		


		


	
	

		


		
14
		
Five Powerful Excel Tips
		


		


	
	

		


		


		


		


		


	
	

		


		


		


		


		


	
	

		


		


		
Workbook Info
		


		


	



Sheet 3: 1 - Lesson Plan

	
	

		
Back to Table of Contents
	
	

		
Lesson Plan - Video Lessons
	
	

		
Check the website for most up-to-date Lesson Plan. Links go directly to the Video Lesson on ExcelExposure.com.
	
	

		


	
	

		
Workbook / Reference Related Lessons
	
	

		
Absolute Beginner's Introduction to Excel
	
	

		
Basic Formatting Techniques
	
	

		
Absolute & Relative Cell Referencing (i.e. the $ sign)
	
	

		
Conditional Formatting
	
	

		
Naming Ranges and Cells
	
	

		
Auto-Filter and Advanced Data Filtering
	
	

		
Introduction to Pivot Tables
	
	

		
Advanced Pivot Tables: Round 1
	
	

		
Advanced Pivot Tables: Round 2
	
	

		
Creating and Designing Charts (including Sparklines)
	
	

		
Data Validation with In-Cell Drop-down Lists
	
	

		
Formula Auditing and Formula Evaluation
	
	

		
Five Powerful Excel Tips
	
	

		
Error Checking and Data Monitoring
	
	

		
Excel 2013 In-Depth Preview
	
	

		
Sheet Manipulation (coloring tabs, renaming, copying/moving, etc.)
	
	

		
Protecting and Hiding Information & Formulas
	
	

		
Advice on Setting Up Models, Worksheets, and Intelligent Data Structure
	
	

		
How to Write Complex Custom Formulas Using Multiple (i.e. nested) Functions
	
	

		
Setting Up Useful Templates to Help Automate Work
	
	

		


	
	

		
Function Related Lessons
	
	

		
Experience Level 1 - Math & Statistical Functions
	
	

		
Experience Level 1 - Lookup / Reference Functions
	
	

		
Advanced VLOOKUP Examples
	
	

		
Advanced Lookup – Index & Match Functions
	
	

		
Experience Level 1 - Date & Time Functions
	
	

		
Experience Level 1 - Text Functions 
	
	

		
Experience Level 1 - Logical Functions
	
	

		
Experience Level 1 - Information Functions
	
	

		
How to Write Complex Custom Formulas Using Multiple (i.e. nested) Functions
	
	

		


	
	

		
Macros / VBA Lessons
	
	

		
Introduction to Macros & VBA programming
	
	

		
VBA Macro Walkthrough #1 - Purchase Order Generator
	
	

		
Guest Lesson: Purchase Order Generator Homework Solution pt 1 of 3
	
	

		
VBA Macro Walkthrough #2 - Message Encoder & Decoder
	
	

		
How to record a macro and interpret/modify results
	
	

		
Writing macros including advanced training in VBA programming
	
	

		
Creating user defined functions in Excel
	
	

		


	
	

		
Excel Tutorials, Tricks & Quick Tips (Non-Video Lessons)
	
	

		
Introduction to Tables: Guest Excel Lesson by VertexVortex
	
	

		
Group / Ungroup (Quick-Tip)
	
	

		
Merged Cells Alternative (Quick-Tip)
	
	

		
Extract List From Data With Duplicate Values Removed
	
	

		
Presentation Options for Data / Information
	
	

		
Copying / Pasting Functionality (values, transpose, Formatting, constants, links, etc.)
	
	

		
Advanced Sorting Methods