Google Sheets for Administrative Assistants Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://learnitanytime.com/p/exercise-files-google-sheets-for-administrative-assistants-tutorial
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.
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
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
(C) 2025 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Source: မြန်မာနက် ® Myanmar Net ⦿ မြန်မာတို့ရဲ့ ဒစ်ဂျစ်တယ် အိမ်ရာ
⦿ #INFOTECH ⦿ Fri, 20 Jun 2025 22:34:05 +0000