Belajar Office Menggunakan Google Sheet dan Google Slide

Explore the power of Google's essential productivity tools with this comprehensive course! You'll gain practical skills in Google Sheets and Google Slides, two indispensable applications for both personal and professional use.

Google Sheets: Mastering the Spreadsheet

This section dives deep into Google Sheets, a powerful online spreadsheet program similar to Microsoft Excel. Learn to:

• Understand the Basics: Get a solid foundation in how Sheets work and their core functionalities.
• Create and Manage Sheets: Learn to create new sheets, save your work, and reopen existing sheets with ease.
• Work with Data: Master data entry – typing text and numbers, adjusting column width, and formatting cells as currency.
• Formula Fundamentals: Unlock the power of formulas! Learn to create average calculations and sum formulas (SUM) to analyze your data.
• Formatting & Styling: Enhance your spreadsheets with customized formatting. Control font size, font color, fill color, and apply bold, italic, and strikethrough text.
• Cell Manipulation: Combine cells, center text, and align cells for professional presentation.
• Data Organization: Learn to hide rows, copy sheets, and move sheets to create effective templates. Also, discover how to use templates for quick starts.
• Saving & Closing: Properly save and close your spreadsheets to ensure your data is secure.
• Modifying Functions: Understand and modify functions within the spreadsheet.

Google Slides: Creating Engaging Presentations

Discover Google Slides, Google's collaborative presentation software, a fantastic alternative to PowerPoint. You'll learn to:

• Presentation Basics: Understand the fundamentals of Slides and how to start a new presentation.
• Slide Design: Master the art of visual communication:
  • Adding Titles & Subtitles: Effectively structure your content.
  • Adding New Slides: Easily insert default slides and specific slide types.
  • Content Integration: Add text, images, and even basic pie charts to your slides.
  • Chart Customization: Learn to edit pie charts, adjust size, resize, and move shapes.
• Visual Enhancements: Make your presentations visually appealing:
  • Color Control: Change background colors and shape colors.
  • Font Styling: Adjust font size, font color, and apply bold, italic, and strikethrough effects.
• Slide Management: Organize your presentation effectively:
  • Duplicate Slides: Quickly create copies of existing slides.
  • Move Slides: Reorder your slides for optimal flow.
• Transitions & Visual Aids: Add dynamic elements:
  • Transitions: Apply smooth transitions between slides.
  • Slide Views: Utilize filmstrip view, grid view, and slide view for efficient editing.
• Presenting & Saving: Deliver a polished presentation, save your work, and close Slides when finished.

Collaboration Made Easy

A key feature of both Sheets and Slides is their real-time collaborative capabilities. Multiple users can edit the same document simultaneously, seeing changes instantly. All changes are automatically saved to Google's servers, and a revision history is maintained, allowing you to revert to previous versions if needed. This makes Google Sheets and Slides ideal for teamwork and project collaboration.