Excel Intermediate To Expert
Sponsored links
Aimed at proficient users of Microsoft Excel, the leading spreadsheet, this is the higher level of our two Excel courses, designed to take you to an advanced, expert level in only 25 study hours at our comfortable Pitman Training centres in High Holborn or Notting Hill.
We operate a flexi-study system where you can start when you like and study at hours to suit you. We're open from 09:00-20:00 Monday to Thursday, 09:00-16:30 on Fridays and 10:00-16:00 on Saturdays.
Visit www.holborntraining.co.uk for more information.
| Delivery: |
|
| Category: |
In 14 lessons, 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.