Laserfiche WebLink
109 <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 and 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 />CIT201: Computerized This course starts with an introduction to basic accounting terms and concepts and walks <br />Accounting I you through the QuickBooks set-up process. Use the leading small business accounting <br />package to organize records, prepare financial reports, handle payroll, and automatically <br />figure federal and state taxes, as well as withholding and employer contributions. <br />Throughout, attention is devoted to creating easy -to -read statements, including profit and <br />loss, balance sheets, accounts receivable, accounts payable, budget, payroll, and project <br />reports, as well as graphs that give students a quick snapshot of overall business. Topics <br />include: <br />• Principles of Accounting <br />• Account Types, Asset, Liability, Owner's Equity <br />• Accounting Records <br />• Invoices and Purchase Orders <br />• Bills and Estimates <br />• Financial Statements <br />• Cash Flow Statements <br />Prerequisite: None <br />Last Revision Date on April 4, 2023 <br />