## Working with Page Breaks in Excel & VBA

If you don’t manually set Page Breaks, Excel will do it’s best to set appropriate Page Breaks. However, if you’ve ever tried to print an Excel spreadsheet, you know it generally does not do a good job. Any time you print a spreadsheet you should review and edit the Page Breaks before printing. Page Break…

Read More## How to Calculate Age in Excel

This tutorial covers how to calculate age in Excel. Calculate Exact Age To calculate the exact age of a person, you want to calculate the difference between the current date (or any other desired date) and the birth date. You might think that you could simply take the difference in days between the current date…

Read More## What-if Analysis in Excel – Scenario Manager & Goal Seek

The what-if analysis tools on Excel allow you to apply different values to formulas and compare results for a variety of scenarios. Why is it important to understand what-if analysis? There are many applications of what-if analysis, such as financial modeling and sensitivity analyses. For example, if you are preparing a financial model, and you…

Read More## How to Calculate a Ratio in Excel

This tutorial will show you how to compare two numbers and calculate their ratio, such as 5:7 or 8:3. Calculate a Ratio – The GCD Method The GCD Function is used to calculate the greatest common denominator between two or more values. We can use GCD to then create our ratios. To use the GCD…

Read More## How to Spell Check in Excel & VBA

This tutorial will demonstrate how to use spell check in Excel and in VBA. Spell Check in Excel Microsoft Excel offers a basic spelling function that can help you check your spelling on any spreadsheet that you produce. This function is very limited, in relation to the spell check function in Microsoft Word or Microsoft…

Read More## Compound Interest Formula in Excel

This tutorial will demonstrate various ways to calculate compound interest in Microsoft Excel. What is compound interest? When you invest money, you can earn interest on your investment. Say, for example, you invest $3,000 with a 10% annual interest rate, compounded annually. One year from the initial investment (called the principal), you earn $300 ($3,000…

Read More## Print Comments in Excel

Excel allows you to display comments on the screen, but by default the comments will not print with your spreadsheets. This tutorial will teach you several different methods to print comments in your spreadsheets. Print Comments – Review Ribbon Method: 1. If you have more than one worksheet, select the one that contains the comments…

Read More## Add Up (Sum) Entire Columns or Rows in Excel

This tutorial covers how to add entire rows or columns in Excel The Sum Function We will use the Sum Function to add up entire rows and columns.

1 |
= SUM(number1, number2, …) |

The Sum Function takes input in two primary forms: standalone cell references (ex.=sum(a1,b2,c3)) or an array of cells (=sum(A1:E1)). We will use the latter method: Tip…

Read More## The Best External Keyboards for Laptops

Keyboard Shortcuts are the key to working efficiently in Excel. Unfortunately, many modern laptops are too small to have a full-sized keyboard, making it harder to use keyboard shortcuts. There are several common keyboard layout shortcomings that are especially limiting: A fn key directly to the left of the CTRL key on the bottom-left of…

Read More## Does Microsoft Believe in Ghosts? – Easter Eggs

In 2007, Spanish-speaking blogger, Kwisatz discovered a surprising image embedded in the hologram of a Windows Vista DVD: Kwisatz blog has since been taken down, however, the original blog post and images can be seen using Web Archive . It appeared an image of three men (ghosts?) had been embedded onto the DVD. The entire image is less than…

Read More