Excel Intermediate To Expert

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.

Delivery:	Other
Regions:	North West England London
Category:	Advanced Microsoft Excel