Master Formatting with Microsoft Excel

Who is this course for?

This specialist course is for you if you are new to Microsoft Excel or have never had any formal training and would like to learn how to format worksheets quickly and efficiently.

What are the benefits

At the end of this workshop you will be able to format your worksheets using Microsoft Excel’s formatting tools and apply formatting which changes according to the cell content.

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

2 Hours

Course Content


  • List

Keyboard Shortcuts

  • Selecting and worksheet elements
  • Quick worksheet navigation

Formatting Worksheets

  • Add, delete worksheets, columns and rows
  • Rename and colour worksheet tabs
  • Set column widths and row height
  • Hide rows, columns and worksheets
  • Add borders to individual cells and ranges
  • Shade rows and columns
  • Show or hide gridlines
  • The Format Painter
  • Page numbers
  • Create customised headers and footers

Formatting Cells

  • Set font and size
  • Merge and split cells
  • Align text
  • Wrap text
  • Centre text across cells
  • Change cell formatting with Find and Replace

Text Formatting

  • Create Styles
  • Use and modify inbuilt Styles
  • Manage Style Galleries
  • Share Styles with other workbooks

Number Formatting

  • Work with inbuilt number formats
  • Create custom number formats

Date Formatting

  • Insert dates using formula
  • Use inbuilt date formats
  • Add custom date formats

Tables and Styles

  • Utilise inbuilt Table Styles
  • Set the default Table Style
  • Modify Table Styles
  • Customise Table Styles
  • Create and apply Styles

Conditional Formatting

  • Add formatting which changes according to the data
  • Manage conditional formatting rules
  • Create custom rules

Setting Margins and Printing

  • Set margins and print area
  • Customise print layouts
  • Repeat rows and columns on every print out

What our users say


  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us