Randomized lists can be really helpful to populate test data, here’s how to randomize a list using the INDEX and RANDBETWEEN functions: Read Danielle O'Connell's answer to How can I randomize a list in Excel? on Quora
With great difficulty… unless you know how to write an array formula 🙂 Yes, just when you thought you knew Excel – an array formula comes along and presents a whole new world of possibilities. But what is an array formula? Array formulas enable us to index ranges that interact with each other in order […]
Hiding columns one-by-one can be tedious, lucky for us the Find box can be used to hide multiple columns containing a specified value at once. Here’s how… Read Danielle O'Connell's answer to How do I hide columns based on cell value? on Quora
Numbers stored as text (or numbers stored as numbers when you expect them to be stored as text) can be tricky little buggers that cause no end of confusion when cells that by all appearances should match – don’t match. Fortunately, just like everything else in Excel – once you understand the source of the […]
Great question from Lisa, who is extracting all information about upcoming events from a database. The database extract contains information about all events – even those that have been cancelled. We can make use of the Find tool to delete all rows recording cancelled events. To delete all rows that contain the word cancelled (in […]
We had an complex task that needed to be automated with many different factors involved in the automation. Danielle is so amazing and an absolute excel guru there is nothing she cant do when it comes to excel I sat with her in awe of her capabilities and what she was able to do to […]
Danielle was able to take an existing Excel based venue booking system, incorporating scheduling, financial reporting catering and more, all in one spreadsheet that was, slow, buggy, and virtually unusable and turned it into a piece of usable efficient and quick worksheet. Has increased my productivity and efficiency and my ROI (Return on Investment) was […]
Excellent and Prompt service Danielle is AMAZING highly recommend her
Danielle’s has been amazing to deal with. She has streamlined and automated important processes that have added to our value proposition and saved us time in the process. 5 stars.
Danielle was great. I approached her with some conceptually complex requirements for a spreadsheet database, and she was able to nail down exactly what we were after with minimal remediation and amendments. Thanks!