Formatting Data in Excel 2019 for Windows

Excel 2019 (Windows)    |    Beginner
  • 14 Videos | 49m 13s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 306 Likes 306
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

  • Playable
    1. 
    Setting your data type in Excel 2019 for Windows
    4m 4s
    UP NEXT
  • Playable
    2. 
    Formatting your data in Excel 2019 for Windows
    4m 9s
  • Locked
    3. 
    Aligning your data in Excel 2019 for Windows
    4m 17s
  • Locked
    4. 
    Using colors in Excel 2019 for Windows
    3m 28s
  • Locked
    5. 
    Changing your cell style in Excel 2019 for Windows
    3m 55s
  • Locked
    6. 
    Using document themes in Excel 2019 for Windows
    3m 25s
  • Locked
    7. 
    Using formulas to modify your text case in Excel 2019 for Windows
    3m 20s
  • Locked
    8. 
    Creating a WordArt title in Excel 2019 for Windows
    2m 12s
  • Locked
    9. 
    Formatting a title in Excel 2019 for Windows
    3m 19s
  • Locked
    10. 
    Create a table in Excel 2019 (Windows)
    3m 46s
  • Locked
    11. 
    Resizing columns & rows in Excel 2019 for Windows
    3m 21s
  • Locked
    12. 
    Inserting columns & rows in Excel 2019 for Windows
    2m 35s
  • Locked
    13. 
    Inserting borders in Excel 2019 for Windows
    4m 6s
  • Locked
    14. 
    Transferring format styles in Excel 2019 for Windows
    3m 18s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 561 Likes 561