Advanced Excel for Business

Master advanced cell locking in Excel by using absolute, relative, and mixed references to build scalable formulas, autofill across rows and columns, and implement discount-rate calculations.

Explore using go-to special to locate cells with formulas, view show formulas, and examine conditional formats, data validations, and the last cell while tracing precedents and dependents.

Use the offset function to reference cells by a given row and column, define height and width, nest it in other functions, and apply to quarter revenue and expenses.

Explore how to use if statements with and and or to evaluate average sales for Q1 and Q2, determine certificate award eligibility, and label progress as excellent or probation.

Use Excel's scenario manager to build and compare multiple demand scenarios side by side, adjusting quantity sold, selling price, variable costs, and fixed costs to see impact.

Build and analyze hierarchical pivots in Excel, convert data into tables, apply conditional formatting and data bars, and create charts that reflect sales revenue by region and city.

Use the match function to drive vlookup column indices for dynamic, accurate lookups across many columns, with named ranges and data validation that update when structure changes.