Microsoft Excel gives businesses the solutions to
maintain their data. So when it comes to do the information management and
maximizing company profits, it becomes very important to handle data carefully
and do the analysis through all different ways to achieve the best of it.
Why Excel jobs are increasing in India?
India is moving towards Digital Economy, we are
moving towards cashless economy. There will be an increase in number of online
transactions. More such transactions will take place; higher will be the requirement for the resources to do data management.
And this is not only about Banking & Finance, the amount of data we are generating is increasing in every industry - Travel & Tourism, Food & Beverages, Healthcare, Social Media.
Excel Jobs comprises 75.6% of Analytics Industry.
Job Search portal - Indeed claims the highest number
of jobs in Data Analytics/ MIS Executive.
Key Skills every company is looking for in excel are Conditional Formatting, Vlookup, Hlookup, Validation Rules, Reporting using Pivot Table or Charts, Dashboards, Validation Rules, What-if-Analysis, Index Match, VBA, Macros, Sql.
Test your Excel Skills-
Q-1)
How many rows and columns are there in Microsoft Excel?
Q-2)
What is the syntax for Vlookup?
Q-3)
What is IF and DATEDIF function in Excel?
Q-4)
Between Vlookup and Index-Match, which is more preferable and why?
Q-5)
How to apply multiple rules in Conditional Formatting?
Q-6)
How to make drop down list?
Q-7)
What is variant in excel?
Q-8)
What is Dashboard and what are the important things we should keep in mind
while creating a dashboard?
Q-9)
What is Ubound and Lbound in VBA?
Q-10)
What is Option Explicit and Option Base 1? And why do we need this?
Check
your score, if you feel any need for Advanced Excel & VBA training, you can
contact us on:
Ph:
9999201478
No comments:
Post a Comment