Master how to create and open a workbook in Excel, including launching the app from the start menu or desktop, choosing blank or template options, and accessing recent files.

Learn to create new worksheets in a workbook using the plus sign, the home tab insert options, and keyboard shortcuts, building familiarity with multiple sheets in Excel.

Identify and troubleshoot common Excel errors, including division by zero, value, name, lookup, and reference errors, and learn to handle them with iferror.

Master the and function in Excel to make logic-based decisions using multiple criteria, with examples of true and false outcomes and nested if logic.

Explore the Excel cell() function to retrieve cell formatting, location, or content using the info_type argument, with an optional references parameter defaulting to the current cell.

Explore how the row function in Excel returns a cell's row number, and how to use an optional reference argument to compute row positions for data manipulation.

Master the Excel if function, a fundamental tool for logical tests and conditional statements that automate spreadsheets. See how to determine bonuses from sales data using true and false outcomes.

Explore the IFS functions in Excel to evaluate multiple conditions and return values based on the first true test, replacing nested if statements for clearer formulas.

Learn to apply the filter function in Excel to display rows that meet criteria, analyze data by department, and extract department-wise insights from a dataset.

Explore the date function in Excel to create date values, manage date data, and perform calculations for schedules and project timelines, using number format and custom year, month, and day.

Learn to use the datediff function in Excel to calculate date differences between start and end dates in years, months, or days.

Master the edate function for date calculations in Excel by starting from a date, adding or subtracting months, and applying it across rows with drag and down.

Master the EOMONTH function to calculate the end of a month from a start date, enabling efficient data calculations for taxes, financial planning, and project management.

Learn how to use the count function to tally numeric values in a range in Microsoft Excel, excluding blanks and noting related functions like blank.

Learn how to use the round function in Excel to round numbers to a chosen number of decimal places. Apply it to financial data and measurements for precise results.

Master the sum function in Excel to add up a range of numbers in a spreadsheet. Use the sum formula with parentheses and explore AutoSum for quick totals.

Learn how to use the average function to calculate the arithmetic mean of a selected range in Excel, a handy tool for data analysis and reporting.

Master the subtotal function in Excel to summarize, group, and organize data, including hidden or filtered rows, with practical examples of summing items like mouse and microphone.

Learn to generate subtotals with a grand total in Excel by selecting data, using the data tab, and choosing sum as the subtotal function to group and total items.

Explore the int and trunk functions in Excel, learn how int rounds down to the nearest integer, and how trunc offers optional decimal control for flexible rounding.

Master the len function in excel to count characters in a cell, including spaces, enabling quick text length checks and data analysis across numbers and text.

Master the Excel mid function to extract specific characters from text, learn its syntax using text, start_num, and num_chars, and see practical examples.

Learn how the Excel index function retrieves data from a specific cell in a range using array, row, and column arguments; discover practical examples and error handling.

Master the Excel match function to locate a lookup value in a range and return its position. Use exact and approximate matches, define the lookup array, and apply dynamic formulas.

Learn how the exact function in Excel compares text strings character by character, returning true only when text one and text two match exactly, and how case sensitivity affects results.

Master the HLOOKUP function in Excel to search a header row and return data from a chosen row, using exact or approximate matches, with practical sales data examples.