Excel Introduction

Event Details

Date: 
Thursday, 23 January, 2020 -
09:30 to 17:00
Venue: 
Jarrold Training Center - St James' Mill - Whitefriars - Norwich - NR3 1SH

If you're looking for a good starting point with Excel, this is it.

The mystery of calculations will dissolve and getting everything to fit on the right number of pages will become a few seconds work.

You will have a spreadsheet up and running with calculations within an hour and by lunchtime you'll be happy duplicating a number of different calculations across the spreadsheet. Formatting columns, text and numbers will ensure the spreadsheet looks good on the screen, and will still look good when fitted to a page with headers and footers for printing.

Tips, tricks and shortcuts abound and we can't resist squeezing in a quick chart at the end of the day, just to show how easy it is.

You will learn:

  • The Excel screen - The proper names for components of the screen and how to use them
  • Spreadsheet basics - Entering and editing information along with saving as various file types
  • AutoFill - Filling calculations, dates and text based lists such as months of the year
  • Calculations - Add, subtract, multiply, divide and percentages
  • Functions - Sum, Average, Min and Max
  • Formatting - Column & row, numbers, date and time as well as text
  • Printing - Scaling up and down to fit a page along with headers and footers
  • Working with larger spreadsheets - Freezing and splitting the screen

 

Gold Patrons