Training Home | Business Applications | Excel 2007: Advanced Formulas and Functions

Excel 2007: Advanced Formulas and Functions Training DVD

Learn how to take your skills to the next level. This Excel 2007: Advanced Formulas and Functions 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 Excel 2007: Advanced Formulas and Functions 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 Excel 2007: Advanced Formulas and Functions tutorials. In order for the demo videos to play QuickTime needs to be installed.

This Weeks Limited Offer

25% off AutoCAD Videos

OVER 9 hours of Video Training - ONLY $74.95

We are pleased to announce that we have just released our Amazing AutoCAD training videos. This highly intuitive and engaging training course is only $74.95, which is amazing value. To try a free demo just follow the link below. To try for FREE Click Here »

Customer Testimonials

Mordy Golding and Garrick Chow are really exceptional instructors. They are knowledgeable but don't ever talk over my head. They come off as friendly, very professional and experts in their fields. I really enjoyed their videos and feel like I learned a lot. I look forward to purchasing books or other tutorials that they host.
carol g.

Introduction

Welcome
Using the exercise files

1. Formula and Function Tips/Shortcuts

Using the entire row/column references
Copying column formulas instantly
Converting formulas to values with a simple drag
Creating 3D formulas to gather data from multiple sheets
Updating values without formulas
Showing all formulas with a single command
Highlighting formulas with two clicks
Simplifying debugging formulas
Creating range names to enhance readability

2. Excel Functions

Understanding and using basic Excel functions
Using common functions: SUM, AVERAGE, MAX, and MIN
Using and extending AutoSum

3. IF and Related Functions

Exploring IF logical tests and using relational operators
Creating and expanding the use of nested IFs
Using the AND, OR, and NOT functions with IF to create compound logical tests

4. Lookup and Reference Functions

Looking up information with VLOOKUP and HLOOKUP
Using VLOOKUP for approximate matches
Using VLOOKUP for exact matches
Nesting Lookup functions
Finding table-like information within a function with CHOOSE
Locating data with MATCH
Retrieving information by location with INDEX
Using MATCH and INDEX together

5. Power Functions

Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF
Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS

6. Statistical Functions

Finding the middle value with MEDIAN
Ranking data without sorting with RANK
Finding the magnitude data with LARGE and SMALL
Tabulating blank cells with COUNTBLANK

7. Date Functions

Understanding Excel date/time capabilities in formulas
Identifying the day of the week with WEEKDAY
Counting working days with NETWORKDAYS
Determining a completion date with WORKDAY
Tabulating date/time differences with DATEDIF

8. Math Functions

Working with rounding functions
Finding the remainder with MOD
Building random number generators with RAND and RANDBETWEEN
Converting a value between measurement systems with CONVERT

9. Array Formulas and Functions

Extending formula capabilities with Arrays
Counting unique entries in a range with an Array formula
Determining frequency distributions with FREQUENCY
Flipping row/column orientation with TRANSPOSE
Building analysis via regression techniques with TREND and GROWTH
Combining multiple functions in arrays

10. Text Functions

Locating and extracting data with FIND and MID
Extracting specific data with LEFT and RIGHT
Removing excess spaces with TRIM
Using CONCATENATE with functions
Adjusting case within cells with PROPER, UPPER, and LOWER
Adjusting character content with REPLACE and SUBSTITUTE
Reviewing additional text functions

11. Financial Functions

Calculating payments with PMT
Finding future values with FV
Determining total amount of future payments with PV

12. Information Functions

Working with the IS information functions
Using error-checking functions: ISERR, ISERROR, IFERROR
Getting data from remote cells with OFFSET
Returning references with INDIRECT

Conclusion

Goodbye

Excel 2007: Advanced Formulas and Functions Info

Title Information.

In Excel 2007: Advanced Formulas and Functions, author and trainer Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course.. Close »

Instructor : Dennis Taylor

All Training Courses by this author

Publisher:

lynda.com, Inc.

Duration:

5.25 hours - 61 lessons

Platform:

PC or Mac

Fomat :

Video CD

Price:

$49.95

£32.72

€36.66

Select your delivery option

Excel 2007: Advanced Formulas and Functions Related Training Videos :

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

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

I was a contract/freelance web designer struggling with the transition from table-based to CSS-only layouts. I was falling behind the curve, losing work and quickly becoming obsolete. After watching all of your CSS training videos, I was able to land my dream job at an award-winning web design agency here in Phoenix, AZ. THANK YOU!!
bobby d.