Northwestern Events Calendar

Jul
24
2014

HRD156-Excel 2010: Beyond the Basics

When: Thursday, July 24, 2014
9:00 AM - 4:00 PM CT

Where: Parkes Hall, 127, 1870 Sheridan Road, Evanston, IL 60208 map it

Audience: Faculty/Staff - Student - Public - Post Docs/Docs - Graduate Students

Cost: NU Employees $165; Non NU Registrants $300

Contact: Learning & Organization Development   (847) 467-5081

Group: Office of Human Resources | Talent Development & Well-being

Category: Training

Description:

To register, click the "More Info" link above

This full-day workshop is ideal for self-taught users of Microsoft Excel who would like to fill in the gaps in their know-how as well as learn time-saving tips and tricks. Techniques to produce reliable Excel workbooks are covered, including how to display, format, edit existing worksheets and develop new ones plus how to make the most of Excel by creating formulas to analyze data quickly. 

Key Points

Quick tour of the Excel 2010 environment

Enter and edit labels, values, and formulas in a worksheet

Use Autofil to quickly fill in predefined labels and to copy text, numbers and formulas

Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas

Understand function syntax and use functions such as SUM, AVERAGE, MIN, MAX, and COUNT to perform calculations in a worksheet

Format text, numbers, rows, and columns in a worksheet to make them more prominent and easier to read

Preview, control Page Setup options for, and print worksheets and set and clear a print area

Try the new SmartArt

More Info Add to Calendar

Add Event To My Group:

Please sign-in