Q. I want to strengthen my Excel and Word knowledge. Can you suggest some books and/or videos that would assist me with this goal? A. CPE courses can be a great way to learn how to use Word or Excel, ...

Have you ever sent an Excel file to a colleague, only to realize they couldn’t open it because of compatibility issues? Or perhaps you’ve spent hours perfecting a spreadsheet, only to see its ...

The guide provides insight into how to use the hidden “FILES” function in Excel, a legacy macro function that lists all files in a specified folder. MyOnlineTrainingHub takes you through how to enable ...

Q. Help! I have been working on a very important Excel file for a client, and suddenly my computer locked up and says, “Excel is not responding.” Is there anything I can do so that I don’t lose all of ...

Microsoft Excel has several features designed to help you recover unsaved versions of spreadsheets and prevent data loss. If Excel closes before you save a file, you should see a Document Recovery tab ...

If you work with multiple Excel files over the course of a workday, and especially if you use a dual-monitor setup, you might wonder how you can launch each Excel file in its own window so you can ...