Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 31 Minute(s)
Language
English
Taught by
Emmanuel Chukwudi Onyewuchi
Rating
Course Overview
Learn how to create, manipulate, visualize and analyze data with Microsoft Excel and Google Sheet
Develop your Data Analysis Skills, learn how to create, manipulate, visualize and analyze data with Microsoft Excel & Google Sheet
Spreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence.
This course is designed to take you from a beginner to an intermediate level when it comes to spreadsheet software.
You will learn the environment of the top 2 spreadsheet software that is often used in the workspace today, with insights and skills on these top 2 spreadsheet software you will be able to deal with every other spreadsheet tool that comes your way.
This course is divided into 2 major modules:
1. Microsoft Excel Spreadsheet
In this module, you will learn how to organize, manipulate and analyze data with Microsoft Excel. The lectures in the Microsoft excel module are created with Microsoft Excel 2013 version, but with any version of Microsoft office from 2010 to the latest version will be able to follow through this course.
2. Google Sheet
In this Module, you will learn how to organize, manipulate and analyze data with Google Sheet.
More Concepts and guides delivered in this course:
Understanding the environment of Microsoft Excel and Google Sheet
How to create, save, and open a workbook.
Data entry, cell formatting, working with multiple worksheets and
Discover how to format dates and numbers.
Discover the essentials of using formulas and functions.
How to rename, insert, move, and reference an Excel worksheet.
Discover how to create charts and graphs
Learn practical methods to sort and filter your data
Learn visualize data with chart and SmartArt
Discover how to analyze data with a Pivot table and pivot chart
And more
Course Content
- 3 section(s)
- 41 lecture(s)
- Section 1 Introduction
- Section 2 Microsoft Excel Spreadsheet
- Section 3 Google Sheet
What You’ll Learn
- Spreadsheet 101-Understand the concepts of Spreadsheet software
- How to create, organize, analyze, manipulate data with Microsoft Excel and Google sheet
- How to use Autosum, Subtotal, IF function to perform simple and complex calculations
- How to sort and filter data with Microsoft Excel and Google sheet
- How to use chart and pivot table to analysis data
- How To Automate Repetitive Task With Macro
- And lots more
Skills covered in this course
Reviews
-
AAllison Beck
Very comprehensive overview. Enjoyed the class
-
RRoma Gupta
It was really great course in terms of understanding and learning. Easy to grasp and use of it will be on the daily basis which I personally liked the most.
-
YYousra Kaddah
It was a good match for me. It is informative and helpful. It was easy to follow the instructions; however, some were repetitive. There was a technical issue in the first part of this course. The videos after video # 11 don't work properly even after I open my account on my laptop. The part of the Google sheet was working very well. Overall, it is perfect and helpful. Thank you!
-
JJalal mohammed
i was more interested in the google sheet tutorial , its been a great experience so far. thank you
