Learn Google Sheets and Microsoft Excel at Once from Basic

Name: Learn Google Sheets and Microsoft Excel at Once from Basic
Rating: 4.3 (569 reviews)

Master Google Sheet and Excel from the ground up with this comprehensive beginner's course

Created byLearnify IT

Last updated 5/2026

English

English [Auto],

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 sections • 30 lectures • 4h 5m total length

Introduction3:04
Discover how Google Sheets functions as a cloud-based spreadsheet for organizing, analyzing, and collaborating on data across devices, with real-time collaboration and browser-based access.
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
Learn cell, rows, and columns in Google Sheets, including relative and absolute references and basic sum formulas, plus the menu bar features and Excel comparison.
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
Explore Google Sheets and Microsoft Excel functions such as sum, count, counta, and count unique to analyze data and count distinct values across ranges.
Useful features for report design10:56
Discover five powerful report-design features in Google Sheets: copy ranges to another spreadsheet, insert hyperlinks for navigation, group rows and columns, apply alternating colors, and define a custom theme.
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
Learn how to import a range from one google sheets spreadsheet to another using query, select specific columns, where conditions, and import range with proper permissions.
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
Master Vlookup and Hlookup in Google Sheets and Excel by learning how to set the search key, choose the data range, select the index, and apply exact-match for precise results.
Date functions7:37
Explore date functions in Google Sheets and Excel, including today, tomorrow, yesterday, and date arithmetic, and learn to extract day, month, and year and adjust dates.
Class Project 18:50
Learn how to transpose data in Google Sheets to create a horizontal range and use the HLOOKUP function for horizontal lookups, with practical steps and tips.
Class Project 27:38
Class project 2 demonstrates using index and match in google sheets and excel to retrieve sales data, and enhances presentation with data validation and a brand dropdown list.

Intro3:40
Master the basics of Microsoft Excel, including the interface, navigation, data entry and formatting, essential formulas, and key data analysis with sorting, filtering, and tables.
Introduction and opening up Excel spreadsheet8:20
Discover how Microsoft Excel functions as a versatile spreadsheet for data organization and analysis, with templates, charts, and time-saving tips for opening new spreadsheets.
File tab8:28
Discover the file tab in Microsoft Excel, including opening recent workbooks, pinning items, and using OneDrive and browse features, plus protecting, inspecting, and sharing workbooks.
Home. Insert Page layout4:20
Discover the essentials of the home, insert, and page layout tabs in Microsoft Excel, including clipboard, fonts, alignment, charts, sparklines, tables, filters, and printing options.
Formula, Data, Review, View10:33
Explore the core Microsoft Excel tabs, from formulas and data to review and view, and learn to navigate options, formula auditing, and tools for building, analyzing, and protecting workbooks.
Errors13:16
Learn to diagnose and fix common Microsoft Excel errors, including hash, value, spell, name, hash spill, hash ref, deviation zero, and Na Excel error, using provided practice data.
Logical Functions13:59
Explore essential logical functions in Excel, including and, or, not, and xor, to evaluate multiple conditions and produce true or false results for data analysis.
Relative absolute cell reference4:17
Learn how relative and absolute cell references work in Microsoft Excel, including anchoring with F4, using the fill handle, and dragging formulas for consistent results.
Switch, Cell Row6:25
Learn how to use switch, cell, and row functions in Microsoft Excel to map numbers to days, reference cells, and determine row position with absolute and relative references.
IF, IFS Nested IF10:38
Explore core Excel functions, IF, IFS, and nested IF, and learn how logical tests return results, handle multiple conditions, and build nested chains for decision rules.
Keyboard Shortcuts10:53
Learn essential Microsoft Excel keyboard shortcuts to speed up work, including Ctrl N for new workbooks, Ctrl O, Ctrl S, Ctrl C/X/V, Ctrl Z/Y, and navigate with Tab and arrows.
Pivot Table Filter Data6:03
Learn to filter a data range and build a pivot table to analyze year and end balance, while reinforcing data validation concepts.
Class Project 16:29
Apply basic accounting functions in Excel to complete a five-step class project that analyzes credits, totals, averages, and profit. Learn lookups with VLOOKUP and replace techniques.
Class Project 27:36
Organize data in Excel by applying data validation, creating a drop down list, and building a pivot table to summarize, analyze, and visualize datasets.
How to Take Help of AI Learn Google Sheets and Microsoft Excel at Once from B...0:04

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:

Foundations of Spreadsheets:
- Understand the basics of spreadsheet terminology and functionality
- Navigate the user interfaces of both Google Sheets and Microsoft Excel seamlessly
Data Entry and Formatting:
- Learn efficient data entry techniques
- Master formatting options to make your spreadsheets visually appealing and easy to understand
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
Data Analysis and Visualization:
- Utilize pivot tables and charts for insightful data analysis
- Learn how to represent your findings visually for effective communication
Collaboration and Sharing:
- Understand collaborative features in Google Sheets, such as real-time editing and comments
- Explore Excel's sharing capabilities and version control
Advanced Features:
- Dive into advanced features like macros and scripting to automate repetitive tasks
- Discover unique capabilities in both platforms for enhanced productivity
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

Learn Google Sheets and Microsoft Excel at Once from Basic

What you'll learn

Explore related topics

Course content

Google Sheet15 lectures • 2hr 10min

Excel15 lectures • 1hr 55min

Requirements

Description

Who this course is for: