·Referencing in Formulas
·Understanding Logical Functions
·Getting started with Conditional Formatting
·Important Formulas in Excel
·Working with Dynamic table
·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
·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
·Creation of Interactive Components
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
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
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 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.