Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

How to Create an Excel Spreadsheet to Figure Out Sick Leave. Your company allots employees a specific amount of sick leave per year, quarter or month.

What’s the difference between a table and a range of columns and rows on an Excel spreadsheet? How do I create and populate tables? And, once a table is created, how do we custom filter, format ...

This collection features six courses packed with over 33 hours of intensive training to help first-timers get experience with all of Excel’s data parsing abilities.

After you've assembled all your financial data and created a worksheet to contain your income in one column and your expenses in another, you can use Excel's "SUM" function to create a formula to ...

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

Show users how to create a quick table of contents in Excel using the power of hyperlinks.