Home >> Training >> Courses Available
Oryx XL - excelling in IT support services
Other Microsoft Excel Training Courses:
Microsoft Excel. Introduction (1 day)
Microsoft Excel. Intermediate (1 day)
Microsoft Excel. Advanced (1 day) Download Microsoft Excel - Advanced PDF
Course Contents:
| 1: Dealing with large data lists Using Autofilter Using Subtotal function Using subtotals Using multiple subtotals |
4: Working with Databases Using Dsum Using Data Validation Using Sumif function |
| 2: Templates Creating templates Using templates Automating use of templates |
5: Pivot Tables Pivot Tables Pivot Table Example Pivot Table Toolbar |
| 3: Lookup and Input Table The Lookup Function Vlookup Hlookup |
6: Nested & Advanced Functions If Statements Goal Seek Advanced date calculations |
Other courses you may be interested in:
Microsoft Word. Introduction, Intermediate & Advanced (1 day each)
Microsoft Access. Introduction & Intermediate(2 Days)
