What is this courseabout
This training would be very useful toparticipants across various industries and functional specializations such asMIS, Finance, Marketing, Operations, Human Relations, Information Technologyand Administration.
This interactive training targets specificbusiness situations, and then demonstrates how to create spreadsheets for thoseproblem areas. Attend these extraordinary, information-packed, powerfulsessions to increase your productivity, improve the quality, accuracy &make a better report.
This course is recommended for end usersseeking proficiency in the use of Microsoft Excel 2013 at advanced level orseeking to obtain Microsoft Office Specialist (MOS) certification in MicrosoftExcel 2013.
What are the coursedeliverables?
Scope of Learning:
User able to manage data independently
User able to do reports (eg: Financial,Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc)
User will become data analyst
User will able to do MIS reports
Maximum organization willuse the excel
It requires day to dayactivities to manage & analyse the data
High impact, proventraining – 30000+ professionals trained globally
Experienced, expertinstructors – Our Instructors come with a rich, 10+ years of industryexperience.
Classroom Trainingprograms delivered across 50+ locations globally
Content is developedin-house in GreyCampus by highly experienced industry experts
ProgramHighlights
Course Objectives:
At the end of thetraining the participants would learn/use/acquire the followingtechniques/knowledge:
• Excel Advancements –some amazing features incorporated only in last 5 years
• Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP,INDEX and MATCH
• Advanced Data Sorting and Filtering techniques
• Generating Pivot Tables and Charts from complex datasets, instantly
• Implementing Slicers and Sparklines to build interactive dashboards
• Exploring Data Validation techniques and creating dynamic lists
• Using What-If-Analysis and Data representation techniques
