close
 

Now Open for In-Person Classes. COVID-19 Updates.

 

Scheduled Maintenance: PeopleSoft/MyCerritos will be down December 2-5 for maintenance.

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.

Drop Date: 11/18/2022

CIS 151 MS Excel Syllabus

Here are links to buy the textbook or electronic book.

Textbook:

GO! with Microsoft Office 365, Excel 2019 Comprehensive, 1st edition

E-textbook:

GO! with Microsoft Office 365, Excel 2019 Comprehensive, 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

Office Ch01

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, Instruction 1A VideoInstruction 1B Video
  2. Ch02 instruction, Instruction 2A VideoInstruction 2B Video
  3. Ch03 Instruction, Instruction 3A Video, Instruction 3B Video
  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)

Test Solutions

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

Stay Connected

Site Map | Accreditation | Disclaimer | Document Readers | Report a Website/Accessibility Issue | Safety Reporting | Consumer Information Last Update: 11/24/2022