2021-2022 Course Catalog

IT 120 Spreadsheet Applications

presents the student with comprehensive spreadsheet techniques using MS Excel. Students learn to develop a professional workbook; work with formulas, charts and graphics, lists, outlines, sorting, filtering, subtotaling, 3-D references, advanced functions, conditional formatting, data validation, templates, data tables, and scenario management; import and export data; audit formulas; create hyperlinks and a web page; work with large documents; and automate a worksheet with Visual Basic macros. This course is designed for those students pursuing training in office productivity software and/or MOS certificate preparation. This course is applicable toward all certificates and degrees (credit hours 3.0, lecture hours 2.0, lab hours 2.0).

Credits

3.0

Division and Department

Math, Science & Business / Information Technology