Rapid Learn Microsoft Excel

Course Objectives

During the two half day sessions, attendees will be taken from fundamentals right through to competent user level..

Prerequisites

Attendees should be comfortable using a modern PC system.

Course Duration

2 x ½ days

Course Content

  • Excel Basics
    • Spreadsheet Concepts
    • Moving Around / Selecting Cells
    • Entering Text and Numbers
    • Using Pre-defined Lists
    • Summing Rows and Columns
  • Calculations & Corrections
    • Entering Formulae
    • Correcting Mistakes
  • Moving, Copying, and Inserting
    • Moving/Copying Cells
    • Inserting Rows/Columns/Cells
  • Formatting Worksheets
    • Formatting Basics
    • Number Formatting
    • Alignment of Entries
    • Changing Fonts
    • Adding Borders to Cells
    • Column Width / Row Height
  • Printing Basics
    • Previewing the Printout
    • Fitting a Spreadsheet on a Page
    • Altering Page Margins
    • Headers and Footers
    • Printing the Worksheet
  • Charting Basics
    • Creating Charts
    • Chart Settings
    • Formatting Chart Elements
  • More about Calculations
    • Absolute References
    • Using Functions
    • Examples of Functions
  • More Features
    • Using Comments
    • Splitting and Freezing
    • Using Zoom
    • Conditional Formatting
    • Protect Areas of the Workbook
  • More about Printing
    • Setting the Print Area
    • Using Print Titles
    • Controlling Page Breaks
  • More about Charts
    • Further Formatting
    • Adding Data to an Existing Chart
  • Working with Multiple Worksheets
    • Selecting Multiple Worksheets
    • The Worksheets Context Menu
    • Navigating Multiple Worksheets
    • Calculations between Worksheets
  • Data Commands
    • Working with Lists
    • Sorting Lists
    • Sub-Totalling a List
    • Filtering a List

Download Course Content PDF

Acrobat-PDF

Download Full Course Schedule PDF

Acrobat-PDF

Ask a question

Please contact us to make a booking

If you can't see the course you are looking for - contact info@base2.co.uk