Loading Events

« All Events

  • This event has passed.

Intermediate Excel

5th June 2019 @ 9:30 am - 4:30 pm

£165 Non-Academy Price £115 Academy Price
Objectives: This course is designed to take current users to the next ability level by providing them with new skills and a more in-depth understanding of Microsoft Excel’s capabilities. On completion, attendees should be able to identify quickest and best practice procedures and be competent using more of the formulas, tools and features that Excel has to offer.
Style: A structured, hands-on, tutor-led session using practical examples and exercises.
Prerequisites: Delegates attending this course must have previous experience using Microsoft Excel. An

understanding of basic formulas and formatting options would be an advantage.

Content:

 

Quick review of essentials

Screen layout and view
Using AutoFill / Custom Lists
Working with workbooks & worksheets
Useful hints tips and shortcuts

Formulas = Add + Subtract – Multiply * Divide /

Using best practices and quickest methods
Longer formulas using the BODMAS rule
Working with percentages Absolute Cell Referencing
Calculating with dates =TODAY() =NOW()

Further formatting options

Number format options Conditional formatting
Format as table
Using the Format Painter

Using Functions

SUM MAX MIN
COUNT
COUNTA
COUNTBLANK
AVERAGE
Introduction to IF Functions

Text Functions

UPPER
LOWER PROPER

Paste Special

Values / Formats
Column Widths
Transpose

Working with comments

Inserting / editing / deleting Comments
Show / Hide comments

Working with database lists

Best practices for data input
Review of Sorting and Filtering essentials
Filtering using specific criteria
Using Subtotals
Introduction to Pivot Tables
Freeze Panes / Find and Replace

Calculating with multiple worksheets

Grouping & Ungrouping multiple worksheets
Calculating on a totals/summary worksheet

Further Printing options

Repeat Title rows / Custom Headers & Footers

Benefits to the organisation

  • Get the job done quickly and efficiently
  • Avoid time wasting and costly mistakes
  • Portray a professional image

NB: This course is also available as in-house course tailored to the needs of your organisation if you have a minimum of 5 delegates (Please enquire for details)

Details

Date:
5th June 2019
Time:
9:30 am - 4:30 pm
Cost:
£165 Non-Academy Price £115 Academy Price
Event Category:

Organiser

BPI
Phone:
01685 884175
Email:
info@bpigroup.co.uk

Venue

BPI
Venture Wales Building, Depot Rd
Aberdare, RCT CF44 8DL United Kingdom
+ Google Map
Phone:
01685 886357
Website:
http://www.bpigroup.co.uk