Beginners Excel Course

Our Beginners Public  Excel course  is  a one day  Instructor -led course  designed for new users of Excel, or those with  a basic knowledge.

We cover all aspects of creating a spreadsheet  especially learning about  the three Essential Excel concepts:

  1. Relative References
  2. Absolute References
  3. Using Cell References

You will at the end of this course have a very strong  foundation in building and using formulas and functions.

You will master controlling your worksheets and workbook,  how to print them properly, create basic charts and learn fundamental data analysis techniques.

This course covers both 2007, 2010 ,2013   & 2016 Excel versions.

See Course Syllabus Below.

This Course is CPD Certified

Upcoming Beginner’s Course Dates

Level 1  Course Dates:

  • Tuesday  14th November
  • Tuesday  12th December

Course Duration

One Full day

Course Requirments

None

Course Location

GEC center, Taylor’s lane, Dublin 8
(beside the Guinness Storehouse)

Course Price

€248 Inclusive
5% discount for three or more Bookings.

Our Clients

Training Rooms

Course Location

GEC Centre, Taylor’sLane, Dublin 8
01 429 8724
Support@ExcelTraining.ie
Book Online

Course Syllabus: Beginners Course:

Excel Overview

  • A overview of the screen, navigation and basic spreadsheet concepts
  • Understanding workbooks, worksheets, rows, columns, cells
  • Various selection techniques

Entering Data

  • Entering, Editing and Deleting Text, Numbers, Dates
  • Using Auto Lists
  • Moving and Copying data
  • Inserting, Deleting and Hiding Rows & Columns
  • Inserting, Deleting, Moving and Copying Sheets
  • Using navigation techniques

Formatting and Proofing

  • Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns
  • Basic conditional formatting
  • Copying and Clearing Formats
  • Working with Styles
  • Spell Check, Find & Replace and AutoCorrect

Creating and Editing Formulas and Functions

  • Concept of Formulae
  • Creating Formulae, Editing Formulae
  • Bodmas : Mathematical Order
  • Copying Formulae
  • Using Functions – Sum, Average, Max,Min, Count, Counta

Essential Excel Concepts:

  • Understanding Relative References
  • Understanding Absolute References
  • Using Cell references in Excel

Linking cell references in other Worksheets & Workbooks

  • Accessing cells in other worksheets
  • Accessing cells in other workbooks
  • Summarizing data from various worksheets.

Printing and Page Setup

  • Page Orientation
  • Adding Headers and Footers
  • Printing a selection
  • Setting a print area
  • Shrink to Fit
  • Adjusting page breaks within Page Break Preview
  • Repeating columns and rows
  • Printing Grid lines
  • Setting a print area

Charts

  • Creating Various charts types
  • Formatting Charts
  • Changing Chart Locations

Introduction to Data Analysis

  • How to create a list in Excel
  • Important rules when building a list
  • Sorting
  • AutoFilters
  • Autosum Tool