Recent Posts

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

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

Printable Yahtzee Scorecard Template in Excel

Contents: 1. Download 2. How to Use 3. How to Play Yahtzee In Excel Download To download this workbook containing printable scorecards...

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