Contact Us

Hide

Online course detail

Advanced Excel Training course Gurgaon,Delhi

Even after the advent of so many software and tools, still 70% of companies rely exclusively on MS-Excel for day-to-day work. An alarmingly large number of individuals use Microsoft Excel to get their job done. Hence its a no surprise that there is an intense demand for individuals who are experts in using excel and have all the shortcuts and tricks on their fingertips. Advanced Excel for Data Analytics is a Job Oriented Course designed to meet the job requirement of Freshers and Experienced professionals.

Instructor-Led Training  |  Free Course Repeat  |  Placement Assistance  |  Job Focused Projects  |  Interview Preparation Sessions

Read Reviews

Connect With Us

Curriculum

    Learning Objectives  – This module will make you familiar with basic Excel features. Excel is a table like sheet consisting of multiple Rows and Columns. You will learn how to

    • Customize quick access toolbar and ribbon.
    • Differences between Relative and Absolute references
    • Perform complex calculations.
    • Protect a workbook/worksheet and adding, deleting, hiding & unhiding Sheets.
    • Secure important and confidential data.
    • Learn different data types that are supported by excel like Number, Currency, Date, Percentage, Text formats, etc.
    • Mostly the excel data is not formatted and has bad alignment. There are multiple features available in Excel Home Ribbon to solve this problem.
    • Column
    • Bar
    • Line
    • Pie
    • Scatter, etc.
    • Data Sorting
    • Data Filtering
    • Removing Duplicate Values
    • Validation Rules
    • Data Consolidation
    • Text to Columns
    • What if Analysis
    • Grouping/ Ungrouping
    • Named Ranges
    • Vlookup & its Limitations
    • Hlookup
    • Index Match
    • Hyperlink
    • Indirect
    • Offset
    • Transpose

    Practice Problems of Vlookup:

    • Vlookup General Problems
    • Vlookup with Match Function
    • Vlookup using (*) problems
    • Vlookup using Running Countif
    • Nested Vlookup
    • Char
    • Concatenate
    • Exact
    • Find
    • Left
    • Right
    • Proper
    • Search
    • Mid
    • Upper

    Real time problems on Text functions

    • And
    • If
    • IfError
    • Not
    • OR
    • True

    Real time problems on Logical functions

    • Day
    • Date
    • Hour
    • Minute
    • Second
    • Time
    • Month
    • Year
    • Today
    • Weekday
    • Now

    Real time problems on Date/time functions

    • Sum
    • Sumif
    • Sumifs
    • Count
    • Countif
    • Mod
    • Product
    • Sumproduct
    • Roundup
    • Array Formulas

    Real time problems on Mathematical Formulas

    • Pivot Table
    • Pivot Charts

