Courses / Microsoft Excel Advanced

Microsoft Excel Advanced

Course logo

Target: More experienced users of Excel
Entry requirements: Delegates should already be using Microsoft Excel
Outcome: After completing this course delegates will be able undertake more complex tasks within Microsoft Excel.
Content: Custom Formatting
Custom Number Format
Custom Date Format Codes
Using Conditional Formats

Working with Named Ranges
Creating Range Names
Using the Go To Command
Range Names in calculations

Importing and Exporting Data
Object Linking and Embedding
Sharing Data with Other Applications
Importing a Text File into Excel

Lookups and Data Tables
Creating Data Tables
Using the LOOKUP Function
Using the VLOOKUP Function
Using the HLOOKUP Function
Preventing LOOKUP Errors

Templates
Creating Workbook Templates
Custom Templates
Storing Templates

Analytical Tools
Using Goal Seek and Solver
Working with Scenarios
Using Views

Using Pivot Tables
Creating Pivot Tables
Formatting Pivot Tables
Rearranging Pivot Tables
Working with Pivot Charts

Using Views and Creating Reports
Creating Custom Views
Creating a Workspace File
Using Workspace Files
Using the Report Manager
Printing Reports

Using Macros
Understanding Macros
Recording a Basic Macro
Running a Macro
Assigning a Macro to a Toolbar
Button Image Editor
Editing a Macro
Macro Virus Protection
Cost: Training rates are available on request
Enrolment: .
Website: www.corazonit.com

Starts: All training is delivered on clients site and can be either one to one or in groups.
Duration: Up to 1 day
Timetable: By mutual agreement
Provider: Corazon Training

Main (View map) 146 Woodbridge Road
IPSWICH
Suffolk
IP4 2NS
UNITED KINGDOM

Telephone 01473 219593 m: 07702911223

Fax 01473 219593

Email info@corazonit.com

Website http://www.corazonIT.com

Venue Notes At Client's site:

Contact Elene Marsden

There are currently no ratings for this course.

You need to be logged in before you can give a rating and comment on this course.

The information on this website is gathered from third parties and responsibility cannot be accepted on their behalf.

Where we have signposted to 'Informal Learning' we can not guarantee that all details/links are fully current.

To get full access to the Courses, Forums, and even add your own courses on the site please register with Suffolk TAP.