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 11, 2019 | Microsoft Word Tips
It sounds like you want a table of contents. At least that’s the easiest way. Make sure that you’ve applied styles to your section headings, like in the following figure. Do the same for the other section headings. You can use the F4 key on each header to apply the...
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”))...
