Summer 2020
> Computer Related
> INFO.1800
> 045
Course No: INFO.1800-045; SIS Class Nbr: 1154; SIS Term: 2940
Course Status: Registration Closed
Course Description
This course will look at all the features of Excel that make it the powerful business tool that it is. The following topics will be discussed: the basics of workbooks and worksheets, including worksheet concepts and 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; Excel¿s 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 & Instructor
- Prerequisites: INFO.2020 or equivalent; requires MS Excel® 2016; Windows based
- Credits: 3; Contact Hours: 3
- Instructor: Robin Desmond
-
UMass Lowell Bookstore
When Offered & Tuition
- Online Course
- 2020 Summer: May 18 to Jun 29
- Chat Hours: Sun 6-7pm*
- Course Level: Undergraduate
-
Tuition: $1140
- Note: There is a $30 per semester registration fee for credit courses.
*Chat Hours provide an opportunity for the instructor and students to communicate
in "real time". It is an informative and interactive session where course related questions, answers,
and discussions take place. While student attendance during chat hours is not required, it is highly recommended.
Weekly chat sessions are archived for students who are not able to participate in the live chat sessions at the
scheduled times.
Related Programs: A.S. in Information Technology, B.S. in Information Technology, B.S. in Information Technology: Business Minor Option, B.S. in Information Technology: Population Health Informatics and Technology Minor Option
Every effort has been made to ensure the accuracy of the information presented in this catalog. However, the Division of Graduate, Online & Professional Studies reserves the right to implement new rules and regulations and to make changes of any nature to its program, calendar, procedures, standards, degree requirements, academic schedules (including, without limitations, changes in course content and class schedules), locations, tuition and fees. Whenever possible, appropriate notice of such changes will be given before they become effective.