giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Excel 2010 Advanced
 
   
 
Microsoft Excel 2010 Advanced
 
Target Audience:  

Users who need to be able to exploit the full potential of Excel to build powerful spreadsheets, including a wide array of  formulae and functions and who also need to use Excel modelling tools to report on results.

 
   
Objectives:  

By the end of the course users will be able to create sophisticated spreadsheets, which include complex functions.  They will be able to utilise analysis tools to summarise and extract data, use pivot tables, scenarios, database functions and auditing tools. The use of macros will facilitate the automation of tasks.

 
   
Prerequisites:  

A thorough grounding in building multiple sheet workbooks which include functions,  such as Min, Max, Average and simple Ifs. Users should also be able to create simple charts and use filter and sorting options.

 
   
 
       
     
  Duration: 2 Days
  Cost: £300 + VAT
     
 
  Course Date Location
  26/05/2016 Bradford
  20/06/2016 Liverpool
  23/06/2016 Bradford
  06/07/2016 Liverpool
  26/07/2016 Bradford
  24/08/2016 Bradford
  24/08/2016 Liverpool
  27/09/2016 Bradford
  26/10/2016 Liverpool
  26/10/2016 Bradford
  29/11/2016 Bradford
  19/12/2016 Liverpool
  19/12/2016 Bradford
         
Powerful Formulae & Functions
  • Date & Time Functions
  • Math & Trig Functions (Round & Int)
  • Logical Functions (If, And & Or)
  • Statistical Functions (Countif & Sumif)
  • Lookup & Reference Functions
  • Text Functions
  • Financial Functions
  • Data Tables
 
Formula Auditing
  • Tracing Dependant & Precedents
  • Formula Error Checking
  • Copy & Paste Special
  • Cerating & Using Custom Views
 
What-If Analysis Tools
  • Creating, Editing & Deleting  Scenarios
  • Scenario Summary Reports
  • Using Goal Seek
  • Using Solver
 
Using Multiple Workbooks
  • Arranging Workbooks
  • Entering Formula Across Workbooks
  • Linking Information Across Workbooks
  • Linking Information Across Applications
 
   
Data Validation
  • Different Types of Validation
  • Input Messages
  • Error Alerts
  • Locating Invalid Data
 
Introducing Pivot Tables
  • Creating a Pivot Table
  • Extracting Data from a Pivot Table
  • Pivot Calculations
  • Sorting,Grouping & Filtering Pivot Data
  • Pivot Chart Reports
 
More on Charts
  • Modifying Charts
  • Adding Chart Elements
  • Formatting Charts
  • Sparklines
  • Creating Projections with Trendlines
  • Creating Combination Charts
  • Custom Chart Templates
 
Automating Spreadsheets with Macros
  • Recording & Running Macros
  • Deleting a Macro
  • Editing Macros
  • Macro Virus Protection