MIS Professional Training – Advance Excel + Macro + Access + SQL
A Management Information System (MIS) provides organisation with the information they require in an organised manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.
This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology , which is MACRO -Automation.
What Will I Learn?
- Advance Level Excel
- Expertise in Using Text Function
- Expertise in Using Logical Function
- Expertise in Using Math Function
- Expertise in Using Lookup & Reference Function
- Expertise in Using Date and Time Function
- Expertise in Using Pivot Table and Chart
- Expertise in Using What If Analysis Tools
- Many Others Excel Tools
- MS Access Knowledge on Table, Form, Queries and Reports
- SQL Queries
- Macro Recording
- Excel VBA Object Handling with practical Project
- Excel VBA Variable with practical Project
- Excel VBA IF & Case with practical Project
- 3 Types of Loop with practical Project
- Create your own Function
- Events in VBA
- FSO in Excel VBA
- Userform in Excel VBA
- Automate Pivot and Outlook in Macro
- Many More Macro Topics and Projects
Topics for this course
Autofill Value and Text4:52
Autofill Advance Tools4:43
Cell Reference Types4:29
Operators Based Equation9:02
Advance Math Function7:15
Advance Math Function 200:06:38
Using of Wild Card in Math Function2:44
Text Function – Upper, Lower, Proper and Trim Function00:05:47
Text Function – Right and Left Function00:03:54
Text Function – Find and Task00:06:13
Text Function – Solution and Nested Left00:05:32
Text Function – Find and Left Nesting00:02:51
Text Function – Mid Function00:03:15
Text Function – Mid Task and Solution00:06:05
Text Function – Concatenate Function00:03:23
Text Function – Concatenate Task and Solution00:02:08
Text Function – Replace Function00:04:48
Text Function – Replace Task and Solution00:05:05
Text Function – Substitute Function00:04:36
Text Function – Len, Rept, Exact and Search Function00:02:40
Text To Column00:09:00
Hide Formulas and Unlocked Cell00:04:14
Protect File with password00:02:31
If Function – Logical Test8:44
If Function – with Equation and task00:03:06
If Function – Nested If00:03:53
If Function – Advance00:04:45
If Function – Advance 200:04:55
AND , OR Function00:06:42
AND, OR, IF Nested00:05:09
AND, OR Advance Example00:02:19
Pivot Table – Intro00:05:20
Pivot Table – Manage Field Area00:07:18
Pivot Table – Value Field, Report and More00:05:20
Pivot Table – Slicer and Duplicate Pivot00:06:53
Pivot Table – Group To Mange Date and Values00:05:09
Pivot Table – Insert Calculated Field00:03:23
PMT function – EMI calculator00:04:40
Data Table – Create Loan Table00:07:52
Print Option in Excel – Part 100:11:50
Print Option in Excel – Part 200:08:22
Chart Preparation in Excel00:14:32
Chart Preparation – Advance00:05:23
Chart Preparation – Customize00:03:56
Conditional Formatting in Excel00:05:24
Conditional Formatting – Types of Rules00:11:32
Conditional Formatting – Mange Rules00:04:12
Conditional Formatting – New Rules 100:03:11
Conditional Formatting – New Rules 200:04:37
Data Validation – Input Message and Error Alert00:04:58
Vlookup with Iferror Function00:05:09
Vlookup Nesting with If Function00:02:23
Index and Match Nested00:08:20
Vlookup Column Trick00:04:36
Advance Vlookup Trick00:06:23
MS ACCESS & SQL
Create Table in MS Access00:14:19
How to Import and Export in Access00:07:00
Create Form from Table00:04:23
Create Blank Form in Access00:14:08
Creating Report in Access00:02:57
Query in Access00:11:37
SQL Queries part 100:08:13
SQL Queries part 200:04:22
EXCEL VBA – MACRO
Macro Recording Part 100:15:17
Macro Recording Part 200:05:19
Macro Recording Part 300:03:10
Types of Ways to Run Macros00:05:59
Introduction to Macro00:08:57
Start Macro Programming00:07:06
Macro Task Basic00:04:05
Methods to Refer Range00:06:55
Selection of Multiple Cell00:05:56
Formatting through VBA00:07:18
End Command in VBA00:06:17
Offset in VBA00:04:49
Task on Data Entry Automate00:02:14
Solution For The Task00:05:11
Methods to Refer to Sheets00:08:31
Methods Related to Sheets00:10:05
Sheet Related Task00:01:52
Sheet Related Task Solution00:03:48
Methods to Refer to Workbooks00:02:50
Methods Related to Workbook00:03:20
Workbook Related Project00:10:35
Declared Variable Introduction00:10:02
Data Types in Variable00:06:16
Object Variable Related Task00:02:16
Solution of Task 200:03:43
Variable Related Project00:07:42
Apply IF in VBA00:05:22
AND OR in VBA00:08:13
Task for IF00:01:28
Solution of IF Task00:03:03
Select Case 2nd Scenario00:04:50
Select Case 3rd Scenario00:08:38
Loop Practical Example00:05:02
Loop Related Task Solution00:04:14
Do While Loop00:02:13
For Loopcounter Loop00:06:29
For Loopcounter Step Importance00:03:50
For Loopcounter Step Example 200:06:34
For Each Loop00:04:46
For Each Example 200:04:15
For Each Task Solution00:02:41
Loop Related Task00:01:38
Loop Solution and Further Task00:06:23
Loop Related Project00:14:52
How to Create Events00:09:25
Events Example and Task00:03:04
Events Task Solution00:02:37
Sheet Specific Events00:03:18
Create Function in VBA00:06:49
Function Related Task00:01:33
Function Related Task Solution00:01:42
Create Optional Parameter in Function00:04:15
VBA to Control Outlook for Mail00:09:24
Outlook Related Project00:05:13
Create Pivot Table with VBA00:09:03
File System Object in VBA00:05:46
File in FSO00:03:03
FSO Practical Example00:07:00
Late Binding Technique in Macro00:04:49
About the instructor
Sir has prompt in clearing any doubt I have.
Never before have I walked away from a training course with so much practical knowledge that can be applied to my work immediately.
Although I am having basic knowledge so after few videos I have really started to enjoy and learns a lot.It is very important to practice alongside although.
I have Completed my advanced excel & MIS Training. The best part is the trainer always answered my question promptly.
I have Successfully completed my MIS course. There is such a wonderful trainer who makes sure we understand all the concepts completely. The online classes were mostly practical that my trainer helped us to work with real-time projects with examples which will be very much useful for my career.
Very well explained indeed.
Its a great course too learn how to use excel, no matter your current level. Highly recommend.
Explained clearly, covers all the basics and beyond. I learnt what i want to learn plus much more.
The course does not feel long or dragged out. the examples are there to help and by doing them helps learning and makes it easier to understand.
I started this course with no experience at all in Excel. I have learned so much in a short period of time, in this class. I will be refreshing on these courses multiple times. Great teacher! He is very easy to follow.
This course is quite detailed and well explained by mentor, way mentor simplify concepts with example is really commendable.
Really solid knowledge base. Explained topics well enough.
I felt that the teacher has been extremely thorough in explaining the different functions of excel, which has been helpful in my journey to learn excel in detail
This course was great, I learned quite a lot, the instructor spoke clearly and concisely, the complete ribbon overview was a fantastic idea, I think some beginners might find the nested formula section a bit too difficult, but other than that, this course is really good.
This was by far the best online course I have taken so far. Already purchased a few others to learn more about this topic with you so looking forward to them. It's a lot of information to digest, but it's all about practicing these more.
This course has a good instructor, every thing is explain step by step
Excellent course, I do feel I know so much more compared to when I started it.
The instructor explains the concepts really well.
to the point
It was a Great course. Easy to follow. Well Mapped out. The Tutorials were clear and sharp. Just loved the course and it helped me expand my knowledge of Excel.
Absolutely brilliant course as a starting point for procedures that can be used in Excel. So simple to understand the information being given, from the newcomer to Excel right up to the final sections with VBA code & functions. Delighted when seeing codes I entered working. Great to have the course saved so can re-run sections to improve memory & speed of using formulas and procedures.
The course is very good for the beginners or intermediate learners. The VBA part was quite difficult to follow along but eventually got the grasp on.
This course contains all the required ingredient to become a MIS professional. Excel the most required then the Macro and VBA which the next step. It also contains MS Access and SQL for Database concepts.
The topics are explained very nicely which is easily understandable and clears the concepts.