Within a large range of tabular data, you may want a list containing only data sets that have a specific value. This list could contain the value of the first column of all the rows with a specific date in the third column. For example, here’s how to list all the names with a blank […]
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? […]
Microsoft Word has a large range of symbols that you can insert easily into your document. For example, here’s how to insert the telephone symbol: Read Danielle O'Connell's answer to How do you insert the telephone symbol in Microsoft Word? on Quora
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 […]