|
IMPORTING AND EXPORTING DATA
|
 top
|
Shows users how to import data from Excel to other applications, query a database application to extract data, and export data from other applications into Excel.
TOPICS
COVERED
Importing Data Using the Text Import Wizard
Importing Text by Other Methods
Importing Data from an Application or File
Querying a Database
Exporting Data to an Application
|
WORKING WITH TEMPLATES, LINKS AND REPORT MANAGER
|
top
|
Shows users how to create, apply, and edit templates; use a workspace; link workbooks; preview and print worksheets; and use the Report Manager.
TOPICS
COVERED
Working with Templates
Using a Workspace and Linking Workbooks
Previewing, Printing, and Report Manager
|
FORMATTING, SORTING AND FILTERING DATA |
top
|
Shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.
TOPICS
COVERED
Formatting Numbers
Using and Applying Conditional Formats
Sorting and Grouping Data
Using a Data Form
Using a Data Filter
|
NAMING RANGES, WORKING WITH MACROS AND
CUSTOMISING TOOLBARS |
top
|
Shows users how to add and delete a named range and use a named range in a formula; use the HLOOKUP and VLOOKUP functions; record, run, and edit a macro, assign a macro to a toolbar button; and hide, display, and customize toolbars.
TOPICS
COVERED
Adding, Using and Deleting a Named Range
Using Lookup Functions
Recording and Running a Macro
Editing a Macro
Working with Toolbars
|
VALIDATING AND AUDITING DATA |
top
|
Shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.
TOPICS
COVERED
Validating Data
Using the Auditing Toolbar
Tracing Precedents and Dependents
|
ANALYSING DATA AND USING PIVOTTABLES |
top
|
Shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts.
TOPICS
COVERED
Using Goal Seek
Using Solver
Working with Scenarios
Using Data Analysis and PivotTables
Using PivotTables and PivotCharts
Using a PivotTable with the Web
|
SHARING WORK AND ADDING SECURITY |
top
|
Shows users how to add comments to cells, change workbook properties, apply and remove worksheet and workbook protection and file passwords, track changes, create a shared workbook, and merge workbooks.
TOPICS
COVERED
Working with Comments and Properties
Adding Security
Tracking Changes
Sharing Work
only £50.00
(approx $88 USD)
|
