Microsoft Excel 2016 Level 1.4 Formatting a Worksheet

  • E-Learning

This training video helps new and experienced Excel users create more attractive and readable spreadsheets in Excel 2016. Using step by step processes, the video explains how to change the font, font size and format the spreadsheets name and column labels. Viewers learn how to use the format painter tool to quickly apply formatting changes to single or multiple cells. Excel data readability is significantly affected by the alignment of cell contents. 

This training demonstrates the use of right alignment, left alignment, and centering, aligning content to the top or bottom of the cell. It also shows how to merge cells and align the contents of the expanded cell and wrap text. Excel 2016 has simplified formatting a spreadsheet and this course shows viewers how to use the programs tools to create a visually appealing and easy to read display of data. 

It is best to complete this course in one sitting, if you do need to stop the training midway, please enable cookies for our website and allow popups (turn off your popup blocker) so that you don't lose progress for the course.


Topics Covered

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates


0.5 hours


Best Practices


As Needed

Who Should Attend:

New And Experienced Excel Users