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

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, Cork, Limerick, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and internationally.

Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.

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 E-mail 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
  • Nested IF
  • Shortcut to view all formulaes
  • Auditing Toolbar
Data & Form
  • Data & Form
  • Using the Form to search for records
  • Adding records using the Form
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
Scenarios
  • Creating Scenarios
  • Shortcuts to viewing scenarios
Views
  • Hiding Rows
  • Create Views
  • Shortcut to view “Different Views”
Toolbars
  • Creating Personal Toolbar
  • Deleting Toolbar
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 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
Website Designed by Inspire IT Web Design & SEO Specialists All right reserved Inspire IT 2011
Click here to go back to the homepage