Microsoft Excel Advanced

Microsoft Excel

Level: Advanced

Duration: 1 day

After completion of this course the delegates should have gained an extensive knowledge of Excel's capabilities

Intended Course Content

The following are suggested topics for this level of the package and it is not intended that every subject will be covered. The actual content can be decided prior to the day or after discussion with the delegates. It will be dependent upon the skill levels of each individual.

• Revision of previous topics
• Successful use of complicated pivot tables
• Advanced filters
• Creating templates
• Security - cell and sheet protection
• Advanced formatting - conditional formatting, data validation and use of comments
• Understanding the available options
• Scenarios, Solver and Goal Seek
• Custom Views
• The auditing tool bar
• Creating and using Lookups
• Exploring the available functions
• Creating a Macro and assigning it
• Importing and exporting information, including text to columns

Pre Learning Requirements

Delegates should already be familiar with Excel, either being self taught or having attended introductory and intermediate courses.