FROG Software Training: Excel Intermediate


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

Dates Wednesday, October 7, 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 01223841848
Website Event website

Event details:

Objectives

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 ($)

 

Names

  • 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

 

Charts

  • 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!