Troubleshooting common issues in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 6 videos | 19m 18s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 190 users Rating 4.6 of 190 users (190)
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

  • 44s
    This 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 25s
    Excel 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
  • Locked
    3.  Finding personal information
    2m 45s
    Before 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
  • Locked
    4.  Recovering unsaved changes
    4m 26s
    AutoRecover 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
  • Locked
    5.  Enabling formulas to update automatically
    2m 41s
    In 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
  • Locked
    6.  Adjusting language options
    4m 17s
    In 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Rating 3.5 of 57 users Rating 3.5 of 57 users (57)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 364 users Rating 4.3 of 364 users (364)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)