Course Contents

· Introduction

·Referencing in Formulas

·Name Range

·Understanding Logical Functions

·Getting started with Conditional Formatting

·Advanced-level Validation

·Important Formulas in Excel

·Working with Dynamic table

·Data Sorting

·Data Filtering

·Chart Creation

·Various Techniques of Charting

·Pivot Tables in Excel

·Ensuring Data and File Security

·Getting started with VBA Macros

·Core concepts of VBA

·Ranges and Worksheet in VBA

·IF condition

·Loops in VBA

·Debugging in VBA

·Messaging in VBA

·Practical Projects in VBA

·Best Practices of Dashboards Visualization

·Principles of Charting

·Getting started with Pivot Tables

·Creating Dashboards

·Creation of Interactive Components

·Data Analysis

What you will learn

  • earn the basic and advanced concepts of MS Excel

  • Deploy functions, formulae and logical functions

  • Use the sorting and filtering on Excel spreadsheet data

  • Learn about Excel charting principles

  • Learn about data quality issues

  • Use Pivot Table for explaining advanced options

  • Learn about advanced functions like DSUM and DMAX

  • Use VBA Editor for editing Macros

  • Work on practical VBA projects

Course Description

  • MS Excel reigns supreme when it comes to business tool usage in the industry. Employees with this skill are required from small companies to big International companies. Knowledge of Excel is required from entry level staff to Senior Managers across industries. It is an essential tool in every job.

Why This Course

  • This training program is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

  • This course will help you  to improve your spreadsheets. Understand VLOOKUP functions, IF functions, analyse data with PivotTables.

  • The basic package for Microsoft Excel skills is Rs 354,974 per year. Experience strongly influences salary for this job.

About The Course

  • Excel is one of the most used software applications of all time. This course is designed for the users those who want to perform accurate and rapid calculations with results ranging from simple calculation to complex financial analyses. Advanced MS Excel Course helps you to structure and present your data impressively

FAQ

What if You miss a  class?

You can access recording video of to your missed class on our website.

Can i attend a demo class before enrollment?

You can view our live-demo  session recordings always.

Who should go for this Training?

This training of qwikmind is suited for all the professional which will be provided by trained IT professional.

What if I have more queries?

Write to us at contact@qwikmind.com with your query and we will get back to you soon.

Prerequisite for the course

  • A basic understanding of Mainframe system is helpful.There is no need for any prior knowledge to take this Training Course.

ADVANCED EXCEL TRAINING

 
 
 
 
 
 

Copyright © 2017 QwikMind - All Rights Reserved.