Microsoft Excel 2007: Advanced

0( 0 REVIEWS )
Overview Sit back and discover how to unleash the power of Excel with this in-depth video series, Total Training for …


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.

The Advanced course in Microsoft Excel 2007 will build on your beginner and intermediate level skills and knowledge, making you an expert on the subject. You will explore many key topics through the course such as how to analyse data, manage data, learn advanced functions, apply conditional filter and formatting and create and manipulate PivotCharts. Qualifying in this course will give you the opportunity to work in multiple sectors and industries. Excel is an application that is in-demand and if you have a thorough knowledge of it, you can use it effectively in the workplace impacting your performance and efficiency in your job.

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?
  • Course outline
  • Course Duration: 
  • Method of Assessment:
  • Certification:
  • Entry Requirement:
  • Career Path: 
  • Presenter Information:
  • Job seekers
  • Graduates
  • Administrators
  • PA professionals
  • Accountants
  • Bookkeepers
  • Business Owners

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

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.

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 the course. 

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

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

Once you successfully complete the Microsoft Excel 2007: Advanced course, you will gain a recognised qualification that will prove your expertise in Excel to potential employers and organisations. You can use this certification to gain entry to exciting career opportunities across a wide spectrum of industries.

The video tutorial series will help you to be more creative and unleash the power of MS Excel effectively. This course is an excellent training opportunity for those who are hoping to master Excel since you can learn the new advanced techniques of the tool and analyse the data successfully. A career with bright prospects await you with the completion of this course. According to, some of the key job positions along with the average UK salary per annum you can go for after completing this course will be as follows.

  • Administrator - £17,477 per annum
  • Receptionist - £16,297 per annum
  • Bookkeeper - £20,786 per annum
  • Small Business Owner - £24,297 per annum
  • Administrative Assistant - £16,876 per annum
  • Personal Assistant - £25,144 per annum
  • Accounts Administrator - £18,669 per annum
  • Accountant - £28,571 per annum
  • Accounts Assistant - £18,876 per annum
  • Junior Accountant - £17,750 per annum

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

Students feedback


Average rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

WhatsApp chat