Excel Data Management and Analysis for Basic to Expert Level

Explore how Excel formulas work by using operators and cell references — relative, absolute, and mixed — alongside the formula bar and copying techniques to calculate totals from a dataset.

Learn how to use basic Excel functions—sum, average, count, min, and max—on a sales data set to perform simple calculations and data analysis for reporting.

Learn to work with dates and times in Excel, using today and now to insert current date and time, and to calculate work experience from joining dates.

Learn to use if, and, or functions in Excel to perform conditional calculations and determine bonus eligibility based on sales targets in a simple data set.

Explore the left, right, and mid text functions to extract department codes, employee numbers, and joining years from a sample employee data set in Excel.

Sort sales data in Excel by amount in ascending or descending order and apply filters to display only matching records for targeted analysis.

Learn to create and manage Excel tables, name them, and use structured references to keep formulas dynamic, readable, and scalable as data grows.

Learn how to use data validation in Excel to enforce data integrity by restricting invalid entries, applying rules to employee IDs and ages, and using input and error messages.

Master pivot tables in Excel to analyze and summarize sales data and create reports. Drag fields into rows and values, customize calculations, and apply filters to explore sums and averages.

Learn to analyze data with averageif, countif, and sumif by applying conditional criteria to a revenue dataset, converting it to a table, and calculating sums, counts, and averages.

Learn to create and customize column, bar, line, pie, and scatter charts in Excel using a simple sales dataset; apply data labels and trend lines to visualize trends and comparisons.

Learn to create and customize charts in Excel by adding chart titles, axis labels, data labels, legends, and applying styles and colors to make monthly sales data clear.

Modify chart elements in Excel by adjusting axes, data series, and gridlines for clearer readability. Format data series, enable axis titles, and apply gradient fills and colors to enhance charts.

Create sparklines in Excel to visualize monthly sales trends inside a single cell, using line, column, or win-loss charts and basic customization.

Record and run macros in Excel to automate repetitive tasks without coding knowledge, then enable the developer tab and format a data table with a macro.

Learn to consolidate data from multiple worksheets and workbooks into a single summary sheet using Excel's consolidate feature, with practical steps for January, February, and March sales.

Explore what-if analysis in Excel with goal seek and scenario manager to adjust variables, forecast projected sales, and compare conservative, moderate, and aggressive growth strategies.

Import data from CSV, text files, and web sources into Excel, then export data in two formats using Power Query Editor to transform and work with external data sources.

Develop clear spreadsheets by applying borders, alignments, and consistent formatting, and convert data into tables with headers. Use data validation and conditional formatting to prevent errors and highlight key values.

Apply built-in Excel data validation to ensure data integrity and accuracy, preventing erroneous entries by enforcing range rules and informative error alerts.

Master essential Excel keyboard shortcuts to navigate with arrow keys, edit, and format data quickly, including table creation with Ctrl+T and selection shortcuts like Shift+Space, Ctrl+Space.

Explore how to identify and fix common Excel errors, including division by zero, reference, and hash value errors, using if and isnumber for reliable totals and price-per-quantity calculations.