CIS 151: Microsoft Excel for IS/IT

This course is a foundation class for Information Technology. The fundamentals of building worksheets include: creating worksheets, formatting, functions, formulas, macros, data tables, analysis tools, templates, Wizards, and the creation of charts. Techniques to deal with multiple worksheets and large worksheets are covered. The database functions of EXCEL will include sorting, filtering, queries, macros, and record retrieval. This course covers the topics required in industry certifications. Hands-on exercises are used to reinforce the function of EXCEL. This course is not open to students who have taken both CIS 54A and CIS 54B.
Transfer Credit: CSU

Note: This is now an ONLINE class.  The online time of our class is "Asynchronous"

Asynchronous courses take a more non-traditional approach. Students do not “attend” class at a set time, but rather, access pre-recorded lectures and digital curriculum materials and respond through email, and at a time of their own choosing.  Zoom video conferences during our online time will be only as needed.

This link should be greatly helpful with ONLINE class questions:
ONLINE LEARNING STUDENT FAQS

Drop Date: Apr 23, 2024

CIS 151 MS Excel Syllabus

Lab Solutions

Here are links to buy the textbook or electronic book.

Textbook:

GO! with Microsoft Office 365, Excel 2021, 1st edition

E-textbook:

GO! with Microsoft Office 365, Excel 2021, 1st edition

This is a class on the MS Excel application you will need access to this app on a WINDOWS or Mac/Apple computer.

Cerritos College offers Office 365 for FREE!

Student Lab Data Files

Excel SHORTCUTS!

Chapter Notes

Note: These Videos are from Excel 2016, but there are very few differences in tasks of Excel 2016 and 2019.

Office Ch01 Video

  1. Ch01 instruction
  2. Ch02 instruction
  3. Ch03 Instruction
  4. Ch04 Instruction
  5. Ch05 Instruction
  6. Ch06 Instruction
  7. Ch07 Instruction
  8. Ch08 Instruction
  9. Ch09 Instruction
  10. Ch10 Instruction

Videos
1 Project 1AProject 1B
2 Project 2AProject 2B
3 Project 3AProject 3B
4 Project 4AProject 4B
5 Project 5AProject 5B
6 Project 6AProject 6B
7 Project 7AProject 7B
8 Project 8AProject 8B
9 Project 9AProject 9B
10 Project 10AProject 10B
11 Project 11AProject 11B

Labs Solutions(See lab descriptions and submit labs thru Canvas)

  • EX1A solution
  • EX1B solution
  • 2C solution
  • 2D solution
  • 3C solution
  • 3D solution

Test Solutions

  1. Test01 Part B
  2. Test02 Part B
  3. Test03 Part B
  4. Final Part B