MS Excel Intermediate

Start date: 26 November 2019

Duration: 1 day 9.30-4.30

Location: tbc

Certificate: n/a

Cost: Non-Member €150 Member €120

Programme overview

This course is designed for learners who have used Excel before and want to expand their knowledge, improving formatting, organising data, highlighting key information and creating formulas/links between sheets. The course will introduce new concepts for sorting data, and building conditional formulae. If you think you know Excel, this course will show you what you've been missing. Learners will leave feeling a new confidence in their Excel expertise and ready to take on new challenges with data. During the training session, each learner will work through exercises and practice using the various Excel features covered during the course.

Learning outcomes

Learners will be able to:

  • ✓ Work with Multiple Worksheets
  • ✓ Create Charts
  • ✓ Manage Lists
  • ✓ Work with dates
  • ✓ Work with formulae and functions.

Who is the course for

This course is suitable for those who are currently using MS Excel on a regular basis but may not have attended formal training recently or may never have attended training.  It is also the next step for those who have already completed Excel Level One and would like to explore further functionality available within MS Excel. You should have a good working knowledge of Excel before attending this training,

Modules

Formatting

  • Advanced Formatting Options
  • Using the Format Painter
  • Deleting Formats
  • Using AutoFormat
  • Conditional Formatting

Viewing and Modifying Worksheets

  • Zoom Setting
  • Splitting a Worksheet
  • Freezing Titles
  • Print Titles
  • Hiding and Un-hiding Columns and Rows

Formulae and Functions

  • Recap of Basic Formulae
  • Recap of Basic Functions
  • Copying Formulae
  • Relative vs. Absolute cell addressing

Custom Lists

  • Working with Lists in Excel
  • Creating Custom Lists
  • Incrementing Numbers & Dates

Working with Multiple Worksheets

  • Switching between sheets
  • Inserting / Renaming / Deleting sheets
  • Moving / Copying sheets
  • Group Edit
  • Linking sheets using Formulae
  • Breaking Links

Charts and Drawing Tools

  • Creating a chart
  • Changing the Chart Type
  • Changing / Adding chart elements
  • Formatting charts
  • Moving / Resizing the chart
  • Creating combined charts
  • Displaying data on a secondary axis

Database Features

  • Sorting Records
  • Using AutoFilter

Working with Dates

  • Formatting Dates
  • Date Calculations
  • The Today Function

Trainer Profile

E-Bridge Training Limited has been delivering a wide range of standard and tailored training courses since 2001. We deliver fully customisable training solutions in the area of IT Applications and Soft Skills and our “Blended Training” approach whereby we combine both IT and Soft Skills training to provide the complete solution.
We are totally flexible with regard to course duration etc. and have for example run 2 x half days training for staff so that participants need only be away from their desk for a half day. We also have the flexibility to run shorter 4 x 1-1 sessions throughout the day. We are happy to work with whatever requirements exist at that time within M1 Skillnet client companies.
OUR TRAINERS: We have a team of experienced & dedicated trainers who in addition to the MS Office applications. In addition to having the relevant training qualifications, as a starting point all trainers complete an in-depth E-Bridge ‘Train the Trainer’ programme. This is to guarantee consistency and ensures that all trainers deliver course content in a similar way. All trainers are involved in the design, development, delivery and evaluation of the training programs as although the core courses are pre-designed we are regularly creating customised solutions for customers covering content that is specifically requested by participants.

Applications Closing on Nov 20th 2019