Formatting Data in Excel 2019 for Windows

Excel 2019 (Windows)    |    Beginner
  • 14 videos | 49m 13s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Refine your data's appearance with Excel 2019 for Windows. In this course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format and align their data. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Formatting Data Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Set your data type in your excel 2019 spreadsheet
    Format your data in excel
    Align your data in excel
    Use colors in your excel 2019 spreadsheet
    Change your cell style in your excel 2019 spreadsheet
    Use document themes in your excel 2019 spreadsheet
    Use formulas to modify your text case in your excel 2019 spreadsheet
  • Create a wordart title in excel
    Format a title in your excel 2019 spreadsheet
    Create a table in excel 2019
    Resize columns and rows in your excel 2019 spreadsheet
    Insert columns and rows in your excel 2019 spreadsheet
    Insert borders in excel 2019
    Transfer format styles in excel 2019

IN THIS COURSE

  • 4m 4s
    You can insert a large variety of data types in your Excel spreadsheet. You can, for example, create dates, percentages, fractions, prices, and text values. You can ensure that these values are correctly displayed by using the format tools. These tell Excel how to classify your data and how to adjust its appearance in your spreadsheet. FREE ACCESS
  • 4m 9s
    In Excel, you can improve the appearance of your data and make it more readable by adjusting its formatting options. Excel features a huge library of fonts that can be applied to your text. You can also adjust the text size and apply different font effects, such as bold, italics and underline. FREE ACCESS
  • Locked
    3.  Aligning your data in Excel 2019 for Windows
    4m 17s
    You can improve the appearance of your table by adjusting your cell's alignment settings. In Excel, you can not only adjust the horizontal alignment of your cells, but also the vertical alignment. It is even possible to adjust the orientation of any text that you have inserted into your cell. FREE ACCESS
  • Locked
    4.  Using colors in Excel 2019 for Windows
    3m 28s
    Color can help to make your data stand out to your reader. It can also be used to make it easier to read your table. In Excel, you can apply color to two main elements: your cell's contents, and your cell's background. FREE ACCESS
  • Locked
    5.  Changing your cell style in Excel 2019 for Windows
    3m 55s
    Cell styles can be used in Excel to quickly change the color, alignment, and size of any data in a specified cell. These styles can be used to control the appearance of multiple cells simultaneously. You can also create your own customized cell styles. FREE ACCESS
  • Locked
    6.  Using document themes in Excel 2019 for Windows
    3m 25s
    Excel themes can be used to change the overall appearance of your spreadsheet. You can also change the color sets in use, the fonts, and even some graphical effects. These tools can be used to quickly give your spreadsheet a completely new look. FREE ACCESS
  • Locked
    7.  Using formulas to modify your text case in Excel 2019 for Windows
    3m 20s
    Excel features a certain number of formulas that can be used to convert your text characters. For example, if you have inserted a number of text values and you need to reformat them into capital letters, you can use the UPPER formula. You can also convert values into lower case, and even make data entries into proper nouns. FREE ACCESS
  • Locked
    8.  Creating a WordArt title in Excel 2019 for Windows
    2m 12s
    Excel 2019 features the WordArt tool which can be used to create clean, professional-looking titles. This can be done using WordArt so that you can insert the title independently of any cells. FREE ACCESS
  • Locked
    9.  Formatting a title in Excel 2019 for Windows
    3m 19s
    Once you've created a title you can format it so to make it presentable and easy to read. Change your title's color, outline, and rotation, and even apply special effects, such as shadows, glows and reflections. FREE ACCESS
  • Locked
    10.  Create a table in Excel 2019 (Windows)
    3m 46s
    Quickly organize your data into tables. Once you do so, it’s easy to format, sort, or apply filters to analyze the data. FREE ACCESS
  • Locked
    11.  Resizing columns & rows in Excel 2019 for Windows
    3m 21s
    If you want to ensure that your data is readable and correctly displayed, then at some point early on you will need to know how to resize your columns and rows. These changes can be made manually. Excel can however also automatically resize your columns or rows so that every data value is correctly displayed. You can even resize multiple rows and columns simultaneously. And if you would rather not resize a cell, you can always adjust the wrap settings to adapt its contents instead. FREE ACCESS
  • Locked
    12.  Inserting columns & rows in Excel 2019 for Windows
    2m 35s
    If your table is missing some data, you can insert a new column or row. This is much easier than simply starting your table again. In Excel, you can also insert multiple columns and rows in a single action. FREE ACCESS
  • Locked
    13.  Inserting borders in Excel 2019 for Windows
    4m 6s
    One good way of making your data values and ranges stand out in Excel is to use the different border tools. These border tools can be used to adjust the color, thickness, and style of any outline effects that are applied to your cells. FREE ACCESS
  • Locked
    14.  Transferring format styles in Excel 2019 for Windows
    3m 18s
    If you have formatted an existing table and you want to reuse the style that you have created, you can transfer it to another data selection. In Excel, you can use the copy and paste tools to quickly transfer your format styles. You can also use the dedicated format painter tool, which allows you to select a format and apply it to a new selection. 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

Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Course Creating and editing macros in Excel 365
Rating 4.5 of 380 users Rating 4.5 of 380 users (380)
Course Using Table Tools in Word 2019 for Windows
Rating 4.5 of 126 users Rating 4.5 of 126 users (126)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Cleaning & Analyzing Data in Tableau Prep Builder
Rating 4.4 of 58 users Rating 4.4 of 58 users (58)
Course Getting Started with Design Thinking
Rating 4.4 of 2479 users Rating 4.4 of 2479 users (2479)
Course Getting Started in Excel 2019 for Windows
Rating 4.5 of 1588 users Rating 4.5 of 1588 users (1588)