Microsoft Excel Masterclass: Learn Excel Step by Step

Enter and edit data in Excel by typing in cells and navigating with tab and enter. Apply formatting and fill handles to organize, copy, and present data.

Learn to copy, cut, and paste data in Excel, including keyboard shortcuts and paste options like values, formatting, and formulas.

Master Excel formatting by applying font styles, colors, and cell alignments to create professional, easy-to-read spreadsheets.

Apply borders and shadings in Excel to organize and highlight data, using the home tab, border options, format cells, and fill colors to customize line styles, colors, and patterns.

Learn to perform basic calculations in Excel using the sum and average functions on expense data, display totals in a cell, compute averages, and use AutoSum for quick totals.

Master Auto Fill and Flash Fill in Excel to save time and boost productivity, demonstrating quick series creation, weekends, months, custom lists, and real-time data cleaning.

Sort data in Excel by alphabetical, numerical, or colors, use multi-level sorting for regions and sales, and filter via the data tab by categories, numbers, or colors, then clear filters.

Explore how Excel tables structure data with built-in formatting, filtering, and formulas. Create tables from raw data, customize styles, and leverage updates, sorting, and total rows.

Master conditional formatting in Excel to automatically highlight top performers, trends, and errors with colors, data bars, color scales, and icon sets.

Explore custom number formats in Excel to control how numbers, text, and dates appear without changing values, using four sections (positive, negative, zero, text) and leading zeros.

Learn how to link data across sheets in Excel, referencing single cells or ranges so values update automatically as source data changes, using tables, named ranges, and arrays.

Group and ungroup worksheets in Excel to apply headers, formatting, tables, and formulas across grouped sheets, saving time and preventing accidental data overwrites.

Explore excel's logical functions (if, and, or) to create conditional formulas that determine pass or fail from scores, combine conditions, and automate data analysis.

Master Excel lookup and reference functions, including VLOOKUP, HLOOKUP, and XLOOKUP, to quickly retrieve data like employee salaries by ID, using exact match and the return array.

Learn how to use today, now, and date functions to display the current date and time in Excel. Create custom dates and automate deadlines, calendars, and timelines to streamline workflows.

Master text manipulation in Excel using left, right, mid, concatenate, and text functions to extract substrings, join names, and format dates and numbers.

Create and customize pivot tables in Excel to analyze data by region and product, format currency, sort and filter insights, and build pivot charts with slicers.

Transform your data into dynamic, interactive visuals by creating pivot tables and pivot charts in Excel, then customize charts and add slicers to filter data with a click.

Create dropdown lists in Excel to standardize data entry, reduce typos, and simplify analysis by selecting items from a source list through data validations.

Learn to restrict invalid data entry in Excel with data validation, enforcing whole numbers, dropdown lists, and date ranges, while customizing clear error messages.

Explore goal seek, data tables, and scenario manager to solve complex data questions in Excel, study how to set targets, compare scenarios, and present options clearly.

Learn to create and customize column, line, and pie charts in Excel using a well-structured data set with headers, then format titles, colors, axes, and labels to present monthly sales.

Customize chart elements in Excel by turning a basic column chart into a polished visualization with descriptive titles, formatted axes, data labels, color themes, and optional trend lines.

enrich your Excel dashboards with sparklines and dynamic charts, turning data into quick visual summaries and interactive charts that auto-update as you edit tables.

Create an interactive Excel dashboard using a named data table, a pivot table, and slicers and timelines to filter by regions, products, and dates, with accompanying charts.

Learn how to record and run macros in Excel to automate repetitive formatting of headers and tables, enable the developer tab, save as macro-enabled workbooks, and edit or delete macros.

Master automating repetitive Excel tasks with flash fill, formulas, and macros (VBA), plus tips on enabling the developer tab, recording macros, and using templates, queries, and conditional formatting for visuals.

Create and use Excel templates to streamline budgeting, project tracking, and data organization, boosting productivity through consistency, accuracy, and pre-built formulas and formatting.