Google Sheets for Administrative Assistants Tutorial

Google Sheets for Administrative Assistants Tutorial

Get Ad-Free Training by becoming a member today!
   / @learnskillsdaily  

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Exercise Files: https://tinyurl.com/kdyzs3h6

Who it's for: This course is designed for administrative professionals who use Google Sheets to manage tasks, projects, and records in a business or organizational setting. It’s especially valuable for administrative assistants seeking to streamline data handling, improve productivity, and enhance reporting through spreadsheets. No prior advanced experience with Google Sheets is needed—just a willingness to learn and apply practical tools.

What it is: Google Sheets is a cloud-based spreadsheet application developed by Google that allows users to create, edit, and share spreadsheets online. It offers powerful tools for organizing data, performing calculations, and creating charts and graphs. With real-time collaboration, multiple users can work on the same document simultaneously, making it ideal for team projects, data tracking, and administrative tasks. Google Sheets is accessible from any device with internet access and integrates seamlessly with other Google Workspace apps.

What you'll learn: Participants will learn how to work with tables, charts, and different data views in Google Sheets. The training covers converting data to tables, using conditional formatting, creating charts (column, pie, and sparkline), printing with headers and footers, linking data, building pivot tables, and applying data validation. Learners will also explore collaboration features, dropdown menus, and formatting techniques that make Sheets more interactive, efficient, and visually clear.

Start 0:00
Introduction 0:09
Converting a List into a Table 1:33
Organizing Table Columns 7:57
Removing Duplicates 13:56
Conditional Formatting 18:16
Chart Basics 27:28
Customizing Charts 34:20
Sparkline Chart 41:24
Freezing Rows and Columns 44:06
Export to PDF with Headers and Footers 48:05
Linking to Sheets 51:34
Linking to Cell Ranges and External sites 54:36
Module 2 Intro 59:27
Pivot Table Basics 1:00:04
Filtering a Pivot Table 1:07:20
Pivot Table Options 1:09:55
Data Validation Basics 1:15:12
Troubleshooting Data Validation 1:23:53
Collaborating in Google Sheets 1:27:40
Conclusion 1:34:55

#googlesheets #tutorial #administrativeassistant

Learnit is no longer associated with this channel/video.

(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.