Advanced Excel Training in Bangalore

Advanced Excel Training in Bangalore targets to make the IT sectors task more easier and simpler.  Excel Next is the most populous firm in Bangalore for training people in Advanced Excel Course. We all know, Bangalore is known as the Silicon Valley mainly referred to as the IT Capital of India, it is very important for the employees to excel in the IT Sector and know the Advanced Excel Techniques. The structure and course curriculum of Advanced Excel Training in Bangalore, is designed in a way that it helps the employees to do all the calculations and visualization of the data at a fast pace.

Excel Next has been associated with many companies for providing the best Advanced Excel Training in Bangalore. Few of our reassuring clients are Exl Service, Flipkart, Wildcraft, PWC, Tata Motors and Consulates of Canada in Bangalore where we have provided Advanced Excel Training on Regular basis.

Our firm is also incorporated with the best excel VBA training in Bangalore which might be a great help for the employees belonging to the IT Sector. The Excel VBA and Macros training in Bangalore helps the people of Bangalore to automate their daily routine and tasks by making their own Macros. In case you wish to get a deeper insight about the coding of Macros and you’re keen to learn more about Excel VBA training, you can view our training curriculum here 

Excel Next is a team of such an amazing league of trainers who’ll help you make your daily complicated task look easier. Advanced Excel Training in Bangalore helps the employees to use such tools which maximizes the amount of time saved. The employees review the Advanced Excel Training in Bangalore saying it is one the finest Advanced Excel Training Firms in the city of Bangalore. Over the years the Employees have realized that these training methods have helped them to overcome the obstacles they were facing during the working hours. Advanced Excel Training tells you about using end no. of visualization tools and techniques that not only makes your work error free by give you accurate result and even saves the extra hours which employees invested in making their Worksheets and Presentations.

Our firm doesn’t just expertise in providing Advanced Excel or VBA training but is populous in giving PowerPoint Presentation Trainings as well in Bangalore. This is helpful for the people who wants to make their Presentations attractive and well defined by the add-on tools present in the PowerPoint Presentations. To be a part of the PowerPoint Training Program, check our course curriculum by clicking here

The Advanced Excel training in Bangalore targets to cover up these topics:

Day 1:  Module #1 to #6

Day 2:  Module #7 to #1

#1: Essential Shortcuts

Learning pre-requisites: Paste Special – Value

Aim: Work faster with effective shortcuts

Flow:

