Excel Data Analysis for Professionals and Analysts

Master essential Excel keyboard shortcuts for productivity, navigate with enter, tab, and arrows, select with ctrl+shift+arrow, and format, edit, or comment using common shortcuts like today(), ctrl+t, and shift+f2.

Identify and handle missing data in Excel by filtering blanks, then fill with the average or mark as unknown, or delete incomplete rows to clean your dataset.

Split a single column into first and last names using text to column, create emails with flash fill, and find and replace errors quickly using keyboard shortcuts in Excel.

Learn to create drop-down lists in Excel using data validation, define a department list, and apply it to a column by referencing a range or table.

Explore Excel lookup functions across vertical and horizontal datasets, including VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP, with XLOOKUP offering omni-directional search.

Master essential Excel text functions: left, right, mid, trim, len, and concatenate, to extract characters, remove spaces, count length, and merge text using dummy data.

Explore essential date and time functions in Excel, including today, now, month, year, day, week, edate, and date if, plus time formatting to compute ages, differences, and work hours.

Master nested and dynamic formulas in Excel by building multi-level if statements, sorting data, and extracting the top three students with index and large functions.

Explore how to use sumif, countif, and averageif to sum, count, and average data that meet specific conditions, demonstrated with practical Excel examples.

Learn how dynamic ranges in Excel auto-update with offset and indirect, using named ranges and the name manager to sum data and fetch product prices as you add new rows.

Learn to use conditional formatting in Excel to reveal data insights by highlighting high and low scores (80+ and below 60), spotting duplicates, and adding data bars for visual comparison.

Learn to use subtotal and grouping in Excel to summarize sales by product and by salesperson, using sort to group pens and pencils and show grand totals.

Explore pivot tables in Excel to summarize large data sets, drag fields to rows and columns, and apply filters, sorts, and formats for insights on regions, products, and revenue.

Master Excel data analysis by sorting, filtering, and grouping data, and using subtotals to compare department salaries.

Explore calculated fields in pivot tables and use custom summaries to compute price times quantity, then compare counts, averages, maximum, minimum, and percentages to reveal insights.

Learn how to build pivot charts from a pivot table to visualize region, product, and total sales, using slicers for interactive filtering and dynamic updates.