Complete Excel Bootcamp: Zero to Hero in Excel

Explore the workbook structure, including multiple worksheets and cells, and learn how alphanumeric cell references uniquely identify each cell, with notes on csv versus excel file types.

Explore the anatomy of an Excel cell, uncovering its properties such as address, column, row, color, contents, format, protection, and type, and learn how these properties affect workbook behavior.

Develop muscle memory through hands-on Excel practice in exercise set one, focusing on copy and paste across ranges by copying three cells B9:B11 into column M to produce nine cells.

Learn how to adjust row heights and column widths, auto-fit sizes, and apply formatting with hotkeys, borders, alignment, date formatting, and the format painter in Excel.

Adjust column width and row height to fit content. Apply color and bold, copy styles with the format painter.

Explore common Excel functions and formulas, from logical functions and sum to min, max, average, median, and mode, with practical cell references, locking, and if logic for high value customers.

apply cell references and Excel functions across three exercises, building a cascading list of top polluted cities and evaluating 2021 air quality index thresholds using data from 2018 to 2021.

Master Excel references and functions, including absolute locking, row and column locks, and cascading lists with concatenate. Apply sum, average, median, and if logic to analyze data and format results.

Learn list operations in excel, including sorting (primary, secondary, tertiary), filtering (substring and value-based), and subtotals for quick statistics, plus advanced conditional formatting rules using formulas.

Duplicate data to create unique customer views, sum revenue per customer, and apply data validation to locations and store types lists to prevent invalid entries.

Master Excel logical functions, especially the if statement, by combining with sum, handling divide by zero with if error, and testing is blank or is error.

Master Excel's logical functions, including is number, is text, and, or, not, and learn to handle errors and values, validate imported CSV or text data, and manage nested if statements.

Construct a compound key from first name, last name, and age to look up credit and check the credit limit; then split phone numbers with text functions.

Learn conditional aggregation in Excel by using sumif, sumifs, averageifs, countifs, maxifs, and minifs with multiple criteria to summarize data efficiently.