Inspire IT deliver IT Training in the Microsoft Suite throughout Ireland. We also deliver training in Web Design
Advanced Excel 2007

Advanced Excel training course outline which includes Pivot Tables, macrosCourse Objectives:

Our Microsoft Advanced Excel training course will improve efficiency and productivity in the work place with the use of advanced features such as Pivot Tables, Short Cuts, Filters, Macro's and scenarios. This course is aimed at the everyday user. We will look at functions such as IF, Vlookup and Nested IF's.

 

 

Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.

We will travel onsite anywhere in Ireland

Prior to to course we will discuss your requirements and develop the course content to suit your needs.

  • All participants receive handouts and course files of the course content if they want to review the information at a later date.
  • 6 months FREE Support after course.
  • Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.
  • We deliver one to one training

For more information please E-mail our Senior Trainer Alan Joyce at info@inspiresit.ie or contact him at 085 1055651 or Skype inspireitweb

 

Navigation & Data input

  • Quick Navigation of spreadsheets
  • Accurate selection of large amounts of data
  • Shortcut Keys
  • Named Ranges, modifying & deleting
  • Custom Lists, creation & deleting
  • Using AutoFill to create numbered sequences

Functions: IF & VLookups

  • Absolute Addressing
  • Using the IF Function – Using the Paste Function
  • Using the Vlookup
  • Count IF and Count A
  • Sum IF
  • Nested IF
  • Shortcut to view all formulaes
  • Auditing Toolbar

Advanced Filter

  • Using the AutoFilter
  • Using the Advanced Filter
  • Filtering Results to another area of spreadsheet

Auditing Toolbar

  • Using the Auditing Toolbar
  • Tracing Precedents
  • Tracing Errors in Formulaes

Protection

  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting parts of a spreadsheet
  • Placing a password on the file

 

Goal Seek & Consolidation

  • Using the Goal Seek in Excel
  • Consolidating Data in a spreadsheet

Pivot Tables

  • Creating Pivot Tables
  • Modifying Pivot Tables
  • Formatting data within Pivot Tables
  • Refreshing data in a Pivot Table
  • Creating a Pivot Chart
  • Modifying a Pivot Chart
  • Grouping Pivot Table
  • Inserting Calculated Fields into a Pivot Table

Scenarios

  • Creating Scenarios
  • Shortcuts to viewing scenarios
Data Consilidation
  • Saving Workspaces
Import
  • Importing Data into Excel
  • Importing a Text file into Excel

Macros

  • Recording a Macro
  • Running a Macro
  • Assigning a Macro to a button in Toolbar
  • Assigning a Macro to a push button on spreadsheet
  • Editing & Deleting a Macro
  
  Back to Office 2007 courses>>    
HOME | MICROSOFT OFFICE | WEB DESIGN | ONE TO ONE | CONSULTANCY | TESTIMONIALS | ECDL | ECDL ADVANCED | BLOG | PROFILE SITEMAP
Contact Us: 085 1055651 E-mail: info@inspiresit.ie Skype: inspireitweb
Website Designed by Inspire IT Web Design & SEO Specialists All right reserved Inspire IT 2010
Click here to go back to the homepage