Data Analysis with Excel

Data Analysis with Excel

Data Analysis with Excel

oduc

Course 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.

Reviews

Average Rating

0
(0 rating)

Detailed Rating

0
0
0
0
0
Price ₦149,999.00
Instructor Loctech Admin
Duration 6 weeks
Lectures 95
Enrolled 59 students
Language English
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Wishlist 0
Open wishlist page Continue shopping