Excel 2013: Level 3 (Advanced) for Library Staff - Starke (8/27/14)

 

This workshop had been rescheduled from a previous date.

In this Excel 2013: Level 3 (Advanced) course, attendees will build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses.

Lessons will include:

• advanced functions and formulas
• lookup functions such as VLOOKUP, MATCH, and INDEX
• data validation and advanced data filtering
• chart formatting options to create more complex charts
• PivotTables and PivotCharts
• exporting and importing data using Excel with the web and query external databases
• analytical features of Excel, such as Goal Seek, and how to create scenarios
• running and recording macros
• exploring VBA code

All attendees will be provided with courseware, and you will head back to your libraries with the skills needed to competently work with Excel spreadsheets at the advanced level.

Trainer: Sherrie Butterfield, New Horizons Computer Centers

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Cost: NEFLIN classes are free of charge for Florida library staff. Registration is required for all classes and NEFLIN members get priority.

Cancellation Deadline is 9 am on Monday, August 25.
Otherwise, no show fees may apply. See all NEFLIN CE policies at http://www.neflin.org/training. 

 

Register Now!