Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Sheets + MS Excel Course: Basic to Advance Level
Rating: 4.4 out of 5(39 ratings)
184 students

Google Sheets + MS Excel Course: Basic to Advance Level

Master Google Sheets & Excel - Learn Complex Data Analysis. Become an Expert: Learn Pivot Tables, QUERY & many more
Created byHimanshu Dhar
Last updated 11/2025
English
English [Auto],

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

Course content

30 sections • 130 lectures • 14h 30m total length

  • Understanding Google Sheets9:29

    Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. In this you will have a good understanding of it.

    Also download the Practice File from Resource option. Practice along with the lectures for better understanding.

  • Autofill and Smartfill option8:27

Requirements

  • Basic Computer Knowledge

Description

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.


Who this course is for:

  • Seeking career in MIS and Data Management

Report abuse