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
  15/11/2017 Bradford
  16/11/2017 Liverpool
  04/12/2017 Liverpool
  07/12/2017 Bradford
  22/01/2018 Bradford
  01/02/2018 Liverpool
  15/02/2018 Barnsley
  27/02/2018 Bradford
  13/03/2018 Bradford
  22/03/2018 Liverpool
  12/04/2018 Bradford
  26/04/2018 Barnsley
  02/05/2018 Bradford
  10/05/2018 Liverpool
  21/06/2018 Barnsley
  28/06/2018 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