How to Use the SUMIF Function
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
27
Sep
Improve Your Pivot Table Workflow in Excel
In this quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to
Dates in Excel – Part 1
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
30
Sep
Using AUTOFILL in Excel – Part 2
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
27
Sep
Using AUTOFILL in Excel – Part 1
The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the
27
Sep
How to Use Excel’s COUNT Functions
There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post
27
Sep
Comparison Operators – Excel
Comparison operators are very helpful in Excel to force a Boolean result from a formula. Once we test two values against each
22
Sep