This is the Excel trick that will change everything about how you work with data

Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once.  Follow BI Video: On Twitter  … [Read more...]

This is what separates the Excel masters from the wannabes

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP. Follow BI Video: On Twitter  … [Read more...]

11 basic Excel tricks that will change your life

Even regular users of Microsoft Excel might not be getting as much out of it as they can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know.1. Jump from worksheet to worksheet with Ctrl + PgDn and Ctrl + PgUp RAW Embed 2. Jump to the end of a data range or the next data range with Ctrl + Arrow Of course you can move from … [Read more...]