Advanced Excel Training In Delhi

Excel Next stands out for giving advanced excel training in Delhi. Our team targets to provide the richest and most qualitative training in the Delhi NCR. Living in the era where techniques are playing major role. Our trainers have always targeted to offer and deliver the best training and guidelines in Delhi till date.

Ernst and Young, Delhi, ITC, Delhi, R1RCM, Delhi, Saint Gobain, Delhi, Rockwell, Noida, Exl Service Noida, Rio Tinto, Gurgaon and PWC, Gurgaon are amongst few of our promising clients whom we have provided timely training for Advanced Excel in Delhi, so that they excel in their Profession.

Excel Next even stands out for giving excel VBA training in Delhi NCR. The Excel VBA and Macros training in Delhi region help the people to automate their daily routine and tasks by making their own Macros. To know more about Excel VBA training, view our training curriculum Excel VBA Training

Advanced Excel training in Delhi NCR, provides a complex structure of database in easy manner. The main purpose of the training is to make it understandable. Make the task easier to perform using MS Excel advanced techniques for the professionals based in Delhi NCR. The Advanced Excel training helps the people to acquire frequent and desired skills into Advanced Microsoft Excel, anyone can rely on Excel Next which specializes in providing Advanced MS Excel Training in Delhi.

Excel Next doesn’t just excel in providing Advanced Excel or VBA training but holds skillfulness in giving PowerPoint Presentations Trainings as well in Delhi. And the people who want to be a part of the PowerPoint Training Program, check our course curriculum by clicking Powerpoint Training

Advanced Excel training session in Delhi 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 analyse 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.

Excel Next even offers the learners with the required Training in Advanced Excel in Delhi, Gurgaon and Noida to help the employees be capable of competency in their regular task

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

Feel free to contact us here by filling contact form:

Contact US: +91-808-004-2523 / [email protected]