Course Description

    There is no department in industry where excel is not used. It is omnipresent. We understand that MS-Excel content coverage is huge and can become difficult to handle. Hence we at Gyansetu, have strategically devised this course as per the exact demand of the industry and ensure that at the end of the course, you Excel in excel.

    Gyansetu’s Advance Excel Training covers Data Alignment, Data Formatting, Conditional Formatting, Validation Rules, Grouping, Functions to perform financial, mathematical or statistical calculations such as VLOOKUP, HLOOKUP, INDEX MATCH, SUM, COUNT, DATE-TIME, Pivot Table, Pivot Chart, Formulas, Functions, VBA, Macros & SQL. You will also get to implement an Excel project towards the end of the course.

    After the completion of Advanced MS Excel 2016 course at Gyansetu, you will be able to:

    1. Explain Excel Important Functions like VLookup, HLookup, Index Match.
    2. Perform tasks like Data Filtering & Sorting.
    3. Apply Multiple rules using Conditional Formatting.
    4. Limitations in VLookup over Index Match.
    5. Create Reports using Pivot Table, Pivot Charts & Dashboards.
    6. Password protect a workbook.

    We at Gyansetu understand that teaching any course is not difficult but to make someone job ready is the essential task. That's why we have prepared capstone projects which will drive your learning through real time industry scenarios and help you clearing interviews.

    All the advanced level topics will be covered at Gyansetu in a classroom/online Instructor led mode with recordings

    No prerequisites. This course is for beginners.

      Gyansetu is providing complimentary placement service to all students. Gyansetu Placement Team consistently work on industry collaboration and associations which help our students to find their dream job right after the completion of training.

      • Our placement team will add Big Data skills & projects in your CV and update your profile on Job search engines like Naukri, Indeed, Monster, etc. This will increase your profile visibility in top recruiter search and ultimately increase interview calls by 5x.
      • Our faculty offers extended support to students by clearing doubts faced during the interview and preparing them for the upcoming interviews.
      • Gyansetu’s Students are currently working in Companies like Sapient, Capgemini, TCS, Sopra, HCL, Birlasoft, Wipro, Accenture, Zomato, Ola Cabs, Oyo Rooms, etc.


      ???????

      • Gyansetu trainer’s are well known in Industry; who are highly qualified and currently working in top MNCs.
      • We provide interaction with faculty before the course starts.
      • Our experts help students in learning Technology from basics, even if you are not good in basic programming skills, don’t worry! We will help you.
      • Faculties will help you in preparing project reports & presentations.
      • Students will be provided Mentoring sessions by Experts.

    Certification

    Advanced Excel Certification

    APPLY NOW

    Reviews

    Placement

    Enroll Now

    Structure your learning and get a certificate to prove it.

    Advanced Excel Training course Gurgaon,Delhi Features

    FAQs

      We have seen getting a relevant interview call is not a big challenge in your case. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training. We help you prepare your CV by adding relevant projects and skills once 80% of the course is completed. Our placement team will update your profile on Job Portals, this increases relevant interview calls by 5x.

      Interview selection depends on your knowledge and learning. As per the past trend, initial 5 interviews is a learning experience of

      • What type of technical questions are asked in interviews?
      • What are their expectations?
      • How should you prepare?


      Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.

      We have seen getting a technical interview call is a challenge at times. Most of the time you receive sales job calls/ backend job calls/ BPO job calls. No Worries!! Our Placement team will prepare your CV in such a way that you will have a good number of technical interview calls. We will provide you interview preparation sessions and make you job ready. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training. Our placement team will update your profile on Job Portals, this increases relevant interview call by 3x

      Interview selection depends on your knowledge and learning. As per the past trend, initial 8 interviews is a learning experience of

      • What type of technical questions are asked in interviews?
      • What are their expectations?
      • How should you prepare?


      Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.

      We have seen getting a technical interview call is hardly possible. Gyansetu provides internship opportunities to the non-working students so they have some industry exposure before they appear in interviews. Internship experience adds a lot of value to your CV and our placement team will prepare your CV in such a way that you will have a good number of interview calls. We will provide you interview preparation sessions and make you job ready. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training and we will update your profile on Job Portals, this increases relevant interview call by 3x

      Interview selection depends on your knowledge and learning. As per the past trend, initial 8 interviews is a learning experience of

      • What type of technical questions are asked in interviews?
      • What are their expectations?
      • How should you prepare?


      Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.

      Yes, a one-to-one faculty discussion and demo session will be provided before admission. We understand the importance of trust between you and the trainer. We will be happy if you clear all your queries before you start classes with us.


      We understand the importance of every session. Sessions recording will be shared with you and in case of any query, faculty will give you extra time to answer your queries.

      Yes, we understand that self-learning is most crucial and for the same we provide students with PPTs, PDFs, class recordings, lab sessions, etc, so that a student can get a good handle of these topics.

      We provide an option to retake the course within 3 months from the completion of your course, so that you get more time to learn the concepts and do the best in your interviews.

      We believe in the concept that having less students is the best way to pay attention to each student individually and for the same our batch size varies between 5-10 people.

      Yes, we have batches available on weekends. We understand many students are in jobs and it's difficult to take time for training on weekdays. Batch timings need to be checked with our counsellors.

      Yes, we have batches available on weekdays but in limited time slots. Since most of our trainers are working, so either the batches are available in morning hours or in the evening hours. You need to contact our counsellors to know more on this.

      Total duration of the course is 64 hours (32 hours of live instructor-led-training and 32 hours of self-paced learning).

      You don’t need to pay anyone for software installation, our faculties will provide you all the required softwares and will assist you in the complete installation process.

      Our faculties will help you in resolving your queries during and after the course.

    Relevant interested Courses