Google Sheets eLearning Bundle Course
Course Details:
Length: 6 courses
Access Length: 6 months
Price: $175/person (USD)
Bundle & Save: View Bundle
Bulk Pricing: 10+ Contact Us
Course Features:
Instant Access After Purchase
Lecture by Recorded Video
Stop and Start as Needed
Certificate of Completion
Software Lab Included?: N/A
(Cloud Based Software)
Delivery Method:
Self-Paced Online
Individuals and Groups
@ Your Location
Course Overview
Transform Your Data Skills: Master Google Sheets and Become a Spreadsheet Wizard!This comprehensive Google Sheets eLearning Bundle takes you from beginner to advanced, equipping you with the skills to streamline your work, make data-driven decisions, and automate tedious tasks.
Key Benefits- Master Spreadsheet Fundamentals: Effortlessly create, navigate, and format spreadsheets to handle any data you encounter.
- Unleash Data Insights: Use formulas, functions, and PivotTables to analyze data, uncovering trends and patterns.
- Unlock Data Insights: Analyze complex datasets with logic, lookups, PivotTables, and visualizations.
- Collaborate Effectively: Share and collaborate on spreadsheets, manage access controls, and streamline workflows.
- Save Time and Effort: Discover tips, tricks, and automation tools to boost your spreadsheet workflow.
- Google Sheets: Beginner: Conquer the fundamentals with this foundation-building course. Start building, formatting, and using Sheets like a pro. What You'll Learn:
- Interface navigation
- Data entry and formatting
- Basic formulas and functions
- Chart creation
- Google Sheets: Advanced: Dive deep into advanced formulas, data manipulation, PivotTables, macros, scripting, Forms, and more. What You'll Learn:
- Logical functions (IF, AND, OR)
- Lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH)
- Data manipulation with text functions
- Date calculations
- PivotTables for analysis
- Data validation and conditional formatting
- Macros and scripts for automation
- Forms integration
- Data linking and protection
Ready to simplify your work life? Enroll in the Google Sheets eLearning Bundle today and master the essential spreadsheet tool for the modern workplace!
Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.
Course Notes
Important Course Information
eLearning Training Delivery Method
How It Works
This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.
- Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
- Lecture utilizing video and recorded screenshots
- 6-month subscription length
- Instant Access After Purchase
Have more than 10 students needing this course? Contact Us for bulk pricing.
Learning Objectives:
- Mastery of Spreadsheet Fundamentals:
- Effortlessly navigate the Google Sheets interface.
- Enter, manipulate, and format data with efficiency.
- Construct basic formulas and understand common functions.
- Create various chart types for data visualization.
- Data Analysis Expertise:
- Apply logical functions (IF, AND, OR, Nested IF) for conditional calculations.
- Utilize lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH) to retrieve data efficiently.
- Manipulate text using specialized text functions.
- Perform calculations with dates and time intervals.
- Build and interpret PivotTables to uncover insights within large datasets.
- Workflow Efficiency and Collaboration
- Implement data validation and conditional formatting for input control and visual cues.
- Automate tasks using macros and gain a basic understanding of scripting.
- Integrate Google Forms for streamlined data collection.
- Link data between spreadsheets and manage protection settings.
- Collaborate effectively through sharing controls and commenting.
Target Audience
- Professionals across industries: Anyone who regularly works with data and needs to track, analyze, and report on information.
- Students: Those seeking to develop spreadsheet skills.
- Individuals seeking career advancement: Those looking to upskill and demonstrate proficiency in Google Sheets.
- Anyone wanting to streamline personal workflows: For budgeting, organizing household data, or managing personal projects.
Key Features
- Audio Narration
- Video
- Inline Activities
- Supplemental Resources
- Post-Assessment
Languages
- Audio/Video/Course Text: English.
- Subtitles (Closed Caption): American English, Arabic, Brazilian Portuguese, Canadian French, Chinese (Simplified), Chinese (Traditional), Dutch, French, German, Hindi, Indonesian, Italian, Japanese, Korean, Latin American Spanish, Russian, Spanish, Thai, Turkish, and Vietnamese.
Course Duration
- Google Sheets Bundle: 4 hrs 15 min
- Essential Career Skills Pack: 2 hrs 23 min
Course Topics
Google Sheets: Beginner
Course Duration - 2 hrs
This course provides a quick start to this application and is designed to teach students how to use the Google App and Google Sheets to create sophisticated spreadsheets for tracking, analyzing, and storing data.
Course Objectives:
Course Objectives:
- Identify the core components of the Google Sheets interface and explain their purposes.
- Create a new Google Sheets spreadsheet, import data from other file formats, and save work in various locations.
- Navigate efficiently within a spreadsheet using both the keyboard and mouse for cell selection and data manipulation.
- Enter various data types (text, numbers, dates) into cells and apply appropriate formatting for clarity and accuracy.
- Construct basic formulas using mathematical operators and cell references, demonstrating an understanding of calculation order.
- Utilize common functions (SUM, AVERAGE, etc.) to perform calculations and summarize data.
- Format cells, rows, and columns to improve the visual presentation of a spreadsheet, including alignment, borders, and themes.
- Organize a spreadsheet by sorting and filtering data, applying freeze panes, and managing multiple sheets.
- Create basic charts (column, line, pie) to visually represent data within a spreadsheet.
- Collaborate effectively on a spreadsheet by controlling sharing settings and leaving comments for other contributors.
Detailed Course Outline:
Detailed Course Outline:
Getting Started with Google Sheets
- What is Google Sheets?
- Opening Google Sheets
- Importing and Converting Spreadsheets to Sheets
- Navigating the Sheets User Interface
- Understanding Sheet Components
- Using the File Menu
- Creating a Spreadsheet
- Saving a Spreadsheet
- Accessing Help
- Navigating a Spreadsheet by Mouse or Keyboard
- Working with Cell and Ranges
- Using Various Data Selection Techniques
- Working with Common Sheet Commands
- Working with Copy and Paste
- Understanding Data Types
- Formatting Values
- Using the Autofill Handle
- Inserting Links
- What are Formulas and Functions?
- Understanding the Components of A Formula
- Understanding Calculation Hierarchy and the Order of Operations
- Creating Basic Formulas
- Working with Basic Functions and Autosum
- Using Cell References
- Using Explore
- Formatting and Aligning Data
- Modifying Columns and Rows
- Using Borders and Fill
- Using Paint Format
- Inserting Notes or Comments
- Inserting Checkboxes
- Applying a Theme
- Using Zoom Tools
- Working with Sheets
- Working with Spreadsheet Tabs
- Hiding and Unhiding Spreadsheets
- Sorting Sheets Data
- Filtering Sheets Data
- Using Filter Views
- Using Freeze Panes
- Printing a Spreadsheet
- Using Find and Replace
- Using Spell Check
- Preparing a Spreadsheet for Printing
- Changing Spreadsheet Settings
- Finalizing Printing
- Downloading and Emailing Files
- Sharing a Spreadsheet
- Inserting a Chart
- Formatting a Chart
- Moving and Sizing a Chart
- Creating a Scorecard Chart
- Inserting Images
- Creating Drawings
Google Sheets: Advanced
Course Duration - 2 hrs 15 min
This course will teach students advanced concepts and formulas in Google Sheets. Students will learn to use logical statements, lookup functions, and date and text functions. Additionally, students will learn how to link spreadsheets and Sheets files, work with range names, learn the options for spreadsheet protection, create PivotTables, and work with macros and scripts. Students will also learn about conditional formatting, inserting graphics, and creating Forms.
Course Objectives:
Course Objectives:
- Link data between separate Sheets files and control protection settings to safeguard specific cells, ranges, or entire sheets.
- Apply logical functions (IF, AND, OR, nested IF) to create conditional formulas for decision-making within spreadsheets.
- Utilize advanced lookup functions (VLOOKUP, HLOOKUP, INDEX/MATCH) to retrieve data from other spreadsheets or tables efficiently.
- Manipulate text strings using functions like CONCATENATE, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, and others for data cleaning and formatting.
- Calculate dates, workdays, and time intervals using date-specific functions (TODAY, NOW, NETWORKDAYS, YEARFRAC)
- Employ data validation rules and advanced conditional formatting to control input, highlight patterns, and visualize data.
- Construct and manipulate PivotTables to summarize large datasets, identifying trends and relationships.
- Automate repetitive tasks by recording macros and introduce the basics of scripting to customize Sheets behavior.
- Design Google Forms to collect data, link them to Sheets for automatic updates, and send forms for response collection.
- Implement approval workflows within Sheets to track requests and streamline collaborative processes.
Detailed Course Outline:
Detailed Course Outline:
Linking and Protecting Data
- Importing Data
- Linking Sheets
- Linking to Another Spreadsheet
- Protecting Sheets and Ranges
- Working with Versions
- Reviewing Accessibility Settings
- Working with Range Names
- Understanding Logical Functions
- Using Logical Statements
- Using AND and OR Functions
- Working with Nested IF Statements
- Using SUMIF, AVERAGEIF, COUNTIF, and More
- Using the IFERROR Function
- Working with Lookup Functions
- Understanding Lookup Functions
- Using VLOOKUP
- Using HLOOKUP
- Using INDEX and MATCH
- Comparing Two Lists with VLOOKUP and IFERROR
- Using CONCAT, CONCATENATE, and TEXTJOIN
- Splitting Text to Columns
- Using LEFT, RIGHT, and MID Functions
- Using UPPER, LOWER, and PROPER Functions
- Using the LEN Function
- Removing Duplicates and Trimming White Space
- Understanding Date Functions
- Using TODAY, NOW, and DAY Functions
- Calculating YEARFRAC and NETWORKDAYS
- Using Named Functions
- Importing Named Functions
- Using Data Validation
- Adding Conditional Formatting
- Grouping and Ungrouping Data
- What is a PivotTable?
- Creating a PivotTable
- Working with PivotTables
- Creating a Chart from a PivotTable
- Filter Charts and Tables with Slicers
- What are Macros?
- Creating a Macro
- Working with Scripts
- Creating a Form
- Working with Forms
- Sending a Form
- Creating a Timeline View
- Requesting Approval
- Approving Sheets
Essential Career Skills Pack
Productivity and Time Management
Course Duration - 30 min
It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.
Course Objectives:
Course Objectives:
- Set your priorities to better manage your time
- Improve your productivity by sharpening your focus and multitasking effectively
Detailed Course Outline:
Detailed Course Outline:
- Productiity & Time Management
- Prioritization
- Getting Things Done
- Procrastination
- Multitasking & Focus
- Summary
Basic Digital Skills
Course Duration - 13 min
With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.
Course Objectives:
Course Objectives:
- Recall the essential digital skills framework
- Elaborate on the toolkit of essential digital skills
- Identify how to develop or improve your digital skills
Detailed Course Outline:
Detailed Course Outline:
- The Essential Digital Skills Framework
- The Toolkit of Essential Digital Skills
- Developing Digital Skills
- Summary
4 Ways to Boost Creativity
Course Duration - 30 min
The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.
Course Objectives:
Course Objectives:
- Define creativity
- Think outside the box
- Develop the right mental attitude
- Leverage the power of groups
- Ensure managers make it happen
Detailed Course Outline:
Detailed Course Outline:
- What is Creativity at Work?
- Learn to Think Outside the box
- Develop the Right Mental Capacity
- Laverage the Power of Groups
- Ensure Managers Make It Happen
- Summary
The 11 Essential Career Soft Skills
Course Duration - 1 hr 10 min
Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?
This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.
Course Objectives:
Course Objectives:
- Understand how to be a great communicator
- Become a stronger listene
- Appear professional to co-workers and bosses of all ages
- Avoid common career blunders that often end careers
- Manage expectations for bosses and colleagues
- Position yourself for promotions
- Make technology your asset, even if you are afraid of technology
- Avoid the Not My Job Syndrome
- Develop EQ to Match Your IQ
- Develop leadership qualities
Detailed Course Outline:
Detailed Course Outline:
- Introduction
- The Soft Tech Savvy Way to Always Be Essential
- Not My Job, And I Am Happy to Do It
- You Can Become a Master Communicator
- Feedback Video for The 11 Essential Career Soft Skills
- Become a Leader Without the Title or Formal Authority
- Your EQ Will Beat a Higher IQ
- Building Your Winning Team
- Make Every One of Your Seconds Count
- Unleash Your Inner Anthony Robbins
- Avoid Being Uncool
- Clothes Can Still Make or Break Your Career
- Conclusion The 11 Essential Career Soft Skills
- Extra: Developing Your Career Secret Sauce
Related Google Workspace Information:
How Much Do Google Workspace Training Courses Cost?
Public instructor-led Google Workspace course prices start at $550 per student. Group training discounts are available.
Self-Paced Google Workspace eLearning courses cost $175 at the starting point per student. Group purchase discounts are available.
What Google Workspace Skills Should I Learn?
A: If you are wondering what Google Workspace skills are important to learn, we've written a Google Workspace Skills and Learning Guide that maps out Google Workspace skills that are key to master and which of our courses teaches each skill.
Is there training for Google Workspace?
A: Yes, there is training for Google Workspace. You can find a variety of training options within the Google Workspace Admin console. From here, you can access training materials, video tutorials, and other resources to help you get the most out of your Google Workspace experience.
Certstaffix Training also offers self-paced eLearning courses on Google Docs, Slides, Sheets and Classroom. Browse our Google Workspace courses or contact us to find out more.
How do I learn to use Google Sheets?
A: There are a few different ways that you can learn to use Google Sheets. You can find many helpful tutorials and resources online, or you can sign up for a class through Certstaffix Training.
If you want to learn on your own, there are plenty of great tutorials available online. YouTube is a great place to start, as there are many step-by-step video guides that can walk you through the basics of using Google Sheets. Once you feel comfortable with the basics, you can start exploring more advanced features and functions.
Another option is to sign up for a class through Certstaffix Training. We offer self-paced eLearning that you attend in a web browser on your own schedule. Browse our Google Sheets courses or contact us today.
Is Google Slides easy to use?
A: Google Slides is a powerful and easy-to-use presentation tool that can help you create professional-looking presentations. It's also free to use, making it a great option for businesses and individuals on a budget. Whether you're new to Google Slides or just need a refresher, our Google Slides training classes can help you get the most out of this versatile program.
Browse our Google Slides courses to get started.
How do beginners use Google Docs?
A: There are a few different ways that beginners can use Google Docs. One way is to take advantage of the many training resources that are available online. Certstaffix Training provides Google Docs classes online for individuals and onsite for groups, which can be a great way to learn how to use Google Docs.
Another way for beginners to use Google Docs is to explore the various features and tools that are available. The Google Docs Help Center is a great resource for learning more about how to use this word processing software.
Finally, it can be helpful for beginners to ask questions and get help from more experienced users. The Google Docs community forums are a great place to start if you have any questions about using this software.
What are the top Google Workspace skills?
A: With more businesses using Google Workspace (formerly G Suite) to improve productivity and collaboration, there is a growing demand for workers with the skills to use these tools effectively. Here are some of the top Google Workspace skills that can help you get ahead in today’s competitive job market:
Top Google Workspace Skills
1. Google Docs: Google Docs is a versatile tool that can be used for everything from creating and editing documents to collaborating with team members in real-time. To be proficient in Google Docs, you should have a good understanding of how to use its various features, including commenting, suggest mode, and track changes.
2. Google Sheets: Google Sheets is a powerful spreadsheet application that can be used for everything from data analysis to creating complex financial models. To be proficient in Google Sheets, you should have a good understanding of how to use its various features, including formulas, functions, and pivot tables.
3. Google Slides: Google Slides is a versatile presentation tool that can be used for everything from creating slide decks to collaborating with team members in real-time. To be proficient in Google Slides, you should have a good understanding of how to use its various features, including transitions, animations, and speaker notes.
4. Google Forms: Google Forms is a powerful tool that can be used for everything from creating surveys to collecting data from team members. To be proficient in Google Forms, you should have a good understanding of how to use its various features, including question types, skip logic, and response validation.
5. Google Calendar: Google Calendar is a versatile tool that can be used for everything from managing your personal schedule to scheduling team meetings. To be proficient in Google Calendar, you should have a good understanding of how to use its various features, including event reminders, shared calendars, and event scheduling.
By possessing these top Google Workspace skills, you’ll be in a strong position to take advantage of the growing demand for workers who are proficient in using these powerful tools.
Where Can I Learn More About Google Workspaces?
Google Workspace Blogs
- Google Workspace | Google Blog
- Google Workspace Updates blog
- 15 Best Google Workspace Blogs and Websites
Google Workspace User Groups
Google Workspace Online Forums
Explore Google Workspace Training Classes Near Me:
Certstaffix Training provides Google Workspace classes near me or online, depending on the number of students involved. We offer online courses for individual learners, as well as in person classes at your office for corporate groups. Our trainers are highly experienced professionals with the expertise necessary to help you gain a thorough understanding of Google Workspace concepts and tools. With our courses available online for individuals or in person for corporate groups, it's easy to develop your Google Workspace skills. Start learning today and see how Certstaffix Training can help you reach your goals.
AL
Google Workspace Training BirminghamAR
Google Workspace Training FayettevilleGoogle Workspace Training Little Rock
AZ
Google Workspace Training PhoenixGoogle Workspace Training Tucson
CA
Google Workspace Training BakersfieldGoogle Workspace Training Fresno
Google Workspace Training Los Angeles
Google Workspace Training Oxnard
Google Workspace Training Sacramento
Google Workspace Training San Diego
Google Workspace Training San Francisco
Google Workspace Training San Jose
CO
Google Workspace Training Colorado SpringsGoogle Workspace Training Denver
CT
Google Workspace Training HartfordGoogle Workspace Training New Haven
Google Workspace Training Stamford
D.C.
Google Workspace Training Washington, DCFL
Google Workspace Training Daytona BeachGoogle Workspace Training Fort Myers
Google Workspace Training Jacksonville
Google Workspace Training Lakeland
Google Workspace Training Miami
Google Workspace Training Orlando
Google Workspace Training Sarasota
Google Workspace Training Tampa
GA
Google Workspace Training AtlantaGoogle Workspace Training Augusta
HI
Google Workspace Training HonoluluIA
Google Workspace Training Des MoinesID
Google Workspace Training BoiseKS
Google Workspace Training WichitaIL
Google Workspace Training ChicagoIN
Google Workspace Training IndianapolisKY
Google Workspace Training LouisvilleLA
Google Workspace Training Baton RougeGoogle Workspace Training New Orleans
MA
Google Workspace Training BostonGoogle Workspace Training Springfield
Google Workspace Training Worcester
ME
Google Workspace Training PortlandMI
Google Workspace Training DetroitGoogle Workspace Training Grand Rapids
MD
Google Workspace Training BaltimoreMN
Google Workspace Training MinneapolisMO
Google Workspace Training Kansas CityGoogle Workspace Training St. Louis
MS
Google Workspace Training JacksonNC
Google Workspace Training CharlotteGoogle Workspace Training Durham
Google Workspace Training Greensboro
Google Workspace Training Raleigh
Google Workspace Training Winston-Salem
NE
Google Workspace Training OmahaNM
Google Workspace Training AlbuquerqueNV
Google Workspace Training Las VegasNY
Google Workspace Training AlbanyGoogle Workspace Training Buffalo
Google Workspace Training New York City
Google Workspace Training Poughkeepsie
Google Workspace Training Rochester
Google Workspace Training Syracuse
OH
Google Workspace Training AkronGoogle Workspace Training Cincinnati
Google Workspace Training Cleveland
Google Workspace Training Columbus
Google Workspace Training Dayton
Google Workspace Training Toledo
OK
Google Workspace Training Oklahoma CityGoogle Workspace Training Tulsa
OR
Google Workspace Training PortlandPA
Google Workspace Training AllentownGoogle Workspace Training Harrisburg
Google Workspace Training Philadelphia
Google Workspace Training Pittsburgh
Google Workspace Training Scranton
RI
Google Workspace Training ProvidenceSC
Google Workspace Training CharlestonGoogle Workspace Training Columbia
Google Workspace Training Greenville
TN
Google Workspace Training ChattanoogaGoogle Workspace Training Knoxville
Google Workspace Training Memphis
Google Workspace Training Nashville
TX
Google Workspace Training AustinGoogle Workspace Training Dallas
Google Workspace Training El Paso
Google Workspace Training Houston
Google Workspace Training McAllen
Google Workspace Training San Antonio
UT
Google Workspace Training Salt Lake CityVA
Google Workspace Training RichmondGoogle Workspace Training Virginia Beach
WI
Google Workspace Training MadisonGoogle Workspace Training Milwaukee
WA
Google Workspace Training SeattleGoogle Workspace Training Spokane