Microsoft Excel Advanced (Level 3) 2003 2007 2010
Sponsored links
ADVANCED MICROSOFT EXCEL – from Base2
– 2 days
This course will introduce some of the more advanced features of
Microsoft Excel.
Attendees should have a good working knowledge of Microsoft Excel
and be comfortable with arithmetic.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
1 Data Functions
• Text Functions
• Logical Functions
• HLOOKUP/VLOOKUP
• Error Functions
2 Handling Worksheets
• Working with multiple sheets
• Inserting / Deleting / Renaming
• Moving / Copying
3 Formatting and Validation
• Custom Number Formats
• Conditional Formatting
• Data Validation & Cell Protection
• Hiding Cell Entries
4 Using Lists
• Advanced Sorting & Data Filtering
• Pivot Tables
• Database Functions
5 More about Worksheets
• Worksheet Auditing
• Using Views
• Scenarios & Report Manager
• Designing Data Entry Forms
6 Advanced Charting
• Understanding a Data Series
• Chart Options
• Types of Chart – Doughnuts, Radar, Surface & Bubble
• Advanced Formatting
7 Customising the Environment
• Setting Options
• Creating Custom Toolbars
• Using Styles
• Automatic / Manual Range Names
• User-Defined Templates
8 Data Analysis
• Absolute, Relative & Mixed References
• Formulas between Worksheets & Workbooks
• Data Tables
• Using Goal Seek and Solver
9 Exchanging Information
• Using Import & Export Wizards
10 Simple Macros
• Recording a Macro
• Running a Macro
• Editing a Macro
This Training Course is taught in classrooms in the following locations:
Newcastle
Sunderland
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
