Google Sheets

• Functions in Google Sheets

  • Use functions in Google Sheets to perform calculations and manipulate data.

  • Common functions include SUM, AVERAGE, and COUNT.

  • Functions can be used to tally expenses claims per organization.

• Formatting in Google Sheets

  • Format cells to display specific types of data, such as currency or dates.

  • To replace a date with a numerical value in Google Sheets, use the 'Format' options to change the display format.

  • For example, to display 1,228 as currency, select the cell, go to Format > Number > Currency.

• Data Manipulation in Google Sheets

  • Perform data manipulation tasks like calculations, sorting, and filtering in Google Sheets.

  • To pin data in place while scrolling, freeze rows or columns by selecting the row or column, then go to View > Freeze.

Google Forms

• Google Form Features

  • Google Forms allow users to create surveys, quizzes, and collect data.

  • Maximum file size that can be uploaded to a Google Form is limited.

  • Maximum number of responses that can be collected in a single Google Form is limited.

• Question Types in Google Forms

  • Different types of questions can be used in Google Forms, such as multiple choice, short answer, and dropdown.

  • Users can customize the interface of Google Forms to suit their preferences.

Google Annotate

• Annotation in Google Annotate

  • Google Annotate allows users to highlight words, add comments, and ask questions on documents.

  • Different colors can be used to signify different meanings, such as blue for unknown words and yellow for confusing sentences.

  • Users can click on specific tools to highlight, add comments, or look up meanings of words.

Google Drive

• Features of Google Drive

  • Google Drive provides storage for files and allows easy access from any device.

  • Users can search and filter files to locate specific items.

  • Creating folders, customizing the interface, and using search features are common tasks in Google Drive.

• File Management in Google Drive

  • Users can create folders, star important files, and search for specific items within Google Drive.

  • The 'Starred' folder in Google Drive serves a specific purpose.

  • Search and filter features in Google Drive help users locate specific files or folders.

Leadership

• Qualities of Effective Leaders

  • Effective leaders are open to feedback and possess problem-solving skills.

  • They prioritize teamwork over individual achievements.

  • Communication plays a vital role in effective leadership.

Google Mail

• Email Management in Google Mail

  • Crafting effective emails involves considering tone, formatting, and content.

  • Using strong passwords and security measures is crucial for online account safety.

  • Improving email readability can be achieved through proper formatting.

Google Slides

• Presentation Design in Google Slides

  • Google Slides allow users to create presentations with transitions and animations.

  • Adding transitions and animations enhances the visual appeal of slides.

  • Animations help move smoothly between different pieces of content.

Google Docs

• Document Editing in Google Docs

  • Google Docs provide tools for collaborative editing and document creation.

  • Revision history feature allows users to track changes and revert to previous versions.

  • Users can combine values in rows, columns, and cells using specific functions.

• Formatting Tools in Google Docs

  • Google Docs offer formatting options like italics, bold, underline, and font styles.

  • Users can create tables, use different buttons, and search for specific content within documents.