SkillSoft Explore Course – Lambers, Inc.

Productivity & Collaboration Tools Office 365 Excel for the Web

Excel for the Web makes it easier to enhance the presentation of your worksheets.

Discover how you can customize your font options, align data, and use colors. If you are working with large amounts of data, it will be useful to know how to resize rows and columns, as well as set borders.

In this course you will also learn how to create table and customize them with the formatting style options to improve the presentation of your data.

Asset ID	ds_msexon20_04_enus
Course Type	Video Course
Course Category	Office 365

Objectives
Excel for the Web: Formatting Data apply data formats to a data range use font format options in a spreadsheet insert, customize, and delete borders apply font and background colors use conditional formatting to highlight data transfer format styles from a worksheet to another insert and delete columns or rows resize columns and rows in a spreadsheet convert a data range into a table and edits its contents change the appearance of a table with the formatting styles

Objectives

Excel for the Web: Formatting Data

apply data formats to a data range
use font format options in a spreadsheet
insert, customize, and delete borders
apply font and background colors
use conditional formatting to highlight data
transfer format styles from a worksheet to another
insert and delete columns or rows
resize columns and rows in a spreadsheet
convert a data range into a table and edits its contents
change the appearance of a table with the formatting styles