Looking to become an Excel power user? Excel has a number of features that will make it easier for you and your colleagues to enter data into your spreadsheets. If you’re developing a spreadsheet that ...

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This behavior can be frustrating when you ...

There may be times when a business proposal or report you need to write needs data that is kept in two or more separate Excel worksheets. Fortunately there a couple of ways you can combine multiple ...

In this video, learn how to create fully clickable tabs inside a single Excel sheet that change colors when selected, automatically updating the corresponding data. This technique consolidates ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet. Line graphs can help make data easier to understand by creating a visual representation of ...