Office Automation

Office Automation Course

Office Automation is essential for increasing workplace efficiency, streamlining processes, and improving productivity. In the Office Automation course at Prolytics, you will learn key techniques to automate tasks using various office software and tools. This course will equip you with the skills to manage documents, spreadsheets, emails, and databases efficiently.

The course covers key topics such as Microsoft Office Suite, Google Workspace, document management, automation tools, and collaboration platforms. Whether you're a beginner or a professional looking to enhance your office productivity skills, this course will help you master office automation techniques.

What will you learn
  • Introduction to Office Automation

    Understand the fundamentals of office automation and its impact on productivity.

  • Microsoft Office Suite

    Learn how to efficiently use Word, Excel, PowerPoint, and Outlook for office tasks.

  • Google Workspace

    Master Google Docs, Sheets, Slides, and Gmail for seamless collaboration.

  • Document and Data Management

    Explore techniques for organizing, securing, and automating documents and databases.

  • Office Productivity and Collaboration Tools

    Understand automation tools like macros, templates, and cloud-based collaboration platforms.


By completing this course, you will develop expertise in the following areas:

  • Understanding office automation fundamentals
  • Efficiently using Microsoft Office and Google Workspace
  • Managing and automating documents and spreadsheets
  • Utilizing cloud-based collaboration tools
  • Improving workflow efficiency through automation
  • Enhancing communication and email management
  • Implementing security and data protection best practices
  • Utilizing office automation software and AI-driven tools
  • Exploring real-world office automation applications
  • Advancing career opportunities in office administration

