FROG Software Training: Excel Intermediate

Designed for existing users. Attendance of the Introduction course or equivalent knowledge is required.

Dates Tuesday, April 13, 2021 - Download as vCalendar
Event Times: 09:30 to 16:30
Venue Microsoft Teams
Contact Name Rachel Crew
Contact Phone 01223 841848
Website Event website

Event details:


The aim of this course is to have the participant `up and running' immediately following a one day intermediate programme based upon their existing skills and future needs.  At the end of the course the participant should be able to understand basic formulae in more detail, print and manage large spreadsheets more easily and create simple graphs. 


Refresher of the Basics

  • Tips for Creating Spreadsheets
  • Basic Formulae / Functions
  • Absolute References ($)



  • Naming Cells
  • Editing and Deleting


Tips for Working with Large Spreadsheets

  • Freezing Screen Titles
  • Splitting Windows
  • Displaying Multiple Sheets / Files on Screen


Worksheet and File Linking

  • Creating Simple Links
  • 3D Referencing
  • Consolidation
  • Hyperlinks
  • Links to other Programs



Page Setup Options

  • Headers and Footers
  • Repeat Headings for Printing
  • Scaling
  • Page Break Preview
  • Setting Print Areas


List Data

  • Sorting a List
  • Filters



  • Creating, Formatting and Editing Basic Charts
  • Sparklines

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!