## Recent Posts

#### How to Convert Percent to Decimal

There are numerous ways to display numbers in your reports. Using percentages and decimals are two common ways to do so. In this post, I'll cover when it might ...

#### Free Excel Template to Track Berkshire Hathaway’s Portfolio

Warren Buffett fans like to track the billionaire investor's moves, and a good way to do that is through Berkshire Hathaway's 13f filings. His company reports ...

#### How to Apply Conditional Formatting to Charts in Excel

Conditional formatting cells can be an effective way to highlight values so that they can easily stand out. You can apply similar logic to charts, and in this ...

#### Convert Celsius to Fahrenheit Using an Excel Formula

Switching back between Celsius and Fahrenheit can be cumbersome if you haven't memorized the formula. There are multiple steps involved and you can easily make ...

#### How to Calculate APR in Excel

The Annual Percentage Rate (APR) on a loan tells you what your total borrowing cost is per year. It's different from just the interest rate because it will inc ...

#### How to Avoid Using Nested IF Statements in Excel

Nested IF statements aren't always the most efficient way to structure your formulas. And they can make it difficult later on if you need to fix a formula or m ...

#### How to Create a Chart With a Target Line

Are you creating a chart that shows progress, with a certain goal in mind? In this post, I'll show you how to create a chart with a target line so that you can ...

#### How to Create For Loops in VBA

You can add lots of automation to your spreadsheet by utilizing visual basic (VBA) and running macros. One of the more common macros you might run include loop ...