NEWCASTLE COMPUTER TRAINING

Microsoft  Excel – Advanced (1 Day)

• Advanced Data Entry and Formatting Techniques

                        Restricting Cell Entries to Specific Numbers, Dates or Times

                        Restricting Cell Entries to Specific Entries in a List

                        Applying Custom Number Formats to Cell Entries

                        Applying Conditional Formatting to a Worksheet

• Naming Ranges

                        Defining Range Names

                        Navigating Using Range Names

                        Using Range Names in Formulas

• Lookup Functions

                        VLookup

                        HLookup

• Creating Excel Templates
• Auditing a Worksheet (Tracing Precedents, Dependents and Errors)
• Linking Multiple Workbooks (Files)
• Working With A Database

                        Sorting Records

                        Applying Custom Sorts

Totalling Database Entries

Filtering Records

Specifying Criteria Ranges in Filters

Using a Data Form to Enter Records

Querying an External Database

• Analysing Data

                        Pivot Table Reports

                        Pivot Chart Reports

                        Creating a Pivot Table or Chart for the Web

                        Using the Solver

                        Outlining a Worksheet

                        Goal Seek

• Importing and Exporting Data

                        Import Data from Other Applications into Excel

                        Importing a HTML Table into Excel

                        Exporting Excel Data into Other Applications

• Excel Workgroup Features

                        Tracking Changes in a Workbook

                        Inserting Comments

                        Accepting and Rejecting Tracked Changes

• Excel Security

Protecting a Shared Workbook

Protecting an Unshared Workbook

Locking and Unlocking Cells for Worksheet Protection

• Creating Macros in Excel

                        Recording a Macro

                        Running a Macro

                        Editing a Macro Using VBA