Microsoft Excel: Data Analysis, Management and Visualization

Learn four basic excel formulas—sum, average, min, and max—to analyze data, then use range selection and alt+equal for quick totals, with conditional formatting to highlight extremes.

Explore relative, absolute, and mixed references in Excel, showing how dragging formulas updates relative references, locks values with dollar signs, and fixes rows or columns for consistent calculations.

Explore Excel logical functions like if, and, or, and not to create dynamic, condition-based rules for discounts and weekend sales.

Master Excel text functions left, right, and mid to extract characters from the start, end, and middle, then combine names with concatenate and text join for a clean, readable list.

The lecture teaches how to use Excel date and time functions: today, now, datedif, and end-of-month, to manage schedules, calculate durations, and create dynamic time-stamped reports.

Learn to sort data by single or multiple columns and filter by criteria in Excel to organize and analyze large datasets efficiently.

Explore data validations and drop down lists in Excel to control data entry and reduce errors. Customize error messages and reference ranges to keep your data accurate and consistent.

Learn how conditional formatting in Excel formats cells by value to highlight trends and important data with colors, data bars, color scales, icons, and heat maps.

Learn to use flash fill and autofill in Excel to split and join data, generate emails from patterns, and extend series with the fill handle.

Master removing duplicates and text to columns to clean and organize data in Excel. Learn to select ranges, use the data tab, and apply delimited splits for names.

Analyze large datasets in Excel by creating pivot tables and pivot charts to summarize sales by region, drill down by product, and visualize results with dynamic charts.

Learn to filter data visually with slicers and timelines in Excel, converting data to tables or pivot tables, and building interactive dashboards for sales, regions, products, and dates.

Learn to use Excel subtotals and grouping to automatically summarize data by category, customize totals with sum, average, or count, and collapse or expand groups for focused analysis.

Learn to enable Excel's data analysis Toolpak and run descriptive statistics, including mean, median, mode, standard deviation, and range, with steps for input, labels, and output.

Explore scenario manager, goal seek, and data tables in Excel to model different inputs, reach targets, and visualize how price, quantity, and discount affect total sales.

Create and format column, line, pie, bar, and area charts in Excel to visualize monthly sales data with titles, labels, and axis information.

Master advanced Excel charts by creating combo charts, sparklines, and waterfall charts to visualize revenue trends, profits, and accumulative data with clear, color-coded visuals.

Learn to customize Excel charts by editing chart titles, axis titles, gridlines, legends, and data labels, apply number formats and styles for polished, professional data visualizations.

Learn to insert and design SmartArt in Excel to visualize data and ideas, customize layouts, colors, and styles, and format shapes for professional diagrams.

Master lookup functions in Excel—VLOOKUP, HLOOKUP, INDEX, MATCH, and XLOOKUP—with practical examples mapping product IDs to prices and performing exact-match lookups.

Explore how Excel array formulas and dynamic arrays automate calculations across ranges, leveraging sequence, filter, and sort to generate dashboards and streamline data analysis.

Master Excel error handling with iferror and iserror to catch formula mistakes and division by zero. Replace errors with meaningful messages to keep your spreadsheets clean and professional.