Data Analytics with Excel

Book Description This Book will transform you into Data Analytics Expert . In this course you will learn how to use MS Excel to read, clean, transform, visualize and analyze the data. Course Outcomes A. Skills 1.Understand what is Data Analytics 2.Change in perception to view data 3.In depth knowledge in MS Excel 4.Creating Interactive and deep insight Dashboards 5.How to use Data Analytics for effective decision making B. Best Practices Experience on how to transform and model data, create advanced calculations and build stunning reports, publish your model, build a dashboard. C. Way Forward Recommendations and guidance on how to apply the knowledge acquired to resolve real problems at the workplace. Who can Apply for this course CMA, CA, MBA, Engineers, IT professionals, Banking and Finance professionals, Marketing, Suppy chain, Students in UG/PG programs, HSC passouts, and aspiring professionals of any other educational background. Jobs opportunities IT system analyst, Healthcare Data Analyst, Operations Analyst, Data Scientist, Data Analytics Consultant, Quantitative Analyst, Big Data Specialist Prospective Employers Banks, Insurance companies, Specialist software development companies, Consultancies, Telecommunications companies, Public sector organizations, Social media specialists, Colleges and universities, Pharmaceutical companies, Manufacturers. Title Page Copyright Contents Introduction to Data Analytics Applications of Data Analytics Real life examples of Data Analytics Basics & Navigation Formulas & Functions Functions Formatting Pivot Table & Slicer Power Query Power Pivot Charts & Dashboard Practice Files Link About The Author