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
Duration : 3 / 4 Months
Exam : Online Exams
Certificate : Master In Excel
Training Mode : Online & Class Room
- 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
- Formula & Functions In Excel
- 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
- 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
- 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