Basic Excel - Excel for beginners in 90 minutes

Enter the data, add headers, and save the workbook to cloud or pc, then format the table by adjusting wrapping, column width, and header styling.

Learn to clean data by standardizing date formats, fill missing quantities, and format prices to USD using Excel shortcuts like Ctrl-1, with custom and default formats for consistent reports.

Sort Excel data by date or by two metrics, such as region and date, apply A to Z or Z to A, expand the selection, and undo with Ctrl Z.

Filter data in a table by region or criteria using column filter arrows. Clear filters, apply less than 500, and toggle with control shift l.

Enable filters to show the five worst performers by quantity and save region-specific views to OneDrive for easy sharing.

Learn to manually format cells and apply cell styles in Excel, including backgrounds, borders, fonts, merging titles, and creating or customizing styles for polished reports.

Explore how formatting changes what Excel displays versus the underlying data, including numbers vs text, dates, currency and accounting formats, decimals, separators, and clear formats.

Learn to apply conditional formatting to visualize data in Excel, highlighting top and bottom orders with color scales, data bars, and icons, and manage or clear rules as needed.

Enhance layout and readability in Excel by using freeze panes for headers, adjusting row height and column width, and toggling grid lines for a cleaner, readable worksheet.

Convert data to a table and name it, apply table styles, and enable a total row. Use calculations like average and sum to analyze quantities and freight in Excel.

Extend the table, add a total column, and automatically compute unit cost times quantity and net cost with a 5% discount, then format numbers with separators.

Learn how to enter and apply basic excel functions such as sum, average, min, and max using fx, formulas, and autosum to build a concise summary table.

Format Excel charts by adding chart elements, customizing titles and data labels, and adjusting axes for clarity. Remove unnecessary series and the y-axis to boost readability and focus.

Develop and polish charts by formatting elements with right-click, highlighting the series, and adjusting colors; use quick analysis for percentage totals and accessible contrast to communicate pods clearly.

Explore pivot table expansion, filters, and sorting to identify the top warehouse by revenue, rearrange rows, aggregate products, and generate a ready-to-share report.

Protect sheet and workbook in Excel by unchecking locked for cells you want editable, applying sheet protection with a password, and protecting the entire workbook for file-level security.

Set up page breaks and adjust margins in Excel to create a clean, printable dashboard for your manager, Chloe.

Explore the essentials of Excel with a basic course that covers formulas, tables, charts, a pivot table, and printing a real report, and gain a glimpse of common features.