by John MacDougall | Dec 26, 2016 | Tutorials
Are your Excel files too big? Are they taking too long to open and save them? Are you looking for a spreadsheet that understands the binary language of moisture vaporators? Star Wars jokes aside, you might want to give the xlsb file type a try, these are Excel’s...
by John MacDougall | Dec 24, 2016 | Power Query
WARNING!!! Mega POWER Ahead! Note: When using the completed workbook, you will need to change the folder reference in the query to wherever you save the sample files. From the Query Editor, go to View > Advanced Editor and change the folder path. If...
by John MacDougall | Dec 23, 2016 | Tips
Get The Completed Workbook Suppose we have some data for an employee list that will continually be updated and we want to make sure that any user adding to the list doesn’t add a duplicate entry. In this post we’ll learn how to use data validation...
by John MacDougall | Dec 23, 2016 | Tutorials
What’s so great about Excel tables? Excel tables are great for organizing and analyzing related data and can make your life a lot easier. They’re definitely a feature you’ll want to start using. Formulas that reference a table are easier to read and...
by John MacDougall | Dec 20, 2016 | Tips
By default when typing data or a formula into a cell and pressing enter, the active cell cursor will move down one cell. You don’t have to be stuck with this if you don’t want it though. You can also have it go up, left, right or not move at all if you...