top of page

# 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. |

bottom of page