Tutorials

A complete list of every tutorial and lesson written on this site.

General:

Basic Excel Formulas and Functions	Excel formulas and functions are powerful tools for performing calculations and data analysis. Formulas are custom calculations you...
How to Remove Extra Spaces from Text	Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....
How to Change Cell Color in Excel	Changing cell color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...
How to Wrap Text in Excel and When to Use it	The "Wrap Text" feature allows you to display cell contents on multiple lines within a single cell instead of having the text overflow...
How to Find and Replace Values in Excel	Find and Replace allows you to find specific information across large workbooks and make sweeping changes if necessary. Contents: 1....
How to Link Workbooks in Excel	When working with multiple Excel workbooks, you'll often find yourself needing to reference numbers from one workbook in a separate...
The Basics to Creating and Using Formulas in Excel	Formulas are an integral part of Excel, and are the defining feature that elevates a workbook far above a simple calculator. Contents: 1....
How to Extract Everything to The Left of a Specific Character in Excel	A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to pull out...
How to Quickly Copy Worksheets in Excel	Often times you'll want to create copies of existing worksheets to tweak or use as a template elsewhere in your workbook. There are a few...
How to Change Text and Font Color in Excel	Changing text color can highlight specific areas on your worksheet that may otherwise go unnoticed. Specific problems, important...
How to Use the Format Painter in Excel	The Format Painter tool will help you quickly copy the formatting from anywhere in your workbook, saving you the time and hassle of...
How to Remove Duplicates in Excel	Sometimes it is necessary to remove duplicate items from a column or duplicate rows out of an entire table. Removing duplicates will help...
How to Freeze Rows and Columns in Excel	Often times when scrolling through data in Excel, you want to keep the top few rows visible so you can easily see the column headers...
How to Hide and Unhide Sheets in Excel	Often, you won't want every worksheet in your workbook to be able to easily be viewed by everyone. Hiding and unhiding sheets will let you p
How to Zoom in Excel - 5 Methods	When working in Excel, it can sometimes be difficult to get an overview of an entire worksheet, especially if you're working on a smaller...
What is Paste Special in Excel? Everything You Need to Know	Paste special allows you to copy any cell or range of cells, and paste specific characteristics from those cells, it is also one of the...
What Is the Best Way to Learn Excel?	Excel is massive. It can be intimidating to learn. What's the best way to start? What different methods are there to help you learn?
What is Excel? A General Overview and History	What is Excel? Why do people use it? What came before it?
Understanding the Basic Layout of Excel	If you're just learning to use Excel, learning to navigate efficiently is a crucial building block that will allow you to get better,...

Tutorials:

