Microsoft Excel: Intermediate

Loading Events

« All Events

  • This event has passed.

Microsoft Excel: Intermediate

July 12 @ 9:00 am - 5:00 pm

|Recurring Event (See all)

One event on 27th June 2018 at 9:00am

One event on 12th July 2018 at 9:00am

One event on 26th July 2018 at 9:00am

One event on 7th August 2018 at 9:00am

One event on 23rd August 2018 at 9:00am

One event on 4th September 2018 at 9:00am

One event on 27th September 2018 at 9:00am

One event on 2nd October 2018 at 9:00am

One event on 25th October 2018 at 9:00am

One event on 6th November 2018 at 9:00am

One event on 29th November 2018 at 9:00am

Member Price: £125 + VAT
Non-member: £165 + VAT

Duration: 1 Day

location: Rotherham

 

A 1 Day course aimed at users that have attended the introduction course or are an experienced user currently creating and using excel within their role. By the end of the day users will be able to use features including sort, filters, PivotTables and Linking spread sheets.

Formulas

  • Shows the user how to action the more enhanced commonly used formulas.
  • VLOOKUP formula
  • IF Logical Tests
  • Nested IF Formulas
  • SUMIF formula
  • COUNTIF formula
  • AVERAGEIF Formula

 

Formatting Cells

  • Quick ways to professionalise your cells formatting and appearance.
  • Conditional Formatting
  • Format Painter Tool
  • Data Validation

 

Working with Data

  • Effective ways of working with sets of Data in Excel.
  • Using Named Ranges
  • Formatting data using Tables
  • Creating Dynamic Expanding Ranges

 

Excel with other programs

  • Shows the functions of other programs through excel.
  • Linking multiple excel workbooks
  • Embedding word documents
  • Embedding PDF files

 

Protection

  • Restrict the formatting and editing of your spread sheets by users.
  • Read Only
  • Restricted editing options
  • Password protection
  • Splitting Windows

 

Pivot Tables

  • Creating, editing and understanding the Pivot Table tool in Excel.
  • Understanding Pivot Tables
  • Creating Pivot Tables
  • Modifying data and refresh data
  • Creating Pivot Charts

Details

Date:
July 12
Time:
9:00 am - 5:00 pm
Event Categories:
, , ,

Venue

Rotherham
South Yorkshire United Kingdom

Organiser

Chamber Skills Solutions
Phone:
01709 386200
Email:
training@brchamber.co.uk
Website:
www.brchamber.co.uk/training

Other

Enquiry Only
Is Inquirable

Book this training course