
Explore worksheets within a workbook, learn to rename, add, hide, unhide, move, and color-code sheets to keep your Excel 365 projects organized.
Learn to copy and paste data in Excel 365 using right-click or Ctrl+C/Ctrl+V, then accelerate replication with the autofill tool and the drag handle that recognizes patterns and dates.
Customize your Excel workspace to boost productivity by hiding gridlines and headings, splitting the view, freezing panes, and opening a new window to compare sheets side by side.
Format numbers in Excel for dates, revenue figures, and percentages using format cells, custom date formats, thousand separators, and center alignment to create clear, professional sheets.
Lock cells and hide formulas with panel protection in Excel to safeguard data and share results without revealing calculations. Use the format painter to apply consistent formatting across selected cells.
Create simple drop down lists in Excel using data validation to restrict data entry to a predefined department list, ensuring consistency, reducing errors, and enabling interactive, user-friendly forms.
Learn to create dynamic drop down menus in Excel 365 using named lists and data validation. Update automatically when you edit source list, keeping your data entry clean and adaptable.
Hide and unhide worksheets in Excel to keep large workbooks organized; right-click a sheet tab to hide, and use unhide via the dialog box to reveal hidden sheets.
Mastering Excel 365 covers customizing headers and footers in page layout, with logos, dates, file paths, and page numbers; set print area and repeat top rows and left columns.
Master Excel 365 basics by learning to set print area and print titles in the page setup, defining exact cell ranges, repeating headers, and ensuring clean, professional printouts.
Learn to manage Excel 365 charts by adding or removing data via the data selection settings, adjusting data sources and series, and filtering months like January to May.
Enhance Excel 365 charts by adding axis titles, data labels, and legends; customize colors and gridlines to boost readability, clarity, and visual impact.
master excel 365 formula skills by learning the sum, min, max, and average functions to calculate totals, extremes, and averages across cell ranges.
Learn to use the countif function in Excel 365 to count cells based on criteria. Apply it to count scores seven or above across math, literature, and English.
Learn how to use the sumif function in Excel 365 to sum values by a condition, with a Vietnam student example and fixed ranges using dollar signs.
Master how to use Vlookup in Excel 365 to find a student's score by name. Learn about the leftmost name column, table array, and using false for an exact match.
Explore real-time collaboration with shared workbooks, import external data, and master tools like text to columns, split window, freeze pane, pivot tables, and pivot chart, plus macros.
Welcome to "Mastering Excel 365: Your Complete Beginner’s Guide" — your entry point into the world of smart data handling, productivity, and professional spreadsheet management.
Whether you’re starting fresh, switching from an older Excel version, or simply brushing up on your skills, this course is designed to make Excel 365 intuitive and approachable. With step-by-step guidance, real-world applications, and interactive examples, you’ll confidently transform raw data into well-organized insights.
This course begins by demystifying the Excel 365 interface, helping you navigate ribbons, tabs, and toolbars with ease. You'll then learn how to personalize the workspace and format spreadsheets to make them both visually stunning and highly functional.
From data entry and organization to printing best practices and advanced charting, you’ll gain the skills needed to present your work professionally. You’ll also explore core formulas and functions — Excel’s true superpower — and learn time-saving tools that boost your productivity.
Led by Yoann Bierling, a seasoned data and tech expert, the course integrates practical experience and real-world examples. Yoann’s background in business intelligence and online publishing ensures you get not just the “how,” but the “why” behind every concept.
By the end, you’ll no longer feel overwhelmed by Excel — you’ll feel empowered by it. Start now and turn Excel into your new digital superpower.