SYLLABUS Essential MS Office
Basic Word 26 Topics
Introduction to Word
Page Setup (Margin, Orientation, Columns, Page size)
Save & open a document
Create new document
Breaks (Page Break & Column Break)
Hyphenation & Line Number
Document Formatting(Change in font, change in font size, highlighting text and change in text color)
Change case
Format Painter
Strikethrough, Double Strikethrough, Small Caps, All Caps
Bold, Italics & Underline
Subscript & Superscript
Indent & Line spacing options
Working with Tables
Bulleted and Numbered List
Change Text Direction
Find and Replace
Spell Check
Working with Text Box
Header and Footer
Draw a Shapes
Working with images in the document
Add a Drop Cap
WordArt and Watermark
Page Border and Page Color
Business Bills, Invoices and Receipts
Essential Word 13 Topics
How to insert symbols
Multi-level List
Step by Step Mail Merge Wizard
Select and Edit Recipients List
Envelopes and Labels
Hyperlink and Bookmark
Insert a SmartArt Graphics and Charts
Selection Pane
Thesaurus, Word Count, Translate and Language
How to create a cover page
Insert date and Time
Take a Screenshot
Arrangement of Objects
Basic Excel 13 Topics
Introduction to Excel
Saving Workbook and Adding / Deleting Renaming Worksheets
Basic calculations : Sum, Product, Factorial, Square Root, Average, Max, Min, Mode & Median
Basic functions like Count, Counta & Count Blank, Upper, Lower, Subtotal
Data Sorting
Format Painter
Text to Column, Text Formatting
Filter, Rand Function
Average and AverageA
Count, Counta and Countblank
How to insert and delete a cell, row and column from a worksheet
Round, Roundup, Rounddown
Date & Time Functions like Date, Day, Month, Year, Today, Hour, Minute, Second
Essential Excel 18 Topics
Charts
Multicategory Chart
Static Transpose
Find Depreciation of an Asset
Logical Functions like IF, IF-Else
Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim
Lookup
Subtotal Function
Rank Function
Rand and Randbetween
Sumproduct
Choose
Format as table
Conditional formatting
Page setup & Print
Freeze Panes
Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,
Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions
Basic PowerPoint 17 Topics
Introduction to PowerPoint
Create a presentation
Slide Setup
Save a presentation
Choose a slide design
Text Formatting in Slides (Change in font, change in font size and change in text color)
Text Alignment in Slides
Background formatting in slides
Working with Text box
Insert Pictures
Draw a shapes
Add Symbols
Working with Tables
Change Text Direction
Insert a Smartart & Chart
Text formatting through WordArt
Different types of Slide Layout
Essential PowerPoint 7 Topics
Create a Photo Album
Insert a Screenshot
Adding Audio and Video to your Presentation
Transitions and Animations
Create custom slideshow of slides
Date and Time & Slide Number
Different views in PowerPoint( Normal, Outline view, Slides Sorter, Notes Pages, Reading View)
Project on Essential MS Office 7 Topics
MS Word- Format documents efficiently in MS Word.
MS Word- Preparations of document
MS Word- Create Registration & Application Form
MS Excel - Create and manage Spreadsheet Layouts
MS Excel- Increase your efficiency by creating and using important Excel shortcuts
MS Excel- Create Salary Slip of an Employee
MS PowerPoint- Apply Charts, Graphs & Tables to your PowerPoint Presentation
What you'll learn Essential MS Office
- Learn the essential Microsoft Office Skills in Excel, Word and PowerPoint.
- Learn Word tools using columns, indents, footers, borders and watermark.
- Learn practical methods to sort and filter your data in Excel.
- Expertise in Date, Time and Logical Function
- Learn to Customize the PowerPoint slides.
- Animations and Transitions in MS-Power Point.
- Add animation to text, shapes and pictures.
- Learn the Shortcut Keys for Microsoft Word, PowerPoint & Excel.
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 52% Scholarship
-
Monday 03-Jun-2024 -
Wednesday 05-Jun-2024 -
Thursday 06-Jun-2024 -
Friday 07-Jun-2024
About Essential MS Office Course in
Microsoft Office is an essential application for students, office workers, executives, finance analysts, Retail store manager and Project manager.This course helps the candidates to get started with the latest version of Microsoft Office. The course enables the candidates to acquire the necessary knowledge to efficiently use the features of Microsoft Office to achieve excellence in the daily routine tasks.
By taking this course you will be able to:
- Confidently use the core Microsoft Office programs in the workplace.
- Learn the skills employers expect you to have in Word,Excel and PowerPoint.
- Apply best practices to your work.
- Achieve confidence and job satisfaction through practice.
Exam & Certification Essential MS Office
An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.
Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.
![ISPL Academy Certificate Sample](images/certificate03.jpg)
Essential Courses Alumni
Frequently Asked Questions
What is the duration of course Essential MS Office?
Essential MS Office is a short term course of 3 months.
What is the fee of Essential MS Office?
The fee of course Essential MS Office is Rs.6500/-
What topics are covered in Essential MS Office?
This course covers Introduction, Essential Word, Excel, Powerpoint
What is the mode of Training?
The course is available in both online & classroom modes at the training center in Dehradun.