Q. I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of ...

Small businesses need to ensure data integrity in spreadsheets. Microsoft groups objects such as drop-down lists in a category called data validation. These objects help spreadsheet creators control ...

Tracking the time your employees take off needn't cause you a headache. With Microsoft Excel you can set up a workbook that can organize all sick days, personal days and any other days you need to ...

Navigating through a complex Excel workbook or spreadsheet can be a real headache, especially when you’re dealing with multiple sheets and endless data. But what if there was a way to simplify this ...

If you want to create a dashboard in Microsoft Excel, this post will help you. A dashboard is a type of graphical representation that depicts the key performance indicators for a particular topic or ...

Alan is a technology author based in Nova Scotia, Canada. A computer enthusiast since his youth, Alan stays current on what is new and what is next. With over 30 years of experience in computer, video ...