Google Spreadsheet Course Contents Total Duration: One day

• Create a new spreadsheet
• Import and convert old spreadsheets to Sheets
• Customize your spreadsheet
• Add data to your sheet and format it
• Work with multiple sheets
• Set up formulas to calculate tabular data
• Sharing and Protecting Sheets (Share your google sheet with your co-workers. Jointly editing a spreadsheet is one of the critical functions of Sheets, and Google has made it a seamless experience (Share and collaborate)
• Downloading Data & Work Offline
• Google Sheets: Advanced Formulas and Functions, Advanced Formulas VLOOKUP, Nested if, SUMIF etc…..

• Create & Customise Forms
• Add & View Responses
• Integrate Google Forms

• Google Sheets: Pivot Tables
• Create Report
• Run Report
• Using Charts in Reports
• Add Additional Metrics
• Migrating from Google Sheets to Excel

• Making Google Drive the default save location
• Downloading Google Docs files
• Converting files when uploading
• Automatically substituting text
• Using templates
• Creating interactive geocharts
• Creating flowcharts and social media posts with Google Drawings
• Working offline
• Searching for docs and links with Google Search