by Ginette | Jun 8, 2023 | Microsoft Excel
Excel Quick Start Guide – Basic Excel Quick Start Guide – Intermediate Excel Quick Start Guide –...
by Colin Foster | Jul 9, 2021 | Microsoft Excel
As you become more experienced with Excel, you get comfortable with the idea of “nesting” one formula within another one. A classic use of this is with nested IF() statements where the first IF() checks a TRUE/FALSE option & then the Value_If_True and...
by Colin Foster | Jun 14, 2021 | Microsoft Excel
We’re well used to Word wrapping text automatically at the end of a line, moving seamlessly onto the next row. However, because it’s not a word processor, Excel doesn’t do that naturally, but we can tell it to do so – either automatically or by putting the breaks...
by Colin Foster | Apr 1, 2021 | Microsoft Excel
There will be occasions when the decimal places that Excel ordinarily calculates to are not necessary; we are only interested in the non-decimal part of the calculation. For example, if our calculation is to determine how many full-time staff members or machines are...
by Colin Foster | Mar 15, 2021 | Microsoft Excel, Tips and Tricks
When we have a list of data, sometimes it can be quite difficult to extract information from it quickly and efficiently. However, provided that we’ve the right sort of information in the various columns of our list, then we can make a start by using Excel’s...
by Colin Foster | Jan 13, 2021 | Microsoft Excel, Microsoft Excel, Microsoft Excel
There are three ways that we can calculate price increases. The first calculates the increase & then adds this to the original value; the second calculates the new price only (though, of course, we can use that & the original price to work out the difference)....
