Microsoft Excel for Data Analyst - Online Self Learning
GreyCampus Inc.
Summary
- Certificate of completion - Free
Overview
Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's Data Analysis features to the maximum, rather than focusing on individual Excel functions and features.
Description
This training would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.
This interactive training targets specific business situations and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report.
Course Objectives
At the end of the training the participants would learn/use/acquire the following techniques/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
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 will use the excel
-
It requires day to day activities to manage & analyse the data
-
High impact, proven training – 30000+ professionals trained globally
-
Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.
-
Classroom Training programs delivered across 50+ locations globally
-
Content is developed in-house in GreyCampus by highly experienced industry experts
Who is this course for?
This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.
Requirements
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.