MS Excel: Beginners to Pro
This course helps beginners and professionals as well to enhance their technical skills to create MIS reports at the corporate level.
What Is MIS?
The Full form of MIS is Management Information System where you need to prepare the Multiple reports and data analysis For Your Management, For Your stakeholders, For Your business partners, and For anybody who is directly or indirectly involved in the business. The industry is moving very fast in the field of Data and Data Analytics. MIS is the most critical area in any business for taking crucial decisions to run business.
For the preparation of the multiple reports, you need to have a strong hand on MS Excel and VBA Macros. The areas which should be really good are, Strong Formula Writing Skills, Strong Data Presentation Skills, Strong Analytic Skills, Strong Interpretation skills by using MS Excel, and you should have the strong Excel VBA Macros Skill also to cure the repetitions, means if you repeat an activity a multiple numbers of time on day to day basis, weekly basis or monthly basis, that can be done by using VBA Macros Skills.
Why RVM Learning?
RVM Learning is the Place where you find all the solutions related to MIS related problems and skill enhancement training modules, which cover all the tools Like MS Excel, Interactive Dashboards. Our primary focus is to develop the working professionals so that they can take the entry in this filed, they can face MIS Interviews Related Questions, they can clear their MIS interviews, and we develop the professionals in this way so that they can start performing for their organization from the first day by using MIS Related tools.
Career Opportunities After MIS Training?
After completion of this training, a participant can look for any opportunity which is in Data Analysis, Reporting, and MIS. In short, after having strong Excel and Macros Knowledge, a participant can start with any opportunity which is related to data analysis, data presentation, data interpretation, and data arrangement.
- Lectures 44
- Quizzes 0
- Duration 15 hours
- Skill level All levels
- Language English
- Students 57
- Certificate Yes
- Assessments Yes
- Excel Intro & Resource Use
- Excel _ Structure
- Shortcuts & Ribbon Tab
- Working with Excel _ Structure
- Removing Formats from Online Data
- Formatting – Putting Years in Formula
- Filling Data & Auto Fill
- Auto-Fill Alphanumerical in Excel
- Formatting – Cleaning All Formats
- Sorting & Filtering in Excel
- Data Navigation & Selection
- Goto Dialogue Box
- Conditional Data Formatting with Filter
- Paste Special & Usage
Section 2:Formulas and Functions
- Introduction to Formula & Functions
- Arithmetic Functions
- Arithmetic Continued
- Error Handling in Excel
- Error Handling – Data Validation
- Handling Single Condition in Excel
- Multiple Criteria
- Text Functions and Real time Application
- Handling Logics in Excel
- If with AND, OR and Nested IFS
- Date Function in Excel
- Project: Finding NSE Working Days
- Look Up Functions – Vlookup
- Vlookup on Multiple Conditions
- Index Match
- Multidimensional Lookup Using Index Match
- Vlookup and Choose
- Tables in Excel
- Pivot Tables
- Data Handling with Slicers
- Project: NSE 100 Stocks Industry Bifurcation
The videos are excellent source of excel knowledge. He breaks down each topic into easy to understand pieces. I would definitely recommend.
It was a good experience. learned lots of new techniques, thanks for such wonderful videos.
Instructor's absolute mastery over subject is evident right from the very first video itself. Instructor's voice volume, tone modulation, tempo are just perfect which makes course engaging and not get bored. All in All this is a Fabulous, Amazing Enjoyable course.