CHANDIGARH NO.1 - Web Education Academy - Admissions on 1st come 1st basis - Lowest Fee, Learn Unlimited! - Book a Free Demo Class
for Course Inquiry?
Call Now!

09878375376

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

9

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

webtechlearning chandigarh

For Any Enquiries,

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

Please Contact Us:  09878375376,

info@webtechlearning.com

 

 

Top Search: > > > >

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

Book My Free Demo Class Now!

Note: you can meet your trainer, get demo class before joining the Course.

Webtech LearningTM partner's companies