
Explore the basics of Microsoft Excel across Mac, Windows, and web, including formatting options, inserting tables and pivot tables, creating charts, saving your work, and exporting to PDF.
Learn the basics of Microsoft Excel 365 through a free, practical course that provides abundant resources and covers Mac, Windows, and web versions.
Set up Microsoft Excel across devices by creating a Microsoft account, downloading from Mac App Store or Windows Store, or using the web version; sign in to sync data.
Learn the basics of worksheets and sheets in Excel. A workbook holds multiple sheets, which you can rename, while autosave and syncing keep data across devices.
Learn to identify rows and columns in Microsoft 365 Excel. Recognize rows as horizontal lines like row one and columns as vertical groups like A, B, C.
Discover how to work with cells in Microsoft 365 Excel: enter text or numbers, understand cell location such as A1 or G4, and select ranges such as B3 to D3.
Explore Excel's fill feature and flesh fill across desktop and web, dragging patterns like Sundays to Mondays and 1,2,3 to auto-complete data and formulas.
Explore Excel formulas, including sum and random between, and learn to use Flash Fill and cell references to calculate totals and profits.
Format data in Excel by applying bold, color, font size, and center alignment; insert or delete rows and columns, and use undo across Mac, Windows, and web versions.
Convert data into tables in Excel to enable formatting, header recognition, and easy sorting and filtering of data, with options to remove duplicates and paste values only.
Learn how to create a table and pivot table in Excel to extract specific data such as product, profits, sales, and expenses, and visualize it with pivot charts.
Create easy charts from pivot tables to visualize data, using pivot charts such as bar, line, and 3d column charts to compare expenses, profits, and sales.
Create interactive Excel dashboards using pivot tables and charts to visualize monthly sales by category, city, and product, with beginner-friendly guidance and advanced tips.
Learn to access Excel settings on Windows and Mac, customize the ribbon to show or hide items like the Developer option, and save changes for your workspace.
Learn to export and save Excel workbooks by saving a copy to your device, choosing formats like pdf or the entire workbook, and using desktop or web options.
Microsoft 365 Excel is no longer just a spreadsheet tool. It is the backbone of daily work in offices, small businesses, schools, and remote teams across the world. If you want to work faster, stay organized, and make better decisions using data, this course gives you the exact skills you need to start and grow with confidence.
This Microsoft 365 Excel free course is designed for complete beginners and early learners who want a clear, step-by-step path to using Microsoft Office Excel and Excel 365 Online in real work situations. You will not just click buttons. You will understand why things work the way they do and how to apply them to real tasks like tracking expenses, organizing records, creating reports, and presenting clean data to others.
You will begin by learning how Excel 365 works inside Microsoft 365. You will get comfortable with the layout, menus, sheets, rows, columns, and cells so nothing feels confusing or overwhelming. Once you know how to move around smoothly, you will learn how to enter data the right way and control how it appears using simple formatting tools that make your sheets easy to read and share.
As you move forward, you will learn how to use Excel’s fill tools and formulas to save time and reduce manual work. Instead of typing the same things again and again, you will learn how Excel can do the work for you. You will see how formulas can help you add totals, compare values, and check results in seconds.
You will also learn how to turn long lists of data into clear and useful views using tables, sorting, and filters. This helps you focus on what matters instead of scrolling through rows of numbers. From there, you will step into pivot tables and pivot charts, which are powerful tools used in offices and business reports every day. These features help you summarize large data sets and turn them into simple views that show trends, totals, and key results.
One of the highlights of this course is learning how to create an Excel dashboard. This brings everything together into a single screen where you can view charts, summaries, and key numbers at a glance. This is a skill that can set you apart in school, job roles, and freelance work.
You will also learn how to adjust Excel settings and export your files so they can be shared as PDFs or other formats. This is important when working with teachers, managers, or clients who may not use Excel the same way you do.
If you skip learning Microsoft 365 Excel, you may keep spending extra time doing tasks manually, struggle to understand reports others send you, or feel stuck when job roles ask for Excel skills. This course helps you avoid that. It gives you a strong base that you can grow from, whether you plan to move into data work, office roles, finance, marketing, or business support.
By the end of this course, you will feel confident opening a blank sheet and turning it into a clean, working file that makes sense. You will know how to organize data, apply formulas, create summaries, and present results in a way that looks clear and professional.
This course is simple, direct, and focused on real use. You can follow along at your own pace and practice as you go. If you want to learn Microsoft 365 Excel without stress and with real results, this course is made for you.