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
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
Advance MS Word 12 Topics
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
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
Advance Excel 30 Topics
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
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)
Advance PowerPoint 9 Topics
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
Project on Advance MS Office 10 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 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
-
Wednesday 12-Jun-2024 -
Thursday 13-Jun-2024 -
Friday 14-Jun-2024 -
Tuesday 18-Jun-2024
About Advance MS Office Course in
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](images/certificate03.jpg)
Advance Courses Alumni
Frequently Asked Questions
What is the duration of course Advance MS Office?
Advance MS Office is a short term course of 4 months.
What is the fee of Advance MS Office ?
The fee of course Advance MS Office is Rs.8600/-
What topics are covered in Advance MS Office?
This course covers Introduction, Advance Word, Excel, Powerpoint.
What is Advance MS Office?
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.