|
Provided by: Pitman Training Centre London Excel Training - Expert LevelExcel |
 |
Training
Provided by Pitman Training Centre London
Study at the Microsoft IT Academy that won the silver award for "Best Learning Centre" at the National IT Training Awards.
For those who wish to learn advanced Excel spreadsheet skills to the Microsoft Office Specialist (MOS) Expert syllabus.
Available at our High Holborn and Notting Hill training centres.
Visit www.holborntraining.co.uk for more information.
For those who wish to learn advanced Excel spreadsheet skills to the Microsoft Office Specialist (MOS) Expert syllabus.
Available at our High Holborn and Notting Hill training centres.
Visit www.holborntraining.co.uk for more information.
|
|
||||||||||||||
Excel Training - Expert Level
Importing and exporting data. Object linking and embedding. Importing data from web files. Using templates. Creating and applying custom templates. Editing and storing templates. Using multiple workbooks. Linking workbooks. Linking workbooks. Creating and using workspace files. Formatting numbers. Using custom formats. Using conditional formats. Printing workbooks. Grouping worksheets. Printing multiple workbooks. Using the report manager. Working with named ranges. Moving and deleting a named range. Range names in calculations. Adding and removing toolbar buttons. Creating toolbars. Working with Toolbars. Customising toolbars. Adding & removing buttons. Creating a new toolbar. Creating customised menus. Using Macros. Recording macros. Running and editing macros. Assigning a macro to a toolbar or menu. Auditing a worksheet. Data entry validation. Auditing data dependency. Showing cells containing ERROR values.: Working with data lists. Filtering lists and using custom filters. Form option buttons. Criteria option buttons. Data management. Searching for data with advanced filters. Summarising data with outlines. Querying a database. Controlling formatting and layout. Refreshing external data. Pivot tables. Creating pivot tables. Modifying and grouping pivot tables. Creating Interactive Pivot tables for the web. Using Analysis Tools. Goal seeking. Using Solver. Scenario Manager. Workgroups. Applying worksheets protection. Password protecting a file. Adding comments to the worksheet. Working with shared workbooks. Merging workbooks. Tracking changes and resolving conflicts.
About The Training Provider: Pitman Training Centre London
Pitman Training Centre London - We are Pitman Training London (High Holborn and Notting Hill), silver award winners of the "Best Learning Centre" category in the National IT Training Awards. We're also a Microsoft IT Academy We provide executive pa courses, legal secretarial courses, medical secretary training, secretarial skills, touch typing,shorthand, bookkeeping and Sage courses, payroll training, courses in Word, Excel,...
