Master Excel 2016

Master Excel 2016

  • Duration : 156 Hrs
  • Module : 4 Modules
  • Exam : 4 Online Exams
  • Certificate : Master In Excel 2016
  • Training Mode: Online & Class Room

A complete professional course- Microsoft Excel helps companies maximize the value of their data, helping to control costs more effectively and obtain business information. With so many business functions now reliant on IT and the internet, Excel continues to be seen as a vital tool for administration and the effective running of a business. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Mastering MS Excel lets you get home on time

  • Excel makes calculations of complex formulas easy
  • Excel works great as a basic reporting tool
  • Excel is used extensively by just about everyone at work.

Complete Excel 2016

  • Introduction MS Excel 2016
  • Create a new Workoook in Microsoft Excel 2016
  • Worksheet Fundamentals
  • Selecting Cells & Ranges
  • Formatting Cell & Worksheet
  • Cell Style
  • Conditional Formatting
  • Creating Table In Excel 2016
  • Sorting Data in Excel
  • Filter In Excel 2016
  • Creating Charts and Graphics
  • Pivot Table & Pivot Chart Option
  • Graphics & Designing in Excel
  • Add Ins Group Buttons of Insert Tab Excel 2016
  • Linking & Hyperlinking In Excel 2016
  • Analyzing Data with Excel
  • Data Validation In Excel
  • Solver Option
  • Inking Option
  • Using Macros In Excel

Formulas and Functions in Excel

  • Formula & Functions In Excel 2016
  • Date and Time Function
  • Financial Function
  • LOOKUP & Reference function
  • Mathematical & Trigonometry Functions Function
  • Trigonometry Functions
  • Database Function
  • Statistical Functions In Excel
  • Information Functions In Excel
  • Engineering Function

Dashboards & Data Analysis In Excel

  • Excel Dashboards 2016
  • Excel Data Validations
  • Data Analysis
  • What – IF Analysis
  • Analysis Tool Pak
  • Hyperlink, Linking & Embedding in Excel
  • Advanced Functions And Formulas In Excel
  • Excel Industrial Project
  • Additional Functions In Excel
  • Excel Related To H.R
  • Using Excel in Finance

Macros & VBA Programming in Excel

  • Introductions of VBA & Macros
  • Functions and Recording Macros
  • The Visual Basic Editor -Writing VBA code
  • VBA Programming Fundamentals and Concepts
  • Excel Object Model and Properties
  • User Forms, Events, Menus and Toolbars
  • Collaborating with other applications

    CCA Educations Pvt.Ltd. Pune is very proud to be associated with Globsyn Skill Development Pvt.Ltd. Kolkata which is National Skill Development Corporation.....


    Besides franchisees, in the year 2013 requirements came in from university colleges to provide a short term courses to their students in their own premise.....


    COLLEGE OF COMPUTER ACCOUNTANTS (Pune) is a major Accounts education, service and research Institute.....


    With the Great success of our institution, A thought of why not start up with Franchisee’s clicked us.....