Mastering Excel Formulas & Functions: Beginner to Advanced

Master find and search in Excel to locate specific text within cells or ranges; learn the difference—find is case sensitive, search is case insensitive—and apply to filter data.

Explore the concatenate function in Excel to combine names and text, add spaces, and format results with upper, lower, and proper case for clean reports.

Explore how to clean and extract text in Excel using the trim, upper, lower, proper, left, right, and mid functions, mastering common text manipulation tasks.

Learn the Excel REPT function to repeat text or symbols a given number of times. See syntax, symbols and spaces, decimals not counted, and combining with functions for formatting.

Learn how the now and today functions display the current date and time in Excel, update automatically with worksheet changes, and help track data entry timing and durations.

Master Excel date functions by extracting day, month, and year from dates. Create dates by specifying year, month, and day with the date function and apply the results across data.

Explore Excel date and datevalue functions, convert text to dates, and use edate and eomonth to add months and find month ends.

Create precise time values using the time function, then extract hour, minute, and second components with the hour, minute, and second functions in Excel.

Explore how to use the if and vlookup functions together in Excel to perform conditional calculations and look up values from a table, with exact and approximate matches.

Learn to combine vlookup with match in Excel to perform flexible, multi-criteria lookups, use data validation for drop-downs, and retrieve departments, addresses, and contact numbers.

Master vlookup with exact match and column reference to retrieve values from any column, using table array, range lookup false, and absolute references, plus iferror for errors.

Explore how to use Vlookup with an approximate match in Excel, including when to set range_lookup to true, what ascending order means, and how it compares to exact matches.

Explore the hlookup function, a horizontal lookup that searches the top row and returns a value from a row. Learn exact and approximate matching and how to build dynamic lookups.

Explore XLOOKUP and XMATCH in Excel to perform exact lookups and retrieve a student's score by name. Use data validation and tables to practice lookups and handle not found results.

Compare exact match and approximate match in Excel using VLOOKUP, and learn when to apply each for precise lookups and nearest value data analysis.

Create drop down lists in Excel with data validation to enforce predefined options, configure input messages and error alerts, ensuring data consistency for months, designation, and names.

Explore how to build multiple dependent dropdown lists in Excel that dynamically update based on continent, country, and city selections using data validation, index, and indirect functions.

Master advanced pivot table techniques in Excel to group and analyze data, filter by shipping mode and customer, and customize layouts to summarize profit and shipping costs.