Using visual elements in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 12 videos | 39m 11s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 125 users Rating 4.5 of 125 users (125)
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

  • 46s
    This 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 42s
    In 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
  • Locked
    3.  Inserting images
    3m 50s
    Excel 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
  • Locked
    4.  Editing an image
    3m 14s
    Sometimes 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
  • Locked
    5.  Inserting screenshots
    3m 29s
    If 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
  • Locked
    6.  Inserting shapes
    4m 3s
    In 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
  • Locked
    7.  Inserting icons
    3m 45s
    Icons 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
  • Locked
    8.  Inserting special characters
    3m 43s
    Excel 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
  • Locked
    9.  Using colors
    3m 28s
    In 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
  • Locked
    10.  Using themes
    2m 46s
    Excel 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
  • Locked
    11.  Creating a WordArt title
    2m 7s
    Excel 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
  • Locked
    12.  Formatting a WordArt title
    3m 20s
    Excel 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.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.5 of 99 users Rating 4.5 of 99 users (99)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1438 users Rating 4.6 of 1438 users (1438)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)