Excel 101 - Basic Excel. Learn Excel Fundamentals. (2025)

Explore Excel and its interface, learn Excel vocabulary, and see how resizing the interface adapts to your actions. Finally examine the clipboard and its functionality.

Learn core Excel vocabulary, workbook structure, and basic cell references, including workbooks, worksheets, the ribbon, tabs, name box, formula bar, and ready, enter, and edit modes.

The workbook interface adapts as you reduce size, with top bars squeezing and buttons turning into icons, then grouping. Expanding restores the full interface, which smartly adjusts to workbook size.

Excel's clipboard stores up to 24 copied items in a history pane. Access it via the down arrow and paste any item by clicking it or pressing Ctrl+V.

Explore cells, rows, and columns, and learn basic formatting in Excel. Cover cell and number formats, and review worksheet protection from unwanted editing.

Format cells from the home tab using the format cells window to control alignment, font, borders, and protection, then set font size and create an income table with net income.

Explore borders, text alignment, and cell coloring to format an Excel table; apply header styling, adjust alignment, and use fill and font colors for clearer data presentation.

Explore Excel alignment by merging cells with center alignment, wrapping text, and adjusting column width and row height to fit content.

Explore Excel's number formats from general to currency, accounting, and percentage, and learn how decimal places and negative values display in the cell formatting menu.

Learn to format a section based on another in Excel using the format painter to copy formatting and apply accounting format, while adjusting formulas for a second data set.

learn to use the fill handle to extend numbers, dates, and text as a series, copying formulas efficiently across many cells.

Discover the order of precedence and which operators come first in Excel, then explore the most used formulas: average, min, max, and count that form Excel's backbone.

Master the operator order of precedence in Excel formulas, from exponentiation to logical comparisons, and learn how parentheses override rules for accurate results.

Learn how the sum function in Excel adds numeric values, ignores text, and returns errors for invalid selections, with flexible cell references including nonadjacent ranges.

Learn how to use Excel's autoSum function to quickly total yearly sales per employee across months by selecting a range, confirming, and dragging the formula across rows and columns.

Master the average formula to compute the mean of numeric data in a range. It ignores text and logical values, and any errors in the range propagate to the result.

Learn how to count in Excel using count, counta, countif, and countblank to tally numbers, nonempty cells, cells matching criteria, and blank cells, with practical examples.

Master mean and max formulas to analyze numerical data in Excel by selecting a range. Practice with a sample, verify results, and explore combining formulas in one statement.

Compute total labor expenses with sum, min, max, average, and count; then apply a 10 percent salary increase via a formula and fill down.

Explore how to implement charts, insert tables, sort and filter data, and apply multi-criteria sorting, while locking cells, rows, or columns to let formulas work automatically.

Learn to visualize salary data with a two-dimensional pie chart in Excel, add data labels, remove the legend, and show each employee's share of the total.

Learn to create two-dimensional bar charts in Excel to visualize employee sales by quarter, compare performance, and adjust axis scales and data labels for clarity.

Learn to build a line chart comparing 2021 to 2020 results, with monthly points, then refine the title and vertical axis to highlight year-over-year performance.

Learn how to create an Excel table, sort data by name, and filter by position to view salary totals for juniors, using the search bar to refine results.

Filter and sort data without a table in Excel by using a header row and raw data, and format dates and times to reveal entry and exit times.

Identify duplicates in the employee salary data and understand how they distort annual spend, then remove them using Excel's remove duplicates in the table design.

Learn to remove duplicates in a single column outside a table to identify unique entries, and understand risks to adjacent data when shortcuts ignore nearby fields.

Discover how to group and ungroup columns in Excel to manage a phased, multi-year cost report, using outline controls, hide/show, and undo grouping.

Lock cells in excel by surrounding references with dollar signs to keep them fixed when copying formulas, as shown in a 2.4 percent inflation calculation and dragging down.

Master locking rows and columns with dollar signs to create a universal Excel formula that stays anchored to the correct CPI and category as you drag across months.

