Complete Microsoft Excel 365 Masterclass with Copilot Intro

Open workbooks, create sheets, and use templates in excel via the file menu and shortcuts such as control o and control n, with autosave to the cloud.

Learn to view all information about your document in Excel by using File > Info, including name, location on OneDrive, size, title, categories, last modified, authors, and sharing options.

Learn how to upload and share Excel workbooks with autosave and per-user permissions. Generate sharing links, adjust access, and collaborate with teams or Outlook integrations.

Learn to protect a workbook and its sheets with read-only mode and password encryption, preventing accidental changes and enhancing privacy and security.

Inspect a document for issues before sharing, remove sensitive properties like author paths, review accessibility, and verify compatibility across earlier versions to ensure safe, ethical sharing.

View Excel file version history to see when and who modified it, and restore previous versions; copy path, copy as URL, and copy local path on SharePoint and OneDrive.

Learn to check out a file to create a private copy, edit safely, check in with comments and date, and use version history to restore previous edits.

Change browser view options to control access when sharing an Excel file online. Share via link so recipients see only sheets two and three without needing the desktop app.

Master saving in Excel 365 with auto save vs manual save, and saving as a copy or formats like xlsx, xls, macro-enabled, PDF, CSV, and open document spreadsheet.

Learn to print effectively in Excel using print options, real and virtual printers (including Adobe PDF), and settings like margins, orientation, scaling, and page setup.

Export Excel sheets to PDF using the built-in feature, choose a location and file name, select standard quality, define page ranges, and include document properties and accessibility tags.

Master Excel's clipboard: learn copy and paste techniques, paste special options (values, formulas, formatting), paste as picture, and tools like transpose and format painter to boost productivity.

Explore how to make cells readable in excel by adjusting font, size, color, and borders, and learn to use clipboard features and border options for clear data presentation.

Master alignment and text merging in Excel 365 by adjusting horizontal and vertical alignment, wrap text, rotate, and merge across, with tips for cleaner, well-formatted tables.

Learn how Excel formats numbers, currency, accounting, dates (short and long), and times, and master decimals, thousand separators, and date detection that starts with the year.

Explore styling and formatting your workbook with format as table, table design, and conditional formatting, including headers, filters, total rows, and banding to enhance readability.

Master inserting, deleting, and formatting cells, rows, and columns in Excel 365. Learn to adjust row heights, column widths, and basic sheet protections for dashboards.

Master quick editing tools in Excel, including AutoSum, average, fill, across worksheets, sorting, and clear formatting, to streamline data cleanup and analysis.

Master creating simple and pivot tables in Excel 365, organizing expenses by buyer and month, and summarizing data with totals, slicers, and filters. Explore pivot table options and slicers.

Master pivot tables in Excel 365: use slicers and timeline to filter by month or year, refresh data sources, rename tables, and tune layout, formatting, value fields, and totals.

Insert pictures and SmartArt to enhance data visuals, and adjust with background removal, borders, styles, cropping, and aspect ratios. Add alt text for accessibility and explore picture formatting options.

Explore inserting and formatting illustrations in Excel, including pictures, shapes, icons, 3d models, smart art, and screenshots, with tips on shape formatting and alt text.

Explore how to turn data into professional charts in Excel by choosing recommended charts, focusing on line charts for sales, expenses, and profits, and tailoring axis titles, labels, and styles.

Create a map chart in excel from a meaningful data table to visualize country data with 3d maps, then customize titles, data labels, legend position, and colors for clear insights.

Create a pivot chart that links a pivot table and chart from a table portion on a sheet. Customize country and market, adjust axes and values, delete the pivot table.

Explore advanced filtering, spark lines, and links to enhance dashboards. Learn to use comments, text boxes, shapes, bookmarks, and headers and footers to organize and share collaborative Excel files.

Learn to create headers and footers in page layout view, add page numbers, date, time, and file details, and customize first page and odd/even pages.

Explore text, signature lines, and symbols in Excel, using styles with color accents sparingly to keep data meaningful, then insert objects and equations including ink equations and symbols.

Explore the draw menu in Excel, including select, laser select, eraser, pen, highlighter, and the action pen that writes drawings into cells, with ink to shapes and ink replay.

Master how to manage and create a cohesive workbook theme in Excel 365, adjusting colors, fonts, and effects, and saving custom themes for consistent, professional projects.

Explore page setup, print preview, and sheet options to control orientation, scaling, and printing areas. Learn to manage print titles, page breaks, grid lines, and right-to-left sheet settings.

Learn to use operational math in Excel to perform addition, subtraction, multiplication, and division for invoices, including totals, tax, and balance due.

Explore the autosum feature in a weekly expenses table to quickly compute sum, average, max, and min, while excluding the total from the average and selecting ranges with the mouse.

Build a functional monthly expense tracker in Excel by creating expense, dashboard, notes, and cart sheets, using vlookup and iferror to link receipts to participants and calculate per-person totals.

Learn essential date and time formulas in Excel 365, including now, today, year, month, day, hour, minute, second, and date difference, with practical tips to simplify projects.

Create a timeline project in Excel using days360 to calculate total days from start to end dates and distance, then format the data as a table with headers.

Build a completion table with a countA formula to calculate the percentage of tasks completed. CountA tallies done tasks, divide by total, and update progress as items are added.

Build a real-world student progress tracker in Excel 365 using if and average formulas, conditional formatting with color scales to show results, and a pass/fail message.

Create a monthly student attendance tracker in Excel using countif to tally present and absent days, format as a table, and adjust print settings to fit one page in landscape.

Enrich your excel data using get and transform data to import from sources like csv, xml, files, or pictures, then apply data validation, filter, and sort.

Review your workbook before publishing by checking spelling, accessibility, and workbook statistics. Also review changes, version history, comments, and notes, then protect the workbook and sheet with edit permissions.

Enhance your viewing in excel by using normal view, page break, page layout, and custom views. Zoom, freeze panes, split, and arrange windows to review the time sheet more effectively.