Microsoft Office 365

Learn Microsoft Office 365: Excel, Word, PowerPoint & More.

Unlock your potential with our in-depth Microsoft Office 365 courses. Learn Excel, Word, PowerPoint, Access, and more from industry experts. Gain valuable skills for work & personal use.

Gain essential workplace skills with this comprehensive Microsoft Office course. Learn to use Excel, Word, PowerPoint, and other key applications effectively. Improve your productivity and enhance your career prospects.

What will you learn?

Office 365

Microsoft Word

Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings – To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Header & Footers 

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Add a section break to a document

Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
  • Creating List
  • Customizing List style
  • Page bordering
  • Page background

Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option

Styles and Content 

  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote 

Merging Documents 

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert the field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options

Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks 

Proofing the document 

  • Check Spelling as You Type.
  • Mark Grammar Errors as You Type
  • Setting AutoCorrect Options

Printing 

  • Page Setup, Setting margins
  • Print Preview, Print 

 

MS EXCEL

Introduction to Excel

  • Introduction to Excel interface
  • Understanding rows and columns, Naming Cells
  • Working with excel workbook and sheets

 Formatting Excel workbook:

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

Perform Calculations with Functions 

  • Creating Simple Formulas
  • Setting up your formula
  • Date and Time Functions, Financial Functions
  • Logical Functions, Lookup and Reference
  • Functions Mathematical Functions
  • Statistical Functions, Text Functions

Sort and Filter Data with Excel

  • Sort and filter data
  • Using a number filter, Text filter
  • Custom filtering
  • Removing filters from columns’ conditional formatting

Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool
  • Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart

Analyze Data Using PivotTables and Pivot Charts

  • Understand PivotTables, Create a PivotTable
  • Framework Using the PivotTable and PivotChart
  • Create Pivot Chart from the pivot Table.
  • Inserting slicer
  • Creating Calculated fields

Protecting and sharing the workbook

  • Protecting a workbook with a password
  • Allow users to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Documents and PowerPoint Presentation.

Use Macros to Automate Tasks

  • Creating and Recording Macros
  • Assigning Macros to the worksheets
  • Saving Macro enabled workbook

Proofing and Printing

  • Page setup, setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, setting margins, Print Preview, Print
  • Enable background error checking
  • Setting AutoCorrect Options

 

MS POWERPOINT

 

Setting Up PowerPoint Environment:

  • New, Open, Close, Save, Save As
  • Typing the text, Alignment of text
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underlined
  • Cut, Copy, Paste, and Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

Creating slides and applying themes

  • Inserting new slide
  • Changing the layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views

Working with bullets and numbering

  • Multilevel numbering and Bulleting
  • Creating List
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option

Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Change the Order of Objects
  • Inserting slide header and footer
  • Inserting Text boxes
  • Inserting shapes, using quick styles
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Working With Movies and Sounds

  • Inserting Movie from a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video

Using SmartArt and Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
  • Converting text to smart art

Animation and Slide Transition

  • Default Animation, Custom Animation
  • Modify a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Apply a Slide Transition, Modifying a
  • Transition, Advancing to the Next Slide

Using slide master

  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders

Slide show option

  • Start slide show
  • Start show from the current slide
  • Rehearse timing
  • Creating a custom slide show

 Proofing and Printing

  • Check Spelling as You Type
  • Setting AutoCorrect Options
  • Save as Video
  • Save as JPEG files
  • Save as PowerPoint Show file
  • Print Preview, Print

Course Highlights

Hands-on Learning

Engage in interactive exercises, real-world projects, and simulations to solidify your understanding and build practical skills.

Expert Instruction

Learn from experienced instructors with industry expertise who provide clear, concise, and engaging instruction.

Who Can Enroll?

Our MS Office 365 courses are ideal for:

  • Recent 10th Passed out students: Start your career with in-demand data analytics skills.
  • Professionals Seeking Advancement: Enhance your capabilities for better job opportunities and promotions.

Career Opportunities

  • Administrative Assistant: Essential for tasks like scheduling, document creation, and communication.
  • Data Entry Specialist: Proficiency in Excel is crucial for accurate and efficient data input and management.
  • Executive Assistant: Requires strong skills in Word, Excel, PowerPoint, and Outlook for high-level support.
  • Project Manager: Utilize Excel for project planning, budgeting, and tracking progress.
  • Marketing Specialist: Create presentations (PowerPoint), analyze data (Excel), and draft reports (Word).
  • Financial Analyst: Excel is indispensable for financial modeling, data analysis, and reporting.
  • Teacher: Utilize PowerPoint for engaging presentations, Excel for grading and data analysis, and Word for lesson plans.
  • Freelancer: Offer services such as data entry, report writing, and presentation creation to clients.
  • Entrepreneurs: Manage finances, create business plans, and design presentations for your own business.

Apply Online

Upgrade your skills and be competent for the on demand jobs.

Frequently Asked Questions (FAQ)

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.