Microsoft Excel Advanced
Course
In Basildon
Description
-
Type
Workshop
-
Location
Basildon
-
Duration
1 Day
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. Suitable for: After completion of this course the delegates should have gained an extensive knowledge of Excel's capabilities
Important information
Documents
- Microsoft Excel Advanced Flyer
Facilities
Location
Start date
Start date
About this course
Delegates should already be familiar with Excel, either being self taught or having attended introductory and intermediate courses
Reviews
Course programme
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.
Microsoft Excel Advanced