Excel Zero to Hero 2026: Practical Skills & Real-World Uses

Create and rename Excel worksheets, enter values and formulas, and apply data formats to distinguish numbers from strings; save in CSV or PDF and set the print area.

Learn worksheet basics with ribbons, create and rename sheets, rearrange tabs, and enter values in a new blank workbook using common Excel tools and commands.

Learn to enter values and formulas in Excel, select ranges, and use sum to total data, with quick shortcuts and editing options for saving your workbook.

Explore data formats in Excel, distinguishing text, numeric, date, time, and currency data to inform formulas. Use format cells to control decimals, currency symbols, and date layouts.

Learn data handling basics in Excel by using cut, copy, and paste to move or duplicate two-column data, with clear source and destination concepts.

Learn how to save and print in Excel, including save as, print preview, page setup, and printing to PDF.

Master selecting cells, columns, rows, and the entire sheet in Excel, using the mouse, keyboard shortcuts such as Ctrl+A or Cmd+A, and range notation for selecting a specific area.

Explore excel essential functions, including mathematical, logical, and datetime functions, and learn to apply lookup formulas like match plus index to real data in training sessions.

Master basic formula operations in Excel using built-in functions, AutoSum, and the function library across financial, logical, text, date time, and lookup categories.

Learn how to use built-in Excel functions like sum and average, select data ranges, and apply conditional averages (average if) to compute male and female salaries from real-world employee data.

Master essential Excel formulas like counta, countif, mod, and round to analyze non-empty data, count employees by gender or department, and create dynamic real-time summaries.

Learn to format dates and times in Excel using format cells, Ctrl+1, and regional settings (India, England) for databases.

Learn how to use the vlookup formula in Excel to map salaries from two tables by employee id, covering exact matches, table arrays, and column indices.

Learn to use the hlookup formula for horizontal lookups, matching employee IDs across a row to retrieve salaries and other data from master data, with exact or approximate matches.

Learn to combine hlookup with a match formula to pull employee names, IDs, departments, and salaries from a master data table across multiple rows for real world sales reports.

Learn how to use index and match to retrieve data from a master table, compare lookups with vlookup, and apply real-world salary data scenarios.

Explore x lookup basics, functions and formulas, handling exact and approximate matches, and using wildcard characters to filter, search, and prepare analysis reports and charts.

Learn how to use the XLOOKUP formula in Excel 2021 or Office 365 to find country codes and dial prefixes by entering a country name and retrieving the corresponding data.

Master handling #N/A errors and implement exact and approximate matches with XLOOKUP. Use not found and match_mode to return grades from a scoring table.

Learn to use wildcard characters with XLOOKUP to match data across lookup and return arrays, extracting battery life for phone models.

learn to import data from text and CSV files, split text into multiple columns, use flash fill, remove duplicates, and validate data in Excel for real-world data analysis.

Learn to split a single text column into multiple columns in Excel with the text to columns tool, using delimited or fixed width options.

Learn how to use flash fill in Excel to auto-fill data, extract digits or text with left, right, and mid, and concatenate names with Ctrl+E.

Learn to remove duplicates in Excel data using data tools, including choosing selection, headers, and columns. Apply advanced filter and conditional formatting to highlight and preserve unique values.

Learn to apply data validation in Excel to enforce correct inputs by cell, using criteria such as text length, whole numbers, ranges, and custom rules with input messages and alerts.

Learn to import data from text files into Excel using Get Data from Text or CSV, select the correct delimiter, and load or transform with Power Query.

Learn to import data from a CSV file into Excel by setting the comma delimiter, splitting into columns, and loading the data as a usable table.

Learn to format data and build tables, including font selection and beautification, cell alignment (center, left, right, justify), and number, currency, and date formats for clear report presentation.

Learn practical font formatting in Excel, including applying bold, italic, and underline, adding borders and fill colors, and adjusting font type, size, and color for cell data.

