Business and Information Technology

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: Tues.
Class Number: 4174
Campus: Main Campus
Begin Date: 2019-03-19
End Date: 2019-03-26
Building/Room: DEC132A
Times: 9:00 AM - 12:30 PM
O'Brien
Fee: $139
Microsoft Office 2016 will be used for class.

NCIS 153 - Excel Pivot Tables

Learn how to effectively summarize data using PivotTables and PivotCharts. This class starts with strategies for creating, modifying and formatting PivotTables. Then learn how to summarize using other functions including AVERAGE, SUM, Percent of Total and Running Totals. Sort and filter the information in the PivotTables both with the filter arrow and with Slicers. Use transactional data to group dates by months, quarters and/or years. Create a reverse PivotTable. Create PivotCharts. Handouts will be provided. 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: P100
Days: Tues.
Class Number: 4175
Campus: Main Campus
Begin Date: 2019-05-14
End Date: 2019-05-14
Building/Room: DEC132A
Times: 9:00 AM - 12:30 PM
O'Brien
Fee: $75
Microsoft Office 2016 will be used for class. No book needed.

NCIS 165 - QuickBooks Pro

Learn the fundamentals of using QuickBooks to track the finances of a small business. Understand how to set up a new company, work with lists, set up inventory, sell your product, invoice for services, process payments, work with bank accounts, enter and pay bills, and use the EasyStep. Textbook required: Get Going With QuickBooks® for Windows. 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: P100
Days: Thurs.
Class Number: 4177
Campus: Main Campus
Begin Date: 2019-02-21
End Date: 2019-02-28
Building/Room: DEC130
Times: 9:00 AM - 12:30 PM
O'Brien
Fee: $159
Latest version of QuickBooks will be used. Please bring your own laptop to class with you.