Northwestern Events Calendar

Jan
24
2019

Kapnick Center - Excel Training (Basic)

Basic Excel

When: Thursday, January 24, 2019
5:30 PM - 9:30 PM CT

Where: Technological Institute, MG51 (lower level), 2145 Sheridan Road, Evanston, IL 60208 map it

Audience: Student

Cost: $35

Contact: Kapnick Center for Business Institutions   (847) 491-2706

Group: Kapnick Center for Business Institutions

Category: Academic

Description:

In the EXCEL Basics course you will learn the following (and more!):

Tour of application, values versus labels, what is a worksheet, workbook/file
How to set up a simple formula-adding, subtracting, multiplying, dividing order of operations
How to copy formulas across cells, including how to hold a specific part of the formula constant using the “$” absolute referencing
How to sum up a group of cells with the sigma sum and autosum button (also count, average, min and max)-how it works and the pitfalls of not verifying the range selected automatically
How to format a column to fit a longer caption, including making the cell height bigger and using the wrap-around text feature – formatting – size, font, color, alignment (Horizontal and vertical), word wrapping
How to use bold, italics, centering, right and left justify. Formatting
How to use borders to underline, double underline, etc. formatting borders and shading
How to set up appropriate page breaks, manual breaks, page break view and print setting with headers and footers
How to format with $ or %. Number (and date formatting)

*You must register via Eventbrite!

Register More Info Add to Calendar

Add Event To My Group:

Please sign-in