4.6 Upto 3 Month
English / हिंदी में सीखें

Essential MS Office

Basic to Essential Level Microsoft office Training Course | A Complete Guide to MS Word, PowerPoint & Essential Excel to take your formatting, presention and data analysis skills to intermediate level.

Rs.6500 52% off Rs.13500

Free Essential Courses Demo Class Complimentary class with Certificate

Duration

Essential MS Office is upto 3 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

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

  • 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

  • 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

  • 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

  • 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

  • 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)

  • 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 11-Nov-2024

    Upto 3 Month

    Classroom / Online

    Weekdays

  • Tuesday 12-Nov-2024

    Upto 3 Month

    Classroom / Online

    Weekdays

  • Thursday 14-Nov-2024

    Upto 3 Month

    Classroom / Online

    Weekdays

  • Friday 15-Nov-2024

    Upto 3 Month

    Classroom / Online

    Weekdays

About Essential MS Office Course in

The Essential Microsoft office course is a 3-in-1 bundle that covers the intermediate-level topics regarding Microsoft Word, Microsoft Excel and Microsoft PowerPoint. The course builds on the fundamental knowledge and explores the different concepts required in the workplace.
 
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

Essential Courses Alumni

Frequently Asked Questions

Essential MS Office is a short term course of 3 months.

The fee of course Essential MS Office is Rs.6500/-

This course covers Introduction, Essential Word, Excel, Powerpoint

The course is available in both online & classroom modes at the training center in Dehradun.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner