Module 3: Excel Essentials
Build the foundational Excel skills every office professional needs — entering data, formatting worksheets, writing formulas, and organizing information in tables.
What You'll Learn
- How to navigate Excel 2019 and enter data correctly
- How to format worksheets for professional presentation
- How to write formulas and use essential functions
- How to sort, filter, and organize data in tables
Real-World Scenario
Lakeside Medical Associates needs an office supply tracker, a patient appointment log, and a monthly expense report. Your manager hands you Excel and says: 'Set these up and keep them updated.'
Lessons
Complete each lesson in order. Watch the video, review the notes, and finish the challenge.
Introduction to Microsoft Excel 2019
Get oriented in the Excel 2019 interface, understand workbooks and worksheets, learn to navigate large spreadsheets efficiently, and manage your files professionally.
Entering and Formatting Data
Master professional data entry techniques in Excel — entering different data types correctly, using AutoFill and Flash Fill, applying number formatting, and making spreadsheets look polished with cell formatting and conditional highlighting.
Formulas and Essential Functions
Learn how Excel formulas work, master the most important built-in functions (SUM, AVERAGE, COUNT, IF, ROUND), and understand how to identify and fix common formula errors.
Sorting, Filtering, and Data Tables
Learn to organize and analyze data with Excel's sorting and filtering tools, convert data ranges to Excel Tables for powerful automatic features, and prepare spreadsheets for professional printing.
Hands-On: Build an Office Supply Tracker
Apply every Excel Essentials skill in one complete project — design, build, and finalize a professional office supply tracker for Lakeside Medical Associates from scratch.