Excel Fundamentals for the Real World

Transform your relationship with Excel! This comprehensive course turns Excel beginners into confident data wizards through practical, bite-sized lessons that actually stick. Say goodbye to Google searches and hello to spreadsheet confidence.

What Makes This Course Different?

As a 3x Microsoft MVP, I've created practical Excel training that blends technical expertise with real-world applications – no dry theory, just skills you'll actually use tomorrow.

  1. Practical Application: Every lesson focuses on solving real business problems, not theoretical concepts.

  2. Progressive Learning: Skills build logically from basic formulas to Power Query automation, creating a complete Excel toolkit.

  3. Engaging Format: Digestible, entertaining lessons that keep you focused without the typical spreadsheet boredom.

By The End Of This Course, You'll:

Here’s Everything That’s Included:

    • Maximize Course Offerings

    • Best Practices to Enhance Your Learning Experience

    • Download Course Files

    • Structure of the Workbook

    • The Excel Ribbon

    • Customizing the Excel Interface

    • Overview: Data Entry

    • Data Entry & Editing Data

    • Basic Excel Formulas

    • Text-to-Speech Feature

    • Dates & Times

    • AutoFill Data

    • Flash Fill

    • Comments & Notes

    • Go-To Hacks

    • Data Validation

    • Screen Tips

    • Pictures, Shapes & Objects

    • Overview: Worksheet Navigation

    • Navigation Shortcuts

    • Copy, Move & Hide Worksheets

    • Freeze Panes & Split Screen

    • Hide, Unhide, Insert & Adjust Columns & Rows

    • Copy & Paste Data

    • Protecting Worksheets & Ranges

  • Overview: Excel Formulas

    Order of Operations

    Most Common Formulas

    Essential Rule

    Absolute & Relative References

    Named Ranges

    Referencing Other Workbooks & Worksheets

    Circular References

    Combine Values

    • Overview: Excel Functions

    • COUNT, COUNTA & COUNTBLANK

    • COUNTIF & COUNTIFS

    • SUM & AVGSUMIFS & AVERAGEIFS

    • MAX & MIN

    • ROUND

    • Date Functions

    • Time Functions

    • Formula Errors

    • Conditional Formulas

    • VLOOKUP

    • Overview: Data Cleaning & Management Tools

    • Sort Data

    • Add Subtotals

    • Filter Data

    • Delete Blank or Empty Rows

    • Fill Empty Cells

    • Remove Duplicates

    • Find, Select & Emphasize

    • Find & Replace

    • Excel Tables - Why They're So Important

    • Overview: Conditional & Number Formatting

    • Formatting 101

    • Better Than Merge Cells

    • Justify

    • Number Formatting

    • Conditional Formatting

    • Icons & Data Bars

    • Overview: Printing

    • Printing Options

    • Page Breaks & Printing Ranges

    • Printing Large Data Sets

    • Headers & Footers

    • PDFs & Many Sheets

    • Overview: Workbook Design

    • Hyperlinks

    • Cell Styles

    • Workbook Themes

    • Custom Templates

    • Overview: Charts

    • Basic Charts

    • Multiple Chart Series

    • Comparison Charts

    • Combination Charts

    • Dynamic Chart Ranges

    • Pareto & Histogram Charts

    • Treemap Charts

    • Sunburst, Pie & Doughnut Charts

    • Sparkline Graphs

    • Overview: Pivot Tables

    • Pivot Table Prep

    • Importance of Using Tables as Data Sources

    • Sort & Analyze Pivot Data

    • Pivot Table Calculations

    • Slicers & Timelines

    • Pivot Charts

    • Pivot Tables or Formulas?

    • Overview: Power Query

    • Import Files

    • Merge Data

    • Clean Data

    • Overview: New Excel Functions

    • New Calculation Engine

    • UNIQUE

    • SORT & SORTBY

    • FILTER

    • XLOOKUP

FAQ

  • Each course varies in length but all are approximately hours of content. You are welcome to complete the courses at your own pace - whether that’s one module a week or binging your way through in one!

  • You are welcome to take this course whenever you’d like! It is a completely self-paced online course – so you decide when you start and when you finish.

  • Yes! Each course comes with lifetime access to all course materials.

  • Yes! Upon finishing the course, you will receive a certificate of completion from your Microsoft MVP instructor that you’re encouraged to share with you company and on LinkedIn!

  • We have tons of corporate members! Please email us at contact@easily-excel.com for bulk pricing discounts.

  • Yes, you have 14 days to request a refund – no questions asked.