Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Master the fundamentals of Microsoft Excel 365 through this comprehensive 51-part training course spanning nearly 6 hours of instruction. Begin by accessing and navigating the online portal, installing Excel 365 on Windows 11, and familiarizing yourself with workbooks, ribbons, and contextual menus. Customize your workspace by modifying the Quick Access Toolbar and learn essential keyboard shortcuts to boost productivity. Explore time-saving templates and discover how to organize, color-code, and copy worksheets while leveraging OneDrive for cloud storage and collaboration. Develop core data entry skills including formatting text, numbers, and dates, plus utilize custom lists to streamline repetitive data input. Build a solid foundation in Excel calculations by understanding BODMAS order of operations, creating essential formulas and functions, and mastering the difference between absolute and relative cell referencing. Accelerate your workflow with AutoSum, AutoFill, and Flash Fill features, then advance to creating and implementing named ranges for clearer, more efficient formulas. Transform raw data into professional presentations through proper number formatting, manual cell styling, AutoFormat tools, and the Format Painter feature. Learn to clear unwanted formatting and hyperlinks while creating and customizing Excel tables with structured references in formulas. Master data management techniques including inserting and manipulating rows and columns, aligning content, merging cells versus centering across selections, and applying custom themes. Conclude by optimizing large datasets through single-level and multi-level sorting, custom list sorting, filtering techniques, color-based sorting and filtering, and applying subtotals to organized lists.
