The only Advanced Excel Training Course you Need

Meant for Pros

Impress your boss with your data-driven advanced Excel skills and outperform others

Warning: Trying to access array offset on value of type bool in /home2/techns1s/public_html/wp-content/plugins/elementor/includes/base/widget-base.php on line 223

Warning: Undefined array key -1 in /home2/techns1s/public_html/wp-content/plugins/elementor/includes/base/controls-stack.php on line 695

FLAT 20% ON THE COURSE FREE

KNOW HOW

It pays to have friends!

Ask a colleague to join the course with you and GET 20% OFF - BOTH OF YOU.

Know More

20 Hours

Course Duration

Advanced

Take the Game to Next Level

Course Delivery

Classroom or Online

What You Will Learn

Advanced Excel Functions

Solve any query you like with these powerful functions

Advanced Pivots and Charts

Powerful utility to Calculate, Summarize, and Analyze Data and gain insights

Dashboards - Dynamic Graph

Become more open and Adaptable to change.

Advanced Excel Utilities

Excel add-in that fills the gaps and help you deliver more.

Before You Start

Prerequisites

Functional knowledge of Excel
This course is for Advanced users who want to take their game to next level.

Course Format

20 hr Course contains assignments on due dates but you can progress through the course at your own speed.

Course Overview

Target Audience – The target audience for this course are those who are functional users of Excel and who would want to take their game to next level.

Agenda of the Course – To make you a Advanced user of Excel

Practical examples along with some case study are shared with the learner, this helps a person to better visualize how thing will really work in their workplace environment.

Topics Covered

1) Advanced Functions

SUMIF, SUMIFS, SUMPRODUCT, DSUM , VLOOKUP, HLOOKUP
COUNTIF, COUNTIFS
IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
SEARCH, INDEX, MATCH ETC
Various other functions related to Date, Time, Text etc.

2) If Condition

When should use the “IF” Conditions?
Creation of Multiple IF Conditions in One Cell
Use the IF Conditions with the Other Advance Functions
How to use nested IF statements in Excel with AND, OR Functions

3) Advanced Excel Options

Various Methods of Filter and Advance Filter options
Creating and Updating Subtotals
Various Methods of Text to Column options
Uses of Data Grouping and Consolidation options
Various Method of Sorting Data, Conditional formatting
Creating, Formatting and Modifying Chart
Data Validation, Creating drop down lists using different data sources
Linking Workbooks and Uses of Edit Link options
Excel Options, Customizing the Quick Access Tool Bar
Introduction to new tools like Sparklines.
Formula Auditing features and Trace formula error

4) Pivots and Charts Explained

Various Methods and Options of Pivot Table
Using the Pivot Table Wizard
Changing the Pivot Table Layout
Subtotal and Grand total Options
Formatting
Grouping Items
Inserting Calculated Fields
Pivot Table Options
Calculation in Pivot Table
Display and Hide Data in Field
Select, Move & Clear Pivot Data
Creating and Modifying Pivot Chart

5) Excel Tips and Tricks

Some tips that will not only make your simple but also help you to be more productive. I

Don’t miss out on this enriching learning journey – join us at Techno Excel for a rewarding experience in mastering Advanced Excel Training in Hyderabad!

Know your Trainer

With nearly a decade of experience in this industry and training over 2000+ working professionals and delivering 100+ Corporate training – Ravi Saini is the founder of TechnoExcel. He’s been working on Microsoft Excel since a really long time as a user, a Developer, and a Trainer.

About TechnoExcel – Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential. We offer Corporate/Personal hands-on training on Data Science, Advanced Excel , Power BI, VBA – Macros and MS – Access. Sourcing only the highest rated trainers from UrbanPro (India’s No 1 Education Platform) we make sure to deliver that ROI you expect and create long-term positive change in your professional journey.’

Have a Question?

Today the most precious thing on the world is no more oil but data and here at TechnoExcel we try to leverage it and use it at its full potential.

Connect with Us

Sitemap

Excel Courses

Data Science Course

Personalized Services

Discount Program

Services

Contact

TechnoExcel

connect@technoexcel.in

8801912200

Above Allahabad Bank,

Lal Bahadur Colony,

Trimulgherry, Hyderabad