Advance Excel & MIS Training with VBA Macros in Chandigarh

MIS Excel Training in Chandigarh – Webtechlearning provide a best Advance Excel & MIS Training with VBA Macros in Chandigarh, Mohali and Panchkula.

MIS VBA Training Course

MIS Training + Full Study Material + Certification
Call for free demo class –  09878375376

About the Course

Its a 30 to 45 days Advance Training course programme  timing: 9;30am to 9pm.  2 hours a day class, five day a week, weekend batches also available.

Everyone thinks they know MS Excel very well but when they come out for the next level job interviews, we have a fear in mind will i get thru the test, that will get out once you attend this Course.

Call for course syllabus : 09878375376

And you will impressed your reporting manager and others @ your office.
Topics Covered
Warm-up Exercises
Basic operators: + – / * ^
SUM(), MAX(), MIN(), AVERAGE()
Auto fill options
Data formats – Text, Number, Dates
Paste Special (Value, Transpose)
Absolute & Relative referencing ($)
Select Keyboard shortcuts
Data Clean-up & Extraction
Text to Columns
LEFT(), RIGHT(), MID()
T(), N(), VALUE()
SEARCH() vs. FIND()
Find & Replace using wildcard character – Asterisk ( * )
Removing Duplicate values
MIS reporting
Subtotal
Conditional Formatting (incl. Formula based C/F)
Page Setup & Print formatting
Security & File Protection
Essential formulas
SUMIFS(), COUNTIFS()
CONCATENATE(), &
ROUND(), MROUND()
DAY(), MONTH(), YEAR(), DATE()
EDATE(), EOMONTH()
SUMPRODUCT()
TEXT(), LEN(), TRIM()
Data Lookup
VLOOKUP(), HLOOKUP()
VLOOKUP() with MATCH()
INDEX() and 2 MATCH()
Logical functions
IF(), Nested IF statements
AND(), OR()
ISTEXT(), ISNUMBER(). ISERROR(), ISBLANK()
Data Analysis
Custom Sort
Filter & SUBTOTAL()
Advanced Filter
Pivot Table- Grouping, % computation
Select Dashboard techniques
Activate-Deactivate Gridlines
Data Validation (list)
Grouping
Hyper linking
Freeze-Unfreeze panes
Hide-Unhide Columns & Rows
Who should attend
MIS Executives, Business Analyst, Any one who is working in Ms Excel, Coordinators
Pre-requisites
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.
What you need to bring
You can bring your doubts..You can bring your personal laptop and a note book and pen for taking notes
Key Takeaways
After finishing this course you will able to solve your day to day excel task and ensure you will go home early without any tension.
 
Webtech Learning Certificate + Jobs

For Any Enquiries,

WetbechLearning – ISO Certified Academy
Sco 54-55, 3rd Floor, Sector 34-A, Chandigarh

Please Contact Us:  09878375376,

info@webtechlearning.com