ISPL Academy Logo
4.7 Upto 2 Month
English / हिंदी में सीखें

Advance Excel + Advance Word

Take your productivity skills in Microsoft Excel and Microsoft Word to an advanced level and boost your employability skills.

Rs.7100 54% off Rs.15500

Free Advance Courses Demo Class Complimentary class with Certificate

Duration

Advance Excel + Advance Word is upto 2 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 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

  • 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

  • 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

  • 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 54% Scholarship

  • Friday 29-Mar-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Tuesday 02-Apr-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Wednesday 03-Apr-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

  • Thursday 04-Apr-2024

    Upto 2 Month

    Classroom / Online

    Weekday & Weekend

About Advance Excel + Advance Word Course in

Ever dreamt of using MS Word and MS Excel like a pro. Learn the most advance and powerful skills & function of MS Excel and MS Word during this course and become the most valuable asset of your company. Compaines around the word are looking for people expert in using MS Word and MS Excel in advance way. Join of the most sought computer skill by employers around the world. ISPL Academy Dehradun bring you the most advance certification program in Microsoft Word and Advance Microsoft Excel Office Training. Whether you are a professional or beginner; advance understanding of MS Word and MS Excel will give you the expertise you need to apply for a job vacancy of your choice. When you learn from our Trainers, you can be confident that what you will learn will be accurate, complete and up-to-date. This course is available as Online and Classroom mode at our Dehradun Computer Training Centers.   
 

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

Advance Courses Alumni

Frequently Asked Questions

Advance Excel+ Advance Word is a short term course of 2 months.

The fee of course Advance Excel+ Advance Word is Rs.7100/-

This course covers Advance Excel and 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.

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