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).