Track
Back Office
Duration
30 hours
Skill Level
Beginner
Language
English, Hindi, Marathi
About this Course
Enhance productivity with advanced Google Workspace features. Discover shortcuts, integrations, and collaboration tools.
Learning Mode: Learn at ALC or at Home
Detailed Course Curriculum
Hands-on module breakdown aligned with MKCL production standards and industry requirements.
- Working with Google Docs
- Case Study - Resume
- Scenario
- Scenario
- Introduction
- Introduction
- Quick Preview
- Quick Preview
- Creating a Resume
- Creating a Resume
- Enhancing the Resume
- Enhancing the Resume
- Sharing Resume for collaboration
- Sharing Resume for collaboration
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Quick Summary
- Quick Summary
- Case Study - User Manual
- Scenario
- Scenario
- Introduction
- Introduction
- Quick Preview
- Quick Preview
- Designing a User Manual
- Designing a User Manual
- Inserting objects and elements
- Inserting objects and elements
- Adding and enhancing a table of content
- Adding and enhancing a table of content
- Importing an Excel spreadsheet
- Importing an Excel spreadsheet
- Searching and add images from the web
- Searching and add images from the web
- Changing the background colour of pages
- Changing the background colour of pages
- Sharing User Manual for collaboration
- Sharing User Manual for collaboration
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Case Study - Meeting Notes
- Case Study - Brochure
- Working with Google Sheets
- Case Study - Moving Checklist
- Scenario
- Scenario
- Introduction
- Introduction
- Quick Preview
- Quick Preview
- Creating a Moving Checklist
- Creating a Moving Checklist
- Enhancing the Moving Checklist
- Enhancing the Moving Checklist
- Inserting and placing images
- Inserting and placing images
- Using Google Sheets on mobile device
- Using Google Sheets on mobile device
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Case Study - Event Expenses
- Scenario
- Scenario
- Introduction
- Introduction
- Quick Preview
- Quick Preview
- Creating an Event Expenses document
- Creating an Event Expenses document
- Adding images to Event Expenses
- Adding images to Event Expenses
- Setting currency for Event Expenses
- Setting currency for Event Expenses
- Drawing and formatting textboxes
- Drawing and formatting textboxes
- Using conditional formatting and inserting charts
- Using conditional formatting and inserting charts
- Inserting hyperlinks and sharing the document
- Inserting hyperlinks and sharing the document
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Case Study - Invoice
- Case Study - Budget
- Working with Google Slides
- Case Study - Training Presentation
- Scenario
- Scenario
- Introduction
- Introduction
- Quick Preview
- Quick Preview
- Creating a document for Training Presentation
- Creating a document for Training Presentation
- Inserting shapes and drawing text boxes
- Inserting shapes and drawing text boxes
- Inserting and positioning images
- Inserting and positioning images
- Adding footer text to a slide
- Adding footer text to a slide
- Importing data from a spreadsheet
- Importing data from a spreadsheet
- Inserting and formatting images
- Inserting and formatting images
- Applying animation effects
- Applying animation effects
- Sharing the Training Presentation
- Sharing the Training Presentation
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Case Study - Greeting Card
- Introduction
- Introduction
- Scenario
- Scenario
- Quick Preview
- Quick Preview
- Designing a Greeting Card
- Designing a Greeting Card
- Formatting and finalizing the Greeting Card
- Formatting and finalizing the Greeting Card
- Outcome
- Outcome
- Quick Summary
- Quick Summary
- Case Study - Portfolio
- Case Study - Photo Album
- Introduction
- Working with Google Forms
- Create a form using Google Forms
- Response validation
- Verify numbers, emails, and other credentials
- Field type options in Google Forms
- Multiple-choice questions in Google Forms
- Checkbox type questions
- Dropdown type questions
- Linear scale type questions
- Checkbox grid type questions
- Multiple-choice grid
- MakIng a Google Form multiple-choice grid
- Adding date and time options in Google Forms
- Adding an image to a Google Form question
- Adding video to Google Forms
- Adding a new section in the google form
- Adding inquiries to a Google Form
- Quiz in Google Forms
- Exporting responses to a spreadsheet
- Using Google Sheets to combine responses from many forms
- Ways of sharing Google Forms
- Sharing a pre-filled form
- Sending and receiving the responses
- Offline paper forms
- Create a Google Form from a spreadsheet
- Objective
- Google Looker - An Introduction
- Data Sources
- Data Sources
- Data Blending
- Data Blending
- Data Blending inside
- Data Blending inside
- Google Looker (Data Studio)-Creating Reports and Chart Types
- Report canvas interface
- Report canvas interface
- Creating chart types- Table, Pivot table
- Creating chart types- Table, Pivot table
- Bar Chart
- Bar Chart
- Line Chart
- Line Chart
- Time series chart
- Time series chart
- Scorecard Pie Maps charts
- Scorecard Pie Maps charts
- Google Looker (Data Studio) - Action controls for Reports and Managing Reports
- Community visualization
- Community visualization
- Embed URL in reports
- Embed URL in reports
- Creating Groups
- Creating Groups
- Page and report level
- Page and report level
- Creating multi page report with navigation
- Creating multi page report with navigation
- Using parameters to get user input
- Using parameters to get user input
- Copying chart formatting
- Copying chart formatting
- Managing data segments
- Managing data segments
- Regular expressions
- Regular expressions
- Google Looker (Data Studio) -Sharing Reports, Collaborating on Reports and Tips to create an effective report
- Right chart for your report
- Right chart for your report
- Tips to create effective reports
- Tips to create effective reports
- Getting started with Google Sites
- What is Google Site?
- What is Google Site?
- Benefits of using Google Sites
- Benefits of using Google Sites
- Get started with Google Sites
- Get started with Google Sites
- Why do you need to use Google Sites?
- Why do you need to use Google Sites?
- Google Sites Homepage
- Google Sites Homepage
- How to use Google Sites
- Create, name, delete, or copy a site
- Create, name, delete, or copy a site
- Change how your site looks
- Change how your site looks
- Add, Delete and Organize pages
- Add, Delete and Organize pages
- Edit Share & Publish
- Add or Edit text and images
- Add or Edit text and images
- Add and Edit Announcement Banners
- Add and Edit Announcement Banners
- Add Google files, videos, website content and more
- Add Google files, videos, website content and more
- Delete or restore your site
- Delete or restore your site
- Publish and Share your site
- Publish and Share your site
- Review the latest changes to your site before publishing
- Review the latest changes to your site before publishing
- Invite others to edit your site
- Invite others to edit your site
- Add Link and HTML Script
- Add Link and HTML Script
- Use a custom domain for your site
- Use a custom domain for your site
- Analytics, Accessibility and Troubleshooting
- Make your site more accessible
- Make your site more accessible
- Use Google Sites with a screen reader
- Use Google Sites with a screen reader
- Keyboard shortcuts for Google Sites
- Keyboard shortcuts for Google Sites
- Fix a problem with Google Sites
- Fix a problem with Google Sites
- Export your data from Google Docs, Sheets, Slides, Drawings, Sites, Drive, Forms & Jamboard
- Export your data from Google Docs, Sheets, Slides, Drawings, Sites, Drive, Forms & Jamboard
- Introduction to Google Books
- Overview of Google Books
- What is Google Books?
- What is Google Books?
- Characteristic features of Google Books
- Characteristic features of Google Books
- More characteristics of Google Books
- More characteristics of Google Books
- Benefits of Google Books
- Benefits of Google Books
- How to create an account in Google Books?
- How to create an account in Google Books?
- Searching for Books
- Classic Search
- Classic Search
- Advanced Search in Google Books
- Advanced Search in Google Books
- Using Advanced Search
- Using Advanced Search
- More about Advanced Search
- More about Advanced Search
- Searching within a book
- Searching within a book
- Using search within a book
- Using search within a book
- More about search within a book
- More about search within a book
- Previewing and Reading Books
- Previewing a book
- Previewing a book
- Using previewing a book
- Using previewing a book
- Read a book online
- Read a book online
- Using read a book online
- Using read a book online
- Download a book
- Download a book
- Interacting with Books
- Share a book
- Share a book
- Create a new bookshelf
- Create a new bookshelf
- Delete a bookshelf
- Delete a bookshelf
- Clear a bookshelf
- Clear a bookshelf
- Add a book to your library
- Add a book to your library
- Remove a book from your library
- Remove a book from your library
- Outcome
- Future of Google Books
- Future of Google Books
- Possible resources for further learning
- Possible resources for further learning
- What is Google Blogger & How to use it?
- Creating a new Blog using Blogger
- Google Blogger Dashboard
- Add and delete pages
- Create, edit, manage, or delete a post
- Add images & videos to your blog
- Add and remove favicon
- Manage your comments
- Draft and Schedule post
- Advertise on your blog
- Formatting date and time
- Statistics in Google Blogger
- Change your blog’s look
- Use labels to organize your blog
- Help people find your blog on search engines
- Backup or import your blog
- Manage Reading List in Google Blogger
- Managing multiple blogs under one account
- Introduction to Google Ads
- What is Google Ads?
- What is Google Ads?
- Understanding how Google Ads works
- Understanding how Google Ads works
- Types of Google Ads
- Understanding the functioning of each type
- Understanding the functioning of each type
- Google Display Ads
- Google Display Ads
- Understanding Video Ad formats
- Understanding Video Ad formats
- Shopping campaigns and ads
- Shopping campaigns and ads
- More about shopping campaigns and ads
- More about shopping campaigns and ads
- App campaigns and ads
- App campaigns and ads
- Local Search ads
- Local Search ads
- Display and app dynamic remarketing campaigns
- Display and app dynamic remarketing campaigns
- Create Your Google Ads Account and first campaign
- Switching to Expert Mode
- Switching to Expert Mode
- Create a video ad campaign
- Create a video ad campaign
- View campaign Status
- View campaign Status
- Basics of Google Ads
- About Costs
- About Costs
- Using Google Ads successfully
- Using Google Ads successfully
- Benefits of using Google Ads
- Benefits of using Google Ads
- Abbreviations related to Google Ads
- Abbreviations related to Google Ads
- Google advertising policies
- Google Ads mobile app
- Installation and usage
- Installation and usage
- Keywords and ads
- Keywords vs. Search Queries
- Keywords vs. Search Queries
- Adjusting your keyword bids
- Adjusting your keyword bids
- Choosing the right budget
- Tips for Google Ads budget management
- Tips for Google Ads budget management
- A few more tips for budget management
- A few more tips for budget management
- Troubleshooting common issues
- Difference between Google Ads and Google AdSense
- FAQs on Google Ads
- Introduction
- Overview and basic access
- Basic access and page features
- Basic access and Play function
- Navigating podcast displays in the central panel
- Subscriptions Label and Subscribe function
- Add Subscription options
- Unsubscribe function and Queue Label
- Adding different Queue items and Subscribed Channels on homepage
- Add by RSS Feeds feature
- Search Pane function
- Further sections of Search and Optimizing searches
- Settings feature on Side Panel
- Further settings
- Help, Policies, Guidelines, and Feedback
- Google Podcasts App introduction and getting started
- Exploring various features
- Further settings and other functions
- Podcast settings, last row features
- Introduction to Trends and What is Google Trends?
- Access and overview of the Google Trends tool
- Further overview of the Landing Page
- Menu options and other features
- Explore option functionalities
- Using Explore functionality and other features
- Compare functionality on Explore
- Trending Now
- Using Trending Now – Subscription function
- Using Trending Now – RSS Feed, Embed functions
- Daily Search Trends and Real-time Search Trends
- Changing location for “Trending Now”, Introduction to “Year in Search”
- Categories under “Year in Search”
- Subscriptions, Help, Send Feedback features
- Introduction to Google Trends mobile app
- Using the mobile app
- YouTube and Google Functions
- What is Google Travel?
- From Google Trips to Google Travel
- Features of Google Travel
- Benefits of Google Travel
- Steps to use Google Travel
- Find and book flights and hotels
- Compare prices and make bookings on Google Travel
- Sharing trips on google travel
- Customizing an Itinerary on Google Travel
- Finding local attractions and activities in Google Travel
- Create and Manage expenses on Google Travel
- Add budget and view summary on Google Travel
- Introduction
- Overview of Google One
- Overview of Google One
- Difference between Google Drive and Google One
- Difference between Google Drive and Google One
- Google One storage plans
- Google One storage plans
- Setting up Google One Account
- Install Google One
- Install Google One
- Check your storage
- Check your storage
- Back up
- Back up your device
- Back up your device
- Automatic back up
- Automatic back up
- Google One Tools
- Google One home screen
- Google One home screen
- Clean up
- Clean up
- Google One support and Sharing
- Get more from Google
- Get more from Google
- Google One Support
- Google One Support
- Family sharing
- Family sharing
- Requirements for joining a family
- Requirements for joining a family
- Update Google One membership
- Update Google One membership
- Introduction to Google Currents
- Setup account
- Setup account
- Introduction to user interface
- Introduction to user interface
- Types of shareable content
- Types of shareable content
- Creating and Managing Content
- Creating and editing articles and posts
- Creating and editing articles and posts
- Adding media files to content
- Adding media files to content
- Organizing and categorizing content
- Organizing and categorizing content
- Understanding analytics and metrics
- Analyzing audience engagement and engagement metrics
- Analyzing audience engagement and engagement metrics
- Improving the effectiveness of content
- Improving the effectiveness of content
- Share, reshare, edit, and delete a post
- Share a post
- Share a post
- Reshare a post
- Reshare a post
- Prevent resharing or commenting
- Prevent resharing or commenting
- Mute and unmute a post
- Mute and unmute a post
- Create, edit, delete, and other features in a community
- Create a community
- Create a community
- Edit a community
- Edit a community
- Deleting a community
- Deleting a community
- Other features of a community
- Other features of a community
- Engaging with audience
- Commenting and giving feedback
- Commenting and giving feedback
- Promoting content via social media channels
- Promoting content via social media channels
- Monetizing and advertising
- Various monetization options
- Various monetization options
- Getting Started with Google Workspace Marketplace
- What is Google Workspace Marketplace?
- What is Google Workspace Marketplace?
- Grow Business on Google Workspace Marketplace
- Grow Business on Google Workspace Marketplace
- Basics
- Features of Google Workspace Marketplace
- Features of Google Workspace Marketplace
- Uses of Google Workspace Marketplace
- Uses of Google Workspace Marketplace
- Comparing Free and Paid Storage Options
- Comparing Free and Paid Storage Options
- Storage Capacity
- Storage Capacity
- Plans of Google Workspace Marketplace
- Plans of Google Workspace Marketplace
- Use free trial of Google Workspace Marketplace
- Use free trial of Google Workspace Marketplace
- How to find the right plan?
- How to find the right plan?
- Cover Business Industries
- Cover Business Industries
- Resources of Google Workspace Marketplace
- Resources of Google Workspace Marketplace
- Products of Google Workspace Marketplace
- Products of Google Workspace Marketplace
- Connect with Google sales
- Connect with Google sales
- Connect with Customers
- Connect with Customers
- Connect with a Retailer
- Connect with a Retailer
- Accessibility
- Why use Gmail account to use Google Workspace Marketplace?
- Why use Gmail account to use Google Workspace Marketplace?
- Delete Google Workspace Marketplace?
- Delete Google Workspace Marketplace?
- YouTube for Consumers
- Objective
- Objective
- Introduction
- Introduction
- The purpose of YouTube
- The purpose of YouTube
- Getting started with YouTube
- Getting started with YouTube
- use YouTube for entertainment
- use YouTube for entertainment
- Various options available in YouTube app
- Various options available in YouTube app
- How to search videos on YouTube
- How to search videos on YouTube
- subscribe to various channels and manage subscriptions
- subscribe to various channels and manage subscriptions
- Various features in YouTube App
- Various features in YouTube App
- Turn on Incognito
- Turn on Incognito
- Get YouTube premium
- Get YouTube premium
- Add account
- Add account
- Purchases and memberships
- Purchases and memberships
- Time watched
- Time watched
- Your data in YouTube
- Your data in YouTube
- Various settings in YouTube App
- Various settings in YouTube App
- Downloading and offline viewing of Videos on YouTube
- Downloading and offline viewing of Videos on YouTube
- All about YouTube Premium
- All about YouTube Premium
- Using Voice search on YouTube
- Using Voice search on YouTube
- Some key features of YouTube
- Some key features of YouTube
- YouTube for Creator
- Introduction
- Introduction
- The purpose of YouTube Studio App
- The purpose of YouTube Studio App
- Beginner video shoots using mobile phone
- Beginner video shoots using mobile phone
- Uploading videos using YouTube studio
- Uploading videos using YouTube studio
- Various details to fill in while uploading video
- Various details to fill in while uploading video
- Create playlists and more options
- Create playlists and more options
- Editing videos using YouTube Studio
- Editing videos using YouTube Studio
- Discover more features in YouTube Studio
- Discover more features in YouTube Studio
- Discover other features in YouTube Studio
- Discover other features in YouTube Studio
- Analytics in YouTube Studio app
- Analytics in YouTube Studio app
- Understand more about analytics
- Understand more about analytics
- Subtitling of videos
- Subtitling of videos
- Comments management using YouTube Studio
- Comments management using YouTube Studio
- Outcome
- Outcome
- Content Creator - Advanced
- Writing a script for a short video
- Writing a script for a short video
- The different types of self-help videos
- The different types of self-help videos
- The different types of art videos
- The different types of art videos
- The minimal computer hardware configuration for video editing
- The minimal computer hardware configuration for video editing
- The ideal computer hardware configuration for video editing
- The ideal computer hardware configuration for video editing
- Using different backgrounds for video shoots
- Using different backgrounds for video shoots
- Use a digital camera for shooting videos
- Use a digital camera for shooting videos
- Different types of camera lenses
- Different types of camera lenses
- Camera Lens Characteristics
- Camera Lens Characteristics
- An aperture in photography and the ideal settings for portrait photography
- An aperture in photography and the ideal settings for portrait photography
- Shutter speed and the ideal settings for artificial lighting
- Shutter speed and the ideal settings for artificial lighting
- Overexposing
- Overexposing
- Under exposing
- Under exposing
- White balance
- White balance
- Colour temperature in
- Colour temperature in
- Types of camera movements for video
- Types of camera movements for video
- Composition
- Composition
- The types of shots for filming
- The types of shots for filming
- The basic free video editing tools
- The basic free video editing tools
- The different types of cuts in film editing
- The different types of cuts in film editing
- Checking continuity in editing
- Checking continuity in editing
- The best free video titling tools
- The best free video titling tools
- Colour grading
- Colour grading
- Using chroma for video shoots
- Using chroma for video shoots
- The ideal formats for YouTube videos
- The ideal formats for YouTube videos
- Converting video formats
- Converting video formats
- The basic precautions while recording audio
- The basic precautions while recording audio
- The different types of mics used for audio recording
- The different types of mics used for audio recording
- The basic free audio editing tools
- The basic free audio editing tools
- Getting royalty free background music
- Getting royalty free background music
- Photography Fun Facts
- Photography Fun Facts
- Some interesting facts about YouTube
- Some interesting facts about YouTube
- Outcome
- Outcome
- Getting more YouTube Subscribers
- Writing an attractive channel description
- Writing an attractive channel description
- Using keywords to popularise YouTube channel
- Using keywords to popularise YouTube channel
- Boosting YouTube subscription
- Boosting YouTube subscription
- Getting advertising for YouTube
- Getting advertising for YouTube
- Engage viewers for YouTube videos
- Engage viewers for YouTube videos
- Adding other social media links to YouTube
- Adding other social media links to YouTube
- Sharing podcasts on various platforms
- Sharing podcasts on various platforms
- Backlinks
- Backlinks
- What is Google Fit?
- How to set up Google Fit?
- Move Minutes and Heart Points
- Understanding Google Fit App
- Features
- Tracking your fitness
- Tracking your fitness
- Adding an activity
- Adding an activity
- Dark Mode
- Dark Mode
- Coaching Messages
- Coaching Messages
- Sleep Tracking
- Sleep Tracking
- Fit Widget
- Fit Widget
- App Compatibility
- Advantages and Disadvantages
- Apple Fitness vs. Google Fit
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!
Ready to start Advanced Techniques in Google Workspace?
Join our upcoming batch at ZICA Kalyani center with certified instructors.
Other MKCL Courses
-
Data Entry and Data Management
120 hours -
Office Assistance
120 hours -
Google Workspace Expert
120 hours -
Advanced Data Entry Techniques
60 hours