Lorain County Community College Search Header

Business and Information Technology

NCIS 151 - Excel 2013 Intermediate

Eligible for supervisory certificate 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: 10/24/2014
Times: 9:00 AM - 12:30 PM
DE01
Class Number: 4673
End Date: 10/31/2014
O'Brien
Campus: Main Campus
Building/Room: BU212
Fee: $139

NCIS 166 - QuickBooks Pro - Level 2

Eligible for supervisory certificate Keep going with more QuickBooks Pro 2013 knowledge. In this next level you will learn the following: memorize transactions, customize forms, use other QuickBooks Accounts, create reports and graphs, track and pay sales tax, prepare payroll with QuickBooks, use online banking, share files with an accountant, estimate, time track, and job cost, and write letters. Textbook required: Keep 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: 11/14/2014
Times: 1:00 PM - 4:30 PM
DE01
Class Number: 4677
End Date: 11/21/2014
O'Brien
Campus: Main Campus
Building/Room: BU202
Fee: $159