XLSB File Type

XLSB File Type

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...
How To Prevent Duplicate Data Entries

How To Prevent Duplicate Data Entries

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...
Excel Tables

Excel Tables

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...
How To Change What Happens When You Press Enter

How To Change What Happens When You Press Enter

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...