Brush Up your Excel

Who is this course for?

If you are new to Microsoft Excel, new to this version of Microsoft Excel or have not used it in a while and would like to fill gaps in your knowledge or just “work smarter”, this course is an ideal starting point.

What are the benefits

At the end of this course you will have a good understanding of the basic functionality of Microsoft Excel and be able to create formatted spreadsheets with calculations and formulas.

Enquire about this course

Course Enquiry

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

Course Duration

1 Day

Course Content

The Excel Screen

  • Overview of the Excel interface and terminology

Worksheets and Workbooks

  • Navigating Worksheets and Workbooks
  • Changing Column widths and Row heights
  • Inserting and deleting rows and columns
  • Hiding and displaying columns, rows and worksheets
  • Freezing horizontal and vertical panes

Entering and Editing Data

  • Recognising value and label data
  • Entering data using In-Cell and the Formula Bar
  • Working with text, dates, and numbers
  • Using Undo and Redo
  • Inserting and deleting selected cells
  • AutoComplete v Pick Lists
  • Editing cells
  • Find and Replace
  • Managing data series with AutoFill

Formulae and Functions

  • Working with mathematical operators
  • Entering and editing formula
  • Using AutoSum
  • Analysing data with the math function SUM, and the statistical functions AVERAGE, MAX, MIN and COUNT
  • Introducing absolute and relative references

Formatting Techniques

  • Applying font styles
  • Modifying cell alignment
  • Utilising number formats
  • Using the Format Painter
  • Cutting, copying and pasting data
  • Formatting with colours and patterns
  • Adding and editing borders and gridlines

Page Setup

  • Changing page orientation
  • Setting the scale, paper size and print quality
  • Working with margins
  • Centring data on a worksheet

Headers and Footers

  • Using pre-set Headers and Footers
  • Adding page numbers
  • Creating custom Headers and or Footers

Printing

  • Using Print Areas
  • Printing a selection
  • Displaying row and/or column titles on every page
  • Setting the order in which pages are printed

Charts and Sparklines (2010/2013)

  • Creating Charts and Sparklines to show data trends
  • Editing Charts
  • Formatting Charts

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