In Excel and MS Office
Financial Calculations & Excel Made Easy
Intermediate | English | 379146 Learners | Validity: 3 Years
Course Highlights
90+ Videos
13+ Hours of Content
30+ Supplementary Study Materials
Self Evaluation Tests
Certificate of Completion
Introduction
Excel is one of the most widely and extensively used applications around the world. From offices to homes, from professionals to students, from homemakers to artists, everybody needs Excel for professional or personal work. But unfortunately, most people who use Excel, do it in a very limited way because most people are not aware of the full spectrum of tools and functionalities provided by Excel. These tools and features are very easy to learn and will multiply the utility of Excel for you several times. It will also make you very efficient and effective in using Excel.
This advanced excel course covers both fundamental as well as advanced excel topics. It ensures that the participants not only understand these concepts with the help of well-designed examples but also develop the thought process so that they can apply the learning in their day-to-day education or professional life.
Objective
The focus of this advanced excel course is to equip the participants with all the knowledge, understanding, and practice they need to use MS Excel easily, effectively, and efficiently. In this course, we cover the entire range of topics, from the very basics to the advanced topics.
Benefits
No prior knowledge of Excel is required.
From most basics to the advanced topics covered in a single course.
Detailed explanations with an adequate practical demonstration for best understanding.
Assignment sheets are provided for each topic for a better understanding.
Topics Covered
Basics of Excel
Formatting tools and options
Various functions – mathematical, statistical, text, date and time, logical, lookup, financial, etc.
Various tools in Excel for managing and manipulating data
Power query and power pivot
Charts and pivot charts
Interactive dashboards
Handling errors and other useful features of Excel
Intended Participants
This course is useful for anybody who wants to use Microsoft Excel for any kind of work, personal or professional
No prior knowledge of Excel is required at all and therefore, this course is perfectly suitable for absolute beginners also.