Courses / Microsoft Excel Advanced
Microsoft Excel Advanced
- Provider
- Corazon Training
- Summary
- 1 day advanced course on Microsoft Excel.
About the Course
- 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
- Custom Number Format
- Cost
- Training rates are available on request
- Enrolment
- .
- Website
- www.corazonit.com
Availability
- 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
Venues/Contact
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





