
What students will learn, how to use practice files.
Ribbon, Quick Access Toolbar, worksheet tabs.
A workbook contains one or more sheets you add with the plus button. A sheet has columns and rows, with cells named by column and row (for example e5).
Master selecting cells, columns, rows, and noncontiguous ranges in Excel, and navigate efficiently with keyboard shortcuts like tab, enter, and ctrl-arrow keys to move through a sheet.
Discover how to boost productivity with Excel AutoFill and Flash Fill, using the fill handle to generate sequences, dates, and patterns, or extract names, years, and initials.
Learn to save work in Excel, use save as to create copies for safekeeping, and open previously saved workbooks while building and updating a budget sheet.
Insert, delete, hide, and resize columns and rows.
Insert, delete, move, or copy a sheet and select all sheets.
Format data to look professional by applying font styles and sizes, colors, borders, and alignment; merge title cells, wrap text, and auto-fit columns for a polished Excel table.
Format data types in Excel, displaying dates as long date, currency with symbol and thousand separators, convert numbers to text for leading zeros, and apply fractions, percentages, and decimals.
Apply conditional formatting in Excel to highlight cells by rules such as greater than, less than, or text that contains. Manage dates, duplicates, and rule removal for clear visuals.
Apply format as table to apply a theme with borders, font formatting, and fill color. Choose a table style, ensure headers, and use the table design tab.
Understanding the different categories of Excel formulas.
Understanding the mathematical operators' priorities. Applying the first calculation in Excel.
Master the five Excel functions—sum, average, max, min, and count—and their syntax with ranges like f2:f14, applied to salary data.
Master calculating each salary’s percent of total salaries in Excel by using relative and absolute cell references, including partial and totally absolute, and learn to avoid division by zero.
Learn to use Excel text functions to merge names and split order IDs, using concat and left and right to extract country, year, and order code, with auto-fit columns.
Sort data in Excel using single and multi-level sorts to order by warehouse block, product cost, or shipment mode, with ascending or descending options, and manage headers and levels.
Filter data in a dataset using Excel, selecting by warehouse block or product cost, applying multiple criteria, using number filters like between or top, and removing filters.
Learn to freeze panes to keep headers visible while scrolling by locking the top row, the first column, or both; unfreeze as needed.
Discover how to choose the right chart type to represent data, create line and pie charts (including donut and 2D/3D options), and know when limited data favors simple visuals.
Edit chart styles and labels to customize colors, fills, axis text, and legends; adjust chart area, plot area, titles, data labels, and data range.
Explore Excel’s print options for large datasets, using page layout, scaling, and fit to pages, and learn to repeat header rows and set a print area.
Add headers and footers in Excel using page setup, explore presets, and customize content such as page numbers, dates, times, file paths, and logos.
Explore how to print in Excel, preview results, choose printers, adjust page setup, and select what to print from active sheets to the entire workbook or a selected range.
Master the fundamentals of Microsoft Excel and build the essential skills you need for work, school, and everyday productivity.
This beginner-friendly course is designed for absolute beginners who want to learn Excel from scratch using clear explanations, practical examples, and step-by-step instructions.
You will start by understanding the Excel interface, workbooks, and worksheets, then learn how to enter, edit, and format data with confidence. As you progress, you will practice using Excel’s most important tools — including formulas, functions, tables, sorting, filtering, and basic charts — all through real-world examples that mirror common workplace tasks and daily responsibilities.
Whether you are a student, job seeker, office employee, or anyone who wants to use Excel more effectively, this course gives you the foundation you need to work smarter, save time, and increase productivity.
By the end of the course, you will feel confident creating clean, organized spreadsheets, performing basic calculations, and presenting data visually.
No previous Excel experience is required. All lessons are SHORT, CLEAR, and PRACTICAL— perfect for beginners who want to learn Excel the right way from day one.
This course provides a simple learning path that builds your skills gradually, ensuring you develop confidence while practicing with guided examples and helpful demonstrations.