Learn how to lock rows and columns in Excel by freezing the top row and first column, keeping headers visible and speeding navigation through data.

Explore Excel's view side by side to compare two workbooks at once with synchronized scrolling, rearrange panes, and analyze 2020 versus 2021 income and operating expenses.

Explore part V introduction to Excel formulas, including ifs, and learn conditional formatting techniques for practical finance and data analysis tasks.

Master pivot tables to group and aggregate large data, count employees by country, and compute each country’s share of total happiness.

Modify your pivot table by placing country as row labels and counting employees per country, then show happiness score as a percentage of the grand total to compare country performance.

Learn to organize pivot tables by country, display salaries, and customize layout and style; apply subtotals and grand totals, repeat items, and adjust data sources for clear, informative reports.

Insert a slicer to filter data by country. Configure slicer settings to adjust layout, columns, and sizing, enabling fast filtering of multiple subgroups.

Use the sumif formula to total costs by country, with the country column as the lookup range and the cost column as the sum range, then compute each country’s share.

Apply the sumifs formula to calculate gross profit with multiple criteria, filtering revenue over 100000 and costs under 20000, and evaluate if gp meets the 50% threshold.

Use Excel's IF formula to award a 15% loyalty bonus for employees with over five years, calculated on their current salary. Lock cells to keep references when dragging.

Adjust the if formula in Excel by adding an equals sign after the greater-than operator so five years meets the minimum years criterion, ensuring accurate condition evaluation.

Learn how to use the IFS formula in Excel to assign grades from student scores using multiple conditions, returning the first true match to avoid wrong results.

Learn the Excel proper function, which capitalizes the first letter of every word in text or a reference. It doesn't trim spaces, so pair it with trim for clean results.

Demonstrate how the and formula tests multiple conditions—such as gender, age, and work experience—and returns true only when all criteria are met.

Apply conditional formatting in Excel by setting rules such as greater than, less than, or between to highlight salaries, then filter results by color to show values above 40k.

Explore advanced conditional formatting in Excel, including less than, greater than, between, and duplicate highlighting, with practical examples and dynamic formatting behavior.

Apply text-based conditional formatting to highlight cells with specific text (for example, Germany or Bulgaria) and to flag top salary rows with a yellow fill.

Advance through Excel fundamentals by exploring len and trim, left and right formulas, vlookup and xlookup, and combining index and match for powerful lookups.

Explore the LEN and TRIM formulas in Excel to count characters in a cell and remove extra spaces while preserving single spaces between words.

Master the left and right functions to extract characters from a cell, such as first four letters of a name or the last three for invoice numbers or country codes.

Map country residence IDs to country names in Excel with VLOOKUP, linking sheets, selecting the table array, using the correct column index, and applying exact match.

Discover the xlookup formula, which searches for a value across rows and columns, including left, right, top, and bottom directions, with syntax for lookup value, lookup array, and return array.

Explain Xlookup with match modes (0 exact, -1 next smallest, 1 next largest, 2 wildcard) and search modes (top or bottom). Demonstrates text-based lookups using asterisks and question marks.

Learn how the index match formula combines the index and match functions to search and return values using vertical and horizontal criteria, with a basic revenue report demonstration.

Use index match together as one function to compute the 2020 revenue and its legal costs, then express the result as a percentage.

Explore a two-part final assignment in Excel: clean and analyze employee data with duplicates, pivot tables, and charts; use lookup and IF formulas, and trim student scores to determine passes.

Learn to use vlookup instead of xlookup for task 6, with a step-by-step demo on selecting the proper range (column a to f), column index 6, and exact match.

Clean the data by removing duplicates and convert it into a table. Use a pivot table to summarize salaries by country and create a bar chart.

calculate the average number of previous jobs, find the percentage above that average, and increase salaries by 10 percent for those above or equal to the average using Excel formulas.

Learn to grade exams in Excel using ifs logic to classify scores, count passes, and compute pass percentages, with countif and data trimming for clean results.