Lessons

  • Duration
  • 45 Days
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Downloadable Course Transcript
Overview of the Excel window
Mouse-Features
Back Stage View
Section Quiz
Entering Text and Numbers
Creating Basic Formulas
Relative References
Order of Operations
Working with Ranges
Module 2 - Practice Exercise
Section Quiz
Working with the Save and Save As Commands
File Extensions, Share, Export and Publish Files
Module 3 - Practice Exercise
Section Quiz
Opening a File
Working with Larger Files
Freeze Panes Option
Split Screen Option
Module 4 - Practice Exercise
Section Quiz
Headers and Footers
Print Titles
Comments
Page Setup Options
Fit to Print on One Page
Printing Workbooks
Module 5 - Practice Exercise
Section Quiz
Adding and deleting rows columns and cells
Changing Column and-Row Widths
Module 6 - Practice Exercise
Section Quiz
Cut, Copy and Paste
Copying Formulas
Module 7 - Practice Exercise
Section Quiz
Overview of Formulas
Create Formulas Using Functions Part 1
Create Formulas Using Functions Part 2
Absolute Values
Module 8 - Practice Exercise
Section Quiz
Adding Deleting and Renaming Sheets
Additional Sheet Tab Options
3 Dimensional Formulas
Module 9 - Practice Exercise
Section Quiz
Formatting Cells Part 1
Formatting Cells Part 2
Formatting Numbers
Borders and Shading
Format as Table
Using Styles
Using Format Painter
Protecting Sheets
Fill Handle and Custom Lists
Module 10 - Practice Exercise
Section Quiz
Creating Charts
Types of Charts
Editing Charts Part 1
Editing Charts Part 2
Using Graphics to Enhance Charts
Linking Chart Titles
Module 11 - Practice Exercise
Section Quiz
Creating Range Names
Managing Names
Using Names in Formulas
Module 12 - Practice Exercise
Section Quiz
Remove Duplicates
Sort Data
Filter Data
Advanced Filters
Module 13 - Practice Exercise
Section Quiz
Creating an Outline
Subtotals
Module 14 - Practice Exercise
Section Quiz
Arranging Files
New Window Option
Custom Views
Module 15 - Practice Exercise
Section Quiz
Creating Formulas Between File
Working with Links
Consolidating Data
Module 16 - Practice Exercise
Section Quiz
If Statements
VLookups
Data Validation
Formula Auditing
Module 17 - Practice Exercise
Section Quiz
Pivot Tables
Pivot Charts
Module 18 - Practice Exercise
Section Quiz
Slicers
Goal Seeker
Text to Columns
Watch Window
Customizing Ribbons and Tabs
Module 19 - Practice Exercise
Section Quiz
Excel Shortcuts Every User Should Know
WATCH ME: Essential Information for a Successful Training Experience
Excel 2019 Advanced Course Exercise Files
Excel 2019 Advanced Course Demo Files
Downloadable Course Transcripts
Functions - Part 2
Autosum
Section Quiz
How Date and Time Works
Basic Date and Time Functions
Complex Date and Time Functions
Section Quiz
Using Text Functions - Part 1
Using Text Functions - Part 2
Section Quiz
Logical Functions
Exercise 01
Section Quiz
Lookup Functions - Part 1
Lookup Functions - Part 2
Exercise 02
Section Quiz
Financial Functions and Terminology
Personal Financial Functions
Principal and Interest Payments
Depreciation
Exercise 03
Section Quiz
Statistical Functions for Description - Part 1
Statistical Functions for Description - Part 2
Statistical Functions for Forecasting - Part 1
Statistical Functions for Forecasting - Part 2
Exercise 04
One Click Forecasting
Statistical Functions for Inference
Section Quiz
Connecting to Other workbooks
Connecting to Access Databases
Connecting Web Data Sources
Get and Transform
Exercise 05
Section Quiz
Introduction to Tables
Working with Tables
Table References
Table Styles
Exercise 6
Section Quiz
Introduction to Pivot Tables
Working with Pivot Tables
Filters and Slicers
Pivot and Charts
Exercise 07
Section Quiz
What If Analysis
Scenario Manager
Goal Seek
Solver
Exercise 08
Section Quiz
Area Charts
Surface Charts
Radar Charts
Bubble Charts
Sparklines
Stock Charts
Exercise 9
Section Quiz
Web App - Part 1
Web App - Part 2
Section Quiz
WATCH ME: Essential Information for a Successful Training Experience
Course exercise files
Downloadable Course Transcripts
Overview of the MS Word Screen
The Backstage View
Creating a New Blank Document
Working with Non-Printing Characters and Line Spacing
Saving a Document
Opening a Document
Navigating a Document
Go To, Find and Replace
Editing a Document
Practice Exercise
Section Quiz
Selecting Text
Cut, Copy and Paste
Character Formatting Options
Format Painter
Working with Numbers
Working with Bullets
Creating an Outline
Practice Exercise
Line Spacing Options
Working with Indents
Working with Tabs
Practice Exercise
Section Quiz
Working with Tables
Creating a Table
Adding Rows and Columns to a Table
Formatting Table Data
Borders and Shading
Sorting in a Table
Drawing in a Table
Converting Existing Data to a Table
Quick Tables
Using Formulas in Tables
Practice Exercise
Section Quiz
Working with Styles
Creating Styles
Editing Styles
Practice Exercise
Section Quiz
Working with Page Breaks
Working with Columns
Adding a Watermark
Headers and Footers
Section Quiz
What is Sectioning?
Sectioning a document
Odd and Even Sections
Practice Exercise
Section Quiz
Inserting Pictures
Inserting Pictures into Existing Documents
Picture Options
Working with Shapes
Icons and 3D Models
SmartArt, Charts and Screenshots
Practice Exercise
Section Quiz
Working with Envelopes
Working with Labels
Section Quiz
What is Mail Merge?
Creating a Mail Merge Document - Part 1
Creating a Mail Merge Document - Part 2
Merging a Document with an Existing Data Source
Merging Envelopes and Labels
Merging a Directory
Practice Exercise
Section Quiz
Building Blocks
Auto Text
Practice Exercise
Section Quiz
Creating an Index
Creating a Table of Contents
Practice Exercise
Section Quiz
Using the Thesaurus and Spell Check
Comments
Page Setup Options
Printing
Practice Exercise
Section Quiz
Word Options
Protecting a Document
Macros
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Downloadable Course Transcripts
Overview of the Screen and Views
Exercise 1
Presentation Tips and Guidelines
Creating a New Presentation
Working with Slides
Saving a Presentation
Exercise 02
Section Quiz
Formatting Text
Working with Bullets and Numbered Lists
Exercise 03
Section Quiz
Inserting Shapes
Inserting Graphics
Inserting Pictures
Exercise 04
Section Quiz
Selecting Objects
Editing Objects
Formatting Objects - Part 1
Formatting Objects - Part 2
Arranging Objects
Grouping Objects
Exercise 05
Section Quiz
Picture Options
Cropping Pictures
Formatting Pictures
Things You Can Do with Pictures
Exercise 06
Section Quiz
Creating SmartArt
Modifying SmartArt
Creating a Flowchart using SmartArt
Exercise 07
Section Quiz
Creating Tables
Formatting Tables
Inserting Tables
Exercise 08
Section Quiz
Adding Charts
Formatting Charts
Inserting Charts from Microsoft Excel
Exercise 09
Section Quiz
Using Master Slides
Modifying Master Slides
Creating a New Master Design Template
Exercise 10
Section Quiz
Adding Video to a Presentation
Adding Audio to a Presentation
Exercise 11
Section Quiz
Applying Transitions
Transition Options
Exercise 12
Section Quiz
Animating an Object
Effect Options
Working with the Animation Pane
Motion Paths
Triggers
Exercise 13
Section Quiz
Working with Action Buttons
Working with Hyperllinks
Exercise 14
Section Quiz
Onscreen Presentation Options
Hiding Slides
Changing the order of slides
Copying slides
Slideshow Options
Exercise 15
Rehearse Timings
Recording a Presentation
Slide Show Settings
Creating a Custom Slide Show
Exercise 16
Exporting options
The Backstage Area
Printing a Presentation
Exercise 17
Introduction to Access 2019
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Downloadable Course Transcripts
Acquiring Access 2019
Structure of the Course
Section Quiz
Using Database Templates
Creating, Saving and Opening Databases
The Access Workspace and Backstage
Online Help and Tell Me What You Want To Do
Section Quiz
Working with the Ribbon
The Quick Access Toolbar
Contextual Menus
The Status Bar
Section Quiz
Keyboard Shortcuts
Key Tips
Section Quiz
Exploring Access Options
Section Quiz
Creating a Table and Fields
Indexed Field
Lookup Wizard
Numeric Fields
Practice Exercise 01
Section Quiz
Importing Data from Excel
Practice Exercise 02
Section Quiz
Backing up your Database
Compact and Repair
Section Quiz
Design in the Datasheet View
Sorting and Filtering in Datasheet View
Entering and Modifying Data in Datasheet View
Section Quiz
Creating a Link Table
Setting up Relationships
Exercise 03
Section Quiz
Creating a Form
Modifying a Form
Practice Exercise 04
Forms in Layout View
Forms in Design View
Form Design
Practice Exercise 05
Section Quiz
Setting Up Subforms - Part 1
Setting Up Subforms - Part 2
Setting Up Subforms - Part 3
Practice Exercise 06
Section Quiz
Creating a Query
Joins
Query Wizard
Practice Exercise 07
Section Quiz
Setting Up Validations
Calculation using Expressions
Section Quiz
Basic Reports
Report Design
Complex Reports
Practice Exercise 08
Section Quiz
Printing and Print Properties
Section Quiz
Yes/No, OLE Objects and Hyperlink Data Types
Section Quiz
Form Controls
Form Themes
Navigation Forms
Section Quiz
Exporting an Access Database
Section Quiz
Adding Application Parts to a Database
Additional Access 2019 Options
Section Quiz
Edit Database Properties and Encrypt with Password
Section Quiz
Course Overview and Content
WATCH ME: Essential Information for a Successful Training Experience
Course Exercise Files
Course Demo Files
Downloadable Course Transcripts
Section Quiz
Primary Keys and Indexing Rules and Guidelines
More About Indexes
Section Quiz
Setting-up Northwind Database
Working in a Datasheet View
Customizing Datasheet View and Advanced Sorting and Filtering
Subdatasheets
Exercise 01
Section Quiz
Linking Two Tables to Other Access Databases
Section Quiz
Acquiring and Installing SQL Server Express
Setting Up SQL Server Database
Exercise 02
Section Quiz
Splitting an Access Database into Front-end and Back-end
Converting Shared Table into Local Table; Moving Back-end Database
Exercise 03
Addressing Multi-user Issues when Sharing Data
Section Quiz
Basics of Macros
Macros on Events; AutoExec
More About AutoExec; Bypassing AutoExec
Macro Security Settings
Exercise 04
Section Quiz
Customizing the Ribbon and Quick Access Tool
Section Quiz
Convert Macros to VBA; VBA Editor and Property Windows
VBA Modules; Running Code and Error Handling
Creating Modules; Subs, Functions, Intellisense and Variables
Scope, Variable Naming and Strings
Standard Functions; Logical, Case and Loop Statements
Section Quiz
Adding Events to Assets Database
Exercise 05
Common Events; Form and Report Events
Switchboard and Navigation Form; Error Handling
Exercise 06
Section Quiz
Formatting Bound and Control Form
Split Forms; Macro Error Handling
Creating Form with Tab
Go To Combo Box and Its Properties
Exercise 07
Section Quiz
Basics of Queries
Syntax of SQL Statements
Use of Multiple Where Criteria & Select Statements Function
Exercise 08
Action Queries - Part 1
Action Queries - Part 2
Section Quiz
Steps in Packaging Access Application
Exercise 9
Section Quiz
Course Close
An Overview of Outlook 2019
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
Outlook 2019 vs Outlook Online in Office 365
What to Expect from this Course
Getting Help with Outlook 2019
Keyboard Shortcuts
Section 1 Quiz
Navigating the Outlook Interface
The Ribbons and the Quick Access Toolbar
Adding an Email Account
Practice Exercise 01
Section 2 Quiz
Sending and Receiving Mail
Focused Inbox
Customizing the Inbox
Saving Attachments
Customizing Mail Views
Practice Exercise 02
Section 3 Quiz
Searching Mail
Creating Search Folders
Practice Exercise 03
Section 4 Quiz
Ignoring Conversations
Deleting, Archiving and Restoring Mail
Cleaning Up Conversations
Using Follow Up Flags and Categories
Organizing Mail with Folders and Subfolders
Using Quick Steps to Process Mail
Working with Conditional Formating and Mail
Auto-Process Mail using Rules
Managing Junk Mail
Practice Exercise 04
Section 5 Quiz
Creating a New Mail Message
Attaching Files, Photos, Graphics and Other Items
Directing Mail with @mentions
Recalling a Message
Making decisions with Voting Buttons
Adding an Email Signature
Delivery Options
Sending Automatic Replies
Navigating using Hyperlinks and Bookmarks
Practice Exercise 05
Section 6 Quiz
Adding a New Contact
Utilizing the Contact Card
Creating a Contact Group
Managing Contacts using Folders
Practice Exercise 06
Section 7 Quiz
Overview of the Calendar and Views
Customizing the Look and Feel
Creating an Appointment or All Day Event
Creating a Meeting and Inviting Others
Responding to Meeting Invites
Sharing Calendars and Delegating Access
Practice Exercise 07
Section 8 Quiz
Creating a New Task
Assigning and Completing Tasks
Creating Notes
Working with OneNote
Practice Exercise 08
Section 9 Quiz
Opening and Exporting Data
Printing
Customizing Outlook Options
Section 10 Quiz
Course Close
BONUS Lecture
What is Microsoft Teams and why is it useful?
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
What to Expect from this Course
How to access/download Teams
Overview of the Teams Dashboard
Getting Help with Microsoft Teams
Section 122 Quiz
Create a Team and Add Internal and External Team Members
Join an Existing Team
Manage teams and members
Create and Manage Channels
Post and Receive Messages
Target messages using @mentions
Editing and Deleting Messages
Bookmark and Like Messages
Add images, emojis aand gifs to messages
Formatting Messages
Make a Announcement
Using Tags
Attaching Files and Images
Send a Private Message
Add Messaging Extensions
Section 123 Quiz
Video and Audio Calls on Demand
Sharing Files
Schedule a Meeting
Schedule a Live Event
Record a Video Meeting or Call
Notes
Section 125 Quiz
Use the Wiki tab to share information
Using apps, bots and connectors
Customizing Channel Tabs
Section 125 Quiz
Use Search to find specific messages, files or people
Using Quick Commands
Section 126 Quiz
Adjust user settings
Explore the administration settings
Section 127 Quiz
Working with the Teams Mobile App
Section 128 Quiz
Out of Office
Notification Settings
Bypass the Lobby (Invitees)
Control Attendees Mic Settings
Share to Teams from Outlook
Meet Now from the Calendar
Recap of Meeting
Use Grid View to share PowerPoint Content
View Activity History
Feel Connected with Together Mode
Apply Background Effects
React to Conversations with Emojis
Publish a Company-wide Task list
Approvals
Breakout Rooms
Section Quiz
What to Expect from this Course
READ ME: Essential Information for a Successful Training Experience
Downloadable Course Transcripts
OneNote Versions
Working with Keyboard Shortcuts
Customizing the Quick Access Toolbar
Using Touch Mode
Section Quiz
Opening a OneNote notebook and Touring the Interface
Creating a OneNote Notebook
Changing Notebook Properties and Closing
Deleting a Notebook Stored in OneDrive
Creating and Managing Locally Stored Notebook
Creating, Moving and Deleting Sections
Creating Section Groups
Working with Pages and Subpages
WINDOWS 10: Getting Started with OneNote
Section Quiz
Creating a Note on a Page
Sending Content to OneNote
Using the OneNote Clipper
Using the Screen Clipper
Adding Pictures and Online Pictures
Embedding Online Video
Adding Files
Recording Audio and Video
Inserting Links
Inserting Equations and Symbols
Copying and Pasting Content
WINDOWS 10: Adding Content
Section Quiz
Formatting Text
Using the Format Painter
Using Styles
Organize Content with a Table
Creating a Todo List
Checking Spelling
WINDOWS 10: Formatting Notes
Section Quiz
Searching a Notebook
Tagging Notes
Organizing the Interface
Linking Notes
WINDOWS 10: Organizing Content
Section Quiz
Page Setup Options
Changing the Page Color and Background
Customizing Fonts, Themes and the Interface
Setting Paper Size
WINDOWS 10: Formatting Pages
Section Quiz
Applying a OneNote Template to a Page
Creating Your Own Template
WINDOWS 10: Working with Templates
Section Quiz
Working in Pen Mode
Drawing Shapes with Touch
Converting Handwriting to Typed Text
WINDOWS 10: Using Drawing Tools
Section Quiz
Working with Outlook Tasks
Outlook Meetings and Meeting Notes
Sending Page Information by Email
Windows 10: Interacting with Outlook
Section Quiz
Saving to OneDrive
Inviting Others to a Notebook
Converting Notebooks to Other Formats
Exporting OneNote Content
Synching Notebooks
WINDOWS 10: Sharing a Notebook
Section Quiz
Author Indicators
Page Versions
The Notebook Recycle Bin
WINDOWS 10: Collaborating on a Notebook
Section Quiz
Customizing OneNote Options
Password Protection
Setting Backup Options
WINDOWS 10: Setting OneNote Options
Section Quiz
Using OneNote Online
Working with OneNote Mobile app
Section Quiz
EXTRA LESSON: Designing Better Spreadsheets Webinar Recording
EXTRA LESSON: Data Cleaning in Excel Webinar Recording
EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording
EXTRA LESSON: Creating Engaging PowerPoint Presentations Webinar Recording
EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic
READ ME: This Additional Training Is Optional
Ten Excel Tips and Tricks - Part 1
Ten Excel Tips and Tricks - Part 2
Ten Excel Tips and Tricks - Part 3

