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

Advance MS Office

Work like a pro. Learn the most advance and powerful skills & function of Advance MS Office course. A complete guide to MS Word, Excel and Powerpoint.

Rs.10300 49% off Rs.20100

Free Advance Courses Demo Class Complimentary class with Certificate

Duration

Advance MS Office is upto 4 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 Advance 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

  • Insert a Signature Line

  • Collaborative Tools (Compare two documents, Track Changes, Accept and Reject Changes, Comments)

  • Create and run Macros

  • Cross Referencing

  • Footnotes & Endnotes and Bibliography

  • Table of Contents

  • Insert an Equation

  • How to Insert captions

  • Official Letters, Questionnaire, Professional Resume

  • Working with templates

  • Arrangement of Windows

  • Export as PDF

  • 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

  • Concatenate Function

  • Logical Functions like Nested IF, Complex IF-ELSE-IF, IFERROR, AND & OR

  • Dynamic Transpose

  • Criteria Based Functions: Sumif and sumifs, Countif and Countifs, Averageif and Averageifs functions

  • Advance Filters

  • Absolute, Relative & Mixed Reference

  • Advance Conditional Formatting

  • Index, Match function

  • Data Validation

  • Data validation with Dependent List

  • PMT function

  • PPMT and IPMT Function

  • What if Analysis (Scenario, Goal seek, Data Table, Forecast)

  • Pivot Table

  • Consolidate data Sheets

  • Dsum, Dmax, Dmin & Daverage

  • Vlookup Function

  • Double Vlookup Function

  • Advance Vlookup with Max-Min, Vlookup with IfError, Vlookup with Validation, Intersheet Vlookup with Referencing

  • Hlookup Function

  • How to Export Sheet into PDF

  • Basic Macros

  • Advance Charts(Donut Chart, Speedometer Chart, Trend Arrows, Target vs Actual, Scatter chart, Thermometer Chart, Gantt chart with conditional Forma

  • Protect worksheet & Formulas

  • Advance Conditional Formatting with Form Control

  • Triple VLookup

  • VLookup & HLookup with Match Function

  • Solver Function

  • Dynamic Offset with Sum & Average Function

  • Forecast Sheet

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

  • Creating a Professional Presentation

  • Insert Screen Recording

  • Animation Pane

  • Customize a Slideshow(Setup Slideshow, Hide Slide, Rehearse Timings, Record)

  • Master views in PowerPoint( Slide Master, Handout Master, Notes Master)

  • Arrangement of Windows

  • Use of color and grayscale mode

  • Export to PDF

  • Exporting to Video

  • 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 Excel- Find out EMI through PMT Function

  • MS Excel- Create a Pivot Table

  • MS PowerPoint- Apply Charts, Graphs & Tables to your PowerPoint Presentation

  • MS PowerPoint- Create backgrounds and working with templates

What you'll learn Advance MS Office

  • Learn Word tools including using columns, indents, footers, borders and watermarks.
  • Functions & Options explained in most logical and simplest manner
  • Learn how to insert Citations and work with Bibliographies
  • Functions like PMT, Vlookup, Hlookup, Double vlookup, deleting duplicates
  • How to create Mailing labels and Form Letters by Performing Mail Merge
  • Track and accept / reject changes to documents
  • Learn time saving techniques including how to copy slides, and exporting your presentation
  • Add charts, graphs and tables to your PowerPoint presentation
  • Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint.

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

Upcoming Batches

  • JOIN NOW And Get 49% Scholarship

  • Friday 01-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekdays

  • Monday 04-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekdays

  • Tuesday 05-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekdays

  • Wednesday 06-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekdays

About Advance MS Office Course in login

Microsoft Office applications are the most used applications across the world.  In this course of MS This Microsoft Office course is a complete guide for all these above-mentioned MS office applications & their uses. In this course at Microsoft office, you will be able to learn all the advance uses of Microsoft Word, Microsoft PowerPoint and Microsoft Excel. This Microsoft office course is All in one complete MS office guide from basic to advanced level. Microsoft office is the need of everyone so If you are studying in any field or working in any sector this Mega Microsoft Office Training Course is a must for you. If you have never used any of these MS Office products still you can choose this training course because this Microsoft Office course aims to facilitate beginners as well.Office, products such as Microsoft Word, Microsoft PowerPoint and Microsoft Excel will be covered.

Microsoft Word is used for writing books, letters, applications, resumes, and reports or it can be used for any kind of documentation work. Microsoft PowerPoint is used for presentations. In Microsoft PowerPoint, data summary, findings, results, reports, goals, achievements, tasks, or any kind of documentation work can be presented in the form of small points & in fewer slides. Microsoft Excel is used to create spreadsheets for data calculation, data analyzation & data consolidation work.

As already mentioned that this MS Office training aims to facilitate beginners as well so some entry-level topics are also added but if you already have the basic knowledge about any of these seven Microsoft office applications then you can skip only those basic topics as they are almost the same for all of these seven Microsoft Office applications.

Exam & Certification Advance 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

Advance Courses Alumni

Frequently Asked Questions

Advance MS Office is a short term course of 4 months.

The fee of course Advance MS Office is Rs.8600/-

This course covers Introduction, Advance Word, Excel, Powerpoint.

Microsoft Office training will give you the expertise you need to do your day to day tasks and improve your worth in your organization or apply for a job vacancy of your choice. Our expert trainers will teach you on real-life assignments which will give you much needed confidence in using MS Office in your work area or in your day to day activities. Essential excel helps the user to perform complex and large calculations, data processing on the huge amount of data, performs data analysis, better representation of data, etc. It allows the business to increase their productivity and performance by easily sorting and filtering relevant data and using it for better decision making.

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