Course Description

Mastering Excel 2016 – Advanced

Study 365


Excel refers to a spreadsheet program which is available in the Microsoft Office package. The main features available in Excel are graphing tools, calculation and pivot tables. Excel has become the most widely used program by organizations among the other spreadsheet programs. Excel spreadsheets are mainly used by organizations to record expenses and income, organize lists, plan budgets, create multi-layered and interactive reports and many more. Excel can benefit individuals as well in planning and organizing their groceries, recording their income and expenditure and to calculate ROI value.

Almost all organizations has made it essential for employees and potential candidates to possess the necessary knowledge and skills related to Excel in order to perform the activities of an organization effectively. It will be even greater for your career if you could master the advanced features and skills related to Microsoft Excel. Therefore, this course is here to help you master the advanced features and skills of Microsoft Excel 2016. In order to enroll in this course, you need to possess the basic knowledge of Microsoft Excel or have a certificate in Microsoft Excel 2016 basics or intermediate. This course builds on your existing knowledge of Excel and teaches you how to use links, lookup functions, macros, data tables, and more.

Course Curriculum

1: Using Links And External References

2: Using 3d References

3: Consolidating Data

4: Using Lookup Functions, Part 1

5: Using Lookup Functions, Part 2

6: Tracing Precedent And Dependent Cells

7: Watching And Evaluating Formulas

8: Comments And Track Changes

9: Comparing And Merging Workbooks

10: Accessibility Checker

11: Protecting Worksheets And Workbooks

12: Applying Data Validation

13: Search For Invalid Data

14: Working With Macros, Part 1

15: Working With Macros, Part 2

16: Creating Sparklines

17: 3d Maps

18: Data Tables

19: Using Scenarios

20: Goal Seek

21: Forecasting Data Trends

22: Changing Your Display

23: Importing Delimited Text Files

24: Data Forms And Form Controls

25: Calculated Fields And Cube Functions

Why consider learning at study 365?

With so many commitments in our lives, we may not have the time to learn new skills. The beauty of studying online is that you get to find this balance between your education and your daily commitments

Study 365 offers hundreds of online courses to students across the world. Gaining new skills has never been this easy as many of our courses are open to students with little or no qualifications or previous experience. All the courses are up-to-date, relevant, affordable, and will build on existing expertise or give you a jump-start to a new career. The courses are meticulously designed and equals what is offered in a classroom setting. With a solid reputation that has established and made us made us one of the most trusted and reliable online course providers we offer the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in your chosen career. You can learn at your own pace at Study 365 and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules, interactive quizzes and free resources which include Free CV writing pack, free career support and course demo to make your learning experience enriching and more rewarding.

Learning outcomes

  • Using Scenarios and Goal Seek
  • Working with Macros
  • Tracing Precedent and Dependent Cells
  • Comparing and Merging Workbooks
  • Using 3D References
  • Using Data Forms and Form Controls

Access duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this course aimed at?

  • Students
  • Job seekers
  • Employees and employers
  • Anyone interested in mastering advanced Microsoft Excel 2016.

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 and awarding body

Those who successfully complete the course will be awarded the Mastering Excel 2016 – Advanced certificate by CPD & iAP. The qualification will make you valuable to employers, and your motivation at gaining new skills will be recognised.

Tutor info 

It doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally.

Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of the Association for Type International, and her certifications include:

  • Myers Briggs Type Indicator
  • Coaching Using Multiple Models
  • Global Corporate College (GCC)
  • Development Dimensions International (DDI)
  • Zig Ziglar
  • Achieve Global

Barbara  has over twenty-five years’ experience in training and public speaking with an emphasis in Career Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques that will advance their careers. Her educational and career pursuits have provided a diverse background for her to use in instructional design and in the classroom.  She draws from this experience to customize her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Customer Service, Management, and Leadership as well as software training.

Barbara lives in Greer, SC and is a published writer and the recipient of several writing awards, including a Pushcart Prize nomination. She writes for several blogs including two of her own and is an active member of South Carolina Writers Association and HubCity Writers.

Other benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only)

Course Code S 0767
College Name Study 365
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Online Learning
Course Qualification CPD
Course Location Athlone, Westmeath, Ireland
Course Fee 29
Course Duration 365 Days
Entry Requirements Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.
Career Path • Product management director – £82,701 per annum • Sales director – £62,303 per annum • Finance manager – £38,025 per annum • Systems administrator – £25,443 per annum
For information about Study 365, please visit our college page on by clicking here.

Course Provider

Study 365

New Broad Street House, 35 New Broad Street, London. EC2M 1NH, United Kingdom, Cavan, United Kingdom

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Study 365.

Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the community.


Study 365
New Broad Street House, 35 New Broad Street, London. EC2M 1NH, United Kingdom
Visit Website

Comments, Questions & Reviews

Submit A Comment, Question or Review About
Mastering Excel 2016 - Advanced
at Study 365

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy