Dealing with Danielle is a pleasure as she deals with our issues professionally, quickly, efficiently and with a great sense of humour. I can highly recommend DOC Office for their excellent knowledge and professionalism The Project Design a program for recording incidents that produced reports for individual incidents, recorded all incident information and included functionality […]
Danielle is very professional, patient and very knowlegeable! Amazing work!
Download a simple Excel based Sales Recorder that facilitates simple recording of products and/or services sales per individual transaction and allows results to be presented in whatever format is required by the user. The total sales for the prior twelve months and the sales for the requested time frame per product are visually presented on […]
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 […]