Find Courses Find Providers Providers - Promote Your Courses About Us

Excel Expert For Advanced Users

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

If you are already a sophisticated user of Microsoft Excel you will love this course as it opns up new horizons for you. In 14 lessons taking approximately 20 hours of study, you will learn: Lesson One: Importing and exporting data. Object linking and embedding. Importing data from web files. Lesson Two: Using templates. Creating and applying custom templates. Editing and storing templates. Lesson Three: Using multiple workbooks. Linking workbooks. Linking workbooks. Creating and using workspace files. Lesson Four: Formatting numbers. Using custom formats. Using conditional formats. Lesson Five: Printing workbooks. Grouping worksheets. Printing multiple workbooks. Using the report manager. Lesson Six: Working with named ranges. Moving and deleting a named range. Range names in calculations. Adding and removing toolbar buttons. Creating toolbars. Lesson Seven: Working with Toolbars. Customising toolbars. Adding & removing buttons. Creating a new toolbar. Creating customised menus. Lesson Eight: Using Macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu. Lesson Nine: Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values. Lesson Ten: Working with data lists. Filtering lists and using custom filters. Form option buttons. Criteria option buttons. Lesson Eleven: Data management. Searching for data with advanced filters. Summarising data with outlines. Querying a database. Controlling formatting and layout. Refreshing external data. Lesson Twelve: Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating Interactive Pivot tables for the web. Lesson Thirteen: Using Analysis Tools. Goal seeking. Using Solver. Scenario Manager. Lesson Fourteen: Workgroups. Applying worksheets protection. Password protecting a file. Adding comments to the worksheet. Working with shared workbooks. Merging workbooks. Tracking changes and resolving conflicts.

Regions:
  • London
Delivery:
  • Computer Based
Category:
Difficulty:
  • Advanced

Further Details

We're now a Microsoft IT Academy! That means you can qualify for internationally recognised Microsoft certificates as well as Pitman Training qualifications. We offer a self-paced training environment with award winning tutor support, so you'll always have the confidence of knowing you're being looked after. In fact, we have recently won the award for "Best Pitman Training Centre!" You can start this course at any time and create your own flexible timetable so you can study when it suits you - great if you're already working! We're open from 09:00-18:00 on Mondays, Wednesdays and Fridays, from 09:00-20:00 on Tuesdays and Thursdays and from 10:00-16:00 on Saturdays, so it's really easy to fit your studies around your other commitments. You'll enjoy lots of tutor support at our training centre which is 1 minute from Notting Hill Gate tube.

Guide price

POA

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net