Enquire Now

Advance Excel


This Advanced Excel course is designed to take your Excel skills to the next level, equipping you with the tools and techniques needed to perform complex data analysis, create dynamic reports, and automate tasks. Whether you’re a business professional, analyst, or anyone looking to make data-driven decisions, this course will enhance your ability to work with large datasets and leverage Excel’s powerful features.

  • 2 Month
  • Hindi,English

Course Description

This Advanced Excel course is designed to take your Excel skills to the next level, equipping you with the tools and techniques needed to perform complex data analysis, create dynamic reports, and automate tasks. Whether you’re a business professional, analyst, or anyone looking to make data-driven decisions, this course will enhance your ability to work with large datasets and leverage Excel’s powerful features.

Who can do?

  • Business Professionals
  • Accountants and Financial Analysts
  • Data Analysts
  • Project Managers
  • Human Resources Professionals Sales and Marketing Professionals
  • Small Business Owners and Entrepreneurs
  • Students and Recent Graduates Anyone Looking to Improve Efficiency

Job Opportunities

  • Data Analyst
  • Financial Analyst
  • Business Analyst
  • Project Manager
  • Accountant/Controller Operations
  • Analyst Sales Analyst
  • Marketing Analyst
  • HR Analyst
  • Inventory Analyst/Logistics
  • Coordinator Management Consultant

Course Curriculum

    • Goal Seek
    • Scenario Analysis
    • Data Tables (PMT Function)
    • Solver Tool

    • If Function
    • How to Fix Errors – if error
    • Nested If
    • Complex if and or functions

    • 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

    • Vlookup / HLookup
    • Index and Match
    • Creating Smooth User Interface Using Lookup
    • Nested VLookup
    • Reverse Lookup using Choose Function
    • Worksheet linking using Indirect
    • Vlookup with Helper Column

     

    • Creating Simple Pivot Tables
    • Basic and AdvancedValue Field Setting
    • Classic Pivot table
    • Choosing Field
    • Filtering PivotTables
    • Modifying PivotTable Data
    • Grouping based on numbers and Dates
    • Calculated Field & Calculated Items
    • Arrays Functions
    • What are the ArrayFormulas, Use of the Array Formulas?
    • Basic Examples of Arrays (Using ctrl+shift+enter).
    • Array with if, len and midfunctions formulas.
    • Array with Lookup functions.
    • Advanced Use of formulas with Array.

    • Various Charts i.e. Bar Charts/ Pie Charts / Line Charts
    • Using SLICERS, Filterdata with Slicers
    • Manage Primary and Secondary Axis

    • Planning a Dashboard
    • Adding Tables and Charts to Dashboard
    • Adding Dynamic Contentsto Dashboard

    • What Is VBA?
    • What Can You Do with VBA?
    • Recording a Macro
    • Procedure and functionsin VBA

    • What is Variables?
    • Using Non-Declared Variables
    • Variable Data Types
    • Using Const variables

    • Customizing Msgboxes and Inputbox
    • Reading Cell Values into Messages
    • Various Button Groupsin VBA

    • Simple If Statements
    • The Elseif Statements
    • Defining select case statements

    • Introduction to Loops and its Types
    • The Basic Do and For Loop
    • Exiting from a Loop
    • Advanced Loop Examples

    • Using Outlook Namespace
    • Send automated mail
    • Outlook Configurations, MAPI
    • Worksheet / WorkbookOperations
    • Merge Worksheets usingMacro
    • Merge multiple excel files into onesheet
    • Split worksheets using VBA filters
    • Worksheet copiers
  •   Fees 3500
  •   Lesson 13
  •   Duration 2 Month
  •   Language Hindi,English
  •   Placement Assistant 100%