Job Description
About the Workshop
 
Opportunity to learn and explore Advance Functionalities of Excel
 
Number of topics being covered ranging from Excel Formulas to Visual Basic for Applications
 
Contents of this workshop has been specially selected to meet daily corporate requirements
 
Special Consulting services to Participants on any specific Excel Requirement
 
Two Day Workshop will be held over weekends (Saturday and Sunday)
 
Topics Covered
 
Workshop Day 1
 
1. Introduction on usage of Advance Excel Techniques
 
2. Formulas Basic and Advance (40+ formulas)
 
3. Formula Auditing/Type of Errors
 
4. Data Validation
 
5. Data Import
 
6. Text to Columns
 
7. Conditional Formatting
 
8. Advance Filter
 
9. Subtotal
 
10. Name Manager
 
11. Pivot Table
 
12. Pivot Charts
 
13. Charts
 
14. Table
 
Workshop Day 2
 
1. Introduction to VB
 
2. Introduction to VBA
 
3. Introduction to Macro
 
4. Introduction to VBA Editor
 
5. Introduction to Routines
 
6. User Defined Functions
 
7. Data Types, Variables and Constants
 
8. Control Structures
 
9. Object Model
 
10. Excel Objects and Collections
 
11. Logic Development (Algorithms and Flowcharts)
 
12. Exercises
 
Who should attend
 
Students
 
Freshers
 
Employess working on Dashboards, KPI, System Generated data
 
Finance Professionals
 
Management Professional dealing with Data
 
MIS personnel
 
Commerce field, Would be C.A.
 
Anyone who want to learn something new on Excel
 
Key Takeaways
 
Learn Advance Excel Functionalities
 
Advance Problem solving Techniques within excel for effective results
 
Improvise over Data Analytical Skills
 
Cost and Time Saving Techniques
 
Innovative ways of Finding Solution
 
Increase efficiency and productivity
 
Make faster and better decisions on day to day basis
 
Key features include:
 
Skilled presenters (all presenters are Min 7 to 10 Years of experienced)
 
Practical training (based on the real life problems we encounter in our consulting)
 
Flexibility (if something comes up, you can attend the next public course)
 
Workshop Content (Designed as per Corporate Requirement)
 
For more details
email: raghvendraacharya77@gmail.com
 
Opportunity to learn and explore Advance Functionalities of Excel
Number of topics being covered ranging from Excel Formulas to Visual Basic for Applications
Contents of this workshop has been specially selected to meet daily corporate requirements
Special Consulting services to Participants on any specific Excel Requirement
Two Day Workshop will be held over weekends (Saturday and Sunday)
Topics Covered
Workshop Day 1
1. Introduction on usage of Advance Excel Techniques
2. Formulas Basic and Advance (40+ formulas)
3. Formula Auditing/Type of Errors
4. Data Validation
5. Data Import
6. Text to Columns
7. Conditional Formatting
8. Advance Filter
9. Subtotal
10. Name Manager
11. Pivot Table
12. Pivot Charts
13. Charts
14. Table
Workshop Day 2
1. Introduction to VB
2. Introduction to VBA
3. Introduction to Macro
4. Introduction to VBA Editor
5. Introduction to Routines
6. User Defined Functions
7. Data Types, Variables and Constants
8. Control Structures
9. Object Model
10. Excel Objects and Collections
11. Logic Development (Algorithms and Flowcharts)
12. Exercises
Who should attend
Students
Freshers
Employess working on Dashboards, KPI, System Generated data
Finance Professionals
Management Professional dealing with Data
MIS personnel
Commerce field, Would be C.A.
Anyone who want to learn something new on Excel
Key Takeaways
Learn Advance Excel Functionalities
Advance Problem solving Techniques within excel for effective results
Improvise over Data Analytical Skills
Cost and Time Saving Techniques
Innovative ways of Finding Solution
Increase efficiency and productivity
Make faster and better decisions on day to day basis
Key features include:
Skilled presenters (all presenters are Min 7 to 10 Years of experienced)
Practical training (based on the real life problems we encounter in our consulting)
Flexibility (if something comes up, you can attend the next public course)
Workshop Content (Designed as per Corporate Requirement)
For more details
email: raghvendraacharya77@gmail.com
 Salary:
      INR 1,50,000 - 4,25,000 P.A
      
 Industry:
      Banking / Financial Services / Broking
      
 Functional Area:
      Accounts, Finance, Tax, Company Secretary, Audit
      
 Role Category:
      Other
      
 Role:
      Trainee
      
 Keyskills:
      training carrier orientedany graduatesfinance and accountingworkshop excel techniqueschartstablevb vba auditing exerciseslogic development
      
    
    
    Desired Candidate Profile
 Education:
      
                UG - Any Graduate - Any Specialization, Graduation Not Required                
                 
PG - Any Postgraduate - Any Specialization, Post Graduation Not Required
Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required
PG - Any Postgraduate - Any Specialization, Post Graduation Not Required
Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required
Company Profile
iMap Technologies             
iMAP Technologies is a software development and web development 
company, offering complete software product engineering services.                   




