Daniel Ebsary – FCS Auction Services
Working with Danielle from DOC Office was an absolute pleasure. The automation she has provided for our business has greatly reduced time spent on repetitive reporting tasks. Highly recommended.
Working with Danielle from DOC Office was an absolute pleasure. The automation she has provided for our business has greatly reduced time spent on repetitive reporting tasks. Highly recommended.
Danielle has been awesome to work with! Very good at what she does, I don’t think theres much she can’t achieve with automations in excel. The spreadsheet she has put together for us has changed the way we work.
Danielle has streamlined some of our processing saving us plenty of time. Highly recommended.
I have created a data validation rule that checks new entries to ensure they haven’t already been recorded, but when a user pastes into this worksheet, the data validation doesn’t work. How can I prevent people using paste to circumvent my data validation? Unfortunately when cells are pasted over in Excel, it’s not just the […]
How can I prevent people entering a date that’s already been finalised? Oooh… Usually data validation questions are all about creating drop-down lists, so this is a nice change. Data validation is actually a tool that’s used to restrict what can be entered in cells to criteria defined by the user. Although it’s commonly used […]
What formula could I use to extract only Unique items from a large table of data? Great Question! There isn’t an Excel function that’ll do this for you (yet). You could to it with a pivot table, but sometimes that’s not practical, so if you really need a formula to return the results, you’re going […]
Flash Fill is a feature that was new in Excel 2013 and it is absolute gold. If you’ve ever had to extract just a small part of a cell throughout an entire list or had to join together parts of multiple cells within a large list, you’re going to absolutely love Excel’s flash Fill feature. […]
How can I colour code cells in Excel so that -10 is red and +10 is green? With conditional formatting of course 🙂 Excel’s Conditional Formatting menu is choc full of tools to help you automatically format your cells based on their values or on the values of adjacent cells – or both! In this […]
Danielle has been a pleasure to work with and nothing but helpful. A complex task to me was no issue for her to automate, saving me so much time with improved efficiencies when it comes to reporting. Highly recommended. Thanks Danielle
How can I create a dependent drop down list? This is a question that I get all the time and while the question is simple enough – the answer is anything but. It’s going to require the creation of a dynamic named range that’ll use multiple functions nested within a single formula to make the […]