Ultimate Microsoft Excel With Data Analysis & VBA Macros

Apply cell styles and themes in Excel to make spreadsheets polished and professional; use built-in styles, customize and save themes, and apply them across a workbook for consistency.

Learn to merge and split cells in Excel to format data and create clear table labels. Guide yourself through merging options, unmerging, and adjusting column widths for professional spreadsheets.

Learn to manage rows, columns, and worksheets in Excel by inserting and deleting rows, renaming tabs, applying tab colors, and copying or moving sheets across books.

Explore the fundamentals of Excel functions, including sum, average, max, and min, with practical steps to calculate totals, averages, highs, and lows in your spreadsheets.

Master basic Excel formulas for calculations by learning sum, average, multiply, subtract, and divide using ranges and the equals sign.

Learn how absolute and relative cell references work in Excel, how copying formulas updates references, and how dollar signs lock references.

Master autosum and autofill in Excel to streamline data entry and calculations, using the home tab, keyboard shortcuts, and fill handle to extend patterns and accelerate analyses.

Explore how to use the IFS function and the SWITCH formula in Excel to evaluate numbers against conditions and map outcomes such as pass or fruit names.

Learn to manipulate text in Excel using concatenate, left, right, and mid to combine full names into first and last names and to extract middle names.

Master date and time functions in Excel to create, extract, and convert dates and times—using today(), date(year, month, day), time(hours, minutes, seconds) and determining weekday or weekend.

Master how to create and use Excel tables to manage structured data with dynamic ranges, filtering, sorting, and totals. Learn structural references, naming, and analytics like sums, averages, and lookups.

Learn to sort by department, employee name, and salary; apply multiple columns and custom sort; filter by text, numbers, dates, and colors.

Master data validation in Excel to control input with drop-down lists, input restrictions, and custom messages, ensuring accuracy for fields like gender, status, age, and text length.

Remove duplicates by selecting the data range and name column, then use the remove duplicates tool and trim spaces to clean the dataset.

Enable sparklines in Excel to create compact in-cell charts for quick data visualizations, then select data, choose line or column types, and customize styles.

Create and customize bar, line, and pie charts in Excel to visualize quarterly sales data, adjusting colors, titles, axes, and chart elements with design tools.

Add chart titles, axis titles, data labels, and legends to cluster column charts for clear, professional visuals.

Format chart elements in Excel to improve clarity and aesthetics by adjusting axis levels, chart titles, data series colors, and layout styles for descriptive, readable visuals.

Learn to create and customize pivot tables and pivot charts in Excel, drag fields, apply filters, and refresh data for dynamic summaries and visuals.

Learn how to create pivot tables in Excel to analyze and summarize sales data by product, region, and salesperson, using drag-and-drop fields to calculate totals, counts, averages, and more.

Modify pivot table layout in Excel by dragging fields between rows and filters, expand or collapse details, and tailor appearance with options, styles, subtotals, and a slicer.

Create dynamic reports in Excel with pivot tables and charts, analyzing sales data. Use dynamic ranges via offset or table, change data sources, and refresh to update visuals.

Master advanced Excel functions including VLOOKUP, HLOOKUP, INDEX, and MATCH to manipulate data, perform exact lookups, and build dynamic analyses for data-driven decisions.

Master countif, sumif, and averageif to perform statistical analysis in Excel. Count cells meeting criteria, sum values by condition, and calculate averages for selected ranges.

Master array formulas in Excel to perform complex calculations, from summing squared numbers to finding max values by criteria, using control shift enter for batch results.

Master combination and dual axis charts in Excel to visualize multiple data sets with different scales, using recommended charts, secondary axes, and formatting options.

Explore data visualization in Excel by adding trend lines and error bars to charts, using scatter plots and options like linear, polynomial, and moving average, then customize styling and save.

Create dynamic charts in Excel using form controls and the developer tab, so changing product selections updates the chart automatically.

Explore advanced charting in Excel to create dynamic combo charts, sparklines, pivot charts, and map visuals, and customize with data bars and icon sets for compelling data visualization.

Learn to design interactive dashboards in Excel using pivot tables, slicers, pivot charts, and timelines; organize data in tabular form and create dynamic filters and visuals that reveal insights.

Master data filtering in Excel with slicers and timelines, using table formats to organize data. Create and use pivot tables and timelines to analyze trends over time.

Master how to link data between sheets and across workbooks in Excel, creating dynamic connections that automatically update and streamline large data management.

Design effective Excel dashboards by organizing data in tables, keeping it clean, and using clear visuals such as bar and line charts with interactive slicers to empower user insights.