Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Google Sheets and Microsoft Excel at Once from Basic
Rating: 4.3 out of 5(569 ratings)
39,908 students

Learn Google Sheets and Microsoft Excel at Once from Basic

Master Google Sheet and Excel from the ground up with this comprehensive beginner's course
Created byLearnify IT
Last updated 5/2026
English

What you'll learn

  • Foundations of Spreadsheets
  • Data Entry and Formatting
  • Formulas and Functions
  • Data Analysis and Visualization
  • Collaboration and Sharing
  • Advanced Features
  • Tips and Tricks for Efficiency

Course content

2 sections30 lectures4h 5m total length
  • Introduction3:04
  • Opening up google sheets7:47

    Open Google Sheets in your browser and start a blank sheet or choose a template. Save automatically to Google Drive while online, after signing in with your Google account.

  • Cell, Rows Columns and Menu bar.mp49:56
  • Language4:18

    Learn to configure language settings, switch display languages, add languages, and use the detect language (text language) function in Google Sheets and Excel to identify cell language.

  • Basic mathematical functions11:09

    Master basic Google Sheets formulas, including sum, subtraction, multiplication, division, percent, and concatenate with ampersand. Anchor cells using F4, use the fill handle, and work with relative and absolute references.

  • Sum, Count, Counta9:31
  • Useful features for report design10:56
  • Useful shortcut keys10:49

    Learn basic and useful keyboard shortcuts for Google Sheets to speed up work. The lesson covers ctrl+n, ctrl+c/x/v, find, select all, undo/redo, and navigation tips.

  • Data Validation Drop down list11:44
  • Importing range14:23
  • CSV to Google sheet6:25

    Master importing CSV files into Google Sheets using add-ons like coefficient, from files or URLs, and leverage VLOOKUPs and pivots to organize data.

  • Vlookup Hlookup6:00
  • Date functions7:37
  • Class Project 18:50
  • Class Project 27:38

Requirements

  • Basic computer skill

Description

Master Two Spreadsheet Giants: Learn Google Sheets and Microsoft Excel Simultaneously from the Ground Up

In today's data-driven world, spreadsheet proficiency is an essential skill for anyone aiming to excel in their professional or personal endeavors. This comprehensive course empowers you to master both Google Sheets and Microsoft Excel, two of the most widely used spreadsheet applications, equipping you with the skills to tackle data analysis, organization, and presentation with newfound confidence.


Learn the Essentials of Both Platforms:
Google Sheets: Master the user-friendly interface of Google Sheets, gaining proficiency in data entry, formula creation, and chart generation.

Microsoft Excel: Explore the advanced capabilities of Microsoft Excel, delving into data analysis, pivot tables, and macros.


What You'll Learn:

  1. Foundations of Spreadsheets:

    • Understand the basics of spreadsheet terminology and functionality

    • Navigate the user interfaces of both Google Sheets and Microsoft Excel seamlessly

  2. Data Entry and Formatting:

    • Learn efficient data entry techniques

    • Master formatting options to make your spreadsheets visually appealing and easy to understand

  3. Formulas and Functions:

    • Explore the power of formulas and functions common to both Google Sheets and Excel

    • Create complex calculations to automate and analyze your data

  4. Data Analysis and Visualization:

    • Utilize pivot tables and charts for insightful data analysis

    • Learn how to represent your findings visually for effective communication

  5. Collaboration and Sharing:

    • Understand collaborative features in Google Sheets, such as real-time editing and comments

    • Explore Excel's sharing capabilities and version control

  6. Advanced Features:

    • Dive into advanced features like macros and scripting to automate repetitive tasks

    • Discover unique capabilities in both platforms for enhanced productivity

  7. Tips and Tricks for Efficiency:

    • Receive insider tips and shortcuts to boost your efficiency in both Google Sheets and Microsoft Excel

Why Take This Course:

  • Time Efficiency: Learn both Google Sheets and Microsoft Excel in one comprehensive course, saving you time and effort.

  • Versatility: Gain proficiency in the two most widely used spreadsheet platforms, making you versatile in any professional setting.

  • Hands-On Practice: Apply your knowledge through practical exercises and real-world examples.

Whether you're a student, professional, or entrepreneur, mastering both Google Sheets and Microsoft Excel will open doors to endless possibilities.

Who this course is for:

  • Beginner who want to learn google sheet and excel at once