Lorain County Community College Search Header

Business and Information Technology

NCIS 150 - Excel 2013 Basic

Course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, 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: Microsoft Office Excel 2013: 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
Days: Fri.
Begin Date: 02/27/2015
Times: 1:00 PM - 4:30 PM
P100
Class Number: 5132
End Date: 03/06/2015
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139
Class Fee of $139.00
Lecture
Days: Thurs.
Begin Date: 03/19/2015
Times: 9:00 AM - 12:30 PM
P101
Class Number: 5135
End Date: 03/26/2015
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139
Fee for class $139.00

NCIS 151 - Excel 2013 Intermediate

Learn how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. Get introduced to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, learn how to create outlines and subtotals, and how to create and apply cell names. Learn how to sort and filter data, and create and format tables. Learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Customize the Excel environment, and create and modify custom templates. Textbook required: Microsoft Office Excel 2013: Intermediate: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
Days: Fri.
Begin Date: 04/03/2015
Times: 1:00 PM - 4:30 PM
P100
Class Number: 5140
End Date: 04/10/2015
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139
Class has a fee of $139.00

NCIS 152 - Excel 2013 Advanced

Build on the skills acquired in the Microsoft Excel 2013 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: Microsoft Office Excel 2013: Advanced. Purchase your book at the LCCC Bookstore on campus or online prior to class. Students are encouraged to bring a flash drive.

Lecture
Days: Fri.
Begin Date: 05/01/2015
Times: 1:00 PM - 4:30 PM
P100
Class Number: 5141
End Date: 05/08/2015
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139
class has a fee of $139.00

NCIS 165 - QuickBooks Pro

Learn the fundamentals of using QuickBooks 2013 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® 2013 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
Days: Fri.
Begin Date: 02/27/2015
Times: 9:00 AM - 12:30 PM
P100
Class Number: 5144
End Date: 03/06/2015
O'Brien
Campus: Main Campus
Building/Room: BU202
Fee: $159
Class has a fee of $159.00
Lecture
Days: Fri.
Begin Date: 04/03/2015
Times: 9:00 AM - 12:30 PM
P101
Class Number: 5143
End Date: 04/10/2015
O'Brien
Campus: Main Campus
Building/Room: BU202
Fee: $159
Class has a fee of $159.00

NCIS 170 - Access 2013 Basic

This course covers the basic skills and concepts to use Microsoft Access 2013 productivity and efficiently. After an introduction to the Access 2013 environment, learn how to how to plan databases and create tables. Learn to organize fields and records, and to work with data entry rules. Learn how to create basic queries, and how to work with forms and reports. Textbook required: Microsoft Office Access 2013: Basic. Purchase your book at the LCCC Bookstore on campus or online prior to class. Students are encouraged to bring a flash drive.

Lecture
Days: Fri.
Begin Date: 05/01/2015
Times: 9:00 AM - 12:30 PM
P100
Class Number: 5142
End Date: 05/08/2015
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139
Class has a fee of $139.00