About Advanced Excel Courses in Kolkata

With the rise of data, the demand for Advanced Excel Courses in Kolkata is growing both during job hunting and everyday applications. From finance to project management and human resources, having a strong knowledge of Microsoft Excel both at the basic and advanced levels opens the door to many job prospects. So, if you want to upgrade your skills in Excel to the advanced then you can join our course. The course is comprehensive and covers a wide range of topics.

Course Curriculum

Advanced Excel

Module 1 - Excel Introduction and Customization
- An overview of the screen, navigation and basic spreadsheet concepts
- Various selection techniques
- Shortcut Keys
- Customizing the Ribbon
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
Module 2 - Using Basic Functions and Formatting
- Using Functions – Sum, Average, Max,Min, Count, Counta
- Absolute, Mixed and Relative Referencing
- Custom and Special Formats
- Formatting Cells with Number formats,
- Font formats, Alignment, Borders, etc
- Basic conditional formatting
- SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
Module 3 - Protecting Excel and Text Functions
- File Level Protection
- Workbook, Worksheet Protection
- Upper, Lower, Proper
- Left, Mid, Right
- Trim, Len, Exact
- Concatenate
Module 4 - Advance Excel with Logical Functions
- Goal Seek
- Scenario Analysis
- Data Tables (PMT Function)
- Solver Tool
- If Function
- How to Fix Errors – if error
Module 5 - Data Validation
- Number, Date & Time Validation
- Text and List Validation
- Custom validations based on formula for a cell
- Dynamic Dropdown List Creation using
- Data Validation – Dependency List
Module 6 - Creating Pivot Tables
- Classic Pivot Table
- Filtering Pivot Tables
- Modifying Pivot Table Data
- Grouping based on numbers and dates
- Calculated Field & Calculated Items
- Arrays Functions

Advanced Excel

Highlights :

Enhance your Excel skills in advanced functions, formulas, pivot tables and data analysis. Learn how to automate data, create dashboards and study large datasets.

Why Choose Us?

Flexible fee structure
Qualified faculty
100% placement assistance

Who Can Take This Course?

Graduates / Freshers
Working IT professionals

Course Overview

The course will teach you concepts starting from the advanced level to top complex programming skills. You will also get to work on various projects to apply the concepts in various projects. So, enhance your productivity and become a more efficient professional.

Enquire Now

Available Job Opportunities After Doing This Course

Our Course

MIS Executive

They are responsible for planning and overseeing the organization’s information.

Project Coordinator

They organise and manage the budget, schedule and risks to ensure the success of the project.

Market Research Analyst

They are primarily responsible for conducting qualitative and quantitative research to identify and forecast sales trends.

Business Analyst

They analyze the business metrics and devise plans for operational improvement in the organization.

Management Consultant

They help solve issues, improve performance and maximise growth of the company.

Don’t miss out on the opportunity to learn advanced Excel skills and build your career. Enroll today!

Enquire Now

Certificates

Check Other Courses

Data Analytics Python (Core | Advanced) Data Science Data Engineering