SYLLABUS Essential Excel
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
What you'll learn Essential Excel
- Hands on experience to the excel with understanding of shortcuts
- Become more creative, efficient and accurate & Fast in Excel
- Functions explained in most logical and simplest manner
Get Free Participation Certificate
Take a demo class & get the FREE Certificate
Upcoming Batches
-
JOIN NOW And Get 59% Scholarship
-
Monday 29-Apr-2024 -
Tuesday 30-Apr-2024 -
Wednesday 01-May-2024 -
Friday 03-May-2024
About Essential Excel Course in
Exam & Certification Essential Excel
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.
Excel & Analytics Alumni
Frequently Asked Questions
What is the duration of the course Essential Excel?
Essential Excel is a short term course of 1 month.
What is the fee of the course Essential Excel?
The fee of the course Essential Excel is Rs.2600/-
What is Microsoft Excel?
Microsoft Excel is something that we work on in our daily life be it a student or an accountant or any other business professional. While Microsoft Excel is an irreplaceable part of the business field it is also widely used in other fields such as nonprofit organizations, hospitals, and educational institutions. Every one of us knows all the basic functions of Microsoft Excel but there are many advanced terms associated with it that not many are aware of.
What is the mode of Training?
The course is available in both online & classroom modes at our computer training centers in Dehradun.