Troubleshooting common issues in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 6 videos | 19m 18s
- Includes Assessment
- Earns a Badge
- CPE
In Excel 365, it is easy to prevent and resolve issues when working with multiple workbooks. In this course, you will learn how to check whether your workbook has compatibility issues with older versions of Excel, whether it contains personal information that you may not want to share with others, as well as how to recover unsaved documents. Also, you will learn how to ensure formulas are updated automatically when changes are made. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this troubleshooting common issues in excel 365 course
Check for compatibility issues in excel 365
Find personal information in excel 365 -
Recover unsaved changes in excel 365
Enable formulas to update automatically in excel 365
Configure and use language features
IN THIS COURSE
-
44sThis video outlines the key content covered in this Microsoft 365: Troubleshooting common issues in Excel 365 course, including how to check for compatibility issues, enable formulas to update automatically, and how to add adjust the language options. FREE ACCESS
-
4m 25sExcel 365 can check for issues which may cause a workbook to be incompatible with older versions of the application. This is important as there are certain tools and features – such as SmartArt items – that are not supported fully or will experience fidelity losses in older versions of Excel. In this video, you will discover how to check for compatibility issues in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.5.4 Inspect workbooks for issues. FREE ACCESS
-
3. Finding personal information2m 45sBefore sharing an Excel 365 workbook, it’s a good idea to check for any personal or confidential information that might have been added. You can find comments, data inserted into headers and footers, and even hidden rows and columns. Once you have identified any elements that could be considered confidential, Excel can help you to decide what to do with it. In this video, you will explore how to find personal information in Excel 365. FREE ACCESS
-
4. Recovering unsaved changes4m 26sAutoRecover in Excel 365 automatically saves a copy of your work every few minutes. So, if your device crashes, you can restore the last automatically saved version of the workbook. You can set you how often AutoRecover saves information as well as AutoSave files to OneDrive and SharePoint. In this video, you will learn how to recover unsaved changes in Excel 365. FREE ACCESS
-
5. Enabling formulas to update automatically2m 41sIn Excel 365, formulas are updated automatically. However, you can set calculation to manual and choose when to run them yourself. In this video, you will discover how to enable formulas to update automatically in Excel 365. FREE ACCESS
-
6. Adjusting language options4m 17sIn Excel 365, you can change language preferences and configure them to best suit your needs. In this video, you'll see how to configure language options. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 1.3.1 Configure editing and display languages. As well as MOS MO-201 / Excel Expert Certification exam objective: 1.3.2 Use language-specific features. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
