BarCharts : QuickStudy:
EXCEL 2003 ADVANCED
Get the most out of your Excel 2003 software with our QuickTrain Computer-Based Training. With over 10 hours of step-by-step training, QuickTrain will train you on the ins and outs of the Excel 2003 software. To make sure you are learning the information, you will find interactive post tests after each section.
You will learn:
Macros & Tool Bars
• working with macros
• customizing toolbars
Named Ranges & Lookup
• working with named ranges
• lookup functions
Data Formats, Validation & Outlining
• importing data
• custom & conditional formats
• data validation
• outlining
Workspaces & Consolidation
• creating a workspace
• consolidating data
• linking workbooks
Sharing Worksheets
• share & protect worksheets
• working with comments
• tracking changes
Auditing, Scenarios & Reports
• auditing tools
• the scenario manager
• custom views
Data, Sorting, Goals & Pivot Tables
• data forms
• filtering data
• sorting & sub-totals
• goal seeker & solver
• pivot tables
• pivot tables on the web
