FROG Software Training: Excel Intermediate

Designed for existing users. 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
  • 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

 

Looking for something specific?