Learn to format text in Excel using alignment options, center or justify text, merge cells for headers, rotate text, wrap text, adjust indentation, and apply borders for clean, professional spreadsheets.

Learn to format numbers in Excel, set decimal places, apply currency symbols, and switch between general, number, and currency formats using the format cells shortcut (Ctrl+1) for precise data presentation.

Master formatting dates in Excel by choosing from and creating custom date formats, applying them to cells or entire sheets for clear, report-ready data.

Master formatting tables in Excel by applying clean designs, text alignment, rotations, and number formats. Create tables with headers, filters, and table styles, including pivot table basics.

Discover how to create and design pivot tables, adjust value field settings and decimal formats, and use the pivot table design wizard through a step-by-step introduction.

Create an Excel pivot table from clean source data by dragging fields to rows, columns, and values; summarize sales and units with automatic refresh when data changes.

Unlock value field settings in Excel pivot tables to summarize data with count, average, max, min, product, and standard deviation, and format as currency or percentages.

Identify and apply number formats in pivot tables, adjust decimal points, and set currency or accounting formats with US or Canada symbols to align totals. Explore drill down for details.

Explore pivot table beautification options to transform raw numbers into appealing, readable designs with subtotals, grand totals, layout choices, and table styles.

Practice a simple Excel exercise to prepare a pivot table and enable quarterly fields in the pivot output, then compare your results with the instructor's solution.

Drag pivot table fields to enable quarters and subtotals with readymade tools, generating a ready-to-use analytical report covering first through fourth quarters and regional views.

Learn how to create and customize Excel charts, from column, bar, line, area, pie, donut, to scalar and bubble charts, including chart elements, data settings, and ribbon options.

Explore the categories of Excel charts, from column and bar to line, pie, donut, sunburst, histogram, scatter, and map charts.

Master chart elements in Excel by building 2d and 3d column charts, adding titles, axis labels, data labels, data tables, error bars, gridlines, legends, and trend lines.

Learn an easy method to create charts in Excel by selecting data, inserting a chart, and choosing 2D column or 2D bar types; customize titles, labels, and chart designs.

Create column and bar charts in Excel by selecting data, inserting charts, and applying 3D formats, then switch rows and columns and adjust chart formats and titles.

Learn to format charts in Excel by adjusting chart type, colors, shadows, transparency, blur, glow, soft edges, borders, fills, patterns, 3-D effects, and chart size, locking, and background options.

Line charts in Excel visualize year-wise data by selecting the data range, inserting a line chart, and adjusting data and borders to customize the visualization.

Learn to create area charts in Excel quickly by selecting data, inserting a 3D area chart, and adjusting the plot area with real-time data.

Learn to create and customize pie and donut charts in Excel, including selecting data, inserting charts, separating slices, and enabling data labels and chart elements.

Learn to create and format an area or xy chart by selecting data and inserting a chart. Adjust axis, plot area, and number formats for clear visuals.

Learn to create scatter and bubble charts from three-column data by selecting clean data and inserting the chart in Excel, including 3D bubble options.

Explore advanced Excel charts such as frequency distributions, histograms, waterfall, sunburst, tree map, combination charts, and sparklines. Learn how to map data to these visuals and create great analytical charts.

Learn to build frequency distributions and histograms of ratings data in Excel, using countif methods to group into 4–6, 6–8, and 8–10 ranges and visualize with histogram charts.

Learn to create a waterfall chart in Excel by selecting data, inserting a waterfall chart, and adjusting for increases, decreases, and totals across years; apply edits with simple actions.

Learn sunburst and tree map charts in Excel to compare hierarchical values, change data ranges, add data labels, adjust branches, and choose chart types for business needs.

learn how to create combo charts in Excel by combining multiple chart types. explore selecting data, inserting the combo chart, and modifying chart type and design to fit your analysis.

Learn to create and customize sparklines in Excel, including line, column, and win/loss mini charts, to visualize data trends in a single cell for quick insights.