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.
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
Conditional Formatting (incl. Formula based C/F)
Page Setup & Print formatting
Security & File Protection
DAY(), MONTH(), YEAR(), DATE()
TEXT(), LEN(), TRIM()
VLOOKUP() with MATCH()
INDEX() and 2 MATCH()
IF(), Nested IF statements
ISTEXT(), ISNUMBER(). ISERROR(), ISBLANK()
Filter & SUBTOTAL()
Pivot Table- Grouping, % computation
Select Dashboard techniques
Data Validation (list)
Hide-Unhide Columns & Rows
Who should attend
MIS Executives, Business Analyst, Any one who is working in Ms Excel, Coordinators
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
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,
WebtechLearning - Web Education Academy
ISO 9001:2008 Certified Academy
Professional Training + with Live Projects + Certifications+ Job
Call for query: +91 9878 375 376, +91 9915 337 448 , Skype: webtechlearning
Note: you can meet your trainer, get demo class before joining the Course.