Email Project # 1
  • Intro - What Does this Course Cover?
  • One thing before we get started.
  • Working with Emailed Files and Headings.
  • Formatting Cells and Columns
  • Our First Formula in Excel
  • Saving Files, CSV's and PDF's
  • Quiz - Email # 1
Email Project # 2
  • Summaries & Find and Replace.
  • Filtering in Excel
  • Subtotaling - Sums, Averages & Counts
  • Freeze the Data in your Spreadsheet
  • Setting and Print Range for Worry Free Printing
  • Quiz - Email # 2
Email Project # 3
  • Text Wrapping in the Headings
  • Basic Arithmetic in Excel
  • All About Comments
  • Quiz - Email # 3
Email Project # 4
  • Copying and Moving Multiple Tabs in a Spreadsheet
  • Linking to Multiple Tabs & Custom Lists
  • Merging Data from Multiple Cells into a Single Cell
  • Quiz - Email # 4
Email Project # 5
  • Building Professional Charts in Excel
Email Project # 6
  • Inserting Pictures, Word Art and Smart Art
Email Project # 7
  • Working with Data from an Email
  • Vlookups - The Ultimate Tool
  • Anchoring our Formulas
  • Polishing Up the Data for Management
  • Quiz - Email # 7
Email Project # 8
  • Using Vlookups in Separate Spreadsheets
  • Summarizing Data with a Pivot Table
  • Quiz - Email # 8
Email Project # 9
  • Using the If/Then Formula to Test Logic
  • Pivot Table (Part 2) - Pivot Table Options, Filters and Subtotals
  • Excel Options
Email Project # 10
  • The And & Or Formulas - Our First Nested Formula
  • Adding New Columns into a Pivot Table
Email Project # 11
  • Reconcile Two Tables of Data
  • Parsing Data - Text-to-Columns
  • Finish Up The Reconciliation - Remove #N/A
Email Project # 12
  • How to Get Rid of Errors in Your Formulas
Email Project # 13
  • Customize Your Workspace in Excel
Email Project # 14
  • Security Settings for Sensitive Data
Email Project # 15
  • Bringing It All Together - Named Ranges
  • Bringing It All Together - Using Named Ranges in Formulas
  • Bringing It All Together - Create New Named Ranges to Finish the Project
  • Bringing It All Together - Add New Data to the Range
Project # 16
  • The Most Important Thing to Know About Pivot Tables
Project # 17
  • Our First Pivot Table
Project # 18
  • Add New Data to an Existing Pivot Table - Trends
  • Create a Rolling 12 Month Trend Analysis
Project # 19
  • Pivot Table Designs
Project # 20
  • Formulas in the Pivot Table - Calculated Items
  • Formulas in the Pivot Table - Calculated Fields
Project # 21
  • Instantly Get a Supporting Data Report from a Pivot Table
Project # 22
  • Running Totals & Weighted Averages
Project # 23
  • Let's Slice & Dice
Project # 24
  • Advanced Filtering, Grouping & Conditional Formatting
Project # 25
  • Pivot Charts
Reference
  • 4th Section and Downloadable Files
  • RANDBETWEEN
  • TRIM
  • CONCATENATE
  • TEXT TO COLUMNS
  • DATE
  • FILTER
  • SUM VS SUBTOTAL
  • ROUND
  • SUMIF & COUNTIF
  • SUMIF vs SUMIFS
  • Excellent Trick - Fill in the Blanks
  • AND & OR Formulas Explained
  • IF FORMULA (Part I) - Learn Multiple Ways to Use the Excel IF Formula
  • IF Formulas (Part II) - Nesting Multiple IF formulas
  • IF Formula (Part III) Nesting different formulas within the IF Formula