Data sets Navigation, Selection & Deletion
Show all formulas (Ctrl ~)
Inserting today’s date (Ctrl ;), current time (Ctrl Shift 😉
Date format (Ctrl Shift 3)
Time format (Ctrl Shift 2)
Others – Format Cells (Ctrl 1), Sheet toggle (Ctrl PgDn / PgUp)
Quick Access Toolbar
#2: Data Cleaning

Learning pre-requisites: Basics of Find & Replace, Text to Columns, Filter

Aim: Data cleaning precedes analysis

Flow:

Using GO TO Special to detect / select cells which are blank, hard-coded, formula driven
Using GO TO Special with Ctrl Enter to fill intermittent blank cells
Using Machine Learning in Excel to clean data sets in seconds – FlashFill (v. 2013 feature)
Using TEXT function to extract day from a date. E.g. Sun, Mon…
Using VALUE function to cleanse date, time, nos stored as text
#3: Data Analysis using Pivot Table

Learning pre-requisites: Output of the data used in the Module “Data Cleaning” above

Aim: Using Pivot Table along with data visualization tricks to analyze data

Flow:

Basics
Essential Setting (Classic View)
Date Grouping
Move column field headings to right / left
Calculating Count, Sum, %
Color-scales based Conditional Formatting (Heat Map)
Sparklines (in-cell trendline chart)
Slicer (user driven filter)
PivotChart Shortcut
Creating 100s of worksheets in seconds
#4: Lookup Functions

Learning pre-requisites: Basics of VLOOKUP, $ (a 5-mins. fast paced brush-up can be included)

Aim: Gain absolute mastery over data lookup formulas

Flow:

Overview of different forms of Lookup (use-case) – 1D exact, slabs-based, 2D, reverse, fuzzy
VLOOKUP with TRUE – doesn’t mean approximate match
VLOOKUP with TRUE vs. complex Nested IF statements
VLOOKUP with MATCH for 2D lookup
Reverse Lookup with INDEX and MATCH
Fuzzy Lookup for similar names with spelling variations. E.g. India Motors Pvt Ltd vs. India Motor Private Ltd
Overview – OFFSET
#5: Aggregation Functions

Learning pre-requisites: Basics of SUMIF, COUNTIF, $ (a 5-mins. fast paced brush-up can be included)

Aim: Gain absolute mastery over formulas for data consolidation and aggregation

Flow:

SUMIFS with 2 criteria
SUMIFS with range logic (E.g. from-to date)
Using SUMIFS to calculate running cumulative total based on any primary key
SUMIFS vs. AVERAGEIFS
Using COUNTIFS to calculate running count based on any primary key. E.g. 1st, 2nd 3rd time occurrences of any key
#6: Use case of important functions

Learning pre-requisites: None

Aim: Understanding use case of several Excel functions which are simple and yet powerful. This will be fast paced with less focus on practice

Flow:

EDATE – Calculating expiry date. E.g. 3 months contract
EOMONTH – Calculating 10th of next month for due dates.
LEFT, RIGHT, MID – Extract characters from a cell
TRIM, SUBSTITUTE – Cleaning data of a cell
PROPER, UPPER, LOWER – Change case of the text
IF, AND, OR – Combination
Joining strings
Using Find & Replace with wildcard character *
Text to Columns to clean dates & change format
#7: Dashboard – Tracker Sheet

Learning pre-requisites: $, Drop down list, Concatenate (&)

Aim: Creating single sheet dashboard representing multiple individual sheets

Flow:

Understanding INDIRECT with references from same / different sheet
How to add Spin Button from the Developer tab
Adding Sparklines (in-cell trendline)
Using CELL function
#8: What If Analysis using Data Tables

Learning pre-requisites: Drop down list, Range naming, INDIRECT, Activating Developer tab from Options

Aim: Creating 2 variable input and multi-variable output what if analysis

Flow:

Data Tables using VC-HR approach
Using Scroll button from Form Controls to add interactivity
Using INDIRECT function and range naming to make the Data Table break the “one-variable” output limitation
Adding basic heat map on the result values
#9: Leveraging Google to locate readymade Macros code and editing them to automate tasks

Learning pre-requisites: Internet connection for Google search

Aim: Hands on approach to create customized Macros to fully / partially automate repetitive tasks

Flow:

Why learning Macros is a “MUST”
Record & Run a Macros
Linking a button to a Macros
Understanding the basic architecture of a VBA code (Sub, End Sub, Dim)
The right technique to search Google for readymade codes and choosing the best
Forum vs. Blogs

How to draft appropriate search terms
Sub Procedure vs. User defined function (UDF)
Basic DOs & DONTs while searching for VBA codes on Google
Exercises
Create an index of links to worksheets with addl. customization & Worksheet activate event
Split a table in multiple sheets based on filter
Insert rows based on cell value
#10: Speed Test

Learning pre-requisites: Learning from Day 1 and Day 2

Aim: Application of learning and self-assessment

Flow: Exercise based

#11: Non-Excel time saver tricks

Learning pre-requisites: None

Aim: Select non-Excel tricks

Flow:

1)Word Macros to automate pressing Delete-Space on PDF copied text

2)Extract text from scanned images without downloading any software or uploading any files to 3rd party sites

#12: Best Practices – Financial Model presentation (PowerPoint presentation, no practice)

Learning pre-requisites: None

Aim: Fast paced PowerPoint presentation demonstrating select best practices of presenting a Financial Model

Flow:

1) Using Cell Styles for standardizing cell colors & borders

2) Overview of FAST™ Modelling Standard: www.fast-standard.org – a set of rules on the structure and detailed design of spreadsheet based models.

To know more about the training’s course curriculum or to conduct the training with our expert Trainers:

Feel free to contact us here:

Contact Us

+91-808-004-2523

Request Callback

how can we help you?

Drop Email For Corporate Excel Training Across India

The facilitators are not only technically very knowledgeable, but also genuinely helpful and have a clear desire to help professionals work smarter, not harder. Thanks for a week very well spent!

Karnika Bhalla (Deloitte)
Director of Finance, Accounting and Compliance, USAID’s Nepal Hydropower Development Project