MS Excel Training

AKB Institute Provides you the best training in Advance Excel. Our Course training related to real time Project. Students will become expert in Ms. Excel and Advance Excel. Our Couse Module of Advance Excel Specially designed for the Students with efficient & good Skill and also cover Each and Every Module while training. We are constantly working hard to help candidates achieve the best quality training in Excel with one of the best recruitment facility in the Industry. We have helped thousands of candidates in getting their practical skills and secure the jobs in accountancy and Taxation sector in Faridabad and Delhi NCR

 

Course Overview

Understand how to reference data using INDEX and match

Manipulate text-string data using function like RIGHT, CELL, LEN and FIND

Apply data Analysis tool like Data table and Pivot Tables

 

Who is it for

Under Graduates                          Any graduates

Data analyst.                                 Accountant.

Information clerk.                        Business analyst.

Market analyst.                             Financial analyst.

Auditor.                                         Cost estimator.

Try before you enroll

Join us for free one day training and see how we are different and supportive in our training approach

Call or text now to reserve your free training session

We are just a text away 9310127300

Course Benefits

Blended learning methodology with revision based customers accessible from home to give you supreme support in learning

 Flexible one to one training meetings built around your accessibility, with the option to choose days, timing and meetings

Certification from AKB Institute

Recruitment company aiding you with job hunting after training

Specialised one to one training sessions for CV, Interview preparation and Job hunting tips

Setting up of software in your laptops for practice from home

 Cover experience requirement for all significant bookkeeping bodies

Softwares Included

Course Contents

  • Customizing common options in Excel
  • Absolute and relative cells
  • Protecting and unprotecting worksheets and cells.
  • Entering, Editing and Formatting Text
  • Working with basic Excel Formulas
  • Drop down list is Excel
  • Index and match
  • If with AND/OR
  • Offset Combined with other Function
  • Cell Count and MID Functions combined together
  • Data Tables
  • Pivot Tables
  • Column and Line Charts.
  • 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.

Skills You Will Gain

    • Learn everything you need to be a world-class financial analyst.

    • Received advanced Excel spreadsheet training

      Master advanced formulas and functions

     
    • Easy to follow video- based tutorial and lessons.

    • Easy to follow video- based tutorial and lessons.

    • Create sophisticated outputs for financial analysis, including tables, charts and graphs.

     

Industries Covered

  • Construction
  • Wholesale
  • Retail
  • Information Technology
  • Solicitor
  • Medical Surgeries
  • Dental Clinics
  • Online Business
  • Architect & More

Book Free Consultation or Call on 9310127300