MS Excel – Intermediate

Join the E-Bridge Training Ltd (facilitated by ERF Skillnet) for this 5 session MS Excel workshop, Intermediate level.

The course will run online for 5 consecutive weeks, commencing Sept 10th.  

OVERVIEW:

This course is suitable for those who are currently using MS Excel on a regular basis but may not have attended a training course recently or may never have attended formal training. A basic working knowledge of Excel is required in order to attend this training.

This content covers Excel essential functionality, through to Intermediate content and will also focus on timesaving tips and tricks for the day to day use of MS Excel.

WEEK 1: ESSENTIAL SKILLS

• → The MS Excel Window / Customising the ‘Quick Access Toolbar’
• → Using Shortcut Keys – Navigating / Selecting / Data Entry / Editing
• → Working with Rows and Columns – Inserting / Deleting / Resizing columns / Hiding and Unhiding
• → Moving and Copying content – Filling / Cut -Copy- Paste / Drag and Drop / The Clipboard Task Pane
• → Filling continued / Custom Lists
• → Formatting – Font / Alignment / Number / Format Painter / Orientation / Wrap Text
• → Preview / Page Setup / Print Options

WEEK 2: WORKING WITH FORMULAS AND FUNCTIONS

• → Writing and understanding basic formulas
• → Writing and understanding basic functions SUM / MIN / MAX / AVERAGE / COUNT / COUNTA / COUNTBLANK
• → Copying Formulas – Relative vs. Absolute cell addressing
• → Conditional formatting revisited (using formulas)
• → IF Function (The Basics)

WEEK 3: WORKING WITH LISTS / MANIPULATING TEXT

• → Freezing Panes / Print Titles
• → Sorting and Filtering a list
• → The Filter Function – Excel 2019 / 365 only
• → Creating and Working with Excel Tables
• → Manipulating Text
•  

WEEK 4: CREATING AND WORKING WITH CHARTS

• → Creating and editing various chart types
• → Moving / Resizing the chart
• → Adding / Editing chart elements
• → Creating a combined chart
• → Displaying data on a secondary axis
• → Adding an additional range to a chart once created
• → Creating and working with Sparklines

WEEK 5: MULTIPLE WORKSHEETS / DATA CONSOLIDATION

• → Inserting new worksheets / Renaming
• → Navigating between sheets – Mouse / Keyboard / Navigation List
• → Moving / Copying sheets
• → Using ‘Group Edit’
• → Linking sheets using Formulae
• → Breaking Links
• → Other sheet options – Tab colour / Hiding and Unhiding sheets.
• → Data Consolidation – Position / Category (Label)

DATES:              Sept 10th – Oct 8th  

TIME:                 11:30am – 1pm

LOCATION:       5 x online webinars

COST:                €95 per person or €160 for 2 people

TIMETABLE:

This course is subsidised by ERF Skillnet – Early booking is advisable as places are strictly limited.