Complete Excel Bundle: 5-in-1 Beginner to Advanced Course

Explore the fundamentals of cells, rows, columns, and workbooks in Excel. Learn how the active cell, naming box, and sheet references organize data across multiple worksheets, with saving options.

Explore the ribbon toolbar, including the home and insert sections, and learn to view grid lines, headings, and the formula bar to shape your sheet.

Learn to select cells, ranges, columns, rows, and the entire sheet in Excel using mouse drag, shift for ranges, and ctrl for noncontiguous selections, while tracking the active cell.

Master altering rows and columns in Excel by resizing columns with drag and double-click auto-fit, adjusting row height, and applying uniform widths across selections or the entire sheet.

Learn to apply and customize borders in Excel, using bottom, top, left, right, outside, and all borders with style, color, and thickness. Compare borders with grid lines and remove them.

Execute a revision exercise in Excel to create an 11 by 11 bordered grid named times table square, adjust column widths and row heights to 50 pixels, and rename worksheet.

Explore data types in Excel, transforming text, numbers, dates, and times with formatting options. Learn to apply currency, accounting, decimals, percentages, dates, and scientific formats to cells.

Format data in Excel by adding a new worksheet and applying font styles bold, italic, underline, sizes and colors, then adjust alignment, wrap text, and merge cells.

Learn to use Excel's autofill to create a series from a single cell, drag the fill handle, and apply fill series, dates, months, years, and growth trend.

Master creating Excel formulae with the equals sign, arithmetic operators, and cell references; see real-time recalculation via the formula bar and the autofill function.

Learn formulae and autofill in Excel, using relative addressing to copy formulas across cells, and master brackets, bidmas, and the order of operations.

Explore relative and absolute addressing in spreadsheets, including fill series, locking cells with dollar signs and F4, and creating robust formulas that copy correctly across rows and columns.

Learn to format cells in Excel by adjusting column widths and borders, applying bucket fill, and choosing font and fill colors, including rgb values and 256 shades.

Create a times table square in Excel using autofill and fill series, apply formatting, and master absolute vs. relative addressing with dollar signs for a single reusable formula.

Learn to protect a worksheet in Excel by unlocking specific cells, applying protection with a password, and restricting edits while keeping designated input cells accessible.

Learn to apply data validation in excel to restrict cell inputs, enforcing values like whole numbers 1–100 with input messages and error alerts.

Master creating lists with data validation by supplying a list source, including from another sheet, and use hide options and error alerts to guide correct input in Excel.

Learn to add and delete rows and columns using right-click context menus and the insert or delete options, while Excel preserves data validation references.

Apply conditional formatting in Excel to color cells by value, using new rules and format by value ranges; highlight duplicates and unique cells with rule precedence.

Explore the mod function in Excel and learn integer division, using quotient results and remainders from examples like 9 divided by 3 and 20.

Learn to build a times table square in Excel, using dynamic cells, absolute addressing, and data validation, then apply mod-based conditional formatting to reveal even and odd patterns.

Set up a battleship game in Excel by creating a new workbook and designing an 11 by 11 grid. Format cells, merge headers, and prepare a two-player play area.

Learn to use the if function in Excel to act on a logical test. Explore true and false outcomes, text in speech marks, and nested ifs referencing other cells.

Explore the countif function in Excel, which counts items matching a condition within a range. The lesson demonstrates using numbers and letters, notes case-insensitivity, and shows that non-matches return zero.

Explore the counta function, which counts non-empty cells, including spaces, using full columns or specific ranges, with examples that lead to a look at nested if.

Learn how to build nested if statements in Excel, using functions inside functions, including even/odd checks, while noting limits and alternatives.

Explore how to use the sum function in Excel to add a range of values with =SUM(range), and recognize when it’s appropriate versus adding two or three cells manually.

Explore named ranges in Excel, create and name ranges such as some_1 and some_2, and use them to simplify formulas, handle absolute vs relative addressing, and improve readability.

Name a setup range to count ships with count if, use if and concatenation, adjust formulas with relative addressing, protect sheets, and replicate grids for blue and green battleship setups.

Explore how 3D formulas pull data from other sheets in Excel by referencing named ranges and cell addresses, then sum across those references.

Explore inserting shapes from the insert menu in Excel, customize with fill colors, gradients, textures, text, hyperlink options, and independent movement from cells.

Insert and format images in Excel from device, stock, or online sources, then crop, rotate, shadow, and adjust brightness, contrast, and transparency. Understand JPEG vs PNG and remove backgrounds.

In this battleships lesson, learn to set up two 11x11 grids in Excel, name them, test and protect the sheet, and build a hit or miss formula with relative references.

Learn to build a Battleships game in Excel by using conditional formatting, cell ranges, merge and center, protection, and in-workbook linking to create interactive navigation.

Explore comma separated values and file extensions, and learn to view csv extensions and import csv data into Excel.

Explore exporting data from Excel, converting CSV files to PDF, XPS, and other formats, and understand save versus export, including how CSV saves only the active sheet.

Excel is not designed to work directly with CSV files, so saving as CSV can cause data loss; use the legacy wizard to import data from text files.

Learn to import CSV files using the legacy wizard in Excel, enable the legacy option, select comma delimited, mark the top row as headers, and place data correctly.

Explore the mean with the average function in Excel by summing values and dividing by count, and see how values skew the result using a dataset of one million numbers.

Discover how the median and mean differ in Excel. Learn to compute the median by ordering data and finding the middle value, and see how extremes affect the mean.

Explore the mode function in Excel, identifying the most common value and how frequency determines the mode, with notes on legacy compatibility and alternatives for no mode or multiple modes.

Learn how to use the mode.sngl function in excel to identify the most commonly occurring value; excel splits mode into mode.single and mode.double for compatibility.

Identify multiple modes with excel's mode.mult by selecting a column, tally frequencies, reveal two modes, and compare mode.single versus mode.mult, noting mean is called average.

Import a grade list CSV into a new Excel worksheet, clean the formatting, and calculate total, average, median, and mode to analyze student performance during the revision.

Master the VLOOKUP function in Excel to fetch data from a table, convert imported data to raw data, and use exact or approximate matches with named ranges and data validation.

Explore the hlookup function as a variation of vlookup by loading data, naming a range called subject_grades, and retrieving computer science grades with an exact match.