You Can Trust with Global Certification

At Prolytics Institute, our certifications are globally recognized, ensuring that your skills are validated by a trusted authority. Whether you're advancing in your current role or exploring new career opportunities, our credentials give you a competitive edge in today’s global job market.

Our certification programs are designed to meet international standards while catering to local industry needs. This ensures that your expertise is not only widely accepted but also practically applicable wherever you go.

  • 100% Jobs Placements

Committed to preparing you for successful career placement and acing job interviews.

  • Advanced Curriculum

Our curriculum is thoughtfully crafted by senior angular specialists with extensive industry experience.

  • Latest Technologies

The course prioritizes cutting-edge technologies that are in high demand among top web design firms and global corporations.

  • Confidence Development

A Personality Development program that enhances skills in professional communication, email writing, and effective interview techniques.

  • Work on Real Projects

Engaging hands-on practice and real-world projects form a key part of the learning experience.

  • Top IT Professionals

Learn directly from professionals who are currently active as developer in top IT companies.

certification

FAQs

General frequently asked questions for students.

Our instructors are experienced professionals actively working in the IT industry. They bring real-world insights, practical knowledge, and expertise to the classroom, enhancing the learning experience.

Yes, we offer dedicated job placement support to our graduates. This includes resume workshops, mock interviews, and direct connections with our industry partners to help students transition smoothly into their careers.

Prolytics provides both in-person and online classes to cater to various learning preferences. Our online classes are live and interactive, allowing students to engage directly with instructors and peers.

Absolutely! We prioritize hands-on learning through practical projects and assignments based on real-world scenarios. These projects help students gain practical experience and build a portfolio to showcase to potential employers.

Yes, upon successfully completing a course, students receive a certificate from Prolytics, recognized by industry partners and highly valued in the job market.

Prolytics has a flexible refund policy. Students who need to withdraw may be eligible for a partial refund, depending on the timing and course structure. Please contact our support team for detailed information on refunds.

To enroll, visit our website and register the enrollment form for your desired course. You can also reach out to our admissions team for guidance on course selection and the enrollment process.

Students Reviews


Akansha – 19-Mar-18:

I was from accountancy field, but in my job I started feeling need of computer for my daily job work.I did office-automation course from Prolytics and I am completely satisfied.

Pradeep – 22-Jun-19:

The instructors I had when doing the office automation course at Prolytics was very polite and patiently taught me basics.