Microsoft Excel 2016 Advanced

Content
1 module

Difficulty
Intermediate

Course Length
196 mins

Instructor
Francis Dalton

Price
€49.00

Description

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

Objectives

Welcome

 

Introduction

 

 

Overview

 

Working with Functions

 

Overview

 

 

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

 

Overview

 

 

Testing Conditions with IF

 

 

Using IF functions with relational operators

 

 

Using the IFS function

 

 

Using VLOOKUP

 

 

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

 

Overview

 

 

Using Goal Seek

 

 

Using Solver

 

 

Using Scenario Manager

 

 

Using data tables

 

Data Management Features

 

Overview

 

 

Sorting data

 

 

Using filters

 

 

Splitting data into multiple columns

 

 

Using Flash Fill

 

 

Removing duplicate records

 

 

Using validation tools

 

Working with Lists

 

Overview

 

 

Query Data with Database Functions

 

 

Outline and Subtotal Data

 

Pivot Tables

 

Overview

 

 

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

 

Overview

 

 

Understanding and creating Macros

 

 

Running and editing a macro

 

Security and Sharing

 

Overview

 

 

Unlocking cells and protecting worksheets

 

 

Protecting workbooks

 

 

Assigning passwords to workbooks

 

 

Sharing workbooks

 

 

Tracking changes

 

 

Conclusion

 

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

Disclaimer


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

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 fran.dalton@gmail.com  or +353 (0)83 152 6813 

Shopping Cart

Your cart is empty