Training Home | Business Applications | Microsoft Excel 2008 for Mac Training DVD
Microsoft Excel 2008 for Mac Training DVD
Take your skills to the next level. This Microsoft Excel 2008 for Mac training DVD is the ultimate in comprehensive learning for the discerning professional.
The training uses broadcast quality audio and video to deliver concise and informative training right to your desktop. Complete with practical working files and presented via an intuitive, easy-to-use interface, These Microsoft Excel 2008 for Mac tutorials make learning simple, quick and enjoyable. All training courses are authored by certified professional instructors who have a passion for teaching.
Training Benefits - Learn from the Pros
- Reduce learning time by 80%. Learn from a professional trainer from your own desk.
- Visual training method, offering users increased retention and accelerated learning.
- Breaks even the most complex applications down into simplistic steps, ideal for users who learn faster when shown.
Table of contents : see below. - Try a Free Demo
For evaluation purposes the links below offer an insight into the quality of these Microsoft Excel 2008 for Mac tutorials. In order for the demo videos to play QuickTime needs to be installed.Introduction
1. Getting Started with Excel
2. Using Workbooks
- Creating and opening workbooks
- Importing workbooks
- Saving workbooks
- Using Undo and Redo
- Sheets vs. pages
3. Working with Sheets and Cells
- Adding and removing sheets
- Copying and moving sheets
- Renaming and hiding sheets
- Selecting sheets and their components
- Cell basics
- Auto-filling cells
- Restricting input with validation rules
- Quick and easy functions
- Manipulating cells
- Working with rows and columns
- Sorting and filtering
4. Formatting Workbooks
- Using pre-defined ledger sheets
- Using AutoFormat
- Conditional formatting
- Working with styles
- Creating, renaming, and selecting styles
- Applying themes
- Creating and deleting themes
- Using headers and footers
5. Using Formulas and Functions in Excel
- Using basic formulas and functions
- Using the Formula Builder
- Understanding cell references
- Using common functions
- Joining text in cells with concatenation
- Using the SUMIF function
- Using the Lookup function
- Performing a Goal Seek analysis
6. Working with Charts
- Adding charts
- Modifying charts
- Adding data to a chart from multiple sheets
- Formatting general chart attributes
- Advanced chart formatting
7. Working with Text
- Adding and removing text
- Formatting text
- Using the Format Painter
- Using special characters
- Using hyperlinks
8. Reviewing Your Work
- Splitting and freezing rows and columns
- AutoCorrect options
- Checking spelling
- Other reference tools
- Find and Replace
9. Working with Objects
- Inserting text boxes
- Copying with text boxes
- Modifying text in a text box
- Creating bulleted and numbered lists in a text box
- Working with shapes
- Adding and adjusting images
- Adding SmartArt graphics
- Adding WordArt
- Adding video
- Aligning and layering objects
10. Exploring Excel PivotTables
- What are PivotTable reports?
- Creating a PivotTable report
- Manipulating your PivotTable report
11. Sharing Your Spreadsheets
- Printing a sheet
- Exporting to other formats
- Protecting a workbook
- More protection and tracking changes
- Sending a spreadsheet with comments via email
12. Creating Custom Templates
- Creating a template
- Modifying a template
- Adding a template to the Elements Gallery
Microsoft Excel 2008 Training Video Conclusion
- Goodbye
Excel 2008 for Mac Training Essentials
Title Information.
From customizing the interface to producing professional reports, this Microsoft Excel 2008 for Mac Training Video fully explores the intricacies of working with this information management software. Using real-world examples, this Excel training video explains how to manipulate workbooks; use formulas and functions; perform goal-seeking analyses; layout and present text and charts; use basic templates; and create custom Excel templates, themes, and layouts. Exercise files accompany the tutorials. Close »
Format : DVD
Price : $99.95 | £49.95 | €64.95
Publisher : lynda.com, Inc.
Duration : 8.5 Hours - 73 lessons
Platform : PC or Mac
Closed Captioning : Yes
Microsoft Excel 2008 for Mac Related Training Videos :
Microsoft Entourage 2008 for Mac Training DVD | Microsoft PowerPoint 2008 for Mac Training DVD | Microsoft Word 2008 for Mac Training DVD
Microsoft Entourage 2008 for Mac Training DVD | Microsoft PowerPoint 2008 for Mac Training DVD | Microsoft Word 2008 for Mac Training DVD
Learn Online - Unlimited Access - Low Price
Giving you amazing freedom to learn at your own pace these online training videos combine high quality professionally created content, broadcast standard high definition video and crystal clear audio, at an extremely cost effective price. The tutorials are presented via an easy to use interface.
You can now access an entire library of professionally created tutorials in High Definition video for the same price as our competitors charge from one DVD.
Users are bound by no constants on the amount of titles that can be viewed, access can be from any location and where available, working files are included at no extra charge.
Comprehensive list of all Online Training Courses included in the online service.
CREATE A TEST ACCOUNT
Sample the quality of this online training with a free online test account. You will have immediate access to the first 20 minutes of all the tutorials in the online learning library.
