Online Training Home | Microsoft Excel 2007 Adv - Online Training
Advanced Microsoft Excel 2007 Training DVD
These Advanced Microsoft Excel 2007 training course represents a mile-stone in quality content delivery and affordability.
For an amazingly low price you can have immediate, unlimited access to not only this Advanced Microsoft Excel 2007 training course, but also a fantastic array of other related titles, all in high definition video, and all for a unbelievable low price. All tutorials come with working files and are presented in a user friendly interface which allows you to search, book-mark and control the pace at which you learn.
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 Advanced Microsoft Excel 2007 tutorials. In order for the demo videos to play QuickTime needs to be installed.-
Product Trailer
- Windows Media Player
-
Free Demo Tutorial 1
- Quicktime »
Windows Media Player »
-
Free Demo Tutorial 2
- Quicktime »
Windows Media Player »
Try before you buy. We're so confident that you're going to love our online training courses, that we're giving you a FREE 7-day guest pass. 
SUMMARIZING DATA
- Advanced Subtotals
- Formatting the Subtotal Rows
- Adding and Copying with Subtotals
- Consolidating Data
- Introducing the SUMIF Command
- Working with the SUMIF Command
- Using Array Formulas
- Looking at AutoSum Tricks
- Utilizing Fill Handle Tricks
WORKING WITH PIVOT TABLES
- Creating a Pivot Table
- Rearranging Fields in a Pivot Table
- Explaining the Report Layout Options
- Using the Report Filters Feature
- Using Top 10 & Date Filters
- Handling Blank Cells
- Drilling Down in the Pivot Table
- Sorting a Pivot Table
- Formatting a Pivot Table
- Creating Custom Formats
- Explaining the Grouping Options
- Adding Formulas to a Pivot Table
- Changing a Calculation in a Pivot Table
- Replicating a Pivot Table
- Counting with a Pivot Table
- Using Pivot Charts
CHARTING IN EXCEL
- Charts Refresher
- Moving, Sizing & Copying Charts
- Formatting Charts
- Formatting a Series
- Exploring the Home & Format Ribbons
- Deciding What Chart Format to Use
- Show a Time Series with Column or Line Charts
- Using Combination Charts
- Using Line Chart Accessories
- Using Bar Charts to Show Comparisons
- Using Component Charts
- Using Correlation Charts
- Exploring Other Charts
- Chart Lies Revealed & Advanced Chart Types
- Creating a Custom Layout
GETTING VISUAL
- Using Conditional Formatting
- Using Advanced Conditional Formatting
- Highlighting, Sorting & Filtering Columns
- Using SmartArt Functions
- Using Different SmartArt Graphics
- Embedding a Formula into a Shape
CREATING POWERFUL FORMULAS
- Using Goal Seek to Find an Answer
- Auditing Formulas
- Shrinking the Formula Bar
- Understanding Errors
- Joining Text Columns
- Using Custom Formatting Codes
- Pasting Values
- Using Paste Special
- Breaking Apart Text
- Converting Text to Numbers
- Using Date Functions
- Using Bizarre Date Functions
- Using Exponents
- Using the VLOOKUP Function
- Using Index Match
- Using the Offset Function
- Using the Convert Function
- Looking at Interesting but Obscure Functions
- Using the Rand Function
- Working with Regression
- Ranking & Sorting Formulas
RECORDING MACROS
- Displaying the Developer Tab
- Recording a Simple Macro
- Simplifying the Macro
- Recording Using Relative References
TIPS & TRICKS
- Showing Off New Tips in Excel 2007
- Tips for Handling Worksheets
- Using Excel as a Word Processor
- Miscellaneous Tips
- Validating Data
- Changing Text Entry Direction
- Using Speak Cells
- Final Comments & Credits
Microsoft Excel 2007 Advanced
Title Information.
Now that you got your feet wet learning the new features in Microsoft Excel 2007 in the first video series, Total Training for Microsoft Excel 2007: Essentials, you're ready to dive into the advanced capabilities. While creating pivot tables and macros seems daunting, you'll be at ease learning some new techniques that will streamline your next data analysis project. Sit back and discover how to unleash the power of Excel with this in-depth video series. Close »
Format : ONLINE
Publisher : Total Training
Duration : 6 hours - 79 lessons
Platform : PC or Mac
Closed Captioning : No
This course is available in the following plans:
Unlimited Access: ALL Training Titles
Unlimited Access: Microsoft Library
Unlimited Access: ALL Training Titles
Unlimited Access: Microsoft Library
Advanced Microsoft Excel 2007 Related Training Videos :
Microsoft Access 2007 - Online Training | Microsoft Excel 2007- Online Training | Microsoft Office 2007 Getting Up to Speed | Microsoft Project 2007 Training DVD
Microsoft Access 2007 - Online Training | Microsoft Excel 2007- Online Training | Microsoft Office 2007 Getting Up to Speed | Microsoft Project 2007 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.
