IT Training >
Microsoft Office >
Excel
Excel 2010 - Advanced
Handling the important basic functions. Nesting functions. Using the powerful analysis tools. Creating automated templates with Excel.
Course Description
Description
- The New interface Office Fluent
- Increased general capacity
- Review tips & tricks to optimize calculation operations
- Manipulating categories of functions
- Automating worksheets by using Formulas and Functions
- Introduction to databases
- Simple analysis tools
- Analyzing data by using Pivot tables
- Creating customized charts
- Working with templates
- Recording macros
- Tips and tricks
- Exercises
Prerequisites
Having a basic knowledge of Excel (Formulas, functions).
Who Should Attend this course ?
This course is addressed to good basic users, who wish to learn Excel furthermore in fields such as accountability, finances or science
