Beginner to Advanced MS Excel Course

Explore data organization and cleaning in Excel, covering sorting, filtering, removing duplicates, and text functions like left, right, mid, trim, and concatenate with practical examples.

Master the if function in MS Excel, with three arguments, then apply and, or, and not to create complex logical conditions using real-world examples like sales targets and stock status.

Master the Vlookup function in Excel to search the first column of a range and return a value from a different column, using exact or approximate matches for lookup tasks.

Explore how hlookup performs horizontal lookups by searching the first row of a table and returning values from the same column, with exact or approximate matches.

Learn index and match for flexible lookups in Excel, alternatives to vlookup and hlookup, returning values by row and column and locating exact matches, then combine them for dynamic lookups.

Master table slicers in Excel to visually filter tables and pivot tables by clicking buttons, and learn to add, configure, and use them on a sample superstore dataset.

Learn how structured references replace cell ranges with table name and column headers to create readable, dynamic range formulas with no manual adjustments.

Create and customize line, pie, column, and combo charts in Excel to analyze data. Explore chart designs, axis options, and formatting to highlight trends and comparisons.

Learn to summarize and visualize data in Excel with pivot tables and pivot charts, performing aggregates like sum, average, count, min, max, and dynamically group by region, product, and filters.

Explore pivot tables to group data by month, quarter, and year, summarize sales with sum, average, and count, and drill down for detailed insights.

Explore eight nested functions in Excel, including if with and or, vlookup with iferror, sumif, index with match, left with find, and date with year and month.

Master array formulas in Excel with single and multi cell types, learn sum of squares, sumif, and transpose, plus dynamic arrays and ctrl-shift-enter guidance.

Master advanced text functions in Excel by formatting numbers and dates, using text, left, right, and mid, trim, and concatenate to create currency-formatted cells and merged strings.

Learn advanced date functions in Excel for live dashboards and deadlines, including today, date diff, workday, networkdays, and date formatting with text functions. Also cover edate and eomonth basics.

Set up data validation rules in Excel to control input types, values, and messages. Explore validation criteria, input messages, error alerts, and drop-down lists to enforce data quality.

Learn to protect worksheets and workbooks in Excel by locking and unlocking cells, protecting sheet and structure, allowing specific edits, and encrypting with a password.

Learn how to establish data relationships in Excel by linking tables with primary and foreign keys, enable the data model, and analyze across tables with pivot tables.

Power Query Editor in Excel enables importing, cleaning, transforming, and reshaping data from multiple sources, automating workflows, and saving reusable queries for dynamic monthly reports.

Learn powerful Power Query techniques in Excel, including removing duplicates, splitting columns, and unpivoting data, then create custom and conditional columns and merge queries.

Learn to join six hospital data tables in Power Pivot and Analysis, establishing relationships and pivot tables in Excel.

Discover Power Pivot in Excel to model data, create relationships between tables, and build DAX measures for pivot tables and dashboards.

Master descriptive statistics in Excel, including mean, median, mode, and standard deviation. Use iris data and simple examples to compute these measures with functions like average, median, and mod.sngle.

Learn correlation and regression in Excel with ad budget and revenue data, using Analysis ToolPak, and interpret the regression equation y = mx + b and R-squared.

Enable and use the data analysis toolpak in Excel to perform descriptive statistics, correlation, t tests, ANOVA, moving averages, and rank and percentile analyses.

Explore what-if analysis in Excel with goal seek and scenario manager, using inputs to forecast revenue, profits, and multiple scenarios for comparative insights.

Learn to build one-variable and two-variable data tables in Excel for what-if analysis, showing how loan inputs like interest rate affect monthly payments via the PMT formula.

Learn how to record your first macro in Excel, automating repetitive tasks by capturing and replaying a sequence of actions—from enabling the developer tab to saving as a macro-enabled workbook.

Modify recorded macros in Excel by editing the underlying VBA in the Visual Basic for Applications editor, learning to adjust ranges, formatting, and comments to customize macro behavior.

Learn the basics of VBA syntax in Excel, including macros, modules, and variables with data types such as integer, double, string, and boolean, plus how to use msgbox and concatenation.

Explore how VBA loops work in Excel, focusing on for next loops for a known number of iterations and do while loops for conditions, with step-by-step examples using message boxes.

Learn how to implement VBA if-else in Excel, using comparison operators to build conditional logic, declare variables, and test macros with message boxes.

Learn how to work with Excel objects in VBA, including workbooks, worksheets, and ranges, by creating macros that format cells, set fonts, colors, and values.

Explore message boxes and input boxes in VBA for Excel automation. Show how to display information with a message box and capture user input via an input box.

Master error handling in VBA for Excel automation, using on error resume next, error.number, and error.description to handle division by zero and runtime errors.

Create user defined functions in VBA for Excel to automate repetitive tasks. Build functions like add numbers and EMI calculator, declaring parameters and calling them in cells.

Learn to automate repetitive tasks in Excel using macros and VBA, including recording a macro, writing simple modules, autofitting columns, applying borders, and formatting data, saved as a macro-enabled workbook.

Learn to build a financial analysis dashboard in Excel for beginners, using pivot tables, charts, and a navigable layout. Track revenue, gross sales, profit, and profit margin with dynamic KPIs.