Key takeaways:
- Understand the use of Advanced Excel Functions
- Filter and Group
- To sort and sort in any way you want
- Group and sub group data for ease of use
- Understand shortcut techniques for efficient use of Excel
- How superpower functions can solve complex problems â??data validation, etc
- Analyse data like a professional
- Tips
- In Excel to help work faster
- To help you think in different ways and come out with logical solutions for a reporting requirement.
- To help in the preparation and planning required before working with a data for a desired result
Course Highlights:
- Name Manager
- Create From Selection
- Evaluate Formula Inline
- Evaluate Formula
- Text To Column
- Remove Duplicates
- Data Validation
- Keyboard Shortcuts
- Table Creation
- FILTERING
- SORTING
- COUNTIF
- COUNTIFS
- SUMIF
- SUMIFS
- IF
- IFERROR
- IFNA
- AND
- OR
Who should attend:
- Field Engineers / Project Engineers
- Project Managers
- Procurement / Vendor Development Managers
- Middle / Senior Management Executives
- Accounting Professionals
- HR Professionals
- Engineering Contractors
- Sales & Marketing Managers
- Quantity Surveyors and Cost Managers
- IT graduates, BSc-IT, BCA, MCA, MSc-IT etc
- Management Professionals â?? (BBA, MBA)
- Faculties and Research Scholars
- Students
Pre - Requisite:
- Used Excel in Daily Work For At Least 2 Years
- Understand Concept of Rows, Columns, Sheet Tabs, Workbook
- Understand QAT
- Understand How to Add Buttons To QAT
- Understand Relative Cell References
- Copy-Paste Special
- Text Formulas
- Edit Excel Sheets
- Delete Rows, Columns
- Add Rows, Columns
- Understand Formula Operators and Precedence
Training Methodology:
- Training will cover a presentation by the trainer to start with explaining the knowledge area followed by real world examples.
- An actual case will be given to trainees to try the skills learnt on the M S Excel software and they will be guided step by step in preparing a workable schedule. They will be exposed to possible situations, constraints faced in the real scenario.
- Q&A sessions to reinforce the understanding of the knowledge area.
Please note:
- The excel work sheet with answers will be shared with the participants at the end of the class
- Participants are to bring their own laptops with MS Excel 2010 or later. 10 workstations are available on first come first use basis for those who donâ??t have a laptop
Registration details:
Delegate fee includes Course material, Certification and Refreshments.
Fee for the program may be paid by Cash / Demand Draft / Cheque, payable at Bangalore, India. The cheque / draft should be in favour of â??Aadhya Didactics Pvt. Ltd.â??
For Direct transfer of Delegate fee, Bank details will be given on request.
For Registration forms and more information, please contact Ms. Divya K / Ms. Megha
What you need to bring Interest and passion to learn.