Data Analysis with Microsoft Excel and Google Sheets
The "Microsoft Excel And Google Sheets For Data Analysis" course is a comprehensive and practical guide that equips learners with ...
Show more
Course details
Duration
Self-Paced Learning
Lectures
88
Video
10 Hours 21 Minutes
Level
All Levels
- Curriculum
- Reviews
SECTION 1: INTRODUCTION
SECTION 2: EXCEL AND GOOGLE SHEET BASICS
-
2
Getting Started With Excel -
3
Getting Started With Google Sheet
-
4
Worksheet Basics In Excel
-
5
Worksheet Basics In Google Sheet
-
6
Entering Values And Formulas In Excel
-
7
Entering Values And Formulas In Google Sheet
-
8
Data Formats In Excel
-
9
Data Formats In Google Sheet
-
10
Data Handling Basics Cut Copy And Paste In Excel
-
11
Data Handling Basics Cut Copy And Paste In Google Sheet
-
12
Saving And Printing In Excel
-
13
Saving And Printing In Google Sheet
SECTION 3: ESSENTIAL EXCEL GOOGLE SHEET FUNCTIONS
-
14
Basic Formula Operations In Excel
-
15
Basic Formula Operations In Google Sheet
-
16
Mathematical Functions In Excel Part 1
-
17
Mathematical Functions In Excel Part 2
-
18
Mathematical Functions In Google Sheet Part 1
-
19
Mathematical Functions In Google Sheet Part 2
-
20
Textual Functions In Excel Part 1
-
21
Textual Functions In Excel Part 2
-
22
Textual Functions In Google Sheet Part 1
-
23
Textual Functions In Google Sheet Part 2
-
24
Logical Functions In Excel
-
25
Logical Functions In Google Sheet
-
26
Date And Time Functions In Excel
-
27
Date And Time Functions In Google Sheet
-
28
Lookup Functions V Lookup Hlookup Index Match
-
29
Lookup Functions in Google Sheet
SECTION 4: NEW X LOOKUP ONLY FOR EXCEL 2021 AND OFFICE 365
SECTION 5: DATA TOOLS
SECTION 6: FORMATTING DATA AND TABLES
SECTION 7: PIVOT TABLES
SECTION 8: CHARTS
-
41
Excel Charts Categories Of Messages That Can Be Conveyed
-
42
Elements Of Charts
-
43
The Easy Way Of Creating Charts In Excel
-
44
The Easy Way Of Creating Charts In Google Sheet
-
45
Bar And Column Charts In Excel
-
46
Bar And Column Charts In Google Sheet
-
47
Formatting Charts In Excel Part 1
-
48
Formatting Charts In Excel Part 2
-
49
Formatting Charts In Google sheet
-
50
Line Charts In Excel
-
51
Line Charts In Google Sheet
-
52
Area Charts In Excel
-
53
Area Charts In Google Sheet
-
54
Pie And Doughnut Charts In Excel
-
55
Pie And Doughnut Charts In Google Sheet
-
56
Why We Should Avoid Pie Charts
-
57
Scatter Plot Or Xy Charts In Excel
-
58
Scatter Plot Or Xy Charts In Google Sheet
-
59
Frequency Distribution And Histograms In Excel
-
60
Frequency Distribution And Histograms In Google Sheet
-
61
Sparklines In Excel
-
62
Sparklines In Google Sheet
SECTION 9: PIVOT CHART
SECTION 10: MAP CHARTS
SECTION 11: SPECIAL PURPOSE CHARTS
SECTION 12: NAMED RANGES
SECTION 13: SHORTCUTS
SECTION 14: MACROS
SECTION 15: IMPORTING DATA FROM PDF AND WEBSITES
SECTION 16: ADVANCED EXCEL
SECTION 17: ADDONS IN GOOGLE SHEET
Stars 5
4
Stars 4
3
Stars 3
0
Stars 2
0
Stars 1
0
Google