Laserfiche WebLink
CIT10S: Electronic Learn the fundamental skills required to create and use Excel spreadsheets. This course <br />Spreadsheets I teaches you how to start Excel, create and print worksheets, get on-line help, and create <br />simple charts. Topics include: <br />• Basic concepts and terminology <br />• Excel menus and dialog boxes <br />• Creating and modifying worksheets <br />• Copying, deleting, and moving cells <br />• Defining and replicating formulas <br />• Formatting worksheets <br />• Printing worksheets <br />Prerequisite: None <br />60 Hours Lecture <br />20 Hours Lab <br />7.0 Quarter Credits <br />CIT106: Electronic Learn the fundamental skills required to create and use Excel spreadsheets and successfully <br />Spreadsheets II use tables and table tools in a worksheet. This course teaches you how to apply, create, <br />and modify various types of charts, and learned to create a table and format the table as <br />well as work with PivotTable and PivotChart to enhance the appearance of data. Topics <br />include: <br />• Creating simple chart <br />• Creating a custom toolbar <br />• Styles <br />• Using the IF and VLOOKUP functions <br />• Creating and working with pivot tables <br />• Outlining and consolidating works <br />• Using the Goal Seek, Solver and Scenario <br />• Displaying and protecting worksheets <br />Prerequisite: CIT105 must be taken before CIT106 <br />60 Hours Lecture <br />20 Hours Lab <br />7.0 Quarter Credits <br />Date on Apr114, 2023 <br />