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

Essential Office + Advance Excel + Dashboard

Learn expert-level MS Office, Data Visualization & Dashboard Skills. Learn how to work with large set of data and how to visually present them with the help of dashboard.

Rs.15500 39% off Rs.25500

Free Excel & Analytics Demo Class Complimentary class with Certificate

Duration

Essential Office + Advance Excel + Dashboard 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 Essential Office + Advance Excel + Dashboard

Introduction to Computers 5 Topics

  • Operating System Windows

  • File Folder Management

  • Desktop

  • Start Menu

  • Applications

  • 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

  • Line spacing options

  • Bulleted and Numbered List

  • Change Text Direction

  • Find and Replace

  • Spell Check & Thesaurus

  • 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

  • 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

  • Excel Dashboard Introduction

  • Data visualization in Excel Dashboard using charts

  • Interactive elements (form controls) into dashboard

  • Sales Dashboard from scratch

  • HR Dashboard from scratch

  • Single and Multiple slicer to filter the Pivot Table

  • Advance Pivot Charts connectivity with multiple slicer

  • Timeline for Pivot Charts using form control

  • Advance Charts (Multi category Charts, Donut Chart, Speedometer Chart, Thermometer Chart)

  • KPI(Key Performance Indicator) Dashboard

  • Format documents efficiently in MS Word

  • Preparations of Documents to Print and Export

  • Prepare Resume & Bills

  • Create Registration & Application Form

  • Apply charts, graphs and tables to your PowerPoint presentation

  • Create backgrounds and working with templates

  • 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 Essential Office + Advance Excel + Dashboard

  • Format documents effectively using Microsoft Word
  • Using Header, Footer, Page no and Table of content
  • Create Pivot Table and Charts in MS Excel
  • Creating Powerful Presentation
  • Become proficient with Mail Merge using Excel Spreadsheet
  • Suitable for beginners to advanced users ideal for users who learn faster when shown
  • Functions like PMT, Vlookup, Hlookup, Double vlookup, deleting duplicates
  • Add charts, graphs and tables to your PowerPoint presentation.
  • Learn time saving techniques including how to copy slides, and exporting your presentation
  • How to create a mail merge in Microsoft Word.

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

Upcoming Batches

  • JOIN NOW And Get 39% 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

  • Thursday 07-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekdays

About Essential Office + Advance Excel + Dashboard Course in

Join one of the most sought computer skill by employers around the world. ISPL Academy brings you the comprehensive program in Microsoft Office with Advance Excel skills. Whether you are already employed or a fresher; 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 and Advance Excel in your workarea. This course is available in both online and classroom mode at our GMS Road, Dehradun and Tilak Road, Dehradun Computer Coaching Centers.

Exam & Certification Essential Office + Advance Excel + Dashboard

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

Frequently Asked Questions

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

The fee of course MS Office + Advance Excel + Dashboard is Rs.9500/-

This course covers Introduction, Word, Excel, PowerPoint, Advance Excel, Dashboard.

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. 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.

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