Business and Information Technology

NCIS 150 - Excel Basic

Course will familiarize students with spreadsheet terminology and the fundamental concepts of the current version of Microsoft Excel, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. Learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Also, learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. Create and modify charts, and work with graphics. Review workbooks for spelling errors, modify page setup, and print worksheets. Textbook required: Current version of Microsoft Office Excel: Basic. Purchase your book at the LCCC Bookstore on campus or online prior to class. Students are encouraged to bring a flash drive. 0.2 ILU's (International Learning Unit- ILU (© LERN) is an outcome based measurement of learning designed for lifelong learning activities).

Lecture
Section: P101
Days: Fri.
Class Number: 4693
Campus: Main Campus
Begin Date: 2017-11-03
End Date: 2017-11-10
Building/Room: DEC132A
Times: 9:00 AM - 12:30 PM
Grebey
Fee: $139
Microsoft Excel 2016 will be taught for this class. Book will be available prior to class start.

NCIS 152 - Excel Advanced

Build on the skills acquired in the Microsoft Excel Basic and Intermediate courses. Work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, learn about data validation, and will use advanced data filtering. Apply advanced chart formatting options, and create more complex charts. Work with PivotTables and PivotCharts, export and import data, and query external databases. Learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, run and record macros, and explore VBA code. Textbook required: Current version of Microsoft Office Excel: Advanced. Purchase your book at the LCCC Bookstore on campus or online prior to class. Students are encouraged to bring a flash drive.

Lecture
Section: P100
Days: Fri.
Class Number: 4713
Campus: Main Campus
Begin Date: 2017-10-27
End Date: 2017-11-03
Building/Room: DEC132B
Times: 9:00 AM - 12:30 PM
O'Brien
Fee: $139
Microsoft Excel 2016 will be used for the class. Book will be available in the bookstore prior to class starting.