by Laura | Jan 23, 2020 | Microsoft Excel Tips
If you have a spreadsheet packed with data, navigating it can become quite unwieldy, especially if you want to compare data from several different sections. Splitting your screen—whether vertically or horizontally—is a great way to streamline your workflow. To split...
by Laura | Jan 23, 2020 | Microsoft Excel Tips
You can use the Data Validation feature, which enables you to add rules for what’s acceptable in certain cells. Excel makes it quite easy to specify validation criteria. You can apply the following validation options: any value whole number decimal list date time text...
by Laura | Oct 13, 2019 | Microsoft Excel Tips
You use an IF statement to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met. Another way of saying it is that Excel makes a statement, and performs one calculation if the statement is true,...
by Laura | Sep 9, 2019 | Microsoft Excel Tips
Here’s an example where you know the exact range you want to sum, as in the following illustration. To add Sum functions for columns F and G use the following code: Sub SumExample1() Range(“F15”).Value = WorksheetFunction.Sum(Range(“F2:F14”))...
by Laura | Aug 2, 2019 | Microsoft Excel Tips
If you’re an Excel user, you’ve probably used the SUM function. It’s fairly simple. The following formula returns the sum of all values in the range of cells in Column A from rows 4 through 1799: =Sum(A4:A1799) Sometimes you need to sort your data...
by Laura | Aug 1, 2019 | Microsoft Excel Tips
The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. According to Microsoft, it is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on...
