toggle menu

Microsoft Excel And Google Sheets For Data Analysis

Buy Course Now
Study Mode: Online / Offline
Enrolled: 832 students
Course view: 2476
Duration: Self-Paced Learning
Lectures: 88
Course Materials: Downloadable Videos
Video: 10 Hours 21 Minutes
Course type: All Levels
Certificate of Completion: FREE
Microsoft Excel And Google Sheets For Data Analysis

Course Overview

The “Microsoft Excel And Google Sheets For Data Analysis” course is a comprehensive and practical guide that equips learners with the essential skills needed to effectively use these two popular spreadsheet software tools for data analysis. Covering everything from the basics to advanced features, this course empowers participants to harness the full potential of Microsoft Excel and Google Sheets for various data-related tasks.

 

Who Needs This Course

This course is valuable for a diverse audience, including:

Business Professionals: Professionals working in various industries who need to analyze data, create reports, and make data-driven decisions.

Students: Students pursuing degrees in business, finance, economics, or any field that requires data analysis skills.

Data Analysts: Individuals interested in or pursuing a career in data analysis who want to build a strong foundation in using spreadsheet software.

Entrepreneurs: Business owners who need to manage and analyze data related to their ventures.

Researchers: Researchers in academia or other fields who want to effectively organize and analyze research data.

Anyone Interested in Data Analysis: Anyone looking to enhance their data analysis skills, whether for personal or professional use.

 

Benefits for Learners

Enrolling in the “Microsoft Excel And Google Sheets For Data Analysis” course offers learners a multitude of benefits:

Fundamental Spreadsheet Skills: Develop a strong understanding of the basics of both Microsoft Excel and Google Sheets, including creating worksheets, entering data, and formatting.

Advanced Functions: Master a wide range of functions, from mathematical and textual functions to lookup and logical functions, making data analysis more efficient.

Data Handling Techniques: Learn data handling techniques such as cut, copy, paste, and explore data tools for data cleansing and organization.

Data Visualization: Create compelling charts and graphs to visualize data, including bar charts, line charts, pie charts, and more.

Pivot Tables: Understand and use pivot tables for data summarization and analysis.

Named Ranges: Discover how to use named ranges and the INDIRECT function for efficient data referencing.

Keyboard Shortcuts: Increase efficiency with keyboard shortcuts for both Excel and Google Sheets.

Macros: Gain knowledge of macros to automate repetitive tasks in Excel.

Importing Data: Learn how to import data from PDFs and websites, a valuable skill for data extraction.

Advanced Excel: Explore advanced Excel features for analytics, including solving transportation problems.

Google Sheets Add-ons: Understand Google Sheets add-ons and sharing capabilities.

 

By the end of this course, learners will have acquired the skills and knowledge necessary to confidently work with data in Microsoft Excel and Google Sheets. Whether you’re a professional seeking to enhance your data analysis capabilities or a student looking to excel in data-related coursework, this course provides a comprehensive foundation in spreadsheet data analysis.

SECTION 1: INTRODUCTION

1
Introduction To Microsoft Excel And Google Sheets
3 Min 17 Sec

SECTION 2: EXCEL AND GOOGLE SHEET BASICS

1
Getting Started With Excel
8 Min 18 Sec
2
Getting Started With Google Sheet
3 Min 8 Sec
3
Worksheet Basics In Excel
16 Min 42 Sec
4
Worksheet Basics In Google Sheet
5 Min 9 Sec
5
Entering Values And Formulas In Excel
7 Min 5 Sec
6
Entering Values And Formulas In Google Sheet
4 Min
7
Data Formats In Excel
8 Min 37 Sec
8
Data Formats In Google Sheet
3 Min 41 Sec
9
Data Handling Basics Cut Copy And Paste In Excel
13 Min 56 Sec
10
Data Handling Basics Cut Copy And Paste In Google Sheet
4 Min 30 Sec
11
Saving And Printing In Excel
8 Min 57 Sec
12
Saving And Printing In Google Sheet
3 Min 46 Sec

SECTION 3: ESSENTIAL EXCEL GOOGLE SHEET FUNCTIONS

1
Basic Formula Operations In Excel
13 Min 10 Sec
2
Basic Formula Operations In Google Sheet
4 Min 40 Sec
3
Mathematical Functions In Excel Part 1
11 Min 36 Sec
4
Mathematical Functions In Excel Part 2
7 Min 31 Sec
5
Mathematical Functions In Google Sheet Part 1
4 Min 39 Sec
6
Mathematical Functions In Google Sheet Part 2
3 Min 33 Sec
7
Textual Functions In Excel Part 1
8 Min 46 Sec
8
Textual Functions In Excel Part 2
8 Min 37 Sec
9
Textual Functions In Google Sheet Part 1
4 Min 17 Sec
10
Textual Functions In Google Sheet Part 2
3 Min 59 Sec
11
Logical Functions In Excel
11 Min 14 Sec
12
Logical Functions In Google Sheet
10 Min 19 Sec
13
Date And Time Functions In Excel
7 Min
14
Date And Time Functions In Google Sheet
4 Min 54 Sec
15
Lookup Functions V Lookup Hlookup Index Match
8 Min 34 Sec
16
Lookup Functions in Google Sheet
8 Min 59 Sec

