EXCEL ADVANCED 2010

Event Information

Share this event

Date and Time

Location

Location

Rombourne Business Centre

33 cathedral Road

Cardiff

CF11 9LJ

United Kingdom

View Map

Friends Who Are Going
Event description

Description

COURSE OUTLINE
Excel Advanced

This comprehensive course in Excel teaches participants how to use the advanced features of Excel including, Functions, Multiple Functions, Advanced Filtering, Pivot Tables, Subtotaling, Protection. The course provides the necessary tools to be able to use Excel to a high standard in an ever changing business environment.

This 1-day Excel Advanced course will assist delegates to develop their skills in using formulas and functions and manipulating spreadsheets

Course Content:

  • Convert text case to upper lower & proper
  • Merge text from separate cells into one cell
  • Remove unwanted spaces
  • Count the number of entries in a range
  • Using the SUMIF function
  • The COUNTIF function
  • Using ROUNDUP and ROUNDDOWN
  • Linking cells - paste links
  • Consolidating Data
  • Simple if statements
  • Multiple if statements
  • Nested / AND if statements
  • Naming cell ranges
  • What are lookup tables
  • Creating a lookup table using V lookup
  • Formulae using Absolute cell referencing
  • What is goal seeking?
  • Using goal seeking to find results
  • Advanced formatting options
  • Conditional formatting - multiple conditions
  • Calculating with dates
  • Inserting a dynamic date
  • Using formulae to find day – month - year
  • Custom formatting times
  • Setting up data tables - best practice
  • Advanced sorting / Filtering techniques
  • Creating & customising Pivot Tables
  • Subtotalling lists - subtotalling options
  • Amending, refreshing, grouping Pivot Tables
  • Controlling data entry in a specified range
  • Creating input messages and error alerts
  • Scenarios - changing circumstances
  • Viewing a scenario – amending scenarios
  • Creating a scenario summary
  • Hiding rows, columns and worksheets
  • Password protecting a workbook / sheet
  • Password protecting cells and ranges
  • What is a Macro? - Creating a Macro
  • Running/Deleting / editing an existing Macro
  • Viewing all formulae on a spreadsheet
  • Tracing precedents - tracing dependants


Share with friends

Date and Time

Location

Rombourne Business Centre

33 cathedral Road

Cardiff

CF11 9LJ

United Kingdom

View Map

Save This Event

Event Saved