Google Sheets – Advanced
Original price was: $29.99.$14.99Current price is: $14.99.
What you may be taught
-
How to Use Logical Statements
-
Lookup Functions
-
Date & Text Functions
-
How to Link UnfoldSheets and Sheet Files
-
Work with Range Names
-
Create Pivot Tables
-
Work with Macros and Scripts
-
Conditional Formatting
-
Inserting Graphics
-
Creating Forms
This course will educate college students superior ideas and formulation in Google Sheets. Students will be taught to make use of logical statements, lookup capabilities, and date and textual content capabilities. Additionally, college students will learn to hyperlink spreadsheets and Sheets information, work with vary names, be taught the choices for spreadsheet safety, create PivotTables, work with macros and scripts. Students will even find out about conditional formatting, inserting graphics, and creating Forms.
With practically 10,000 coaching movies obtainable for desktop functions, technical ideas, and enterprise expertise that comprise a whole lot of programs, Intellezy has most of the movies and programs you and your workforce wants to remain related and take your expertise to the subsequent stage. Our video content material is participating and gives assessments that can be utilized to check information ranges pre and/or submit course. Our coaching content material can also be incessantly refreshed to maintain present with modifications within the software program. This ensures you and your staff get probably the most up-to-date info and strategies for fulfillment. And, as a result of our video growth is in-home, we are able to adapt shortly and create customized content material for a extra unique strategy to software program and laptop system roll-outs.
Like most of our programs, closed caption subtitles can be found for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.
This course aligns with the CAP Body of Knowledge and must be accepted for two.25 recertification factors below the Technology and Information Distribution content material space. Email information@intellezy.com with proof of completion of the course to acquire your certificates.
Who this course is for:
- Anyone who needs to be taught the superior capabilities of Google Sheets.
10 reviews for Google Sheets – Advanced
Add a review
Original price was: $29.99.$14.99Current price is: $14.99.
Ann McIlwraith –
Simple straighforward instructions, easy to follow, very helpful.
Tushar Adsule –
the presenter takes you through the course very systematically. Liked the contents of the course too. I have definitely learned new things in this course
Freya –
very clear, cohesive. tutor is nice. Very good and helpful
Matt Fernald –
I have completed 5 videos so far. Each one is very well produced. Short and to the point, easy to follow. Good pace.
UPDATE: Finished the course. I loved it. Video production and scripting were excellent: informative and short. The project files were good extensions of the lectures, not just repeating what he did. I only wish there were a “final exam” project file with practice exercises that combine multiple lessons and formulas into one.
All in all, if you have basic comfort with Excel or Google Sheets, can enter and format data manually and run a dozen or so functions, this series will take you to another level. Good luck!
Benjamin Schweizer –
So far, it doesn’t feel like an advanced course.
Meghan OConnell –
Concise and informative!
Mattia Scolari –
It would have been interesting to dive deeper into macros (or add a reference to another course)
Brianna Wilson –
The videos and explanations are so clear!
Natania Hinchliffe –
The resources provided are extremely helpful for trying out these functions myself. The teacher is also very clear and it’s easy to understand!
Ravi Kumar Singh –
Great experience