Wednesday, March 10, 2010                           
You are here :     Home
XL Advanced 2007
Thursday 11 February 2010, 9:30 AM to 4:30 PM Confirmed Skillnet Technical Training Event
  New Horizons

 

ITAG Ref:  T110210
 
Cost Details
Gross Cost per person:  €60
Net Cost per person after rebate:  €45
 
Concepts and Functionality
 
Working with Excel Workbooks
  • The Excel Screen
  • View Options
  • Splitting Worksheet
  • Hiding Worksheets, Columns and Rows
  • Save Options
  •  
Functions in Excel
  • Sumif, Countif, Conditional IF statement, worksheet subtotal, vlookup / hlookup
 
Printing
  • Print Options
  • Page Setup
 
Advanced Formatting
  • Paste special
  • Conditional formatting
 
Sorting and filtering data
 
Subtotals
 
Pivot Tables
 
Data Validation
 
Advanced Chart Editing
 
Auditing and error management
 
Working with multiple sheets and workbooks
 
Scenario Manager
 
Macros
 
 

 



 
       Return 
Custom web site and software development by Gaelstorm Software Solutions, Galway, Ireland - the experts in IT for knowledge networks and online business network management.
 Copyright © 2005-2009 Information Technology Association of Galway   |  Privacy Statement  |  Terms Of Use