Often when a filter is used, selections are based on what to include but they can also be based on what NOT to include. Here’s how… Read Danielle O'Connell's answer to How can I filter by "does not include" in Excel? on Quora
Everyone knows that you can use formulas in Excel, but it’s not so well known that you can do the same in Word. Although complex functions aren’t available, basic formulas to perform mathematical operations can be used in Word to calculate using the value of table cells. Here’s some examples of ones that might be […]
IF statements are a super handy Excel functions, but sometimes they’re used in circumstances where another function would work better. Here’s some other formulas that may be simpler to get the required results. Read Danielle O'Connell's answer to How do you prevent writing multiple IF statements in Excel? on Quora
Excel charts are a great way to represent data and can be easily edited, even after creation. Here’s an example of changing from one type of chart to another. Read Danielle O'Connell's answer to How do you connect the dots in an Excel graph? on Quora
Converting text from lower case or sentence case into upper case in Excel can be achieved either with a formula or with a custom VBA function. If you’re just doing it the once, you’ll probably just use a formula (=UPPER), but if you’re doing it regularly – try creating a custom VBA function like this… […]
In the most simple terms… Logical functions are used to determine whether to perform an action or not perform the action by making comparisons and returning True or False as the result of a simple comparison. However using logical functions in practicality is much cooler… Use them to determine whether to apply a conditional format […]
If you’re working with dates in VBA – it can be a little painful when the date format defaults to US format (mm/dd/yyyy). Sure when you enter 30/10/1979 (my birthday incidentally), it knows it’s the 30th October because there is no 30th month, but when you enter 03/05/1957 (my dad’s birthday), it reads it as […]
If you’re a keyboard user (like me) and hate having to take your hands off of the keyboard to reach for the mouse… There’s a keyboard shortcut to achieve everything in Excel. Ctrl, Alt and Shift in combination with letter keys, number keys and each other are used to negate the need for your hands […]
If you’re wasting time with tedious and repetitive tasks in Excel, it might be time to review your processes or do some training. Macros can be created to automate so much manual processing in Excel. Here’s a simple “copy all files in a folder to a single workbook” macro. This one loops through all files […]
Return the first, second, third or nth cell that meets given criteria with a “simple” array formula…The instruction in this sample will show you which functions you’ll need and illustrate how they all work together