ADVANCED EXCEL FORMULAS & FUNCTIONS

Icon Computer provide Advanced Microsoft Excel Training with the level of excellent quality with life time support at very competitive price. We Covers all topics like calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.....

100% Practical Training Modules
See the below full Course Content

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 (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
Module - 3 (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
Module - 4 (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

Students Work

Browse

About Learn

© 2023 Icon Computer T.C. All Rights Reserved .