Courses

Best Courses we offer

  • Home
  • MS Excel Advance

MCSE 2016 / 2019 MS Excel Basic MS Excel Advance


MS Excel Advance


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

20 hrs

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.




  1. Microsoft Excel Advance Course Content
    PREREQUISITE FROM CANDIDATE FULL DETAIL OF COURSE
    Candidate should have Basic Knowledge of Excel to enroll for this course

    ----------------------------------------
    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)
    **You are now Intermediate Excel User

    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.

Your message has been sent. Thank you!