MIS Laboratory Exercises

Prelim -Excel

• Advanced sort

Filter

•   Filter Exercise 3

Advanced Filter

•   Advanced Filter Discussion 1
•   Advanced Filter Discussion 2
•   Text Advanced Filter
•   Advanced Filter Exercise 1-Set A
•   Advanced Filter Exercise 1-Set B

Prelim Lab- Management Information System

Pivot

• Pivot Slides
• Pivot Exercise-1 
• Data.xlsx
• Pivot Exercise-2
• Pivot Exercise- 1

MS Excel Database Functions 

• Index Problem 1
• dataFile
• Index Problem 2 

Midterm

• X3A- MIS Midterm Laboratory Exam 

Final

• Lesson 1: Access Database
• Access Database Exercise 1 
• Access Database Query Exercise