• No products in the basket.


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).

Who is it for?

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

Course outline

This course is comprised of the following modules:

  • Module 01: Summarizing Data
  • Module 02: Working with Pivot Tables
  • Module 03: Charting in Excel
  • Module 04: Getting Visual
  • Module 05: Creating Powerful Formulas
  • Module 06: Recording Macros
  • Module 07: Tips & Tricks

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. 


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

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT. 

Career Path: 

This course could help you to pursue a career in any of the following industries:

  • Administration
  • Reception
  • Accounting
  • Bookkeeping
  • Business ownership
  • PA professionals

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.

Course Curriculum

Free Introduction
Excel 2007 Advanced FREE 00:00:00
1. Advanced Subtotals 00:00:00
2. Formatting the Subtotal Rows 00:00:00
3. Adding and Copying with Subtotals 00:00:00
4. Consolidating Data 00:00:00
5. Introducing the SUMIF Command 00:00:00
6. Working with the SUMIF Command 00:00:00
7. Using Array Formulas 00:00:00
8. Looking at AutoSum Tricks 00:00:00
9. Utilizing Fill Handle Tricks 00:00:00
1. Creating a Pivot Table 00:00:00
2. Rearranging Fields in a Pivot Table 00:00:00
3. Explaining the Report Layout Options 00:00:00
4. Using the Report Filters Feature 00:00:00
5. Using Top 10 & Date Filters 00:00:00
6. Handling Blank Cells 00:00:00
7. Drilling Down in the Pivot Table 00:00:00
8. Sorting a Pivot Table 00:00:00
9. Formatting a Pivot Table 00:00:00
10. Creating Custom Formats 00:00:00
11. Explaining the Grouping Options 00:00:00
12. Adding Formulas to a Pivot Table 00:00:00
13. Changing a Calculation in a Pivot Table 00:00:00
14. Replicating a Pivot Table 00:00:00
15. Counting with a Pivot Table 00:00:00
16. Using Pivot Charts 00:00:00
1. Charts Refresher 00:00:00
2. Moving, Sizing & Copying Charts 00:00:00
3. Formatting Charts 00:00:00
4. Formatting a Series 00:00:00
5. Exploring the Home & Format Ribbons 00:00:00
6. Deciding What Chart Format to Use 00:00:00
7. Show a Time Series with Column or Line Charts 00:00:00
8. Using Combination Charts 00:00:00
9. Using Line Chart Accessories 00:00:00
10. Using Bar Charts to Show Comparisons 00:00:00
11. Using Component Charts 00:00:00
12. Using Correlation Charts 00:00:00
13. Exploring Other Charts 00:00:00
14. Chart Lies Revealed & Advanced Chart Types 00:00:00
15. Creating a Custom Layout 00:00:00
1. Using Conditional Formatting 00:00:00
2. Using Advanced Conditional Formatting 00:00:00
3. Highlighting, Sorting & Filtering Columns 00:00:00
4. Using SmartArt Functions 00:00:00
5. Using Different SmartArt Graphics 00:00:00
6. Embedding a Formula into a Shape 00:00:00
1. Using Goal Seek to Find an Answer 00:00:00
2. Auditing Formulas 00:00:00
3. Shrinking the Formula Bar 00:00:00
4. Understanding Errors 00:00:00
5. Joining Text Columns 00:00:00
6. Using Custom Formatting Codes 00:00:00
7. Pasting Values 00:00:00
10. Using Paste Special 00:00:00
9. Breaking Apart Text 00:00:00
10. Converting Text to Numbers 00:00:00
11. Using Date Functions 00:00:00
12. Using Bizarre Date Functions 00:00:00
13. Using Exponents 00:00:00
14. Using the VLOOKUP Function 00:00:00
15. Using Index Match 00:00:00
16. Using the Offset Function 00:00:00
17. Using the Convert Function 00:00:00
18. Looking at Interesting but Obscure Functions 00:00:00
19. Using the Rand Function 00:00:00
20. Working with Regression 00:00:00
21. Ranking & Sorting Formulas 00:00:00
1. Displaying the Developer Tab 00:00:00
2. Recording a Simple Macro 00:00:00
3. Simplifying the Macro 00:00:00
4. Recording Using Relative References 00:00:00
1. Showing Off New Tips in Excel 2007 00:00:00
2. Tips for Handling Worksheets 00:00:00
3. Using Excel as a Word Processor 00:00:00
4. Miscellaneous Tips 00:00:00
5. Validating Data 00:00:00
6. Changing Text Entry Direction 00:00:00
7. Using Speak Cells 00:00:00
8. Final Comments & Credits 00:00:00

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.


    CPD Accredited




    Awarded by iAP

    Awarded by iAP

    CPD Accredited Partner

    CPD Accredited

    CPD Membership No: 10582

    Study independently accredited and recognised CPD courses. Gain your certification today.

    cvAll students enrolled with STUDY365 are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.

    cvIf you need career support STUDY365 is here for you. We provide excellent career support through our Career Support Service.

    NUS Extra Card

    NUS Extra Card

    Course Reviews

    • Office Skills, Secretarial & PA Training

      Office Skills, Secretarial & PA Training 2

      I regret doing this course- only a few units were actually useful! *A lot of it is just common sense *The units on Microsoft Word and Outlook were shown using the obsolete versions *Some of the videos were shot & edited very poorly *Some of the written tutorials were shoddy and seemed 'rushed' *A couple of videos were looped *I couldn't find the exercise files for at least one of the units (not at the end where they usually are) *The mock exams and final exam had questions on things that weren't even in the course! All I got from this course is an idea of what I need to work on and how NOT to do it.
      Sally Eastman
    • Adult Nursing & Social Care Training

      Adult Nursing & Social Care Training 4

      Learnt how to work in a practical sense with those who really need you after taking this course.
      Emma Hanks

    Address: Study365, 406 White Horse Lane, London E1 3FY
    Phone: 0203 874 9355​
    Email: support@study365.co.uk

    Certificate Code

    Secure Payment