Microsoft Excel and Google Sheets for Data Analysis

Focused View

Start-Tech Academy,Start-Tech Trainings

10:36:19

114 View

1 - Introduction

1 - Introduction.mp4

03:16

2 - Excel and Google Sheet basics

2 - Getting started with Excel.mp4

08:18

3 - Getting started with Google Sheet.mp4

03:07

4 - Course Resources.html

5 - Worksheet Basics in Excel.mp4

16:41

6 - Worksheet Basics in Google Sheet.mp4

05:09

7 - Entering values and Formulas in Excel.mp4

07:04

8 - Entering values and Formulas in Google Sheet.mp4

03:59

9 - Data Formats in Excel.mp4

08:36

10 - Data Formats in Google sheet.mp4

03:40

11 - Data Handling Basics Cut Copy and Paste in Excel.mp4

13:56

12 - Data Handling Basics Cut Copy and Paste in Google Sheet.mp4

04:30

13 - Saving and Printing in Excel.mp4

08:56

14 - Saving and Printing in Google Sheet.mp4

03:45

3 - Essential Excel Google Sheet functions

15 - Basic Formula Operations in Excel.mp4

13:10

16 - Basic Formula Operations in Google Sheet.mp4

04:40

17 - Mathematical Functions in Excel Part 1.mp4

11:35

18 - Mathematical Functions in Excel Part 2.mp4

07:31

19 - Mathematical Functions in Google Sheet Part 1.mp4

04:38

20 - Mathematical Functions in Google Sheet Part 2.mp4

03:32

21 - Textual Functions in Excel Part 1.mp4

08:45

22 - Textual Functions in Excel Part 2.mp4

08:37

23 - Textual Functions in Google Sheet Part 1.mp4

04:17

24 - Textual Functions in Google Sheet Part 2.mp4

03:58

25 - Logical Functions in Excel.mp4

11:13

26 - Logical Functions in Google Sheet.mp4

10:19

27 - DateTime Functions in Excel.mp4

06:59

28 - DateTime Functions in Google Sheet.mp4

04:54

29 - Lookup Functions V Lookup Hlookup IndexMatch.mp4

08:34

30 - Lookup Functions in Google Sheet.mp4

08:58

4 - New XLookup only for Excel 2021 and office 365

31 - XLookup as a replacement of Vlookup.mp4

09:17

32 - Handling NA and Approximates match in Xlookup.mp4

12:10

33 - Wildcard matching in XLookup.mp4

04:27

34 - Search modes in XLookup.mp4

05:08

5 - Data Tools

35 - Data Tools in Excel part 1.mp4

13:15

36 - Data Tools in Excel part 2.mp4

05:40

37 - Data Tools in Google Sheet.mp4

09:52

6 - Formatting data and tables

38 - Formatting data and tables in Excel.mp4

18:00

39 - Formatting data and tables in Google Sheet.mp4

06:08

7 - Pivot Tables

40 - Pivot Tables in Excel.mp4

08:25

41 - Pivot Tables in Google Sheet.mp4

06:19

8 - Charts

42 - Excel Charts Categories of messages that can be conveyed.mp4

02:09

43 - Elements of charts.mp4

05:23

44 - The easy way of creating charts in Excel.mp4

03:17

45 - The easy way of creating charts in Google Sheet.mp4

02:14

46 - Bar and column charts in Excel.mp4

12:38

47 - Bar and column charts in Google Sheet.mp4

05:11

48 - Formatting charts in Excel part 1.mp4

10:14

49 - Formatting charts in Excel part 2.mp4

04:58

50 - Formatting charts in Google sheet.mp4

07:02

51 - Line Charts in Excel.mp4

09:04

52 - Line Charts in Google Sheet.mp4

03:38

53 - Area Charts in Excel.mp4

05:51

54 - Area Charts in Google Sheet.mp4

04:47

55 - Pie and Doughnut Charts in Excel.mp4

12:58

56 - Pie and Doughnut Charts in Google Sheet.mp4

04:52

57 - Why we should avoid Pie charts.mp4

04:05

58 - Scatter plot or XY charts in Excel.mp4

16:17

59 - Scatter plot or XY charts in Google Sheet.mp4

04:45

60 - Frequency Distribution and Histograms in Excel.mp4

13:03

61 - Frequency Distribution and Histograms in Google Sheet.mp4

00:36

62 - Sparklines in Excel.mp4

05:43

63 - Sparklines in Google Sheet.mp4

02:18

9 - Pivot Chart

