Advanced MS Excel 2016 Certification Training

Sale!

Advanced MS Excel 2016 Certification Training

Excel has become one of the prerequisites for almost all jobs in the analytics and consulting sector. Through this course, you’ll learn the advanced functions that are used by analysts on a day to day basis. You’ll also get accustomed to even more advanced stages of excel use like Macros which further come handy. Throughout the course, you’ll be given hands-on assignments and case-studies to put the theoretical knowledge to practical.

$207.00

Online self paced classes

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You’ll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Overview of Advanced MS Excel 2016

Learning Objectives: In this module, you will get introduced to new features in MS Excel 2016. It also discusses advanced MS Excel 2016 concepts.

Topics:

  • Introduction to new features in MS Excel 2016
  • Familiarization to Advanced MS Excel 2016 concepts

Hands-On:

  • Hands-on on basic excel functions to get you started
  • How to access shortcuts in excel

Custom and Conditional Formatting

Learning Objectives: In this module, you will learn about custom and conditional formatting. This module covers topics on customizing Quick Access Toolbar. It also explains various conditional formatting available in MS Excel 2016.

Topics:

  • Customizing Quick Access Toolbar
  • Application of Conditional Formatting

Hands-On:

  • Customizing Quick Access Toolbar
  • Conditional Formatting

Advance Functions and Formulas

Learning Objectives: In this module, you will learn how to apply advanced functions and formulas. This module covers topics on advanced logical, text, lookup and reference functions. It also discusses how to trace errors and evaluate formulas.

Topics:

  • Logical Functions
  • Text Functions
  • Lookup and Reference Functions
  • Formula Auditing
  • Randbetween
  • Name Ranges and application

Hands-On:

  • Using logical functions, lookups in excel

Advanced Data Tools

Learning Objectives: In this module, you will learn how to work with advanced data tools. This module covers topics on advanced data tools like converting text to columns and data validation. It also discusses how to implement what-if tools.

Topics:

  • Text to Column
  • Data Validation
  • What-If Analysis
  • Duplicate Removal
  • Data Sanitation through excel – Sorting, Filtering

Hands-On:

  • Data Validation through excel using the given assignment

Data Analysis

Learning Objectives: In this module, you will learn how to use pivot tables and charts to analyze data. This module covers topics on pivot tables, pivot chart, sparklines. It also demonstrates the application of advanced filters.

Topics:

  • Data analysis using normal charts, formatting of charts, secondary axis use, scatter plots
  • Data analysis using a Pivot table and pivot charts, sparklines
  • Running Regression in excel, ANOVA, etc.
  • Cover basic stats through excel – Functions like correlation, stddev, average, regression functions

Hands-On:

  • Data analysis through excel using Pivots, charts, regression

Introduction to Macros

Learning Objectives: In this module, you will be introduced to recording and using Macros. This module covers topics on how to record and run Macros. It also discusses how to edit Marcos.

Topics:

  • Introduction to Macros
  • Record Macros
  • Run Macros
  • Edit Macros

Hands-On:

  • Recording, editing and running Macros

Data Security

Learning Objectives: In this module, you will learn how to restrict and protect your data. This module covers topics on protecting cells, sheets, and workbooks. It also discusses how to assign edit range function.

Topics:

  • Protect Cells
  • Protect Sheet
  • Protect Workbook
  • Protect Ranges

Hands-On:

  • Protecting cells, sheets, workbook and ranges on the workbook created in Module 7

Working with Advanced Excel 2016

Learning Objectives: This is a training module to get you ready for the certification project

Topics:

  • Perform and implement advanced tools and techniques in Excel 2016

About the Advanced Excel course

Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Logical functions, Formula Auditing, Data validation, What-if Analysis, Pivot tables, Pivot charts, Advanced Filters, Sparklines, Macros, and Data Security.

What are the objectives of this Advanced Excel course?

After the completion of this training, you will be able to:

  • Learn new features in MS Excel 2016 and implement advanced excel concepts
  • Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
  • Apply advanced functions and formulas to enhance Excel’s productivity
  • Perform What-if analysis command to experiment with data
  • Apply data validation to restrict data input
  • Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
  • Use Macros to automate routine tasks in Excel
  • Integrate passwords to protect Excel files
  • Use Excel shortcuts wherever applicable

Why Learn Advanced Excel?

Advanced MS Excel 2016 Course will help you master your Excel skills and kick it up a notch. This course is designed to equip you with skills to create and work on MS Excel capabilities like:

  • New features of 2016 to help you optimize the platform to the best of its ability
  • Master advanced functions and formulas to perform calculations, data tools to manipulate data, and use Macros to automate routine tasks in Excel
  • Use advanced charts, graphs, and Pivot tables to perform advanced data analysis
  • Provide data protection solution using data security capabilities

Who Should go for this Course?

The following professionals can take up this VBA in Excel course:

  • Data Analyst
  • Financial Analyst
  • Advanced Excel User
  • Fresher seeking jobs in Analytics/Consulting job streams

What are the pre-requisites for this Advanced Excel course?

There are no prerequisites for this course. However, a basic understanding of Microsoft Excel will be supportive.

What if I miss a class?

You will never miss a lecture at CertAddda You can choose either of the two options: View the recorded session of the class available in your LMS or You can attend the missed session, in any other live batch.

What if I have queries after I complete this course?

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Will I get placement assistance?

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the “create your resume” option.