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
Here are links to buy the textbook or electronic book.
This is a class on the MS Excel application you will need access to this app on a WINDOWS or Mac/Apple computer.
Note: These Videos are from Excel 2016, but there are very few differences in tasks of Excel 2016 and 2019.
- Ch01 instruction, Instruction 1A Video, Instruction 1B Video
- Ch02 instruction, Instruction 2A Video, Instruction 2B Video
- Ch03 Instruction, Instruction 3A Video, Instruction 3B Video
- Ch04 Instruction
- Ch05 Instruction
- Ch06 Instruction
- Ch07 Instruction
- Ch08 Instruction
- Ch09 Instruction
- Ch10 Instruction
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)
- Off1A solution
- Off1B solution
- EX1A solution
- EX1B solution
- 2C solution
- 2D solution
- 3C solution
- 3D solution
- 4C solution
- 4D solution
- 5C solution
- 5D solution
- 6C solution
- 6D solution
- 9C solution
- 9D solution