In Microsoft Excel, a program packaged with Microsoft Office, you can create databases of information and then make calculations, graphs and charts based on that data. It's a handy program to have if ...

Often we need to carry out manipulations in Excel documents and apply them to multiple rows, columns and sheets. To do this manually takes too much time and allows for errors to creep in, so Excel ...

Combine the navigational features of hyperlinks with the organizational capabilities of a table of contents, and you get a powerful new way to manage large Excel workbooks. You can create an Excel TOC ...

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

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...

Microsoft Excel application allows you to share your Excel workbook with multiple users across the web. That said, only the users having access to your workbook can open and modify it. This feature is ...