Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 7 hours
Course Outline
1. Introduction to Google Sheets
- General overview of Google Sheets and its integration within Google Workspace
- Operational advantages of cloud-hosted spreadsheet applications
- Accessing Google Sheets via standard web browser interfaces
- Interface navigation and component identification
- Initiating new spreadsheet documents:
- Empty worksheets
- Predefined templates
- Ingesting existing files
- Interaction with sheets, rows, columns, and individual cells
- Administration of multiple worksheet tabs
2. Data Management in Google Sheets
- Data entry and modification procedures
- Handling various data classifications:
- Textual entries
- Numerical values
- Date formats
- Currency representations
- Percentage calculations
- Incorporating data from external repositories
- Transferring, relocating, and structuring data
- Ordering and narrowing down information sets
- Establishing filtered views
- Elimination of redundant entries
- Locating and substituting specific data points
- Data validation rules and dropdown menu implementation
3. Spreadsheet Formatting in Google Sheets
- Application of fundamental styling rules
- Adjustments to cells, rows, and column dimensions
- Configuration of numerical display formats
- Implementation of conditional formatting rules
- Utilization of themes and style presets
- Designing professional-grade layout structures
- Locking specific rows and columns (freezing panes)
- Securing specific ranges and entire sheets
- Optimization for print output and distribution
4. Fundamentals of Formulas and Functions
- Conceptual understanding of formulas in Google Sheets
- Construction of basic arithmetic calculations
- Application of cell reference types:
- Relative references
- Absolute references
- Combined relative and absolute references
- Utilization of standard functions:
- SUM
- AVERAGE
- COUNT
- MIN and MAX
- IF logical statements
- Application of text manipulation functions
- Integration of date and time functions
- Management of formula errors
5. Advanced Functions and Data Analytics
- Complex logical operations
- Lookup and reference functions:
- VLOOKUP
- XLOOKUP
- INDEX and MATCH combinations
- Conditional aggregation methods:
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- Array-based operations
- Definition and use of named ranges
- Development of dynamic calculation models
- Analytical review of structured datasets
6. Chart Creation and Data Visualization
- Selection of appropriate chart categories
- Generation of charts within Google Sheets
- Customization of chart visual properties
- Implementation of specific chart types:
- Column charts
- Bar charts
- Line charts
- Pie charts
- Scatter plots
- Inclusion of labels and explanatory annotations
- Construction of data dashboards
- Visual presentation of analytical insights
7. Sharing and Collaborative Workflows in Google Sheets
- Distribution of spreadsheets to individuals and groups
- Interpretation of permission hierarchies:
- Viewer access
- Commenter access
- Editor access
- Administration of access control settings
- Synchronous collaborative editing
- Utilization of comments and user mentions
- Assignment of specific tasks and action items
- Monitoring modification history
- Version control and recovery of prior states
8. Advanced Collaboration and Productivity Enhancements
- Integration with broader Google Workspace services
- Establishing data links across multiple spreadsheets
- Synchronizing Google Forms with Sheets data
- Process automation using built-in tools
- Configuration of system notifications and alerts
- Standardized protocols for team-based spreadsheet governance
9. Practical Application Workshop
- Construction of a business-oriented spreadsheet based on a real-world scenario
- Ingestion and refinement of operational data
- Implementation of formulas and functions for analysis
- Generation of visual summaries and charts
- Facilitating collaborative review and sharing
- Application of security and access controls
- Communication of findings and strategic insights
10. Conclusion and Best Practices
- Comprehensive review of essential Google Sheets capabilities
- Recommended standards for spreadsheet organization
- Methodologies for ensuring data accuracy and integrity
- Optimization of collaborative workflows
- Curated resources for ongoing professional development
Requirements
No prior technical prerequisites are required.
Testimonials (2)
The final day which is the Machine Learning Topic
John Erick Baltazar - Globe Telecom
Course - Google BigQuery
It was a really good training course, well prepared and explained by the trainer with great hands on experience on GCP.