How can I import data from multiple source workbooks into separate worksheets in a single file? Although this can be achieved with links to the source file – links can easily be broken and can also make the file slow and cumbersome. So instead of creating links, I like to create processes that import the […]
Hi there and welcome to Pivot tabling. In this short tutorial, I’m going to show you how to create a pivot table to provide summary information from your data. This is just the first lesson in a small series of lessons on Pivot Tables. If you find that you want to know more, you can […]
In this lesson we’re going to explore and explain an Excel VLOOKUP function. I want you to think of the process of your VLOOKUP like your manual process for searching a phone book. What are you looking for ? (i.e. the name), Where are you going to look? (i.e. which page), What do you want […]
How can I do a VLOOKUP using 2 cells for the Lookup Value and 2 lookup columns in the table array? That’s a tricky question, as VLOOKUP is designed to work with 1 lookup value and 1 lookup array, but where there’s a will; there’s a way. The way I’m going to show you is […]
INDEX & MATCH are two useful excel functions that provide a solution to VLOOKUPs limitations. Unlike VLOOKUP, INDEX & MATCH can lookup the column and the row matching the specified criteria and return the value at their intersection. Don’t be overwhelmed – watch the intro video below and sign up for our free course on […]
Left & Find Hi there! In this brand new tiny topic you're going to learn how to create a formula that will turn a name from First Name Last Name format into Last Name, First Name format, like this: There's just a few simple functions that you're going to need to know – in fact […]
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 […]