Microsoft Excel 2007: Advanced

Overview

Sit back and discover how to unleash the power of Excel with this in-depth video series, Total Training for Microsoft Excel 2007: Advanced. 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.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professional learning material, all delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

Course Curriculum

1: Summarizing Data

2: Working With Pivot Tables

3: Charting In Excel

4: Getting Visual

5: Creating Powerful Formulas

6: Recording Macros

7: Tips & Tricks

Who is it for?

• Job seekers
• Graduates
• Administrators
• PA professionals
• Accountants
• Bookkeepers
• Business Owners

Course Duration: 

From the day you purchase the course, you will have 12 months access to the online study platform. As the course is self-paced you can decide how fast or slow the training goes, and are able to complete the course in stages, revisiting the training at any time.

Method of Assessment:

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed. 

Certification:

Successful candidates will be awarded a certificate for Excel 2007: Advanced.

Presenter Information:

Bill Jelen is the host of MrExcel.com and the author of sixteen books about Microsoft® Excel® including Special Edition Using Excel 2007, Excel 2007 Miracles Made Easy, Pivot Table Data Crunching for Excel 2007, VBA & Macros for Microsoft Excel, Excel for Marketing Managers and Guerilla Data Analysis Using Microsoft Excel. He has made over 50 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.

His daily video podcast “Learn Excel from MrExcel” is a top 50 tech video podcast on iTunes. Bill will entertain you while showing you the powerful tricks in Excel.

Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world. Jelen joins us from Akron, Ohio.