FROG Software Training: Excel Introduction


Designed for new users.

Dates Thursday, October 1, 2020 - Download as vCalendar
Event Times: 09:30 to 16:30
Venue Microsoft Teams
Contact Name Rachel Crew
Email training@frog.co.uk
Contact Phone 01223 841848
Website Event website

Event details:

Objectives

The aim of this course is to introduce working with spreadsheets and simple calculations.  At the end of the session you will be able to create, edit and format spreadsheets using number and font formatting; alter the structure of the spreadsheet by inserting, deleting and resizing columns and rows.  Finally you will be able to create some simple calculations.

 

The Excel Screen

  • The Ribbon
  • Moving around the screen
  • Selecting cells and ranges

 

Creating a Spreadsheet

  • Opening workbooks
  • Entering text and numbers
  • Saving workbooks / Save as PDF
  • Preview and print workbooks
  • Closing workbooks

 

Editing a Spreadsheet

  • Deleting cell contents
  • Editing text and numbers
  • Copying/moving data/Pasting Options
  • AutoFill
  • Inserting and deleting rows and columns
  • Hiding rows and columns
  • Inserting, deleting, copying and moving worksheets
     

Formatting

  • Apply font formats
  • Formatting ranges (currency, fixed etc)
  • Rotate and indent text
  • Modify cell size and alignment
  • Apply borders and shading

 

Formulae

  • Simple calculations
  • Copying formulae
  • Editing formulae
  • Absolute ($) & Relative Formulae
  • AutoCalculate
  • Range Finder

 

Statistical Functions

  • AutoSum
  • Analysing Data using AVERAGE, MIN, MAX, COUNT and COUNTA

 

Tell Me (Help)

For over 30 years we have improved the skillset of over 20,000 individuals with our exceptional and enjoyable courses. Our training and support started back in 1986, when our founder was working with Stephen Hawking as his PA. But you don’t have to be a world-famous theoretical physicist to take part in our training – All our courses from beginner to advanced level provide you with actionable, hands-on training that you can put into practice immediately and save you valuable time!