There are two types of Microsoft Office users:
- User one uses Microsoft Office to get their work done, just because it''s there.
- User two - the power user - makes Microsoft Office purr like a finely-tuned roadster.
Wouldn''t you rather be the one making Office run so well, you get thrills from using it?
Microsoft Office instructor Chris Ward is a power user, and he wants to show you how you can be one too. In the Word, Excel, and PowerPoint videos, he walks you through each program and shows you how to use the features and functions like they''re meant to be used. He''s not just telling you what the features do - he''s showing you what you can do to make Office work better for you. It''s like having a friend sit beside you, showing you all the cool things you can do.
Here''s what you''ll learn in the videos:
Word 2003:
The Word 2003 videos teach you about mail merge, macros, indexing and cross-referencing documents, master documents and sub-documents, collaboration using Word, importing and linking data from Excel, protecting shared documents, creating and using forms, using tables, and inserting graphics, plus formatting and other common word-processing tasks.
The free video from the Word 2003 series teaches you how to use Master Documents and Sub-Documents to stay organized as you write long and complex documents, including business reports and even books.
Excel 2003:
The Excel 2003 videos cover data filtering and validation, macros, pivot tables, functions and formulas, managing workbooks, formatting for screen display and printing, collaboration using Excel, file management, data organization, sorting data, lists and their functions, creating charts and graphs, using solver and goal seek, and creating and using customized tools, plus fundamental data and content formatting.
The free video from the Excel 2003 series gives you a walkthrough introduction to Excel 2003, covering basic features including the menu and toolbar options available, plus spreadsheet fundamentals.
PowerPoint 2003:
The PowerPoint 2003 videos show you how to use templates and slide masters, online PowerPoint resources, spelling and grammar checking, multimedia content (including video, audio, images, charts, tables, and diagrams), linking-in objects from outside PowerPoint, animations within slides and transitions between slides, collaboration tools, and advanced formatting of slide contents. Plus, this series teaches you to apply what you''ve learned about PowerPoint to deliver presentations more effectively, covering both live and automated PowerPoint presentations.
This series has two free videos. The first free PowerPoint 2003 video gives you a walkthrough introduction to working in PowerPoint 2003. The second free PowerPoint 2003 video shows you how to create powerful PowerPoint presentations for live delivery.
Put Office skills on your resume and mean it
This series also maps to the exam objectives for Microsoft Office Specialist (MOS) certification on Word 2003, Excel 2003, and PowerPoint 2003. MOS certification proves to current and potential employers that you can create, modify, and manage documents and presentations in Word. When the ability to use Word productively is essential to your job, this credential signifies to employers that they can rely on you.
The only prerequisite is the willingness to try
It''s time to take off the gloves and really learn Office. This series provides you the hands-on instruction you need to do it. And the only thing you have to bring to the training is a willingness to try out all the cool skills and techniques demonstrated in the videos.
The MS Office 2003 Certification Package contains:
MOS Series: Word 2003
- Installing Microsoft Office 2003
- Workspace Area Fundamentals
- Entering Text and Symbols
- Editing Text and Spell/Grammar Check
- Automatic Features Part 1
- Automatic Features Part 2
- Utilizing Graphics Part 1
- Utilizing Graphics Part 2
- Diagrams and Charts
- Research Tools
- Formatting Text Part 1
- Formatting Text Part 2
- Formatting Paragraphs
- Formatting Tabs and Columns
- Formatting Pages Part 1
- Formatting Pages Part 2
- Organizing Content - Tables
- Organizing Content - Tables (Formatting)
- Organizing Content - Lists
- Managing and Printing Documents
- Organizing Documents - Table of Contents/Figures
- Organizing Documents - Indexing and Cross-Referencing
- Organizing Documents - Master Documents and SubDocuments (free video!)
- Collaboration Part 1
- Collaboration Part 2
- Mailings and Labels
- Using Tables and Calculations
- Advanced Features - Macros, Forms, and Linking Data
MOS Series: Excel 2003
- Installing Microsoft Office 2003
- Microsoft Excel 2003 Fundamentals (free video!)
- Content Fundamentals
- Data and Content Formatting: Cells
- Data and Content Formatting: Advanced Cells
- Data and Content Formatting: Rows and Columns
- Managing Workbooks
- Page Setup and Printing
- Basic Collaborating and File Management
- Research Capabilities
- Basic Formulas
- Organizing Data
- Functions Part 1
- Functions Part 2
- Functions Part 3
- Data Filtering
- Data Validation
- Lists and their Functions
- Charts and Graphs Part 1
- Charts and Graphs Part 2
- Using Solver
- Goal Seek
- Customized Tools
- Macros
- Collaboration Part 1
- Collaboration Part 2
- Pivot Tables
MOS Series: PowerPoint 2003
- Installing Microsoft Office 2003
- Work Area Fundamentals (free video!)
- Creating Presentations from Templates
- Formatting and Editing Text
- Spelling, Grammar, and Style Formatting
- Importing, Exporting, and Using Online Resources
- Adding Content Part 1 - Tables and Charts
- Adding Content Part 2 - Clip Art and Pictures
- Adding Content Part 3 - Shapes, Word Art, and Diagrams
- Adding Content Part 4 - Media Clips and Linked Objects
- Formatting Content - Advanced Text and Fonts
- Formatting Content - Shapes and Graphics
- Formatting Slides - Backgrounds and Orientation
- Formatting Slides - Animations and Transitions
- Formatting Slides - Slide Masters
- Collaboration
- Setup and Delivery
- Powerful PowerPoint Presentations - LIVE (free video!)
- Powerful PowerPoint Presentations - Recorded
All trademarks and copyrights are the property of their respective holders.