Excel Tutorial for Christa NO EXCUSES 20 min per day

Plural Sight Videos !!!

Download each folder lesson and DO lesson:

https://drive.google.com/drive/u/0/folders/1aRM7mLY9v_I2vi3JlSiiirBirPfKBRDh

1. Beginner Lessons

Loading Data into Excel

Searching and Manipulating Data in Excel

 

2. Intermediate

Calculating Cell Values with Formulas

Recording and Managing Excel Macros

3. Advanced

Summarizing and Organizing Data in Excel

Exploring Data with PivotTables

Distributing Excel Workbooks

Charting Data with Excel

Original Plural sigh lesson is HERE

 

Youtube & Free!!!

Basic: Formulas and Functions

1. Excel Basic Formulas and Function

2. Sum all lookups

LookUps:

Lookups : Lookups will allow you to merge worksheets. E.g:  Match Invoices to Rates.

V Lookup : 30 min or less

Learn V Lookup for basic matching, e.g: match “Acme Inc” = “Acme Inc”

1. How to Do a VLOOKUP With Two Spreadsheets in Excel

Sample: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

2. Excel VLOOKUP tutorial for beginners with formula examples

3. V Lookup Explained

Fuzzy Lookup : 30 min+

Learn Fuzzy Lookup for advanced matching, e.g: Match “ACME Inc” and “Florida ACME Inc”

1. Download Fuzzy Lookup Add-In for Excel

2. Watch Tutorial

 

Playlist Tutorials:

1. Excel Basics

2. Tips & Formulas 

 

 

 

Paid Courses:

1. Advanced Excel: Top 10 Excel Tips & Formulas

- $34.00 Video + includes sample workbook