Practical Examples of Excel Formulas with Presentations

Welcome to Excel Formula Explorer! Whether you're new to spreadsheets or an experienced user, our guide will help you clarify complex formulas, streamline your workflows, and enable you to quickly master the practical application of formulas. There are special animated mini-presentations in each article for this purpose.

Examples of formulas in mini-presentations

how-to-count-cells-by-condition-using-formulaHow to count cells by condition using an Excel formula.

Counting the number of non-empty cells in a table based on user-defined criteria using the COUNTIF function and an alternative SUMPRODUCT formula. Formula for counting cells in Excel by condition.

how-to-use-sumif-formula-with-multiple-conditionsHow to use SUMIF formula with multiple conditions in Excel.

Examples of solutions using the SUMIF function when you need to sum a range of cells based on multiple conditions. Alternative functions: SUMPRODUCT and SUMIFS.

how-to-use-sumifs-formula-with-multiple-conditionsHow to use SUMIFS formula in Excel with multiple conditions.

Examples of formulas for massive summation of numerical values based on multiple conditions. Comparison of the two functions SUMIFS and SUMPRODUCT. Formula Examples for summation in Excel.

how-to-use-sumif-formula-to-get-values-by-conditionHow to Use SUMIF Formula to Get Values ​​by Condition in Excel.

Formula for summing cell ranges based on conditions. Everything you need to know about creating formulas for the SUMIF logical function and similar ones. Sum Formula Based on Selection Criteria.

formula-using-and-and-or-functions-multiple-conditionsExcel Formula Using AND and OR Functions Multiple Conditions.

How to create a formula for checking values based on multiple conditions using logical functions: IF, AND, OR? Analyzing logic with a truth table. Download formula examples in Excel.

sing-and-in-if-formula-with-multiple-conditionsUsing AND in IF Formula with Multiple Conditions in Excel.

Examples of using the AND function in formulas to check cells against multiple conditions using the IF function. How to perform a search with multiple conditions without using the IF function?

how-to-use-if-formula-with-multiple-conditionsHow to Use IF Formula with Multiple Conditions in Excel.

Examples of data validation based on multiple conditions using the IF function and without it. How to create a dynamic dependent drop-down list? How to create linked drop-down lists in Excel?

example-of-using-formulas-with-if-functionExample of How to Use Formulas with the IF Function in Excel.

Example of using a formula in the first argument of the IF function to compare prices with the average value. How to perform conditional analysis of metrics?

how-to-add-time-and-number-of-hoursHow to Add Time and Number of Hours or Minutes in Excel.

Examples of adding time values to a number of hours or minutes. How to add a whole number or decimal value of minutes to a time value in Excel?

how-to-convert-time-to-decimalHow to Convert Time to Decimal in Excel Using Formulas.

Time converter to numerical values. Formulas with examples for converting decimal fractions to hours, minutes, seconds, and vice versa. How to convert a decimal fraction into a time value?

how-to-round-time-to-hours-or-minutesHow to Round Time to Hours or Minutes in Excel Up or Down.

Formula examples for rounding time to hours, minutes, and half-hours forward or backward. How to round time up to the nearest quarter-hour and down to the nearest half-hour?

how-to-subtract-and-calculate-time-differenceHow to Subtract Time in Excel and Calculate Time Difference.

Formula Examples of time subtraction to calculate the difference between the start time today and the end time tomorrow. The formula allows you to correctly subtract time for calculating the interval.

how-to-split-time-into-hours-minutes-secondsHow to Split Time into Hours, Minutes, and Seconds in Excel.

Formula example of filtering by time by splitting it into time components: hours, minutes, and seconds. How to extract hours from a time value in MS Excel?

how-to-get-last-day-of-weekHow to Get the Last Day of the Week in a Month in Excel.

Formula Example of selecting dates of the last days of the week in each month of any year. How to calculate the date of the last Sunday in December Month?

how-to-quickly-create-calendar-using-formula How to Quickly Create Calendar in Excel Using One Formula.

Example of selecting dates based on the occurrence of weekdays in a month. A table for auto-filling a bonus payment schedule. Selecting dates by the weekday occurrence in a month in Excel. Calendar grid template generator.

how-to-convert-date-into-financial-monthsHow to Convert a Date into Financial Months in Excel.

Formula to get the current fiscal month of the year from source dates. Calculate budget months from a calendar date using the EOMONTH and TEXT functions.

how-to-convert-date-to-quarters-for-fiscal-yearHow to Convert Date to Quarters in Excel for Fiscal Year.

Formula for determining quarters by date for any fiscal year start and end periods. How to work with the CHOOSE, MONTH, and ROMAN functions in formulas.

how-to-use-array-formulas-in-excel-tableHow to Use Array Formulas in Excel Table with an Example.

Examples of Using Array Formulas with Multiple Conditions. How to Calculate a Formula in an Array and Check the Sequence of Its Calculations. Download the XLS File for the Guide on Working with Array Formulas in an Excel Table.

example-formula-for-dynamic-cell-range-selectionExample Formula for Dynamic Cell Range Selection in Excel.

Examples of automatic selection of cell ranges from a table. Automatic color highlighting of certain data ranges. Control and checking of input values ​​for errors.

finding-nearest-value-in-array-and-duplicatesFinding Nearest Value in Array and Duplicates in Excel.

Examples of formulas for finding the nearest large values ​​in an array and without an array. How to find the nearest value and get all its duplicates?

1 2 3 4 5 6 7 8