This advanced Microsoft Excel training course will teach you to use the advanced features ofExcel in any version to their full extent. By the end of this course, you will be able to reporton data in a list using PivotTables, edit and analyze complex data using advanced featuressuch as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet,work with controls and record macros.
This course will extend your knowledge into some of the more specialized and advancedcapabilities of Excel by automating some common tasks, applying advanced analysis techniquesto more complex data sets, collaborating on worksheets with others, and sharingExcel data with other applications.

• Before attending this course, students must have:Excel Intermediate or equivalent experience.
• Create, edit and format spreadsheets Navigate within worksheets and books
• Work with absolute references
• Create Tables within Excel
• Sort and filter data

• Create macros to automate common tasks
• Use form controls Collaborate with others by merging and tracking workbooks
• Use advanced techniques to analyse data
• Create and manipulate PivotTables and PivotCharts
• Import and export data Create Power Views
• Learn to use the advanced features of Excel to their full extent.
• Protect your data from deletions or changes

• Getting started
• Entering and Editing Data
• Modifying a Worksheet        
• Formatting              
• Charts                   
• Graphics
• Functions 
• Common Functions
  • Sum Function
  • Average Function
  • Max Function
  • Min FunctioN
  • Count Function
  • The Counta Function
  • The Countblank Function
• Time & Date Functions
• Mathematical Functions
• Logical Functions
  • If Function
  • And Function
  • Or Function
• Mathematical Functions
  • Sumif Function
  • Average if function
• Statistical Functions
  • Count Function
  •  Counta Function
  • Countif Function
  • Countblank Function
  • Rank Function
• Text Functions
  • Left Function
  • Right Function
  • Mid Function
  • Trim Function
  • Concatenate Function
• Financial Functions
  • Fv Function
  • Pv Function
  • Npv Function
  • Rate Function
  • Pmt Function
• Hyperlinks
• Linking & Embedding 
• Managing Workbooks and Worksheets     
• Advanced Formatting              
• Outlining and Subtotals                        
• Cell and Range Names                       
• Data Structure and Tables                 
• Web and Sharing Features                 
• Documenting and Auditing                 
• Application Settings and Templates
• Advanced Functions and Formulas      
• Lookups and Data Tables
• Using lookup functions
• Creating data tables                        
• Advanced Data Management
• Validating cell entries
• Advanced filtering                      
• Advanced Charting 
• Chart formatting options
• Combination charts
• Graphical objects                       
• PivotTables and PivotCharts 
  • Working with PivotTables
  • Modifying PivotTable data
  • Formatting PivotTables 
  • Using PivotCharts
  • PowerPivot                         
• Exporting and Importing data                        
• Analytical Tools
• Goal Seek
• Scenarios
• Auditing
• Macros
• Passwords & Security Issues
• Priniting