By Wipro-HCl -IBM IT Manager "Join Online 100 % Guaranteed Job Internship-Placement Full Day (10 AM to 5 PM ) Live Online Program"


    Best Online advance excel Training Institute In Delhi (Noida).

      5.0 out of 5 based on 460 ratings. 458 user reviews.



  • About Our advance excel Course


    EVISION TECHNOSERVE PVT LTD offers Microsoft certified Advanced Excel training course with live projects by the professional trainer in PUNE, MUMBAI, BENGALURU, CHENNAI, HYDERABAD, KOLKATA, AHMEDABAD, LUCKNOW, DELHI NCR, and NOIDA. Our Advanced Excel training program is specially designed for Under-Graduates (UG), Graduates, working professionals, and for Freelancers. We provide end to end learning on Advanced Excel Domain with deeper dives for creating a winning career for every profile. Join our advanced excel demo classes on Skype & ZOOM and enroll now !



  • Online Training Course Overview


    Excel Training Program at EVISION enables you to analyze the data on any level proficiently and equips you to use the spreadsheets with functions, formulas, charts, perform data mashups, extract or pull the data, visualize the extracted data, pivot table, pivot charts, sampling, and Excel VBA under the mentorship of certified professionals.This Course will help you to analyse data and generate reports in an efficient and fast way to save time and impress. Get In-depth Practical knowledge on excel new modern formulas from the Scratch with our live instructor led classes.


  • Why should you take up this advance excel certification training?


    Microsoft Excel is used by almost all companies today. By taking up this MS Excel online course, you will be able to work effortlessly with data, be it financial, accounting, statistical, or other data from diverse sectors. You will be able to process the data and gain valuable insights using various formulae, functions, graphs, and charts. This will help you get a good job in a company of your choice for a decent pay scale. • Microsoft Excel is leading the market with over 750 million users worldwide – Comscore • Excel is used by finance, sales, marketing, HR, and other departments • Deep Excel expertise is a much sought-after skill in any profession around the world

  • What will you learn ?


    • Q Advanced-Data Sorting
    • Lookup Functions
    • Subtotal, Multi-Level Subtotal
    • Consolidation With Several Worksheets
    • Printing of Raw & Column Heading on Each Page
    • Specified Range Protection in Worksheet
    • Advance use of Data Tables in Excel
    • Generating MIS Report In Excel
    • MIS Reporting& DashBoard

  • Career Path


    • Financial Analysts
    • Retail Store Managers
    • Project Managers
    • Business Analysts
    • Data Journalists
    • Accountants



  • Eligibility


    BCA / MCA / BE / B.Tech / BCS / MCS / BBA / MBA

  • Objectives


    • To Describe what advance excel is
    • To Write advance excel configuration files
    • To Understand how advance excel integrates infrastructure sources
    • To Manage multiple infrastructure environments with advance excel

  • Skiils Covered


    advance excel| AWS| Azure| Python| Security Primer| Remote State Management

  • Key Features



  • Who should learn this course?


    • Business Professionals
    • Accounting Professionals
    • Data Analysts and Programmers
    • Business Intelligence Professionals
    • Statisticians
    • Those looking for a career in analytics

  • Prerequisites


    Anybody wishing to be an expert in MS Excel can take up this advanced Excel course.

  • Course Schedule and Fees


    Week Day batches

    (Mon-Fri)


    30th aug 2021

    Monday

    8:00 Am(IST)

    1hr - 1.30hr/ per person

    Week Day batches

    (Mon-Fri)


    30th aug 2021

    Monday

    8:00 Am(IST)

    1hr - 1.30hr/ per person

    Week Day batches

    (Mon-Fri)


    30th aug 2021

    Monday

    8:00 Am(IST)

    1hr - 1.30hr/ per person

    Week End batches

    (Mon-Fri)


    30th aug 2021     

    Monday

    8:00 Am(IST)

    1hr - 1.30hr/ per person


    can't find a batch you were looking for?


    Course Content


    MODULE 1: EXCEL BASICS Lesson 1 – Getting Started with Excel • Structure of the Excel working area • How to navigate in Excel • Ribbons and tabs, • Quick Access Toolbar (QAT) • Dialog Box & Task Panes • Customizing ribbons and QAT • What is an active cell • How to use ALT shortcuts Advanced Course • Customizing common options in Excel • Absolute and relative cells • Protecting and un-protecting worksheets and cells Lesson 2 - Data Entry, Data Editing, and Number Formatting • Data Entry • Data Editing • Number Formatting Lesson 3 - Data Formatting • Applying borders to all cells • Making headers bold • Giving a background cell color to headers. • Center align the headers. Lesson 4 - Working with Cells and Ranges in Excel • Cell address nomenclature • Selecting cell/ranges in Excel • Copying and moving cells/ranges in Excel • Using paste special • Selecting special cells • Using find and replace to select cells • Adding comments and • Using quick analysis Lesson 5 - Managing Worksheets • Navigating through worksheets in Excel • Changing worksheet name and color • Adding/deleting worksheets • Hiding/Un-hiding worksheets • Moving/copying worksheets • Comparing worksheets side by side • Splitting worksheet into panes • Freeze panes • Saving and opening workbooks Advanced Course - Working with Templates • Designing the structure of a template • Using templates for standardization of worksheets Module 2: EXCEL ESSENTIALS Lesson 6 - Introduction to Excel Tables • Creating an Excel Table • Excel Table features • Structured references • Table slicers Lesson 7 - Auto-fill, Custom Lists, and Flash Fill Lesson 8 - Number Formatting in Excel MODULE 3 – EXCEL FORMULAS Lesson 9 - Excel Formula Basics • Constituents of Excel formula • Operators in formulas • Entering a formula in Excel • Editing a formula • Absolute/relative cell references • Copying/pasting formulas in Excel, and • Formula auditing and debugging. Advanced Course – Conditional Formatting • Highlight Cells Rules • Top / Bottom Rules • Data Bars • Color Scales • Icon Sets • New Rule • Clear Rules • Manage Rules Lesson 10 - Logical Formulas in Excel • AND function • OR function • NOT function • TRUE function • FALSE function • IF function • IFERROR function Lesson 11 - Math Formulas in Excel • INT function • MOD function • RAND function • RANDBETWEEN function • ROUND function • SUM function • SUMIF function • SUMIFS function • SUMPRODUCT function Advanced Course • Subtotals with Ranges • Subtotals • Nested Subtotals • Quick Analysis • Quick Analysis with TOTALS • Sum • Average • Count • %Total • Running Total • Sum of Columns Lesson 12 - Lookup and Reference Formulas in Excel • VLOOKUP function • HLOOKUP function • INDEX function • MATCH function • OFFSET function • INDIRECT function • ROW function • ROWS function • COLUMN function • COLUMNS function Advanced Course - Working with Functions • Writing conditional expressions (using IF) • Using logical functions (AND, OR, NOT) • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX) • VlookUP with Exact Match, Approximate Match • Nested VlookUP with Exact Match • VlookUP with Tables, Dynamic Ranges • Nested VlookUP with Exact Match • Using VLookUP to consolidate Data from Multiple Sheets Lesson 13 - Stats Formulas in Excel • AVERAGE function • AVERAGEIF function • AVERAGEIFS function • COUNT function • COUNTA function • COUNTBLANK function • COUNTIF function • COUNTIFS function • LARGE function • SMALL function • RANK function • MAX function • MIN function Lesson 14 - Text Formulas in Excel • LEFT function • RIGHT function • MID function • LEN function • LOWER function • PROPER function • UPPER function • FIND function • REPLACE function • SUBSTITUTE function • TEXT function Lesson 15 - Date and Time Formulas in Excel • DAY function • HOUR function • MINUTE function • DATE function • DATEVALUE function • TODAY function • NOW function • WEEKDAY function • NETWROKDAYS function • NETWORKDAYS.INTL function Advanced Course • Converting Dates in Serial Format to Month-Day-Year Format • Converting Dates in Month-Day-Year Format to Serial Format • Obtaining Today’s Date • Finding a Workday after Specified Days • Customizing the Definition of a Weekend • Number of Workdays between two given dates • Extracting Year, Month, Day from Date • Extracting Day of the Week from Date • Obtaining Date from Year, Month and Day • Calculating Years, Months and Days between two dates Lesson 16 - Formulas Mix and Match (10 Examples) • Compare Lists, Get Unique List • Get the Closest Match • Get Last Value in the List • Find Last Occurrence of an Item in a List • 2 Way and 3 Way Lookup using Index/Match • Count the Number of Words • Extract Username from Email Id • Find the First Monday of the Month • Extract Data using Drop Down List MODULE 4: DATA ANALYSIS Lesson 17 - Named Ranges in Excel • Creating Named Ranges • Managing Named Ranges • Important Keyboard Shortcuts • Creating Dynamic Named Ranges using OFFSET and INDEX formulas Lesson 18 - Data Validation in Excel • Data Validation Criteria • Input Message • Customizing Error Messages • Circle Invalid Entries • Advanced Data Validation Tricks Advanced Course - Data Validations • Specifying a valid range of values for a cell • Specifying a list of valid values for a cell • Specifying custom validations based on formula for a cell Lesson 19 - Data Sorting and Filtering in Excel • Data Sorting • Multi-Levels of Sorting • Data Filtering • Advanced Filtering • Filtering and Sorting in Excel Data Tables Advanced Course - Data Sorting and Filtering • Sort by Text • Sort by Numbers • Sort by Dates or Times • Sort by Cell Color • Sort by Font Color • Sort by Cell Icon • Sort by a Custom List • Sort by Rows • Sort by more than one Column or Row • Filter by Selected Values • Filter by Text • Filter by Date • Data Analysis with Excel • Filter by Numbers • Filter by Cell Color • Filter by Font Color • Filter by Cell Icon • Clear Filter • Advanced Filtering • Filter Using Slicers Lesson 20 - Using Conditional Formatting in Excel • Introduction to Conditional Formatting • Using Formula in Conditional Formatting • Advanced Examples (Highlight Every Nth Row, Creating Dynamic Search) Advanced Course - Formatting • Using auto formatting option for worksheets • Using conditional formatting option for rows, columns and cells MODULE 5: INTRODUCTION TO EXCEL CHARTING Lesson 21 - Introduction to Excel Charting • Excel Chart Types • Chart Editing • Formatting Chart Elements • Combination Charts • Handling Gaps in Charts Lesson 22 - 10 Advanced Excel Charting Examples • Multi-Category Charts • Gauge Chart • Thermometer Chart • Milestone Chart • Water Fall Chart • Gantt Chart • Chart with Trend Arrows in Data Labels • Actual Vs. Target Values • Spotting Data in a Scatter Chart in Excel • Dynamic Target Line in Excel Bar Charts Lesson 23 - Advanced Dynamic Charts in Excel • Using Charts • Formatting Charts • Using 3D Graphs • Using Bar and Line Chart together • Using Secondary Axis in Graphs • Sharing Charts with PowerPoint / MS Word, Dynamically • (Data Modified in Excel, Chart would automatically get updated) MODULE 6 – PIVOT TABLE Lesson 24 - Overview of Excel Pivot Table • Introduction to Pivot Tables • Creating a Pivot Table in Excel • Formatting the Pivot Table • Grouping data in an Excel Pivot table • Calculated Field/Items in Pivot Table • Pivot Table Slicers • Pivot Charts Advanced Course – Excel Pivot Table • PivotTable Fields • PivotTable Areas • Nesting in the PivotTable • Filters • Slicers • Summarizing Values by other Calculations • PivotTable Tools • Using Pictures in Column Charts • Band Chart • Thermometer Chart • Gantt Chart • Waterfall Chart • Sparklines • Pivot Charts • PivotChart from PivotTable • PivotChart without a PivotTable • Working with Multiple Sheets • Multiple Worksheets with same Structure • Creating a Formula across Multiple Worksheets • Summarizing Data in Multiple Worksheets • What-If Analysis • Goal Seek • Data Tables • Scenario Manager MODULE 6 – EXCEL EXTRAS Lesson 25 - Protection in Excel Lesson 26 - Introduction to Macros and VB Editor Advanced Course - Macros • Relative & Absolute Macros • Editing Macro's

    Read more

    Download Syllabus

    DevOps Real Time Projects


    Project : 1

    if Function


    Codify your application infrastructure The focus of the project be on the learning of the aspects of "IF" function. You will learn to calculate employee bonus, find the average rating of salesman on more. You will use operators and nested if function whenever necessary.


    Skills Required for the project
    Excel Advance Excel

    Duration: 3 Hours

    EVISION Certification is Accredited by all top IT MNC's as in Wipro, TCS, IBM,Infosys,HCL Technologies. We provide Certification after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees.


    Our certification at Evision Technoserve is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects course which will encourage and add to trainee’s resume to explore a lot of opportunities beyond position.

    EVISION Trainer's Profile



    EVISION'S Trainers are:


    • Truly expert and fully up-to-date in the subjects they teach because they continue to spend time working on real-world industry applications.
    • Have recognized in various IT Organizations & Are Well connected with Hiring HRs in multinational companies.
    • Working professionals working in MNC's such as HCL Technologies, TCS, IBM, etc.
    • Certified Professionals with 10+ years of experience.

