Loading Events

« All Events

  • This event has passed.

Tips, Tricks & Shortcuts in Microsoft Excel

March 13, 2015 @ 9:00 am - 11:00 am

Presented by:Pioneer Training, this workshop will present our favorite tips, tricks and shortcuts that we have collected and developed over 15 years of teaching and using Microsoft Excel. Topics will include shortcuts for selecting ranges, using Autofill to create a series of dates or numbers, setting the print area, using page break preview, adding headers and footers, and using page layout view. You’ll learn how to group spreadsheets in the same workbook in order to type or format more than one sheet at the same time, as well as how to create 3-D formulas that calculate across several spreadsheets in the same workbook. You’ll practice dividing text from one column into two columns, as well as how to concatenate text from two columns into one. You’ll learn how to use conditional formatting to format cells according to their values, how to protect all or part of a worksheet, and how to paste an Excel spreadsheet into Word as an Excel object that links to the original spreadsheet and updates automatically. The workshop will also cover a new set of features in Excel 2013 that includes the new Start screen, Backstage View, Flash Fill, the Quick Analysis Tool, and a new set of options related to creating Excel charts. A set of handy keyboard shortcuts will also be included in the workshop.Participants are encouraged to bring laptops and follow along with the instructor, but this is not required.

Pre-registration is required; space is limited.
To register, [email protected]
Tickets & Cost:$20 Members; $30 Non-Members

Details

Date:
March 13, 2015
Time:
9:00 am - 11:00 am
Event Category: