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
- Formatting Numbers
- Using Custom Formats
- Custom Number Format
- Sections
- Custom Number Format Codes
- 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 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 sheets
- 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 Working with Toolbars
- Displaying Hidden Toolbars
- Floating and Docking Toolbars
- Customising Toolbars
- Creating a New Toolbar 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 Creating Map Charts
- Creating Data Map Charts
- Editing a Map Chart Excel and the Internet
- Creating Hyperlinks
- Saving a Worksheet as a Web Page
- Web Page Preview
- Sending Worksheets and Workbooks Via E-mail
Course outlines are for guidance only as training is provided on a consultancy basis to ensure relevant work related issues are covered. - Formatting Numbers
- Cost
- Training rates are available on request
- Enrolment
- .
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
Courses
Syndicate
