Excel 2000 Advanced

This course is designed to give users an understanding of some of the more advanced features and functions within Excel and the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in using advanced features of Excel 2000 to manage, automate and customize workbooks. This Excel 2000 course also instructs users in Year 2000 best practice.

Target audience

Users with a basic understanding of Excel 2000 who want to consolidate and expand on their knowledge of the basic features in a short space of time. A good working knowledge of Excel, plus Windows 95/98/NT/2000 is assumed, gained from the workplace or by prior attendance on an "Excel 2000 Intermediate" course.

Course content

Excel 2000 Advanced Year 2000 Best Practice . Review exercise

Custom formatting Formatting numbers . Using custom formats . Custom number format sections . Custom number format codes . Custom date format codes . Formatting SpeedKeys . Using conditional formats

Working with named ranges Creating range names . Using the Go To command . Range names in calculations

Importing and exporting data Using Paste Special . Object linking and embedding . Sharing data with other applications . Importing a text file into Excel . Importing data from Web pages

Templates and Add-Ins Creating workbook templates . Custom templates . Storing templates . The default template . Loading Add-in programs

Working with multiple workbooks Creating custom views . Creating a workspace file . Using workspace files . Linking workbooks . Creating formulae to link data

Printing workbooks and reports Printing multiple worksheets . Printing multiple workbooks . Using the Report Manager

Lookup and reference functions Using the LOOKUP function . Using the VLOOKUP function . Using the HLOOKUP function . Preventing LOOKUP errors • Conditional statistical formulas

Working with Toolbars Displaying hidden Toolbars . Floating and docking Toolbars . Customising Toolbars . Creating a new Toolbar

Using Macros Understanding Macros . Recording a basic Macro . Relative references . Running a Macro . Assigning a Macro to a Toolbar . Button Image Editor . Editing a Macro . Macro virus protection

Creating map charts Creating data map charts . Editing a map chart . Adding features to a map

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today