Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

Gain speed in excel with keyboard shortcuts for date and time, navigation, and data entry. Use the fill handle, quick selection, and insert or delete rows and columns across worksheets.

Master nested formulas in Excel by combining if, vlookup, and rand between to create a random sample from a unique list of products for valuable customers.

Learn how dates are stored as serial numbers in Excel, perform date and time calculations, and format results as dates or times, including adding and subtracting dates.

Master len and trim to clean data and remove trailing spaces, then apply if and iferror formulas to handle errors in Excel, with examples like a discount calculation.

Build a look-up sheet based on the customer's first name using paste special and transpose. Apply hlookup and match to fetch the customer's last order date, newest to oldest.

Learn how to record and run macros in Excel, using absolute and relative referencing, and enable the developer tab to automate repetitive tasks with VBA.

Explore text to columns and flash fill in excel, using delimiters or fixed width to split data, and generate emails and dates with pattern recognition.

Master data validation in Excel by creating dynamic dropdown lists from a unique product list, removing duplicates, turning it into a table, and using named ranges via the name manager.

Explore sparklines, mini line and column charts in a single cell to quickly visualize yearly data, distinguish highs and lows, and compare positive and negative values.

Build an interactive mini data set with a scrollbar form control, linking a cell and using index and iferror to update name, date, product, and orders in a chart.

Learn to use a combo box in excel to filter a chart by month and year, create month and year formulas, and build a sumifs-based summary across sheets.

Insert and link option buttons to switch chart data by year and month. Use format controls and nested if formulas to drive the data display and keep the chart user-friendly.

Apply conditional formatting to highlight sales performance, compare top reps with data bars and color scales, and create new rules or formulas for dynamic, visual insights.

Master advanced Excel charts by using combo charts with a secondary axis, highlighting top performers with max and if formulas, and grouping by gender for insights and data labels.

Master pivot table visuals by learning design options, conditional formatting with data bars, subtotals management, sorting, and spark lines to enhance readability.

Master summarizing values in pivot tables and deepen pivot table skills with the Analyze tab, refreshing data, creating groups, and using show report filter pages to print per filter.

Explore how to use show values as in pivot tables, including percent of column total and percent of row total, to analyze sales by city and salesperson.

Learn how to create calculated fields in pivot tables, apply discounts, and interpret totals by mastering the order of operations and sum product in Excel.

Learn how calculated fields in advanced excel handle sums, counts, and averages, including a sidestep with a helper column to count and prepare pivot charts.

Master pivot charts in Excel by building pivot tables, converting to charts, and filtering with field buttons; compare with regular charts and use a range-based workaround to avoid bugs.