
What students will learn, how to use practice files.
Ribbon, Quick Access Toolbar, worksheet tabs.
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.
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.
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.
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.