jagomart
digital resources
picture1_Excel Exposure Master Workbook 4 30 13


 186x       Filetype XLSX       File size 0.23 MB       Source: www.atlas101.ca


File: Excel Exposure Master Workbook 4 30 13
sheet 1 about back to table of contents information about this workbook author ben currier website excelexposurecom relevant links university of reddit class page contact ben excelexposurecom sheet 2 table ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
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

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet about back to table of contents information this workbook author ben currier website excelexposurecom relevant links university reddit class page contact master lesson version note is a workinprogress and will be updated as new lessons added check at for the latest file excel ref description plan w list all functions shortcuts experience level function examples pivot underlying data example autofill demonstration referencing related validation advanced filtering conditional formatting lookup index amp match five powerful tips info video most uptodate go directly on reference absolute beginner s introduction basic techniques relative cell ie sign naming ranges cells autofilter tables round creating designing charts including sparklines with incell dropdown lists formula auditing evaluation error checking monitoring indepth preview manipulation coloring tabs renaming copyingmoving etc protecting hiding formulas advice setting up models worksheets intelligent structure how write com...

no reviews yet
Please Login to review.