Loading Events

Events

Microsoft Excel: Advanced

December 4 at 9:30 AM- 4:30 PM

Member price: £135 + VAT
Non-member price: £165 + VAT

Duration: 1 Day

Location: Rotherham

 

A 1 Day Advanced Course, aimed at users that have attended the previous stages or experienced users. This course aims to extend the users knowledge with more tools and commands. By the end of the course, users will be able use features including Goal Seek, Data Tables, Scenario Manager and Macros.

 

Refresh on Formulas

  • Quick refresh on commonly used formulas in Excel
  • VLOOKUP formula
  • IF Logical Tests
  • SUMIF formula
  • COUNTIF formula

 

Consolidation

  • How to consolidate your excel data from multiple locations
  • Bringing together data from multiple sources
  • Viewing multiple worksheets
  • Viewing multiple workbooks

 

Text Manipulation

  • Analysing Data from external Sources.
  • Use basic Text Formulas
  • Format data using Text to Columns
  • Connect to an external Data Source using OBDC Connectors

 

What if Analysis

  • Forecasting return figures for business
  • Goal Seek
  • Data Tables
  • Scenario Manager

 

Forms

  • How to use the form controls to make filling in spreadsheets quicker and easier for your users
  • Command Buttons
  • Check Boxes
  • Scroll Boxes
  • Dropdown lists
  • Data Validation

 

Macros

  • Introduces the user to the basics of macros
  • Creating macros
  • Editing macros
  • Running Macros
  • Macro Security
  • Assign a macro to a command button

 

Customising Excel

  • Customising excels default settings Modify existing toolbars
  • Create custom toolbars
  • Create and edit menu bars

Book this training course

Name
Address
MM slash DD slash YYYY
This field is for validation purposes and should be left unchanged.
  • This event has passed.
Event Series Event Series: Microsoft Excel: Advanced

Details

Date:
December 4
Time:
9:30 AM- 4:30 PM
Series:
Event Categories:
,

Venue

Rotherham

Organiser

Chamber Skills Solutions
Phone
01709 386200
Email
training@brchamber.co.uk

Other

Enquiry Only
Is Inquirable