Apply For This Course Now
Total Course Duration: 1.5 Months
- Multiple-level Sub Total Reports
- Filtering database & Sorting data
- Securing & Protecting Worksheets
- Linking Multiple Sheets
- Sheet Referencing
- Dynamic Linking Word/Excel/Powerpoint
- Functions : LOOKUP, VLOOKUP, HLOOKUP
- COUNTIF, SUMIF
- What-if-analysis
- Goal Seek Pivot Tables & Pivot Charts
- Reporting
- Character Functions
- Scenario Manager
- Date Functions
- NESTED IF
- Consolidation of Data
- Data Validation
- Logical function
- Macro: Definition & Concepts
- Record, Run & Store a macro
- Introduction to VBA Prog
- 30 Projects of Practical Training Electronic Spreadsheet basics
- Formatting Fonts, Numbers
- Relative & Absolute Reference
- Date & Currency Formatting
- Formula charts & Graphs
- 2D/3D Graphs, Pie, Line Cone
- Formatting Charts
- Data Values
Total Course Duration: 2 Months
- Performing complex calculations more efficiently
- Using various Excel functions and executing in Dynamic projects
- Organizing and analysing large volumes of data
- Creating MIS reports
- Designing and using templates
- Consolidating and managing data from multiple workbooks
- Writing conditional expressions (using IF)
- Using logical function (AND, OR, NOT)
- Using lookup and reference functions (VlookUP, HLOOKUP, MATCH, INDEX)
- VlookUp with Tables, Dynamic Ranges
- Nested VlookUP with Exact Match
- Using VLookUP to consolidate Data from Multiple Sheets
- Advanced Formatting : Using conditional formatting option for rows, columns and cells Formatting & customizing Pivot tables
- Using advanced options of Pivot tables, Pivot charts
- Consolidating data from multiple sheets
- Using external data sources
- Using data consolidation feature to consolidate data
- Show Value As (% Row, % of Column, Running Total, Compare with Specific Field)
- Viewing Subtotal under Pivot
- Advanced Date & Time Functions
- Data Validation in financial functions
- Advanced Shortcut Keyboard Commands
- Create Forms with Radio Buttons, Selection tools, other programming tools.
- Creating Slicer (2013 Version)
Total Course Duration: 3 Months
- Module 1:
- Basic
- Create Functions & Procedures
- Design & Create Reports
- Underst&ing Security Levels
- Security levels & its meaning
- Module 2:
- Functions
- What is Function & Subroutine
- Writing Functions using VBA Editor
- Calling Functions other workbook
- Relative & Absolute Macros
- Module 3:
- Recording Macros
- Recording & running macro
- Storing macro in different books
- Creating buttons & assigning macros
- Creating My Menu
- Module 4:
- The Visual Basic Editior
- Editing macros using VBA Editor
- Underst&ing the project explorer
- Exploring windows properties
- Modifying code & Debugging code
- Module 5 :
- Programming Fundamentals
- Variables, Data types & Constants
- Arrays, Object Variables
- Conditional structures (If Then, Select Case)
- Logical Operators / Looping constructs (For loops, Do loops, While)
- Buit-in functions, Creating Subroutines
- Module 6:
- User Forms
- Creating forms, Form events
- Creating custom menus & toolbars
- Creating Add-ins
Certification in Advance Excel
Excel Expert