About this Course

Microsoft® Excel® 2010 Expert teaches the information worker how to work with different types of documents using a variety of core and intermediate features to create and edit professional-looking spreadsheets for a variety of purposes and situations. Some topics may appear to be basic skill sets but are discussed in more detail, exploring at a higher level different options that can be chosen or applied for that skill set.

Course Prerequisites : 

This course assumes that students have completed the Microsoft Excel 2010 Specialist course or have equivalent Excel knowledge and experience. 

• Manage the worksheet environment 
  
• Create cell data 
• Format cells and worksheets 
  
• Manage worksheets and workbooks 
  
• Apply formulas and functions 
  
• Present data visually 
  
• Share worksheet data with other users 
  
• Analyze and organize data
  

Course Objectives :

This course book teaches the skills you will need to successfully complete the Excel 2010 Expert exam. Youwill use Excel to create and edit professional-looking spreadsheets for a variety of purposes and situations. Asyou begin to build your skills, you will then create a variety of workbooks as well as explore different ways toshare the information with internal and external customers. 

After completing this course, you will be able to: 

• customize chart elements 
  
• create and use sparklines 
  
• create trendline charts 
  
• create and apply chart templates 
  
• create a table and modify it 
  
• use dynamic charts 
  
• create, modify, and delete a workbook template 
  
• import from and export to XML data files 
  
• create XML schema and XML maps 
  
• create a shared workbook
  
• track and merge changes on shared workbooks 
  
• protect worksheets and workbooks 
  
• define what a function is 
  
• use the correct syntax for functions 
  
• insert and use various functions 
  
• convert data types 
  
• use the Error Checking Tool 
  
• trace formula errors 
  
• use the evaluate formula 
  
• set up a what-if scenario 
  
• use the Goal Seeking and Solver tools 
  
• create a data table 
  
• use the Analysis ToolPak 
  
• use array formulas 
  
• outline and group data 
  
• use advanced filtering 
  
• create and use PivotTables and PivotCharts 
  
• use the Slicer with a PivotTable 
  
• use cube functions 
  
• create and activate a macro
  
• edit a macro 
  
• add a macro to the Quick Access Toolbar 
  
• add form controls to a worksheet 
  
• display and edit form control properties 
  
• create and use data validation 
  
• create and use pick lists 
  
• circle invalid data 
  
• remove duplicate rows 
  
• set advanced Excel options

Duration : 3days / 22 hrs

Entry Requirement : Completed Microsoft Excel 2010 Specialist course or equivalent excel knowledge and experience.

Rate this course:

Log in to submit

Comments