Sign In
    Saved
      Sign In
      Saved

Spreadsheet Fundamentals by DataCamp

tag
Total Duration
15 Hours

Join millions of people using Google Sheets and Microsoft Excel on a daily basis and learn the fundamental skills necessary to analyze data in spreadsheets! The skills you learn in these courses will empower you to join tables, summarize data, and answer your data analysis and data science questions.

Courses in this Learning Path
1
Data Analysis in Spreadsheets
DataCamp Course via DataCamp
learnpath-img
Duration : 3 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Data Analysis in Spreadsheets

This course will give you a deeper understanding about some of the core functions in Google Sheets. There are a number of predefined functions that we will be covering, such as SUM(), VLOOKUP ()`.., and AVERAGE ()`,,. These methods can be used to analyze school grades, track company performance statistics, track monthly revenues, and view real geographical information about countries around world.

2
Intermediate Spreadsheets
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Intermediate Spreadsheets

This course will expand your Google Sheets vocabulary. This course will teach you how to use Google Sheets to manipulate logical and numerical data. Learn how to calculate summary statistics, and what error and missing types you can expect. Data sets will be provided on 100m sprint world records, asteroid close encounters and benefit claim.

3
Pivot Tables in Spreadsheets
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Pivot Tables in Spreadsheets

Large amounts of data can be difficult and time-consuming to manage in spreadsheets. Would you like a quick and efficient way to organize and analyze all your data? Pivot Tables are the solution! This course will teach you how to quickly and efficiently organize thousands of datapoints using Google Sheets. We'll be looking at the average rainfall of several US cities as well as the Top 10 …

Read More
4
Data Visualization in Spreadsheets
DataCamp Course via DataCamp
learnpath-img
Duration : 4 hours
Price :₹1,093
Level :Intermediate
Learn Type :Certification
Data Visualization in Spreadsheets

A picture can convey a thousand words but only if it is the right one. This course will show you how to use Google Sheets for data visualization. You will learn how to create simple chart types, such as histograms, scatter charts and bar charts. Also, you'll learn how to create more complicated types like sparkline or candlestick. How to prepare data, how to use Data Validation and VLookup …

Read More