Training Home | Business Applications | Microsoft Excel 2007 Training DVD
Microsoft Excel 2007 Training DVD

Learn how to take your skills to the next level. This Microsoft Excel 2007 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. The Tutorial comes complete with practical working files and presented via an intuitive, easy-to-use interface, This Microsoft Excel 2007 tutorial video makes learning simple, quick and enjoyable. All training courses are authored by certified professional instructors who have a passion for teaching.
Self Paced, Affordable Training Videos - Tutorials Taught by Professionals
- 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.
For evaluation purposes the links below offer an insight into the quality of these Microsoft Excel 2007 tutorials. In order for the demo videos to play QuickTime needs to be installed.
Just Released
With Free Working Files!
OVER 164 LESSONS - ONLY $99.95
We are pleased to announce that we have just released our Amazing Final Cut Pro training videos. This highly intuitive and engaging training course is only $99.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »Customer Testimonials
Introduction
1. Getting Started
2. Setting Up Excel 2007
- What's on the Ribbon?
- Making your way around the Ribbon
- Customizing the Ribbon
- Customizing the Microsoft Office Button
3. Modifying Worksheets
- Opening old worksheets
- Adding and deleting worksheets
- Inserting and deleting cells
- Freezing areas of a worksheet
4. Basic Formatting
- Width and height
- Numeric formats
- Alignment of data
- Playing with fonts
- AutoFilter
- Formatting as a table
5. Advanced Formatting
- Removing duplicates
- What is Conditional Formatting?
- Working with Conditional Formatting
- Managing Conditional Formatting rule preferences
- Converting text to columns
- Data validation
6. Using Templates, Styles, and AutoFormat
- Templates
- Styles
- AutoFormat
7. Managing Lists in Excel
- Excel lists have now become tables
- Converting text to columns
- Sorting and Grouping
- Creating a summary report
8. Reviewing Worksheets
- Proofing your work
- Providing comments on worksheets
9. Sharing Worksheets
- Protecting and sharing a worksheet
- Allowing others to edit ranges
- Track Changes
10. Printing Workbooks
- Preparing to print
- Print Preview
- The Page Layout Tab
- Page Breaks
- The Page Layout View
- Headers and Footers
11. Enhancing Worksheets
- Adding themes to your worksheet
- Page setup options
- Scale to Fit
- Worksheet options
- Inserting images
12. Using Templates
- Using templates
13. Manipulating the Screen Display
- Workbook Views
- Hiding and Zooming
- Window Panes
- More screen options
14. Importing Data
- Importing from Access
- Using the Import Wizard for text files
15. Finding and Replacing Data
- The Find and Select button
- Find and Replace
- Removing duplicates
16. Working with Formulas
- What are formulas?
- Order of Operations
- Relative and absolute referencing
- The new Formula Tab
17. Working with Basic Functions
- What are Functions?
- AutoSum
- Minimum
- Trim
- Left
18. Working with Advanced Functions
- Concatenation
- SumIf
- Lookup
- What-If Analysis
19. Charts
- Why create a chart?
- Creating your chart
- Modifying your chart
- Laying out your chart
20. Pivot Tables
- What are PivotTable reports and PivotChart reports?
- Creating a PivotTable
- Laying out your PivotTable
- Designing your PivotTable
- Creating a PivotChart
21. Working with Macros
- Why use macros?
- Creating a macro
- Macro security
22. Workflow in Excel 2007
- Reviewing a workflow in Excel
Conclusion
- Conclusion
Excel 2007 Training Info
Title Information.
Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. This Excel 2007 Training Video on DVD , introduces the new version in detail. The training begins with the essentials of using Excel, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. The tutorials then move on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.. Close »
| Publisher: | lynda.com, Inc. |
| Duration: | 5.25 hours - 85 lessons |
| Platform: | PC or Mac |
| Fomat : | Video CD |
| Price: | ![]() |
$99.95 | ![]() |
£65.47 | ![]() |
€73.36 |
Select your delivery option
Microsoft Excel 2007 Related Training Videos :
Crystal Reports 2008 Training | WordPress Training | Microsoft Project 2007 Training DVD | Excel 2007: Advanced Formulas and Functions | Excel 2007: Intro to Formulas & Functions | Excel 2007: Pivot Tables for Data Analysis
Just Released Training Titles
AutoCAD 2010 Training
Learning Final Cut Pro 7
Microsoft Windows 7
Adobe Photoshop Elements 8 Training [Windows]
Crystal Reports 2008 Training
Learning Final Cut Pro 7
Microsoft Windows 7
Adobe Photoshop Elements 8 Training [Windows]
Crystal Reports 2008 Training
Learn Online - Instant 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.
Join our Newsletter and Save
By joining our newsletter you will be notified of special offers and limited promotions. We don't sell, rent or otherwise disclose your details to any 3rd party. Sign up today and take advantage.
Customer Comments
This website is vital. I get excited everyday when I get to sit down and watch tutorials. I'm taking notes and learning all over again. I love it. Please keep this going. It's a perfect example of the use of technology for our own benefit. Cheers.
robert m.
robert m.
Outlook | PowerPoint | Excel | Word | Training Videos Home | Latest Releases | Downloadable Training | Online Video Tutorials | Training Courses on DVD | Site Map
Infinite Skills Inc
T: 858-866-9147.
Email :
Infinite Skills Inc
T: 858-866-9147.
Email :





emily g.