In this Excel video tutorial, I'll show you how to combine several Excel spreadsheets into a single spreadsheet. I mean, how to merge many Excel workbooks into just one workbook.

So, let's take several different spreadsheets and combine them all into just one spreadsheet.

In this practical example, I have 3 different sales spreadsheets. A worksheet for each store. In total, there are 3 stores. In each excel sheet, I have sales record tables with information like date, product, value and product sku or ID.

These spreadsheets will not be filled in by me, but by a company employee. That way, if I need to know what information is contained in the sales tables, I need to keep opening many Excel files, manually open file by file.

However, opening several spreadsheets is not at all productive, so a great way to gain productivity in Excel and to save time using Excel, either on a daily basis or in the job market, is to unify all the worksheets into one.

To do this, to join the various worksheets into a single file, I will use a formula that is just the equal sign and then, to combine this three datasetes, I'll gonna use the vlookup function. But, I'll need to use one function append to another function to get it done right.

#JopaExcel #Dashboard #Excel