This course is for those who want more from Excel and want to give their Excel knowledge new depths. This course will introduce you with some of the Excel’s advanced features and functionalities that will help you to give your professional career a new boost.
In this course you will be provided an in-depth knowledge of Excel’s in built functions and their structure, Advance filtering techniques with built-in Adavanced Filter command, splitting long text strings in different columns based on delimiters, weaving magic in your Excel worksheets with Custom Number Formatting along with performing various kinds of lookups using Vlookup, Hlookup, Index-Match, Offset, Address etc, on top of all you will learn the use of VBA (Visual Basic for Application) to record macros for faster execution of various tasks which will save a lot of manual work and reduce possible errors.
By the time you finish this course, you will be able to consolidate data from different worksheets and create your own attractive dashboards using charts, Pivot Table, Function based reports.
Our aim is to make your analytical abilities a new boost and make you more productive and efficient in your day to day professional life.
Here we train for the advance level of Ms-Excel wherein we cover below topic along with some important basics and tests.
|COURSE RELATED||FEES & CERTIFICATE||FACILITY|
|Advance level||Yes||Practise matrial-20|
|Coach by - Manoj kumar||Fees 5000||Videos 40|
User forms come handy in our day to day data entry needs, therefore we make sure that you never miss out them
Practicals made me effective. I do want to thanks Manoj Sir for providing such rare study material.
I have done advanced level of Excel and after completing this course I would say ExcelHour has a special focus on logic build up. They made me able to solve issues in multiple ways.
Joining with a reputed organization was my aim. I put more efforts in learning this course and would say thanks to the ExcelHour to provide such mind-blowing faculty who gave 100% of theirs.