10 common tools in Excel 365
Excel 365 (2023)
| Beginner
- 11 videos | 43m 12s
- Includes Assessment
- Earns a Badge
- CPE
To make the most out of Excel 365, you need to be familiar with some of its most frequently-used features. This course highlights ten tools to help take your Excel proficiency to the next level. In this course, you will see how to use the Selection Pane and related tools to select objects in a worksheet. Find out how to quickly apply commands with keyboard shortcuts, search, and KeyTips. Discover a number of features designed to help you review your worksheet, including spell check, AutoCorrect, Smart Lookup, and Translate. In addition, the course explores different ways to find and resolve issues in your workbooks. See how to check for issues related to compatibility with older versions of Excel, accessibility to users with different needs, as well as privacy and confidentiality. Finally, find out how to recover unsaved workbooks. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in the 10 common tools in excel 365 (2023) course
Use the selection pane, select objects tool, and go to special tool to select objects in a worksheet
Apply commands using the search bar, keytips, and keyboard shortcuts
Check spelling in a worksheet
Use autocorrect to automatically correct spelling and grammar mistakes
Search words and phrases using smart lookup -
Use the translation tool
Use the document inspector to find and remove sensitive information
Check for compatibility issues with different workbook formats and save files to an older format
Use the accessibility checker to resolve accessibility issues and access accessibility options
Recover and remove unsaved workbooks in excel
IN THIS COURSE
-
1m 1sThis video outlines the key content covered in the 10 Common Tools in Excel 365 (2023) course, including quickly applying commands, checking spelling, and improving accessibility. FREE ACCESS
-
4m 48sYou can select objects, like shapes, charts, and images, if you need to manage or format them. In this video, you will see how to quickly select all objects using Go To Special, select individual objects using the cursor, and hide and show objects with the Selection Pane. FREE ACCESS
-
3. Quickly applying commands in Excel 3654m 20sBesides manually navigating the Ribbon and the right-click context menu, Excel offers other ways to quickly access the dozens of commands available in the app. You can search for a command by name using the search bar, navigate the Ribbon with the keyboard thanks to KeyTips, and instantly apply commands using keyboard shortcuts. See how in this tutorial. FREE ACCESS
-
4. Checking spelling in Excel 3655m 4sBefore sharing your workbook, it is a good idea to check it for spelling mistakes. In this video, you will see how to run spell check and respond to suggested changes. You will also see how to configure proofing options and access the custom dictionaries. FREE ACCESS
-
5. Using AutoCorrect in Excel 3654m 37sAutoCorrect can save you time and improve accuracy while editing workbooks. In this video, you will see how to use AutoCorrect to automatically fix common spelling mistakes. You will also see how to add words to AutoCorrect and configure other AutoCorrect options. FREE ACCESS
-
6. Using Smart Lookup in Excel 3653m 57sYou can use the Smart Lookup tool to quickly find additional information about key words and phrases used in your spreadsheets. In this video, you will discover how to use Smart Lookup to find images, definitions, and information on the Web. FREE ACCESS
-
7. Translating text in Excel 3653m 14sIf you ever need to work in multiple languages, the Translate tool can come in handy. In this video, you will see how to translate between different languages in Excel. FREE ACCESS
-
8. Using the Document Inspector in Excel 3653m 11sBefore sharing a workbook, it is a good idea to check for any hidden data or personal information that might have been added. Using the Document Inspector, you can find and remove comments, hidden rows and columns, and other elements that might contain sensitive information. Find out more in this tutorial. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
-
9. Checking for compatibility issues in Excel 3654m 17sIf you plan on sharing workbooks with users who own earlier versions of Excel, it is important to check for potential compatibility issues. In this video, you will see how to use the Compatibility Checker tool, as well as how to save your workbook to older file formats. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
-
10. Improving accessibility in Excel 3655m 12sIt is important to check accessibility to ensure that all users, including those with disabilities, can access and interact with the content. This includes making sure the document is screen reader-friendly and has appropriate color contrast. In this video, you will see how to find and resolve accessibility issues in Excel. This video aligns with MO-210 Excel Exam objective: Inspect workbooks for issues. FREE ACCESS
-
11. Recovering unsaved changes in Excel 3653m 31sAutoRecover 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. In this tutorial, you will see how AutoRecover works, as well as how to configure AutoRecover options. 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.
