Advanced Excel Course with AI 2026

Explore the functions in Excel, including the sum and average functions, learn their syntax and inputs, and see how predefined formulas streamline calculations.

Master core mathematical functions in Excel, including sum, average, max, min, count, and rounding. Learn syntax and inputs (values, cell references, ranges) with an invoice dataset for totals.

Master formatting in Excel by applying fill and font colors, borders, alignment, wrap text, and pictures; use general, currency, accounting, date, time, percentage, and custom number formats with decimals.

Explore Excel database functions including dsum, daverage, dcount, and dget to filter a sales table by product via dropdown and compute subtotals, averages, and invoice counts.

Master relative, absolute, and mixed referencing in Excel, learning how formulas change across cells and how to fix references for accurate percent-of-total calculations in quarterly expenses.

Learn to boost productivity in Excel with keyboard shortcuts, master formula syntax, and apply relative and absolute referencing by focusing on row and column behavior.

Master sumif and countif to sum values by criteria and count invoices per customer, using ranges and criteria with sum range, illustrated by advertising and per-customer totals.

Explore how to replace and substitute text in Excel by position, specifying the starting position, how many characters to replace, and which instance to substitute.

Learn to extract characters from text in Excel using left, mid, and right functions, with practical examples like inventory codes and invoice numbers, including syntax and starting position.

Learn to merge data across columns with concatenate and clean up numbers using find and replace, turning multi-column codes into a single value and replacing 91- with 0.

Learn data cleaning in Excel by trimming spaces and changing case to ensure clean primary and foreign keys, improve lookups, and standardize text with upper, lower, and proper case.

Identify chart elements such as chart area, plot area, data points, axes, legend, axis titles, and data labels to easily format and understand a column chart.

Explore how to create and customize a 2D clustered column chart in Excel to show percentage change across expenses, with data labels, axis titles, and a clear chart title.

Create a column chart to compare budgeted versus actual expenses, rename series to budgeted and actual, and add rotated data labels for clear visualization.

Learn to create bar charts for expenses by category, with each bar’s length proportional to its value, and apply data labels, axis titles, color themes, and moving charts for Q1.

Learn how to create a combination chart that blends column and line charts to compare budgeted versus actual data, with carefully placed data labels and formatting tips.

learn to use a scatter plot to compare two numeric variables, temperature and accuracy, by plotting machines and adding data labels to reveal which machine performs best at specific temperatures.

Leverage index and match for vertical and horizontal lookups, overcoming vlookup limitations. Use match to derive dynamic row and column numbers with absolute references and named ranges.

Use hlookup to search the top row and return a value from a row in a budget table. Pair with match to derive dynamic row numbers for April percentage change.

Learn how approximate match in lookups works when exact matches are not present. Use vlookup with true to fetch the closest tax slabs or grading bands.

Enhance Excel lookups with practical tips. Keep lookup values short and spaces-free; use MATCH for row or column numbers; apply exact match unless data is sorted for approximate results.

Learn how to enforce correct data in Excel with data validation, covering 15-digit GST numbers, date ranges, value limits, and drop-down lists to ensure accuracy in professional spreadsheets.

Learn how to apply Excel filters to display data that meets criteria and hide the rest, and master advanced filters for complex criteria and copying results.

Learn to use Excel's filter and sort functions to extract data by criteria, such as department equals sales and designation equals manager, returning and sorting the resulting array.

Learn how to apply conditional formatting in Excel to highlight important data points using rules and criteria. Use icon sets and data bars to quickly identify high and low values.

Apply Excel conditional formatting with a formula to highlight employees in the name, age, and gender columns who are less than 30 and male, using an and condition and blue formatting.

Improve your Excel skills with tips from Ranjit: use custom sort for multi-column data, advanced filters for copied data, and conditional formatting to identify duplicates and highlight key figures.