Top Formulas Post Archives - TheSmartMethod.com

Publishers of the world’s most comprehensive and up-to-date Excel tutorials

Excel tutorials

The only Excel books you will ever need

The only constantly updated Excel 365 titles more…
Thoroughly covers Power Pivot and Power Query more…
Covers business intelligence and OLAP features more…
Simple, easy, understandable, 2-page lessons more…
Available as both printed books and e-Books more…
Used by schools, colleges and universities more…
Available for 365, 2021, 2019, 2016 and Mac versions more…

Category: Top Formulas Post

Search again:

Excel XLOOKUP function (part one)

The new Excel XLOOKUP function was introduced in the July 2020 Excel 365 semi-annual update. It isn’t available in older versions (Excel 2019 and earlier). The July 2020 update was

Excel SEQUENCE Function

This tutorial uses a single Excel SEQUENCE function to create a perpetual calendar. Includes sample files and a step-by-step guide.

An Excel formula to get the week of the month

This article shows you how to create an Excel formula to get the week of month from a date, as well as how to get the week of year from a date.

Use the LAMBDA function and DYNAMIC ARRAYS to construct a roulette simulator

In this step-by-step tutorial Excel’s Lambda function and Dynamic Array feature are used to develop a full professional-grade Excel application.

Use the SUMIF and COUNTIF functions to create conditional totals

How to use VLOOKUP to search for a piece of text and return a matching value. This article also explains what VLOOKUP is and when to use it.

VLOOKUP using text strings

How to use VLOOKUP to search for a piece of text and return a matching value. This article also explains what VLOOKUP is and when to use it.

Separating text and numbers in Excel

This article shows three different ways of separating text and numbers in Excel. You’ll see how to do this using Flash Fill, Text to Columns and formulas.

Subtracting percentages in Excel

This article explains how Excel handles percentages and shows you how to subtract a percentage from a number in Excel using two different methods.

Excel tutorials

Category: Top Formulas Post

Excel XLOOKUP function (part one)

Excel SEQUENCE Function

An Excel formula to get the week of the month

Use the LAMBDA function and DYNAMIC ARRAYS to construct a roulette simulator

Use the SUMIF and COUNTIF functions to create conditional totals

VLOOKUP using text strings

Separating text and numbers in Excel

Subtracting percentages in Excel

Categories

Recently added articles

Excel protected view warning

VLOOKUP inexact match

VLOOKUP exact match

Microsoft Office update channels

Every lesson is presented on two facing pages

Excel linear and exponential series

Excel Tutorials

Articles

Downloads

Policies

About

Which tutorial do you need?

Which Excel Essential Skills version do you need to learn?

Excel 365 for Windows

Excel 2021 for Windows

Excel 2019 for Windows

Excel 2019 for Mac

Excel 2016 for Windows

Excel 2016 for Mac