Course Information
Course Overview
Master Google Sheets & Excel - Learn Complex Data Analysis. Become an Expert: Learn Pivot Tables, QUERY & many more
When its come to open source cloud based Spreadsheet solution Google sheet has no competition, however in the desktop based scenario MS Excel has the dominance. Even though both are have many similarities, the differences also need attention and required training. In this 14 hours of training with 127 lectures videos, you will be taken through the fundamentals of Excel and Google sheets till the Expertise level.
Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk or from your smartphone or tablet on the go Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
In this course you will learn the fundamentals as advance topics of Google Sheets (much of which can be used in MS Excel as well). You will not only learn the basics, like adding and subtracting. But you will also learn valuable advanced formulas like TEXT Function, LOGICAL Function, TEXT Function, LOOKUP Function and many more.
Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. Here you will trained from the very basic till the most advance level in the version 2010.
Course Content
- 10 section(s)
- 130 lecture(s)
- Section 1 Getting started in Google Sheets
- Section 2 Google Sheets: Mathematical Operators and Functions
- Section 3 Google Sheets: Logical Operators and Functions
- Section 4 Google Sheets: Text Functions and Text to Column
- Section 5 Google Sheets: Data Organizing and Formatting
- Section 6 Google Sheets: Data Naming, Linking and Validating
- Section 7 Google Sheets: Pivot Table and Chart Preparation
- Section 8 Google Sheets: Lookup and Reference Functions
- Section 9 Google Sheets: Date and Time Management
- Section 10 Google Sheets - Financial Functions
What You’ll Learn
- Good understanding of Google Sheets and Microsoft Excel at MIS level
- Expertise in Text, Logical and Math Function
- Expertise in Lookup and Reference Function
- Expertise in Date and Time Function
- Mastery in Pivot Table and Chart Preparation
- Mastery in 'What if Analysis' tools
- Data Validation, Filter and Conditional Formatting
- Managing data protection and data sharing in Excel
- Work with Macro Recording
- Working with Named Ranges and Link
- Working Knowledge of Financial Functions
- Creating amazing Google Forms
- Get to learn two most used Spreadsheet from basic to advance
Skills covered in this course
Reviews
-
JJanani
This class is very useful for me
-
SSunit Kushwaha
He delivered required information as it mentioned in course. He delivered use of functions from beginning to advance.
-
AAtharva Pandit
nice course
-
MMisheck Jim Mwamba
It is good and I am on it until I finish