|
Provided by: Pitman Training Centre London Excel Training - Expert LevelExcel |
 |
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.
|
|
||||||||||||
Training
Provided by Pitman Training Centre London
- M asked: How do I sign up for the class?
- asked: I want to take the course how is it run?
- S asked: how to create user define macros. Pls provide some example for the same.
- A asked: Is your course available on dvd for purchase? Thanks, Florida, USA
- L asked: How much does this course cost?
- M asked: We provide training services to corporate clients in Pakistan. Some of our clients have expressed the need for MS Office related training as well as other interpersonal / soft skills. If you are interested in joining hands with to market your e-learning solutions, do reply back to us ASAP. Regards, Business Development Executive
- G asked: I need to know what I can do with the advanced course. I am working as a Statistician and using a program called SPSS. I would like to know how the advanced course in Excel will compare with certain statitical functions Ionly know how to do in more statitical programs. Also how extensive is the advanced course in programming (VBA)
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,...
