Category: Excel®
Quick Tips for Calculating Percentages In Excel
Here are some techniques for calculating percentages. For these examples, we have a simple sheet of travel expenses and you are after the percentage results of prices going up or down for the total and for the individual months. Percent increase Let’s say you anticipate more travel the following year…
Read More
How to Calculate Percentage of Total in Excel
The Ins and Outs of Excel Percentage Formula
Create a Gantt Chart in Excel
If you do any project management, you’ll eventually need to (or be asked to) create a Gantt chart
The Power of Excel Array Formulas Part II
Use an array formula to attach an IF to a function that doesn’t have one
The Power of Excel Array Formulas Part I
Use an array formula to create an IF statement that has two conditions