Microsoft Excel Formulas and Functions: Comprehensive Guide

Learn to manipulate text in Excel using left, right, mid, and concatenate functions to extract name parts and join them into full names with clear function arguments.

Explore how to use the if function along with and, or, and all functions in Excel to create conditional logic, determine pass or fail, top performer, and scholarship eligibility.

Master date and time functions in Excel, including today, now, and date, to auto update dates and create custom dates. Learn date formatting and arithmetic for schedules and employee records.

Master Vlookup and lookup to retrieve department and salary data from employee tables, using vertical and horizontal lookups, table arrays, and column index concepts.

Learn to use index and match for dynamic lookups in spreadsheets, retrieve departments and salaries from a sales data set, and combine them for robust data retrieval.

Master four essential Excel functions: sum, average, round, and count—applied to a simple item list with quantities and prices to summarize data.

Apply trim to remove extra spaces, use len to count characters, and substitute to replace text, enabling cleaning, analyzing, and modifying text data in Excel.

Master nested functions and conditional formulas in Excel by combining if with sum or average to categorize sales against targets, and apply conditional formatting to highlight below-target values.

master advanced lookup with xlookup and match to retrieve data quickly, enabling dynamic and productive spreadsheets for inventory and sales analysis.

Explore dynamic array formulas in excel using sort, filter, and unique. Learn to sort data by price, filter results above 400, and extract unique prices.

Explore advanced statistical functions in Microsoft Excel, including median, mode, and standard deviation, through practical data analysis examples that reveal trends and support better decisions.

Explore Microsoft Excel financial functions including NPV, IRR, and PMT to evaluate investments, analyze cash flows, and calculate loan payments.

Learn to use sumif, countif, and averageif with criteria and ranges to analyze data in Excel, using practical fruit and price examples.

Highlight cells with conditional formatting using formulas in Excel, such as green for fails and yellow for scores under 60, demonstrated on a student score table.

Explore what-if analysis in Excel with goal seek and data tables to support decision making and problem solving, including determining quantity for a target total cost.

Learn to combine multiple Excel functions in a single formula to extract first names from full names and determine bonus eligibility using performance and attendance conditions.

Explore how to create custom functions in Excel using VBA, including user defined functions, average score calculations, and percent difference, via the developer tab and the VBA editor.

Learn to create dynamic ranges in Excel with offset and indirect functions, enabling automated calculations as data changes and supporting flexible reports.

Build interactive dashboards in Excel with dynamic formulas. Visualize averages and maximum scores, update charts based on user input, and apply conditional formatting.

Create dynamic charts in Excel using formulas and named ranges to visualize sales data for 2023 and 2024, add trend lines, data labels, and axis titles for interactivity.

Automate data visualizations in Excel with dynamic formulas and dynamic ranges to keep charts updated as data changes, using a clustered column chart and conditional formatting.