Great Lessons
Google Sheets vs Excel: What is the difference? Both of them structure data in tabular format. In other words, the data is in the form of rows and columns. The major difference between Excel and Google Sheets is that you can share the link of Google Sheets with anyone and they can edit the file ...
To Register in Course you have to watch at least 30 Second of any lesson
What You'll Learn
-
Create and format spreadsheets efficiently using Google Sheets tools and functions
-
Collaborate in real-time with team members on shared Google Sheets documents
-
Utilize formulas and functions to automate calculations and data analysis in Google Sheets
-
Apply data validation and conditional formatting to enhance spreadsheet accuracy and readability
-
Import, export, and connect Google Sheets with other data sources and applications
-
Use Google Sheets add-ons and scripts to extend functionality and automate workflows
-
Create dynamic charts and graphs to visualize data insights effectively
-
Manage multiple sheets and organize data for complex project tracking and reporting
-
Implement data sorting, filtering, and pivot tables for advanced data analysis
-
Share and control access permissions to ensure data security and collaboration control
-
Track changes and version history to monitor edits and revert to previous versions
-
Integrate Google Sheets with Google Drive and other Google Workspace tools seamlessly
-
Apply best practices for data entry, cleaning, and validation to maintain data integrity
-
Use keyboard shortcuts and tips to increase productivity in Google Sheets
-
Create templates and reusable spreadsheets for consistent data management
-
Troubleshoot common issues and optimize Google Sheets performance for large datasets
Course Content
144 Lessons • 5 h 38 m total
Google Sheets Tutorial Lesson 1 Accessing Google Sheets
Google Sheets Tutorial Lesson 2 Interface
Google Sheets Tutorial Lesson 3 Creating and Saving Spreadsheets
Google Sheets Tutorial Lesson 4 Copy Spreadsheets
Google Sheets Tutorial Lesson 5 Renaming Spreadsheets
Google Sheets Tutorial Lesson 6 Moving Spreadsheets
Google Sheets Tutorial Lesson 7 Deleting Files
Google Sheets Tutorial Lesson 8 Entering Data
Google Sheets Tutorial Lesson 9 Format Text
Google Sheets Tutorial Lesson 10 Font and Font Size
Google Sheets Tutorial Lesson 11 Rearrange Column and Row Size
Google Sheets Tutorial Lesson 12 Auto Fill Data
Google Sheets Tutorial Lesson 13 Text Alignment
Google Sheets Tutorial Lesson 14 Insert and Delete Rows and Columns
Google Sheets Tutorial Lesson 15 Move Rows and Columns
Google Sheets Tutorial Lesson 16 Copy and Clear Rows and Columns
Google Sheets Tutorial Lesson 17 Add Delete and Rename Sheets
Google Sheets Tutorial Lesson 18 Duplicate Sheets and Rearranging Sheets
Google Sheets Tutorial Lesson 19 Copying Sheets to Different Files
Google Sheets Tutorial Lesson 20 Color Sheet Tabs
Google Sheets Tutorial Lesson 21 Upload Image in Cell and Over Cell
Google Sheets Tutorial Lesson 22 Image Options
Google Sheets Tutorial Lesson 23 Add Google Image Search Image
Google Sheets Tutorial Lesson 24 Insert Google Drive Image
Google Sheets Tutorial Lesson 25 Insert Image from Photos
Google Sheets Tutorial Lesson 26 Insert Image by URL
Google Sheets Tutorial Lesson 27 Insert Image from Camera
Google Sheets Tutorial Lesson 28 Insert External Hyperlinks
Google Sheets Tutorial Lesson 29 Insert Internal Hyperlinks
Google Sheets Tutorial Lesson 30 Image Over Cell to In Cell and In Cell to Over Cell
Google Sheets Tutorial Lesson 31 Freezing Rows and Columns
Google Sheets Tutorial Lesson 32 Hide and Unhide Rows and Columns
Google Sheets Tutorial Lesson 33 Hide and Unhide Sheets
Google Sheets Tutorial Lesson 34 Using Filters
Google Sheets Tutorial Lesson 35 Filter View
Google Sheets Tutorial Lesson 36 Sorting Data
Google Sheets Tutorial Lesson 37 Data Format
Google Sheets Tutorial Lesson 38 Custom Data Format
Google Sheets Tutorial Lesson 39 Cell Color
Google Sheets Tutorial Lesson 40 Border Formatting
How to Get The Certificate
-
You must have an Account on the platform.
-
Complete all lessons.
-
Watch at least 50% of Lesson Duration.
-
Get your Certificate free 🎉 !
4.5
(42 reviews)
Overall rating
Reviews
Be the First One Review This Course
Great
144 great courses. I learned a lot of new things of immense advantage
it was a mind-blowing experience learning on this platform.
the course was insightful
I admire the fact that the lessons were captivating enough, I actually thought a 144 videos would''ve been too much, thanks again!
Excellent illustration
I appreciate this knowledge.
I am happy to have acquired more knowledge on the use of google sheets. these functions will make me more efficient.
It was a wonderful journey of learning.
Very detailed teaching
Though the lessons are relatively short, the courses were too many. I think it could be broken down into 2 or 3, beginners , intermediate and advanced. There were many lessons that I knew I wouldnt remember and wouldnt be useful to me at the moment as I wasnt yet grounded in the basics
Google Sheets Course Description
Google Sheets vs Excel: What is the difference? Both of them structure data in tabular format. In other words, the data is in the form of rows and columns. The major difference between Excel and Google Sheets is that you can share the link of Google Sheets with anyone and they can edit the file ...
Focus on Learning, Not Ads
Experience the full power of Mindluster with Premium.
No distractions, just pure education.
Cancel your subscription anytime