Applications Software: Excel

Catalog Search > Computer Related > 90.180

Note: This course is not available for the current semester.

Course No: 90.180; Last Offered: Summer 2015;

Course Description

This course will look at all the features of Excel thatmake it the powerful business tool that it is. The following topics will be discussed: the basics of workbooks and worksheets, including worksheet conceptsand terminology; creating a workbook file with arithmetic and function formulas; editing and formatting features that are available for manipulating the data in a worksheet; printing and page setup issues; creating charts to graphically represent worksheet data; and exploring the ways in which Excel can be used for list management purposes. In addition, students will learn the tips, tricks and shortcuts that are available in Excel for doing things efficiently; for example, advanced formulas, including links and What If? analysis; Excels statistical, lookup, time and date, and IF functions. Students will explore a number of the powerful ways in which they can summarize worksheet data in Excel: those include outlining, consolidation, and pivot tables; creating macros in Excel using Visual Basic for Applications, to automate reports and eliminate redundancy in worksheet creation and manipulation.

Prerequisites & Notes

  • Prerequisites: 90.202 or equivalent
  • Special Notes:
  • Credits: 3;

Questions About This Course?

Contact the Advising Center at 978-934-2474 or Continuing_Education@uml.edu

Use the Back button in your browser to go back to search results.