Excel
Microsoft Excel 2003 Certification
Live Online Training with Live Tutors
Our Excel 2003 gives you the comprehensive tools to create spreadsheets and share them on the Web for universal viewing and collaboration. You'll be able to easily analyse data with charts, Microsoft PivotTable views and graphs. And, use automatic formatting to create data-rich spreadsheets. Our interactive series will show you how to utilize all of the tools contained within the most popular spreadsheet program on the market!
Learning / Exam module: Excel 2003
Course Duration: 20 hrs.
Learning Segments:
Course Introduction
Entering and Editing Data
Data Entry Tools
Using Office Tools
Inserting Graphics
Using the AutoFilter Tool
Data Sorting Tools
Inserting Formulas
Using Advanced Functions
Formatting Cells
Row and Column Styles
Applying Templates
Editing and Moving Cell Content
Working with Worksheets
Links and Hyperlinks
Arrange Window Layout
Print Page Setup
Using Print Preview
Summary
Manipulating and Analyzing Data
Using Advanced Filters
Data Validation Tools
Creating and Modifying Lists
Using Scenarios
Automated Data Analysis Tools
Using Goal Seek
Automated Data Analysis Tools
Using Solver
Setup PivotTables
Reference Functions
Working with Database Functions
Error Tracking Tools
Setting Up Named Ranges
Working with Data Formats
Conditional Formatting
Summary
Displaying and Sharing Data
Pivot Charts
Collaboration Tools
Protection Features
Tracking Changes
Managing Changes
Importing and Exporting Data
Consolidating Data
Publishing to the Web
Working with XML Data
Customizing Excel
Create and Edit Macros
Summary
Testimonials
“I’m pleased to tell you that I have passed both A+ exams to day. Your online training and exam prep material did a great job in preparing me to pass!”
Neil Bottomley, Poole, Dorset.
“Great news guys, I passed my ICND part 2 exam. I am now CCNA. You guys have helped to keep me motivated and keep on going even when things were looking really tough.”
Dave Cooper
“15 months ago I was made redundant from a bus company. Now I have a new career as a Microsoft Systems Administrator earning £35,000 a year. I have got LiveTrain Learning to thank for providing me with the learning materials and support to start in an entirely new career direction”
Trevor Linch MCSE, Winchester, Kent
“The quality of the training materials is very impressive and they provide a lot more than just the paper based courseware you would normally get for spending twice as much with other companies. I find the video lectures and demonstrations very informative. Most of all I like the fact that I get lots of hands on practice!”
Irene Vincent, Worthing, Sussex
“We used to send our staff away to learn Microsoft Office at £400 per day; we can now provide each staff member with the same instructor-led style training on site for a fraction of that price”
Sue Herbert, Personnel Manager, Datalink
“This course is very well presented. The instructor is clear and concise, provides a wealth of knowledge and explains the real world applications. The CEH course is definitely for anyone who is serious about Computer Security. I would recommend this course to anyone presently doing programming who wishes to get a better understanding of the different classes of a hacker and the procedures in which a "cracker" (Black Hat Hacker) goes through to gain access into any system. I am enjoying going through this course-- and I am going to complete it ahead of time!”
Paul Turnbull, Manchester