Using visual elements in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 12 videos | 39m 11s
- Includes Assessment
- Earns a Badge
- CPE
An Excel 365 worksheet can contain more than just numbers and text. In this course, you will discover how to make your worksheets more visually appealing using hyperlinks, images, screenshots, shapes, icons, special characters, as well as colors and themes. Start by learning how to insert an image or photograph, which can be used to illustrate your data, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You will then explore how to adjust an image's brightness, contrast, saturation levels, apply a variety of artistic effects and even add a border. You can also create diagrams using shapes and insert icons to help illustrate a worksheet. You will explore the different types of links and hyperlinks you can insert into your document. You will learn how to insert special characters into a cell and see how to use colors and themes to help data stand out and make a table easier to read. Also, you will discover how to create and edit clean, professional-looking titles with WordArt. 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 using visual elements in excel 365 course
Insert a hyperlink in excel 365
Insert images in excel 365
Edit an image in excel 365
Insert screenshots in excel 365
Insert shapes in excel 365 -
Insert icons in excel 365
Insert special characters in excel 365
Use colors in excel 365
Use themes in excel 365
Create a wordart title in excel 365
Format a wordart title in excel 365
IN THIS COURSE
-
46sThis video outlines the key content covered in this Microsoft 365: Using visual elements in Excel 365 course, including how to insert and edit images, use colors and themes, and how to create and format a WordArt title in Excel 365. FREE ACCESS
-
4m 42sIn Excel 365, you can include hyperlinks in your worksheets to connect to websites, email, or other files. Once inserted, a hyperlink can be removed if you no longer need it, without affecting the content it’s linking to. In this video, you will learn how to insert hyperlinks for emails, websites, and documents so you can access them from Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 1.2.3 Insert and remove hyperlinks. FREE ACCESS
-
3. Inserting images3m 50sExcel 365 worksheets can be illustrated with images saved on your computer or retrieved from an online source. You can even access a Bing-powered directory directly from the Excel 365 application. In this video, you will explore how to insert images in Excel 365. FREE ACCESS
-
4. Editing an image3m 14sSometimes images inserted into Excel 365 need to be edited to improve their appearance. You can modify the color and artistic effect or even apply a Picture Style. And if you're not happy with the changes, you can reset the picture. In this video, you will discover how to edit an image in Excel 365. FREE ACCESS
-
5. Inserting screenshots3m 29sIf there's information in another application, such as PowerPoint, that you want to add into Excel 365, you can insert a screenshot of the data displayed on the screen. In this video, you will learn how to insert screenshots in Excel 365, as well as take a screen clipping directly from the application. FREE ACCESS
-
6. Inserting shapes4m 3sIn Excel 365, shapes can be formed into diagrams, to illustrate work processes and ideas. These shapes can be copied and grouped, as well as have text added to them. In this video, you will explore how to insert shapes in Excel 365. FREE ACCESS
-
7. Inserting icons3m 45sIcons can be used as a visual representation of the data in your Excel 365 worksheet, without having to search for a suitable picture online. In this video, you will discover how to insert, edit, and group icons in Excel 365. FREE ACCESS
-
8. Inserting special characters3m 43sExcel 365 features a library of special characters not found on your keyboard, such as the copyright and registered trademark symbols. In this video, you will learn how to insert special characters in Excel 365. FREE ACCESS
-
9. Using colors3m 28sIn Excel 365, colors can be used to highlight certain pieces of data. It can also make the worksheet easier to read. You can even change the text color or apply a Table Style. In this video, you will learn how to add a fill color in Excel 365. FREE ACCESS
-
10. Using themes2m 46sExcel 365 themes can be used to change the overall appearance of a workbook. These themes are also customizable. In this video, you will discover how to apply themes in Excel 365. FREE ACCESS
-
11. Creating a WordArt title2m 7sExcel 365's WordArt tool can be used to create professional-looking titles with color and effects. In this video, you will explore how to create, edit, and remove a WordArt title in Excel 365. FREE ACCESS
-
12. Formatting a WordArt title3m 20sExcel 365 has a selection of preset WordArt Styles, which are predefined formats you can apply to your text. However, these styles can be adjusted to suit your visual preferences and business needs. In this video, you will explore how to format a WordArt title to make it presentable and easier to read in Excel 365. 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.