GitHub Style Habit Tracker & Calendar Heat Map in Excel	I've always admired the way GitHub presents your contribution activity with a slick, heatmap-styled tracker. Let's create our own version...
How to Calculate Working Days in a Month	When working with dates, you'll sometimes find that you need to calculate the number of working (or business days) in a month, from a...
How to Convert Large Decimal Numbers to Binary	There are lots of ways to convert decimal numbers into binary. Excel has a built in function for small numbers, but you'll need a custom...
How to Convert Large Binary Numbers to Decimal in Excel	There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...
How to Begin a Cell with an =, -, or + Sign Without Creating a Formula	Sometimes you find yourself wanting to start a cell with an "=", "-", or a "+" sign, but don't want Excel to create a formula. There are...
How to Perform a Two-Way XLOOKUP	A regular, one-way XLOOKUP, is a fantastic tool, but sometimes you may find yourself needing to lookup a value in two different...
How to Unstack Uneven Data From a List in Excel	While the WRAPROWS function can be great to unstack a list with an even number of items, we'll need a custom formula to wrap, or unstack...
How to Reverse or Flip First and Last Names in Excel	You'll often see names that are out of order, and need to flip them. Here are a couple quick formulas to help you accomplish that task....
How to Create Index Columns Using Dynamically Spilled Arrays	Add an index column to any dynamic array using a few of the latest Excel functions for easy lookups. Contents: 1. Adding Index Column to...
How to Create a Dynamic Array of Repeating Cells	Create a repeating list based off of a range and a specific numbers of repetitions. Contents: 1. Formula 2. Explanation Formula To...
How to Calculate Number of Days Between Two Dates in Excel	A short formula you can use to calculate the number of days between two specific dates. Contents: 1. Formula 2. Explanation 3. Example...
How to Calculate Weekend Days Between Two Dates in Excel	An easy formula you can use to calculate the number of weekend days between two specific dates. Contents: 1. Formulas 2. Explanation 3....
How to Calculate Number of Weekend Days Left in the Current Month in Excel	A quick formula to calculate the number of weekend or non-working days remaining in the current month. Contents: 1. Formulas 2....
How to Calculate Number of Weekdays Left in the Current Month in Excel	A quick formula to calculate the number of weekdays, business days, or working days remaining in the current month. Contents: 1. Formulas...
How to Highlight Weekdays in Excel	Using conditional formatting, we can use a custom formula to highlight all weekday dates from any date range, letting you visually see...
How to Autofill Columns with Multiple Values	If you have ever gotten a report that looks like this, you know it can be a pain to work with. It's like a PivotTable without the Pivot....
How to Round a Price to .99 in Excel	When working with prices, it can often be beneficial to round to the nearest .99 cents. There are a few formulas we can use depending on...
How to Calculate Flow Rate in Excel	Flow rate can be tricky to calculate, but if you have all of the required pieces we can create some easy Excel formulas to do the work...
How to Calculate Weighted Average in Excel	A weighted average is an average where each value has a different level of importance, represented by a weight, which affects the overall...
How to Refresh SAP Analysis for Office Queries & Data Sources with a Macro	Depending on the report, having a way to automate your data source refreshes may save you a ton of time. Contents: 1. How to Create a...
How to Sum Cells By Color in Excel	While not a built-in Excel feature, we can create our own function to easily sum cells by color. Contents: 1. How to Use VBA User Defined...
How to Highlight Weekends in Excel	Using conditional formatting, we can use a custom formula to highlight all weekend dates from any date range, letting you visually see...
How to Convert a Month Name to a Number in Excel	Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...
How to Return the Second to Last Item in a List in Excel	Usually, you need to return the last or first item in a list, but every once in a while, you may find yourself needing to return the...
How to Return the nth to Last Item in a List in Excel	Usually, you need to return the last or first item in a list, but every once in a while you may find yourself needing to return a...
How to Enable the Developer Tab in Excel	The Developer tab in Excel is hidden by default, but offers some very important functions and built in features that every Excel Expert...
How to Count Colored Cells in Excel	While not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...
How to Highlight Cells Containing a Formula in Excel	To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....
How to Return the File Pathway of an Excel Workbook Using a Formula	Sometimes you'll find yourself needing to pull a file's pathway into your Excel sheet. Luckily there is a quick formula we can use to...
How to Return the ASCII Number for Every Character in a Cell	The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....
How to Round a Date to the First of the Next Month	Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...
How to Round a Date to the First of the Previous Month	Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...
How to Remove Date Data from a Time in Excel	Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...
How to Remove Time from a Date in Excel	Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...
How to Take the Average of Non-Zero Cells in Excel	Using the standard AVERAGE function with data that contains zeros can give you an incorrect average. Instead, we can use the AVERAGEIF...
How to Abbreviate a Middle Name in a Full Name in Excel	Formatting names can be a manual and slow process. Here is a quick method to turn a middle name into a middle initial when given a full...
How to Separate a Full Name Into First and Last Names in Excel	Often, you'll receive a list of first and last names combined into a full name and need to separate them. Here's a quick method to easily...
How to Combine First & Last Names Into a Full Name in Excel	Often, you'll receive a list of names broken up into two separate columns, first and last, and need to combine them into a full name....
How to Extract Everything to The Right of a Specific Character in Excel	A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...
Multi-Sheet References & Formulas - 3-D References in Excel	A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...
How to Calculate the Number of Days in a Month From a Date	A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...
How to Return the End of the Month From A Date in Excel	Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...
How to Get the First Day of the Month From A Date in Excel	Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...
How to Extract The Year From any Date in Excel	When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...
How to Extract The Month From any Date in Excel	When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...
How to Extract The Day From any Date in Excel	When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...
How to Pull Quarters Out of a Date in Excel	When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...
Finding the Rightmost Column Containing a Specific Value in a Table or Array	How to find the index of the rightmost column in any table or array that has a cell matching a specified value. Contents: Formula...
How to Round a Date to the First of the Nearest Month in Excel	Contents: Formula Explanation Example - Rounding Dates to First of the Nearest Month Formula = EOMONTH(date, (DAY(date) >...
How to Get a Sheet Name Using a Formula in Excel - 3 Methods	When working in a workbook with a lot of different tabs, being able to pull, reference, and use specific sheet names can save you a lot...
How to Sum Across Multiple Dynamic Arrays by Row in Excel	How to sum across multiple dynamic arrays in a dynamic, flexible formula using the BYROW and LAMBDA Functions.
How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA	When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.
How to Perform Mathematical Operations Using Paste	How to add, subtract, multiply, and divide any size range without the need to create extra columns. All with paste.

Functions:

How to Use the BIN2OCT Function	The BIN2OCT function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number 2.2. What...
How to Use the OCT2BIN Function	The OCT2BIN function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2. What...
How to Use the OCT2DEC Function	The OCT2DEC function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2....
How to Use the DEC2OCT Function	The DEC2OCT function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....
How to use the HEX2DEC Function	The HEX2DEC function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...
How to Use the DEC2HEX Function	The DEC2HEX function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number...
How to Use the HEX2BIN Function	The HEX2BIN function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...
How to Use the BIN2HEX Function	The BIN2HEX function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number...
How to Use the DEC2BIN Function	The DEC2BIN function converts decimal numbers into binary numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....
How to Use the BIN2DEC Function	The BIN2DEC function converts binary numbers into decimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....
How to Use the ASIN Function	The ASIN function is used to return the arcsine of a number in radians. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating...
How to Use the ACOT Function	The ACOT function is used to return the arccotangent of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating...
How to Use the ACOS Function	The ACOS function is used to return the arccosine of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating Arccosine...
How to Use the ATAN Function	The ATAN function is used to return the arctangent of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating Arctangent...
How to Use the IMSUB Function	The IMSUB function is used return the difference between two complex numbers. Contents: 1. Syntax 2. Explanation 3. Example 3.1....
How to Use the IMSUM Function	The IMSUM function is used add or sum two or more complex numbers. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Adding Two Complex...
How to Use the IMSQRT Function	The IMSQRT function returns the square root of a complex number. Contents: 1. Syntax 2. Function Explanation 3. Example 3.1. Returning...
How to Use the SQRT Function	The SQRT function returns the square root of any given number. Contents: 1. Syntax 2. Function Explanation 2.1. What is a Square Root 3....
How to Use the IMREAL Function	The IMREAL function is used to extract the real coefficient of a complex number. Contents: 1. Syntax 2. Explanation 3. Example 3.1....
How to Use the IMAGINARY Function	The IMAGINARY function is used to extract the imaginary coefficient of a complex number. Contents: 1. Syntax 2. Explanation 3. Example...
How to Use the IMABS Function in Excel	The IMABS function is used to find the absolute value of a complex number. It takes a complicated formula and turns it into a...
How to Use the CELL Function in Excel	The CELL function is a useful tool that allows you to retrieve specific information about a cell's formatting, location, and content....
How to Use the CODE Function	The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...
How to use the LOG Function	The LOG function will calculate the logarithm of any given number to a specified base. Contents: 1. Syntax 2. Explanation 3. Examples...
How to use the LN Function	The LN function will calculate the natural logarithm of any given number. Contents: 1. Syntax 2. Explanation 3. Examples 3.1. Calculating...
How to use the GCD Function	The GCD function finds and returns the greatest common divisor (GCD) of two or more numbers. Contents: 1. Syntax 2. Explanation 3....
How to use the AVERAGE Function	The AVERAGE function returns the arithmetic mean of any set of numbers given to it. Contents: 1. Syntax 2. Explanation 2.1. Types of...
How to use the DELTA Function	The DELTA function compares two numbers and returns a 1 if they are the same, and a 0 if they are not the same. Contents: 1. Syntax 2....
How to use the CLEAN Function	The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...
How to use the AND Function in Excel - 3 Examples	The AND function checks if all provided conditions in the function are true, and returns a TRUE. If any of the conditions are false, a...
How to use the BAHTTEXT Function in Excel with Examples	The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...
How to use the DOLLAR Function in Excel with Examples	The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...
How to use the FLOOR.MATH Function in Excel - 3 Examples	The FLOOR.MATH function will round any number down to the nearest integer and if desired, a specific multiple. Contents: Syntax...
How to use the CEILING.MATH Function in Excel - 4 Examples	The CEILING.MATH function will round any number up to the nearest integer and if desired, a specific multiple. Contents: Syntax...
How to use the MROUND Function in Excel - 3 Examples	The MROUND function will round any number up or down to the nearest given multiple. Contents: Syntax Explanation Different Methods of...
How to use the ROUNDDOWN Function in Excel - 4 Examples	The ROUNDDOWN function will round any number down to a specified number of digits. This function differentiates itself from the standard...
How to use the ROUNDUP Function in Excel - 4 Examples	The ROUNDUP function will round any number up to a specified number of digits. This function differentiates itself from the standard...
How to use the ROUND Function in Excel - 4 Examples	The ROUND function will round any number to a specified number of digits. There are plenty of real world situations in which you wouldn't...
How to use the TRUNC Function in Excel - 3 Examples	The primary use of the TRUNC function is to truncate or remove the fractional part of a number. The function can be configured to remove...
How to use the SMALL Function in Excel - 8 Examples	The SMALL function will return the smallest specified number from a given range or data set. For example, SMALL can return the 2nd...
How to use the LARGE Function in Excel - 8 Examples	The LARGE function will return the largest specified number from a given range or data set. For example, LARGE can return the 2nd largest...
How to use the INT Function in Excel	The INT function will round any input number down to the nearest integer, removing the decimal, or fractional, portion of the number....
How to use the FACTDOUBLE Function in Excel	The FACTDOUBLE function will return the double factorial of any inputted number. A double factorial is usually notated as any number with...
How to use the FACT Function in Excel	The FACT function will return the factorial of any inputted number. A factorial is usually notated as any number with a trailing...
How to use the ARABIC Function in Excel to Convert Roman Numerals to Regular Numbers	The ARABIC function converts Roman numerals into Arabic numerals, letting you easily convert Roman numerals into a more readable format....
How to use the ROMAN Function in Excel to Convert Numbers into Roman Numerals	The ROMAN function converts Arabic numerals into Roman numerals in a text format. It can return the classic Roman numeral style or more...
How to use the IMTAN Function in Excel - 4 Examples	The IMTAN function is used to return the tangent of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax What is a...
How to use the IMSINH Function in Excel - 4 Examples	The IMSINH function is used to return the hyperbolic sine of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax...
How to use the IMSIN Function in Excel - 4 Examples	The IMSIN function is used to return the sine of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax What is a...
How to use the IMSECH Function in Excel - 4 Examples	The IMSECH function is used to return the hyperbolic secant of a complex number input in a "x + yi" or "x + yj" format. Contents: Syntax...
How to use the IMSEC Function in Excel - 4 Examples	What is the IMSEC function in Excel and how to use it, with easy to follow examples.
How to use the IMCSCH Function in Excel - 4 Examples	What is the IMCSCH Function in Excel and how to use it, with easy to follow examples.
How to use the IMCSC Function in Excel - 4 Examples	What is the IMCSC function in Excel and how to use it, with easy to follow examples.
How to use the IMCOT Function in Excel - 3 Examples	What is the IMCOT function in Excel and how to use it, with easy to follow examples.
How to use the IMCOSH Function in Excel - 3 Examples	What is the IMCOSH function in Excel and how to use it, with easy to follow examples.
How to use the IMCOS Function in Excel - 3 Examples	What is the IMCOS function and how to use it, with easy to follow examples.
How to use the COMPLEX Function in Excel - 3 Examples	What is the COMPLEX function in Excel and how to use it, with easy to follow examples.
How to use the PERMUT Function in Excel - 3 Examples	What is the PERMUT function in Excel and how to use it, with 3 easy to follow examples.
How to use the PERMUTATIONA Function in Excel - 3 Examples	What is the PERMUTATIONA function and how to use it, with 3 easy to follow examples.
How to use the COMBINA Function in Excel - 3 Examples	What is the COMBIN function in Excel and how to use it, with easy to follow examples.
How to use the COMBIN Function in Excel - 3 Examples	What is the COMBIN function in Excel and how to best use it with easy to follow examples.
How to use the ABS Function in Excel - 5 Examples	What is the ABS function and how to use it with 5 easy to follow examples.
How to use the SIGN Function in Excel - 4 Examples	What is the SIGN Function in Excel and how to use it in 4 easy to follow examples
How to use the PROPER Function in Excel - 3 Examples	The PROPER function will convert any string of words into "proper" capitalization. The first character/letter of every word will...
How to use the LOWER Function in Excel - 2 Examples	What is the LOWER function and how to use it, with multiple practical examples.
How to use the UPPER Function in Excel - 2 Examples	What is the upper function and how do you use it? The UPPER function explained.
How to use the RAND Function in Excel - 3 Examples	What is the RAND function and how to use it with multiple examples.
How to use the RANDBETWEEN Function in Excel - 4 Examples	How to use the RANDBETWEEN function with multiple examples and use cases.
How to use the RANDARRAY Function in Excel - 6 Examples	6 examples of how to use the RANDARRAY function in Excel from basic to advanced.
What Is the EVEN Function and How to Use It in Excel - 2 Examples	The even function rounds any numerical value away from zero, to the nearest even integer.
What Is the ODD Function and How to Use It in Excel - 2 Examples	The odd function rounds any numerical value the nearest odd integer (whole number).
What Is the N Function and How to Use It in Excel - 2 Examples	The N function converts non-number values to a number, dates to serial numbers, TRUE/FALSE to 1/0 respectively, and everything else to 0....
Excel's Secret Formula: =DATEDIF( )	An easy way to find the number of days, months, or years between two dates.

VBA & Macros:

Understanding Objects in VBA	An object in VBA is an Excel component such as a workbook, worksheet, or range, that you can interact with and manipulate. These are...
Understanding Dynamic Arrays - VBA Tutorial	A dynamic array is an array that can change size on the fly, unlike a static array that has a fixed number of elements. Contents: 1. What...
What are Macros? Are They Hard to Learn? Should You? - VBA Tutorial	Macros are used inside an Excel workbook that automate repetitive and complex tasks, allowing you to streamline your workflow and save...
How to Create a Macro in Excel - VBA Tutorial	Knowing how to create macros will let you automate repetitive tasks and create your own customized features and functions in Excel. There...
What are Arrays and How to Use Them - VBA Tutorial	An array is a set of values that are stored in a structured, linear way, allowing you to store and manipulate a large number of values in...
What are With Statements and How to Use Them - VBA Tutorial	In VBA, a with statement is used to reference an object multiple times within a specific block of code. Reducing typing and creating more...
What are Do While Loops and How to Use Them - VBA Tutorial	In VBA, a Do While loop is a type of loop that will continue to repeat a set of instructions until a specific condition is met. Contents:...
VBA Naming Conventions & How to Write Good Variable Names - VBA Tutorial	Naming your variables properly is an important, but often overlooking, building block that, once learned, will improve your codes...
How to Declare Variables and Data Types - VBA Tutorial	Declaring variables is an essential part of programming in VBA. Declaring properly will help you avoid errors and improve the overall...
How to Structure VBA Code and Macros in Excel - VBA Tutorial	When creating macros and writing VBA, it is important to logically structure your code to maximize readability and ensure your code is as...
How to Write Presentable VBA Code and Macros - VBA Tutorial	Good code presentation is an important part of writing VBA (or any other programming language for that matter), and will make your code...
What are For Loops and How to Use Them - VBA Tutorial	For loops are an essential programming method used across many different languages, and allow for more precise, readable, and flexible...
How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA	When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.