Microsoft Excel 2016 Advanced

1 module


Course Length
196 mins

Francis Dalton



Maximise your productivity with the advanced features of Excel

Microsoft Excel 2016 provides users with far more than software for organising their data. In fact, this iteration of Microsoft's spreadsheet software allows users to truly take their data management and analysis to the next level. After completing this comprehensive Microsoft Excel 2016 eLearning platform, users will be proficient with the advanced techniques that put the basic Excel functions into overdrive.

Price: €49+ local tax (vat 23% €61) - Access for 365 days









Working with Functions





Using Statistical Functions



Calculating Loan Payments



Calculating Present Value



Calculating Loan Payoff



Calculating Interest Rate



Calculating Principle & Interest



Work with Logical Functions



Work with Text Functions



Work with Ranges



Using Date and Time Functions



Controlling Automatic Calculations 



Copying Formula Values


IF, VLOOKUP, and Power Functions





Testing Conditions with IF



Using IF functions with relational operators



Using the IFS function






Getting approximate table data with VLOOKUP



Getting exact table data with VLOOKUP



Using INDEX/MATCH functions



Using the COUNTIF family of functions


Data Analysis Tools





Using Goal Seek



Using Solver



Using Scenario Manager



Using data tables


Data Management Features





Sorting data



Using filters



Splitting data into multiple columns



Using Flash Fill



Removing duplicate records



Using validation tools


Working with Lists





Query Data with Database Functions



Outline and Subtotal Data


Pivot Tables





Creating PivotTables



Manipulating PivotTable data



Grouping by date and time



Grouping by other factors



Using slicers to clarify and manipulate fields



Using PivotCharts


Introduction to Macros





Understanding and creating Macros



Running and editing a macro


Security and Sharing





Unlocking cells and protecting worksheets



Protecting workbooks



Assigning passwords to workbooks



Sharing workbooks



Tracking changes





Excel 2016 Advanced
{{ vm.helper.t('reports.module') }}


The material on this website and the courses/publications provided are educational in nature. Learning and skill development takes time, so you should progress slowly to achieve the best results. Professional advice is essential when using any material of a financial education nature as the material cannot be specific to your unique situation. 

We have used all reasonable effort to ensure the information on this site is as accurate as possible. However we provide no warranty or guarantee that information and materials provided are accurate, complete or current.

The material on this website is provided “as is.” Secarata Ltd. disclaims any warranties, expressed or implied, regarding its accuracy or reliability, and assumes no responsibility for errors or omissions. We accept no liability for any injuries or damages caused by acting upon or using the content contained in the course material.


Refunds will only be granted in extenuating circumstances and at the sole discretion of the Directors. Once a course is commenced no refunds will be issued.

Course Access 

Students will have access to online content once the full payment is made. Normally courses are available for 12 months however for some discounted courses the period may be reduced to 90 or 180 days.

For most courses access is immediate on payment, however for our Professional Programmes and for courses paid by instalments it may take 12-48 hours.

In the case of Professional Membership, which is paid monthly, access is cancelled if membership is either cancel or unpaid for a period.  

If you have any queries please contact us at  or +353 (0)83 152 6813 

Shopping Cart

Your cart is empty