0(0)

Data Analysis with Excel

  • Categories DATA ANALYSIS
  • Total Enrolled 0
  • Last Update August 21, 2020

Description

Being able to analyze data is a powerful skill that helps you to make better decisions with your dataset. Microsoft Excel is one of the most widely used tools for data analysis.  It is widely used for many purposes including the likes of financial modeling and business planning. It can become a good stepping stone for people who are new to the world of business analytics. Even before learning R or Python, it is advisable to have knowledge of Excel. It does no harm to add Excel to your skillset. Excel, with its wide range of functions, visualizations, and arrays empowers you to quickly generate insights from data which would be hard to see otherwise. And this is a crucial aspect of any business analytics project.

Whether you dabble in Excel or use it heavily at your job, this course takes you from basic operations such as reading data into excel using various data formats, organizing and manipulating data, to various advanced functionality of Excel data analysis

Start learning today and become an Excel pro!

 

 

Main Features

  • Use Workbook analysis
  • Utilize new Excel features to analyze data
  • Streamline and Analyze Data with Excel PivotTables and Pivot Chart
  • Effectively summarize and present data clearly
  • Present external and Excel based organizational data using a combination of graphical and data views
  • Apply analysis techniques to datasets in Excel
  • Build presentation ready dashboards
  • Use appropriate charts in Excel

What is the target audience?

Course Target Audience:

This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities

  

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Basic Knowledge of Excel spreadsheets.
  • You should have a basic understanding of creating formulas and how cells are referenced by rows and columns within Excel.
149,999.00