MS Excel Intermediate

Start date: 26 November 2019

Duration: 1 day 9.30-4.30

Location: The Mill Enterprise Hub, New Road Link, Greenhills, Drogheda, Co Louth

Certificate: This course is fully Booked

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

We will begin the day with an overview of some of the Level One topics.  This will act as a recap for those who have already attended Level One, and will ensure that the experienced users who have not attended Level One become more aware of the use of Speed Keys etc.  We will then cover some of the intermediate topics – working with and linking multiple worksheets, creating charts, managing lists (Sorting & AutoFilter) among some other options.

Excel Basics (An Overview)

  • Review of Excel Basics concentrating on quick methods of performing commonly used commands / features including an overview of Speed Keys

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.

OUR TRAINERS: We have a team of experienced & dedicated trainers who in addition to the MS Office applications and the relevant training qualifications, have completed 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