SYLLABUS Advance Excel + Advance Word
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
Advance MS 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
Project on Advance Word 4 Topics
How to Protect and Compare a Word Document.
Work with Macros, View Macros & Record Macros
Create Table of Contents, Footnotes & Endnotes
How to Insert Table of Figures and Index
Project on Advance Excel 5 Topics
Calculate Rank
Create a Pivot Table
Find out EMI through PMT Function
Calculate Loan Amount
Compare Sales Report through Consolidate function
What you'll learn Advance Excel + Advance Word
- Become proficient with Mail Merge using Excel Spreadsheet
- Functions explained in most logical and simplest manner
- Suitable for beginners to advanced users ideal for users who learn faster when shown
- Functions like PMT, Vlookup, Hlookup, Double vlookup, deleting duplicates
- Learn advanced skills using Microsoft Word
- Functions like count, countif, countifs, sum, sumif, sumifs
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 55% Scholarship
-
Monday 27-May-2024 -
Tuesday 28-May-2024 -
Wednesday 29-May-2024 -
Friday 31-May-2024
About Advance Excel + Advance Word Course in
Exam & Certification Advance Excel + Advance Word
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 the course Advance Excel+ Advance Word?
Advance Excel+ Advance Word is a short term course of 2 months.
What is the fee of Advance Excel + Advance Word?
The fee of course Advance Excel+ Advance Word is Rs.7100/-
What topics are covered in Advance Excel+ Advance Word?
This course covers Advance Excel and Advance Word.
What is Advance Excel + Advance Word?
Advanced 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. MS Word enables users to do write-ups, create documents, resumes, contracts, etc. This is one of the most commonly used programs under the Office suite. It has advanced features which allow you to format and edit your files and documents in the best possible way.