Complete Excel Bootcamp: Zero to Hero in Excel

Compare Excel versions across PC and Mac, explain 365 subscription vs perpetual licenses, updates, and cross-platform compatibility, with guidance on choosing the right version and checking function support.

Explore how to launch Excel, navigate the ribbon and quick access toolbar, and customize the interface with templates, options, and shortcuts for efficient work.

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.

Master Excel navigation and selection: move between cells with arrows, use tab and enter, and select sheets, rows, columns, and data ranges with shift and ctrl.

Edit cells by typing or using the formula bar, adjust partial content with double clicks, and hide or unhide sheets, rows, and columns with handy options.

Learn to move and copy sheets, rows, columns, and cells across workbooks, using drag-and-drop, move or copy, and copy-paste with formulas and values, while handling overlaps and references.

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.

Master essential Excel actions like selecting multiple worksheets and rows, navigating with shortcuts to final data cell, hiding and unhiding columns, editing cells and formulas, and moving or copying sheets.

Master Excel's special paste options to copy formulas, values, formats, and transpose data, then manage sheets and delete rows, columns, and cells with precision.

Learn how to use auto fill to copy formulas, recognize patterns, and fill down, including days, dates, and years; insert rows, columns, and copied cells while preserving formatting.

Practice common Excel actions through exercise set two, test your mental muscles by completing all listed actions, and review solutions to reinforce Excel skills.

Practice practical Excel actions by copying formatting, pasting values, and transposing data; delete and insert columns, rows, and sheets; autofill sequences, and copy-paste across cells to reorganize workbooks.

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.

Group, collapse, hide subtotals, and nest data in Excel to organize rows and columns; then freeze panes to keep headers visible as you scroll.

Explore how to print and set up pages in Excel, including orientation, page breaks, and print area, then optimize with scale to fit, view modes, and zoom.

Adjust the horizontal page break so all selected columns fit on each print sheet. Understand how to print multiple sheets with all columns across the data.

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

Master cell references in Excel by exploring how copying changes references and how to apply locks: total lock, column lock, and row lock, using F4 to toggle dollar signs.

Explore cascading references to assemble data across cells and sheets using concatenation and IDs or names. Note cautions on cross-workbook links and named ranges, which can break or complicate formulas.

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.

Apply list operations in excel with an exercise across three tabs, practicing sorting, filtering, conditional formatting heatmaps, plus deduplication and data validation for segments and shipments.

Sort by customer name; filter orders after 2015-01-01; apply conditional formatting to sales, discount, and profit; deduplicate segments; add data validation for shipments (ship modes) and segments.

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.

Apply logical functions to compute the expected and actual days, group b-d and f-h columns, and determine at-risk or delayed status from end date comparisons with a delay buffer.

Explore solving Excel exercises using logical functions and if statements, calculating expected versus actual days, grouping data, and applying absolute references to mark risk and delay with a delay buffer.

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.

Apply conditional formatting in Excel to build a Gantt chart, coloring weeks gray for expected, green for actual, and yellow or red for risk or delay using calculations tab (F3).

Use formulas to drive conditional formatting in Excel, shading green for start, yellow for at-risk, and red for delayed activities. Organize the calculations on a separate worksheet to ease debugging.

Learn lookup functions in Excel, including VLOOKUP and HLOOKUP, using lookup values, table arrays, and exact versus approximate matches, and create composite lookups with a composite key and iferror.

Explore how index match expands lookup flexibility beyond vlookup by decoupling keys from column order; combine index and match to pull data by any row and column, with exact-match options.

Apply vlookup and index match to compute transaction revenue from price and quantity, then use if statements to flag expired cards and expired MasterCard and sum the results.

Explore excel lookup functions using vlookup and index match to retrieve card type and card expiration, then apply is expired logic and sum totals for transaction revenue.

Explore core text functions in Excel, including concatenate, CONCAT, and the ampersand for joining, plus find, search, length, left, mid, and right to extract strings.

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.

Create a compound key using concatenate, fetch credit via index match, enforce limits with if; then split phones into area code and last four digits using mid, search, right.

Master Excel math functions, from single value operations like floor, round, abs, and modulo, to aggregation and conditional aggregation, including sum, product, percentile, standard deviation, and sumproduct.

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

Explore a math functions exercise in Excel, using data for several questions, applying conditional formatting, and generating a list of distinct age categories with layered functions.

Master excel functions from modulo and rounding to averageifs, sumproduct, countifs, and index match, enabling data analysis, statistics, and conditional formatting.

Explore how Excel stores dates as serial numbers since January 1, 1900, and apply date functions like today, year, month, weekday, and custom formatting.

Learn to calculate date differences in Excel for various intervals, expressing results as fractional days and converting them to hours, minutes, seconds, and years using simple conversion factors.

Practice date functions in Excel by calculating day and hour differences between shipment and order date as decimals, applying a custom date time format, and identifying weekday with most shipments.

Apply date functions to compute day and hour differences between shipment and order dates, format times, and use averageif and countifs to identify the weekday with the most shipments.