Key takeaways
- Understand the use of Advanced Excel Functions
- Gain Insights from analysis of vast array of data with ease
- Make powerful dashboards
- Understand shortcut techniques for efficient use of Excel
- Using PivotTables to turn raw data into clear information that supports key decisions
- Using advanced graphs and presentation techniques to maximise impact
- How superpower functions can solve complex problems â?? lookups, 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
- How to use Excel only through Keyboard and save the working time
Course Highlights
- Brief Coverage Of Basics of Excel
- Conditional Formatting
- Index and Match
- Graphs
- Pivot Table & Graphs
- What If Analysis
- Subtotal â?? Function and
- Tables
- Lookup functions
- Keyboard Shortcuts
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
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.
Batch
- Weekdays
- Weekend
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, Soft copy of presentation, Evaluation, 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