MS Excel Intermediate DELIVERED ONLINE

Start date: 14 April 2020

Duration: 5 x 1.5 hr sessions over 5 weeks dates below

Location: ONLINE

Cost: RRP €250 Non-Member €150 Member €120

Programme overview

This course will run over 5 1 1/2 hour sessions over 5 weeks on the following dates: Tuesday April 14th 11.30- 1pm, Monday April 20th 9.30am-11am, Monday April 27th 9.30am-11am, Wednesday May 6th 9.30am-11am and Monday May 11th 9.30am-11am.

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

eBridge

Applications Closing on 17th march 2020