Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

# MIS Analyst/Executive

No Reviews Yet

Kapashera, Delhi

Course ID: 8687

Kapashera, Delhi

Students Interested 0 (Seats Left 0)

No Reviews Yet

Advance Excel, MS Access, MS Word

## Topics Covered

Basic Formula:
Add/Subtract/Multiply (Product())/Divide, count(), MID(), REPT(), abs(), column(), row(), match()

Statistical Functions Using The SUMIF/COUNTIF Functions • Using The AVERAGE/COUNT/LARGE/SMALL Functions

Text Functions:
Upper, Lower, Proper, Left, Right, Concatenate, Len, Exact, Search, Find, Clean, Replace, Substitute, Dollar, TEXT

Validations:
Input Messages / Error Alerts/ Drop-Down Lists • Conditional Formatting

Filters:
Extracting Records with Advanced Filter • Using Formulas In Criteria

Sorting:
Sorting by Top to Bottom / Left to Right • Creating / Deleting Custom List • Sort by using Custom List

Date/Time Functions:
Date, Today, Now, Day, Month, Year, Time, Hour, Minute, Second, Weekday, Datedif, Networkdays, WORKDAY

Summarizing Data:
Creating Subtotals/Nested Subtotals • SUBTOTALS Formula

Importing & Exporting Data:
Importing Data from Database/ Text Files/ Web

Logical Function:
Writing conditional expressions (using IF, NESTED IF)
Using logical functions (AND, OR, NOT)

Information Functions
IsBlank, IsError, Isnumber, Istext

LOOKUP Functions
The VLOOKUP/HLOOKUP Functions/Index function

PivotTables
Creating, Formatting Simple PivotTables, slicer

Chart Data Techniques:
The Chart Wizard • Chart Types • Adding Title/Legends/Lables • Printing Charts • Adding Data to a Chart • Formatting/Renaming/Deleting Data Series • Changing the Order of Data Series

MS ACCESS:
Creating Table, queries, report, form, pivot chart, Query design etc.

Basic Computer

Nothing"

## Key Takeaways

Key board shortcut, Excel Tips etc

Not decided yet.

## Students also enrolled in these Courses

Avg Rating

0 Reviews

0 Students

1 Courses

Pankaj Kumar

MCA (Master of Computer Application)

1 Years of Experience

I'm working in a reputed company with Sr. MIS Executive since 2005.

I'm also working with world's largest outsource company as a contractor. I have give all time great performance to my client. You can see my work history in below link.

https://www.odesk.com/users/~~62b7558dcdddf1e7

Thanks,
Pankaj

## Reviews

No reviews currently Be the First to Review

## Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now

Enquire

Submit your enquiry for MIS Analyst/Executive

Please enter valid question or comment

Connect With Pankaj

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Enter valid Email or Phone Number