SYLLABUS MS Office + Advance Excel + Dashboard
Introduction to Computers 5 Topics
Operating System Windows
File Folder Management
Desktop
Start Menu
Applications
Word 24 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
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
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
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
Dashboard in Excel 10 Topics
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
Project on MS Word 4 Topics
Format documents efficiently in MS Word
Preparations of Documents to Print and Export
Prepare Resume & Bills
Create Registration & Application Form
Project on MS Powerpoint 2 Topics
Apply charts, graphs and tables to your PowerPoint presentation
Create backgrounds and working with templates
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 MS 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 47% Scholarship
-
Monday 29-Apr-2024 -
Tuesday 30-Apr-2024 -
Wednesday 01-May-2024 -
Friday 03-May-2024
About MS 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 MS 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.
Frequently Asked Questions
What is the duration of course MS Office + Advance Excel + Dashboard?
MS Office + Advance Excel + Dashboard is a short term course of 4 months.
What is the fee of MS Office + Advance Excel + Dashboard?
The fee of course MS Office + Advance Excel + Dashboard is Rs.9500/-
What topics are covered in MS Office + Advance Excel + Dashboard?
This course covers Introduction, Word, Excel, PowerPoint, Advance Excel, Dashboard.
What is MS Office with Advance Excel?
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.