64 - Pivot Charts in Excel.mp4

05:05

65 - Pivot Charts in Google Sheet.mp4

04:18

10 - Map Charts

66 - Map charts in Excel.mp4

10:00

67 - Map charts in Google Sheet.mp4

02:37

11 - Special purpose charts

68 - Stock charts in Excel.mp4

11:28

69 - Stock charts in Google Sheet.mp4

02:27

70 - Radar charts in Excel.mp4

04:51

71 - Radar charts in Google Sheet.mp4

02:50

72 - Heatmaps in Excel.mp4

02:33

73 - Heatmaps in Google Sheet.mp4

02:33

12 - Named Ranges

74 - Named Ranges in Excel.mp4

10:04

75 - Named Ranges in Google Sheet.mp4

03:18

76 - Indirect Functions in Excel.mp4

05:38

77 - Indirect Functions in Google Sheet.mp4

02:45

13 - Shortcuts

78 - Shortcuts in Excel.mp4

12:33

79 - Shortcuts in Google Sheet.mp4

07:42

14 - Macros

80 - Macros in Excel.mp4

10:04

81 - Macros in Google Sheet.mp4

08:34

15 - New Importing data from PDF and websites

82 - Importing tables from PDF Excel 2021 and office 365.mp4

15:22

83 - Importing tables from PDF Google Sheet.mp4

02:54

84 - Importing data from Website Excel 2019 and above.mp4

11:26

85 - Importing data from Websites Google Sheet.mp4

03:07

16 - Advanced Excel

86 - Advanced Excel Analytics in Excel.mp4

15:48

87 - Solving a transportation problem using Excel.mp4

11:06

17 - Addons in Google sheet

88 - Addons in Google Sheet.mp4

09:57

89 - Sharing in Google Sheet.mp4

03:25

18 - Congratulations about your certificate

90 - The final milestone.mp4

01:33

91 - Bonus Lecture.html

Description

Unlocking the Power of Microsoft Excel and Google Sheets for In-Depth Data Analysis and Visualization

What You'll Learn?

Knowledge of all the essential Microsoft Excel and Google Sheets functions
Master Microsoft Excel and Google Sheets' most popular lookup functions such as Vlookup, Hlookup, Index and Match
Become proficient in Microsoft Excel and Google Sheets data tools like Sorting, Filtering, Data validations and Data importing
Harness full potential of Microsoft Excel and Google Sheets by creating Pivot tables with slicers
Visually enchant viewers using Bar charts, Scatter Plots, Histograms in Microsoft Excel and Google Sheets.
Make great presentations using the Conditional and Table formatting options in both Microsoft Excel and Google Sheets

Who is this for?

Anyone curious to master Microsoft excel and Google Sheets from beginner to advanced in short span of time

More details

Description
If you are looking to up your data analysis game and streamline your work with spreadsheets, then this course is for you. Do you struggle with organizing and analyzing large data sets in Microsoft Excel or Google Sheets? Or, are you looking for ways to make your data more visually appealing and easier to understand?
In this course, you will develop advanced skills in both Microsoft Excel and Google Sheets for data analysis. You will learn how to import, clean, and manipulate data, as well as create charts, graphs, and pivot tables to effectively communicate insights.
What's covered in this course
Setting up MSÂ Excel and Google Sheets
All essential functions such as mathematical, textual, logical, Lookup etc. in both MSÂ Excel and Google Sheets
Data visualization using popular charts and graphs in both MSÂ Excel and Google Sheets
Data analysis tools such as Pivot tables, Filtering and sorting, Data formating etc.
Advanced topics such as Indirect functions and Macros in both MSÂ Excel and Google Sheets
New topics such as dynamically importing data from PDFs and websites
Data analysis is a critical skill in today's business world, as organizations rely on data to make informed decisions. With the rise of big data, the demand for skilled data analysts has skyrocketed, making it a valuable skill to have in the job market.
Throughout the course, you will work with real-world data sets to practice your newly acquired skills. You will also receive hands-on instruction and guidance from an experienced data analyst, ensuring that you receive the best possible education.
What sets this course apart is its focus on both Microsoft Excel and Google Sheets. By learning both tools, you will be well-equipped to handle any data analysis task, no matter what software your organization uses.
Don't let data analysis stress you out any longer. Enroll in this course now and become a confident and skilled data analyst. Start making data-driven decisions with ease!
Who this course is for:
Anyone curious to master Microsoft excel and Google Sheets from beginner to advanced in short span of time

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Start-Tech Trainings

Instructor's Courses

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.