
Master the basics of Microsoft Excel, build confidence, and create tables, apply formulas, and build simple charts to start using Excel with ease.
Learn Excel fundamentals from a blank workbook to building tables, applying formulas, and creating simple charts using the ribbon and autofill.
Learn how number formatting in Excel presents data as currency, percentages, dates, and times, with decimals and alignment for readable, professional spreadsheets.
Apply basic formatting in Excel to highlight important data and improve readability by using font size, bold, italic, underline, font color, fill color, text alignment, wrap text, and borders.
Master rows and columns—the building blocks of every Excel sheet—and learn to insert, delete, resize, and auto fit cells, and freeze panes to keep headers visible while scrolling.
Print your spreadsheet from the file tab, use print preview to adjust margins, orientation, and page size in page layout, and save as pdf from the save as dialog.
Learn to perform calculations in Excel with formulas and autosum, add, subtract, multiply, divide, and functions like max, min, and count, and view and edit formulas in the formula bar.
Master relative and absolute references in Excel by using the fill handle to drag formulas, lock fixed values with dollar signs, and explore mixed references that lock rows or columns.
Sort and filter data to organize information quickly, then visualize trends with charts. Apply conditional formatting and data validation to ensure accuracy, and protect your worksheet to control edits.
Master time-saving Excel shortcuts that freeze headers, apply Ctrl Shift L filters, navigate with Ctrl arrow keys, and auto sum with Alt Equals for instant totals.
Learn how Flash Fill in Excel uses pattern recognition—no formulas—to split first and last names, reformat dates, and extract email domains, with quick demos showing time-saving data cleaning.
Master sumifs, the one-line formula with sum range, criteria range, and criteria, to answer real-world questions fast and dynamically update as data changes.
Learn Sumifs pitfalls like mismatched ranges and messy parentheses, ensure sum ranges match criteria ranges, use full columns or identical start and end rows, and test parts.
Explore Xlookup basics—lookup value, lookup array, return array—and learn how it replaces Vlookup with cleaner, error-friendly, flexible lookups. Build dynamic dashboards with no macros using exact, wildcard, and approximate matches.
Master smart conditional logic in Excel with if, and, or to craft clearer, nested formulas and reliable decision rules.
Switch from static ranges to dynamic Excel tables that automatically expand with new data, keep formulas and charts in sync, and prevent broken dashboards.
Turn your data into a dynamic Excel table using Ctrl+T, ensuring headers are included, so the table grows and updates automatically with formulas and charts.
Create a pivot table in Excel to turn data into insights. Drag departments to rows and sales to values to see totals and trends instantly.
Master Power Query to clean and transform large spreadsheets, fix dates with locale, unpivot wide tables, and apply fuzzy matching. Create reusable automation with a one-time setup for tidy data.
Learn to use data validation in Excel to prevent errors by adding drop-down lists, weekday date restrictions, and duplicate blocking for clean, reliable spreadsheets.
Turn static Excel files into living dashboards using slicers, timelines, and dynamic titles that auto update with your date selections.
Master five executive-level visuals in Excel to turn cluttered data into decisions. Build a waterfall chart, a revenue–margin combo, a heat map, and dynamic chart titles for investor decks.
Discover the fundamentals of Excel vba, the visual basic for applications that automate and customize Excel workflows, and explore the vba editor's project explorer, code window, and immediate window.
Master the core building blocks of VBA by declaring integer, string, boolean, and date variables with dim, mastering subs, functions, scope, and Hungarian notation and CamelCase for readable code.
Discover how the Excel object model drives automation with VBA by mastering workbooks, worksheets, ranges, and cells, and leveraging the application object, properties, and methods to write cleaner, faster code.
Master Excel automation with VBA to combine inventory reports from sales, warehouse, and procurement into one clean file, check for mismatches, and generate a summary.
Whether you're a student, professional, job seeker, or just Excel-curious — this course is your fast-track to spreadsheet confidence.
Welcome to the only beginner-friendly Excel course you’ll ever need. In just a few hands-on lessons, you’ll go from “What’s a cell?” to “Look at this chart I built from scratch!”—no fluff, no overwhelm, just clear, practical steps that anyone can follow.
> What You'll Learn (By Actually Doing It):
How to confidently navigate Excel — ribbons, rows, and all
How to enter, edit, copy, and auto-fill data like a pro
How to format your spreadsheet to make it clean, readable, and professional
How to format numbers as currency, percentages, and dates (with precision)
How to resize, insert, delete, and freeze rows & columns for optimal layout
How to set up your Excel sheet for printing or saving as PDF
How to perform basic calculations — addition, subtraction, multiplication, division
How to use AutoSum, AVERAGE, MAX, and MIN like a spreadsheet wizard
The secret to using relative vs absolute cell references for dynamic formulas
How to sort and filter your data to make sense of large datasets in seconds
No experience? No problem.
This course was designed for complete beginners. We start with the basics and build your skills step-by-step. You’ll work on real examples and be guided every click of the way.
What You'll Walk Away With:
A strong foundation in Excel, applicable to real-world tasks
The ability to create and format tables, build formulas, and even design basic charts
Confidence to use Excel in school, at work, or in personal projects
A set of skills employers actually look for
Tools You’ll Use:
Excel’s user interface (Start screen, Ribbon, Formula bar, Name box)
AutoFill, Undo/Redo, Copy-Paste, Wrap Text, Cell Borders
Sorting, Filtering, Freeze Panes, Page Layout and Print Preview
Your Instructor:
You’re learning with someone who teaches as if your success is personal. Every module is carefully crafted to help you understand and apply Excel — no jargon, no confusion, just clarity and progress.
Extra:
You’ll also get tips to stay productive, make your spreadsheets beautiful, and avoid beginner mistakes that most people don’t even know they’re making.
Enroll Now — Your Spreadsheet Journey Starts Here.
Click “Enroll” and let’s turn you into the Excel-savvy person everyone comes to for help.