Google Sheets for Administrative Assistants Course

Overview

• Instructor: Mo Jones, IT professional and educator.
• Course aimed at administrative assistants, featuring two modules.
• Exercise files available in video description.
• Subscribe for ad-free videos and access to exclusive content at learnitanytime.com.

Module 1: Working with Tables

Lesson 1: Working with Tables

• Convert data to tables for easier data management.
• Explore table features like sorting, filtering, and formatting.
• Learn to manage columns efficiently (insert, delete, move).
• Use conditional formatting to highlight data based on specific criteria, e.g., task status.

Lesson 2: Working with Charts

• Create visuals to represent data, like pie charts and column charts.
• Tailor charts to showcase specific data trends and analysis.
• Use spark lines for displaying data trends within a single cell.

Lesson 3: Freezing Rows and Headers, and Adding Footers

• Freeze rows and columns to keep headers visible while scrolling.
• Export data as PDFs including headers and footers for presentation.

Lesson 4: Linking Data

• Learn how to create hyperlinks to sheets, ranges, cells, or external sources.
• Use links to facilitate navigation between worksheets and external resources.

Module 2: Advanced Google Sheets Features

Pivot Tables

• Gain insights through pivot tables.
• Customize pivot table setup by manipulating columns, rows, and values.
• Use filters to focus on specific data segments, like quarterly sales.

Data Validation

• Enforce data entry rules through dropdowns.
• Provide a structured list for user selections to maintain uniformity.
• Explore advanced options like text, number restrictions, and colors in dropdowns.

Sharing and Collaboration

• Utilize Google Sheets' collaborative features for real-time editing.
• Adjust sharing permissions: viewer, commenter, editor.
• Use comments and at@mentions for collaborative feedback.
• Track version history to manage document changes.
• Manage sharing settings and modify permissions as necessary.

Conclusion

• Learn Google Sheets functionalities to boost productivity and improve data management as an administrative assistant.
• Access courses and certificates without ads through learnitanytime.com.