Cerritos Home Susan Fuschetto Home Susan Fuschetto Home Cerritos Home Campus Information Admissions Academic Resources Student Resources Administration Personnel Services Search Cerritos College Computer and Information Sciences rectangle Susan Fuschetto header

Susan Fuschetto
(page divider)

CIS 151 Excel For I.T. Lectures

The lectures below can be viewed and printed in PowerPoint.  If you print out the slides, then I suggest you use the Handouts option to put multiple slides on a page to save paper.  Also, there may be additional notes I have added to the presentation.  Be sure to read the notes in the Notes pane.

The chapter review tests should be used to study for the exams.  I randomly select questions from the review tests for the actual exams.

The videos are new and I am still learning how to create them.  So be patient I am not a professional video producer.  The videos demonstrate some of the key points in the software.  They do not show all of the commands and details that are in the textbook.  The videos are not a substitution for reading the book, but are provided to enhance your learning.  The videos are created in .wmv files and can be played in any media player that supports .wmv files.  Windows Media player is the default player for Windows and will play the files.  Creating the videos are time consuming especially since I have to add the closed captioning to the videos to be ADA compliant.  I will create as many videos as my schedule permits.  I hope you enjoy them. 

Please note:  for ease of use I suggest that you save the documents to your hard drive/flash drive and then open them up for viewing and printing.  In TalonNet navigation is limited.  Or, in your browser type or copy/paste the following web address in the address bar to go directly to this page.

http://www.cerritos.edu/sfuschetto/CIS151/CIS151Lectures.html

Then save the address as a Favorite or Bookmark it.

PowerPoint Presentation Videos Chapter Reviews Other Documents
Office Fundamentals Office Fundamentals 5:36 minutes Office Fundamentals Office Data Files
Unzipping Files
Chapter 1 Excel Window Components 6:26 minutes
Excel Basics 12:14 minutes
Chapter 1 Excel Data Files
Chapter 2 Formulas & Functions 25:18 minutes.  Use the Next and Previous buttons in the player to move through the video clips. Chapter 2  
Chapter 3 Chart Basic 14:13 minutes Chapter 3  
Chapter 4   Chapter 4  
Chapter 5 Chapter 5  
Chapter 6   Chapter 6 Nested IF Flowchart
Chapter 7   Chapter 7  
Chapter 8   Chapter 8  
Chapter 9   Chapter 9  
Chapter 10   Chapter 10  
      Nested IF
Color Index Properties
Using Else If
Pseudocode

Last update: 10/23/08