Description
Excel Basics for Data Analysis is an introductory course in Excel software and its data analysis applications, published by Coursera Specialized Academy. Analysis project is one of the most complex analysis projects and Excel software can be of great help to specialists in this field as a tool. This complete course has been a step-by-step educational project, and what’s more, the educational videos only include a set of exercises and various demos that are unique in their own way. Excel is one of the most widely used data storage and analysis tools published and supported by Microsoft. Excel is quite versatile and can be used in business projects, marketing and marketing, data analysis, academic research, etc.
The use of this training is general and the materials presented are useful to others active in various fields dealing with data, in addition to data science engineers and analysts. Working with several Excel functions and, above all, searching, classifying, sorting, filtering data and creating pivot tables are some of the most important topics covered in this training.
What you will learn in Excel Basics for Data Analysis
- data science
- Working with different sheets in Excel software
- Various tools and functions of Excel software
- Data analysis with Excel software
- Storing and creating databases of information with Excel software
- PivotTables
- Managing data and using Excel formulas and functions
- Implementation of qualitative and quantitative evaluation techniques of input data to Excel software
- Filtering and sorting data based on different criteria and parameters
- Search functions
- And…
Course Specifications
Editor: Coursera
Instructors: Sandip Saha Joy and Steve Ryan
French language
Beginner level
establishment/university: IBM Skills Network
Number of weeks: 5
Duration: approx. 12 hours to complete
Courses included:
Week 1
Introduction to Data Analysis Using Spreadsheets
Week 2
Getting started with using Excel spreadsheets
Week 3
Data cleaning and management using spreadsheets
Week 4
Analyze data using spreadsheets
Week 5
Final project
Excel Basics for Data Analysis Prerequisites
none
Pictures
Introductory video on the basics of Excel for data analysis
Installation guide
After the clip, watch with your favorite reader.
Subtitle: English
Quality: 720p
Download links
File password(s): free download software
size
462 MB