Further Details
What Is Covered.
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.
Guide price
£351.85 |
