Courses

Best Courses we offer

  • Home
  • MS EXCEL ADVANCE

MCSE 2016 / 2019 MS EXCEL BASIC MS EXCEL ADVANCE MS POWERPOINT


Advanced Excel Training in Mumbai


If you want to start your career in Microsoft Excel (Data Analyst, Reporting or MIS), this is the perfect place for you to start.

Microsoft Excel Pay-Scale (Salary Trend)
According to PayScale survey the Average Salary is ₹307,347/- for Mid-Level position in Data Analyst with Microsoft Excel Skills in Mumbai.

For more details on short Job Description, Salary for Mircosoft Excel Advance skills, kindly read our blogs.
Microsoft Excel Pay-Scale

Don’t think, enroll yourself for Microsoft Excel Advance course at IPsolutions. Our corporate trainers will shape up your career in Data Analyst profile & we will assist you in Placement services.

20 hours

Classroom Training

Monday
Tuesday
Wednesday
Thursday
Friday

Saturday
Sunday


MS EXCEL ADVANCE

Build a strong understanding of Microsoft Excel basics
Know the MS Excel most popular functions
Using Microsoft Excel full power by automating your daily tasks via Macros
Keep large Excel data sets in a list or table
Build interactive reports by mastering Pivot Tables, one of the most common tools
Learn complex formulas such as IF, VLOOKUP, INDEX, MATCH functions and many more You will be groomed by Instructor who holds 14+ years of experience in corporate.

PREREQUISITE FROM CANDIDATE FULL DETAIL OF COURSE
Candidate should have Basic Knowledge of Excel to enroll for this course




  1. EXCEL ADVANCE COURSE CONTENT
    • Working with an Excel List
    • Data Validation
    • Importing and Exporting Data
    • PivotTables
    • PowerPivot Tools
    • Operating with large Excel data sets
    • Excels Conditional Functions
    • Excels Lookup Functions (VLOOKUP, HLOOKUP, INDEX & MATCH)
    • Excels Text Based Functions
    • Auditing an Excel File
    • Protecting Excel Specific area, Worksheets and Workbooks
    • Macros Introduction (Basic)
    • Automating your daily repetitive Tasks in Excel with Macros
    • How to use Macro Recorder Tool
    • Excel VBA Concepts (Overview)
    • Preparing and Cleaning Up Data with a Little VBA (Assignment)
    • Importing Data from Text Files (CSV files)
  2. Important Topic: CHARTS
    • Column Chart Type
    • Bar Chart Type
    • Line Chart Type
    • Pie Chart Type
    • Area Chart Type
    • XY (scatter) Chart Type
    • Stock Chart
    • Surface Chart Type
    • Doughnut Chart Type
    • Bubble Chart Type
    • Radar Chart Type
  3. Course Wrap Up (Assignment & Projects)

    The course is designed by keeping the requirement from corporates. The contents updated on the websites are high level, but during the course time you will learn more on it.

    Additionally, we will also give you overview of Microsoft PowerPoint and Microsoft Power BI (Business Intelligence)

    Note: After every lecture, the student has to go under a Objective type question test on the topics covered during the lecture. Such tests boost the morale of the student and make them experts after the course is completed.

    We also assist in Placement services*.


Your message has been sent. Thank you!