SECTION 4: NEW X LOOKUP ONLY FOR EXCEL 2021 AND OFFICE 365

1
XLookup As A Replacement Of Vlookup
9 Min 17 Sec
2
Handling NA And Approximates Match In Xlookup
12 Min 10 Sec
3
Wildcard Matching In XLookup
4 Min 28 Sec
4
Search Modes In XLookup
5 Min 8 Sec

SECTION 5: DATA TOOLS

1
Data Tools In Excel Part 1
13 Min 16 Sec
2
Data Tools In Excel Part 2
5 Min 40 Sec
3
Data Tools In Google Sheet
9 Min 52 Sec

SECTION 6: FORMATTING DATA AND TABLES

1
Formatting Data And Tables In Excel
18 Min 1 Sec
2
Formatting Data And Tables In Google Sheet
6 Min 8 Sec

SECTION 7: PIVOT TABLES

1
Pivot Tables In Excel
8 Min 25 Sec
2
Pivot Tables In Google Sheet
6 Min 19 Sec

SECTION 8: CHARTS

1
Excel Charts Categories Of Messages That Can Be Conveyed
2 Min 10 Sec
2
Elements Of Charts
5 Min 23 Sec
3
The Easy Way Of Creating Charts In Excel
3 Min 18 Sec
4
The Easy Way Of Creating Charts In Google Sheet
2 Min 14 Sec
5
Bar And Column Charts In Excel
12 Min 38 Sec
6
Bar And Column Charts In Google Sheet
5 Min 12 Sec
7
Formatting Charts In Excel Part 1
10 Min 14 Sec
8
Formatting Charts In Excel Part 2
4 Min 59 Sec
9
Formatting Charts In Google sheet
7 Min 2 Sec
10
Line Charts In Excel
9 Min 5 Sec
11
Line Charts In Google Sheet
3 Min 38 Sec
12
Area Charts In Excel
5 Min 52 Sec
13
Area Charts In Google Sheet
4 Min 47 Sec
14
Pie And Doughnut Charts In Excel
12 Min 58 Sec
15
Pie And Doughnut Charts In Google Sheet
4 Min 52 Sec
16
Why We Should Avoid Pie Charts
4 Min 6 Sec
17
Scatter Plot Or Xy Charts In Excel
16 Min 17 Sec
18
Scatter Plot Or Xy Charts In Google Sheet
4 Min 46 Sec
19
Frequency Distribution And Histograms In Excel
13 Min 3 Sec
20
Frequency Distribution And Histograms In Google Sheet
37 Sec
21
Sparklines In Excel
5 Min 44 Sec
22
Sparklines In Google Sheet
2 Min 18 Sec

SECTION 9: PIVOT CHART

1
Pivot Charts In Excel
5 Min 6 Sec
2
Pivot Charts In Google Sheet
4 Min 18 Sec

SECTION 10: MAP CHARTS

1
Map Charts In Excel
10 Min
2
Map Charts In Google Sheet
2 Min 38 Sec

SECTION 11: SPECIAL PURPOSE CHARTS

1
Stock Charts In Excel
11 Min 28 Sec
2
Stock Charts In Google Sheet
2 Min 27 Sec
3
Radar Charts In Excel
4 Min 51 Sec
4
Radar Charts In Google Sheet
2 Min 50 Sec
5
Heatmaps In Excel
2 Min 34 Sec
6
Heatmaps In Google Sheet
2 Min 34 Sec

SECTION 12: NAMED RANGES

1
Named Ranges In Excel
10 Min 4 Sec
2
Named Ranges In Google Sheet
3 Min 19 Sec
3
Indirect Functions In Excel
5 Min 38 Sec
4
Indirect Functions In Google Sheet
2 Min 45 Sec

SECTION 13: SHORTCUTS

1
Shortcuts In Excel
12 Min 33 Sec
2
Shortcuts In Google Sheet
7 Min 42 Sec

SECTION 14: MACROS

1
Macros In Excel
10 Min 5 Sec
2
Macros In Google Sheet
8 Min 35 Sec

SECTION 15: IMPORTING DATA FROM PDF AND WEBSITES

1
Importing Tables From Pdf Excel 2021 And Office 365
15 Min 22 Sec
2
Importing Tables From Pdf Google Sheet
2 Min 54 Sec
3
Importing Data From Website Excel 2019 And Above
11 Min 26 Sec
4
Importing Data From Websites Google Sheet
3 Min 7 Sec

SECTION 16: ADVANCED EXCEL

1
Advanced Excel Analytics In Excel
15 Min 49 Sec
2
Solving A Transportation Problem Using Excel
11 Min 7 Sec

SECTION 17: ADDONS IN GOOGLE SHEET

1
Addons In Google Sheet
9 Min 58 Sec
2
Sharing In Google Sheet
3 Min 25 Sec

Be the first to add a review.

Please, login to leave a review
Microsoft Excel And Google Sheets For Data Analysis
Price:
₦10,000 ₦3,000
Layer 1
Login Categories