Course Overview - MS Excel analytics

There’s a lot more to Microsoft Excel than SUM and COUNT. Companies and institutions around the world use Excel’s powerful functions to efficiently transform mountains of raw data into clear insights, and now you can too.

In this course, you’ll develop employable analyst skills as you learn how to use, time-saving keyboard shortcuts, convert and clean data types including text, times, and dates, and build impressive logic functions and conditional aggregations. Through hands-on practice, you’ll learn over 35 new Excel functions, including CONCATENATE, VLOOKUP, and AVERAGEIF(S), and work with real-world Kickstarter data as you use your newfound Excel skills to analyze what makes a successful project
.

Our Capabilities

Our Instructor Success where he focuses on fostering long-term, productive relationships between DataCamp and the instructional community. Previously, he worked in Non-profit management as well as data analytics adult education. His career has always centered around her two main passions - people and data!

The Approach

  • Understand the importance of data analytics in today's business.
  • Understand the types of Business analytics and real-life examples of Business analytics.
  • How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.

Value Advantage

 

  • Understand and Identify the principles of data analysis
  • Build presentation-ready dashboards in Excel
  • Apply analysis techniques to datasets in Excel

Course Information

  • Lectures:20
  • Quizzes:4
  • Seat Availble:7
  • Duration:4 Week
  • Course Price:7500 INR