It’s easy to manually add and name a new sheet to your Excel workbook, but sometimes you need it to occur within your code. Here’s how you can create a new worksheet using VBA code: Read Danielle O'Connell's answer to How do I add a single new sheet and name it using VBA in Excel? […]
Grouping pivot table data is handy, however sometimes grouping data by one attribute just isn’t enough… Luckily if you need to group your data into more specific groups then you can group it by multiple attributes. Here’s how you can group Pivot Tables by two attributes (month and year) using the Group dialog box: Read […]
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 […]
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
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