|
Microsoft Office 2004 Excel Training for MAC Apple Computer
Office 2004 for Mac Standard Edition introduces new features designed to help you transform the way you manage information, share your ideas seamlessly, and create impressive documents with confidence. 
Features:
- Word notebook layout view: make meetings more productive by easily taking notes, searching and flagging relevant information, and recording audio directly into your documents.
- Project center: conveniently access e-mail messages, documents, contacts, and even audio and video from one central location.
- Excel Page Layout View: View and manipulate on your screen exactly what you will see on paper, including margins, headers, footers, and page count.
- Improved junk e-mail protection: Enjoy more freedom from unwanted e-mail messages than ever before. The junk e-mail filter removes messages before they get to your Inbox.
- PowerPoint Presenter Tools: You, and only you, will see which slide is up and which ones are on deck, while an on-screen clock maintains the perfect tempo.
Our Excel 2004 for Mac Office training is a course designed to increase your productivity. Business is crucially reliant on the skills of the employees, and using a computer correctly is
at its heart. Our training offers understanding of a powerful application that will not just compliment business needs, but give extra ability and knowledge to present results. Results
are important, as are the data that is put in for the simple concept of visibility. You will gain visibility in a way that helps organizations to make better decisions.
Our Training Features In Development
- Training done in Instructor Led full multi-media format
- Over 6 hours of training
- Covers Beginner to Advance Levels
- Available as single user DVD, Library License and Network Version
- Used by Thousands of Companies -
Library License- This licensing allows you to train an unlimited amount of users on a single computer or for the training to be kept at a single location and individuals would take the
training CDs to their individual computer or workstation to do their training. The Training CDs can not be loaded to a server, installed on the internet or intranet.
Microsoft Office 2004 Excel Training Content
Mac Office Excel 2004 Essentials: Beginner
- 1.0 The Excel Screen
1.1 Overview – Loading Microsoft Excel 2003
1.2 Screen Elements – Menu and Button Bars
1.3 Screen Elements – Workbook and Spreadsheet Properties
- 2.0 Creating Data and Content
2.1 Enter and edit cell content
2.2 Navigate to specific cell content
2.3 Locate, select and insert supporting information
2.4 Insert, position and size graphics
2.5 Saving, closing and opening files
- 3.0 Analyzing Data
3.1 Filter lists using AutoFilter
3.2 Sort lists
3.3 Insert and modify formulas
3.4 Create, modify, and position diagrams and charts based on worksheet data
- 4.0 Formatting Data and Content
4.1 Apply and modify cell formats
4.2 Apply and modify cell styles
4.3 Modify row and column formats
4.4 Format worksheets using AutoFormat
Mac Office Excel 2004 Essentials: Intermediate
- 1.0 Collaborating
1.1 Insert, view and edit comments
- 2.0 Managing Worksheets
2.1 Create new workbooks from templates
2.10 Save data in appropriate formats for different uses
2.2 Insert, delete and move cells
2.3 Create and modify hyperlinks
2.4 Organize worksheets
2.5 Organize workbooks using file folders
2.6 Preview data in other views
2.7 Setup pages for printing
2.8 Print data
2.9 Organize workbooks using file folders
- 3.0 Organizing and Analyzing Data
3.1 Use subtotals
3.2 Define and apply advanced filters
3.3 Group and outline data
3.4 Use data validation
3.5 Create and modify list ranges
3.6 Using statistical, date and time, financial, and logical functions
3.7 Add, show, close, edit, and summarize scenarios
3.8 Perform data analysis using automated tools
3.9 Create PivotTable and PivotChart reports
3.10 Use Lookup and Reference functions
3.11 Use Database functions
3.12 Trace formula precedents, dependents and errors, locate invalid data and formulas,
watch and evaluate formulas
3.13 Locate invalid data and formulas
3.14 Watch and evaluate forumlas
3.15 Define, modify and use named ranges
3.16 Structure workbooks using XML
Mac Office Excel 2004 Essentials: Advanced
- 1.0 Formatting Data and Content
1.1 Create and modify custom data formats
1.2 Use conditional formatting
1.3 Format and resize graphics
1.4 Format charts and diagrams
- 2.0 Collaborating
2.1 Protect cells, worksheets, and workbooks
2.2 Apply workbook security settings
2.3 Share workbooks
2.4 Merge workbooks
- 3.0 Managing Data and Workbooks
3.1 Import data to Excel
3.2 Export data from Excel
3.3 Publish and edit Web Worksheets and workbooks
3.4 Create and edit templates
3.5 Consolidate data
3.6 Define and modify workbook properties
- 4.0 Customizing Excel
4.1 Customize toolbars and menus
|
|
This Study guide and/or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA
™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc.
|
|
