Lorain County Community College Search Header

Business and Information Technology

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 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