At Evision, our expert ensured that they will equips with skills to apply for the best jobs in top MNCs with desired salaries.
Also, will get lifetime access to videos, course materials and 24/7 learning support.
Candidate will get master in skills needed to create a advance excel roadmap, monitor key performance indicators, and measure the critical success factors.
Upon the successful completion of the training, candidate will be awarded the Intellipaat advance excel certification.
Hence, it's clearly a one-time investment.

Clearly, this course is of 45 days duration with 100 percent job guarantee in top IT MNCs.
For more query, WhatsApp on no. 9811722065.

At Evision, candidate can enroll in the instructor-led online training.
All trainers at Evision have 10+ years of relevant industry experience which has made them subject matter experts.
Go through our demo class to check the quality of our trainers.

Evision have 24/7 query management team, and you can raise your issue with our dedicated support team at any time.
You can also avail of email support for all your queries.
If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team.

Evision is offering the most updated, relevant, and high-value real-world projects as part of the training program.
This way, we can implement the learning that candidate have acquired in real-world industry setup.
All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry ready.

Evision actively provides job placement guarantee to all candidate who have successfully completed the training.
For this, we are exclusively tied-up with over 250 plus top MNCs.
This way, you can be placed in outstanding organizations such as Wipro, IBM, TCS, HCL Technology, Infosys, among other equally great enterprises.
We also help you with the job interview and résumé preparation as well.

Once you successfully complete Evision’s training program, working on real-world projects and assignments and scoring at least 60 percent marks in the qualifying exam, candidate will be awarded Evision’s course completion certificate.
This certificate is globally accredited, including top MNCs from around the world.

Please visit our company websites: www.evisions.co.in Or WhatsApp on 9811722065.