Porto

Smart Excel 2016
  1. Home
  2. Smart Excel 2016

Smart Excel 2016

  • Duration : 70 Hrs
  • Module : 2 Modules
  • Exam : 2 Online Exams
  • Certificate : Smart Excel 2016 Certificate
  • Training Mode: Online & Class Room

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows, Mac OS, and iOS. It is an invaluable tool for portfolio managers, traders and accountants.

Module 1

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

Module 2

Functions and Formulas in Excel

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

Our Brands

  • SKILL

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

    Read More →

  • COLLEGE

    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.....

    Read More →

  • FRANCHISE

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

    Read More →

  • INSTITUTE

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

    Read More →