Microsoft Excel Advanced (Level 3) 2003 2007 2010
Sponsored links
ADVANCED MICROSOFT EXCEL – from Base2
– 1 day
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.
