Microsoft Excel Tips, Tricks and Shortcuts Seminar
Microsoft Excel - Tips, Tricks and Shortcuts
February 10, 8:30 - 10:30 AMThis workshop will present our favorite tips, tricks and shortcuts that we have collected and developed over 20 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 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 and 2016 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.
Date and Time
Friday Feb 10, 2017
8:30 AM - 10:30 AM EST
Friday, February 10th
8:30 - 10:30am
Location
Hampton Inn - Chicopee
600 Memorial Drive
Chicopee, MA 01020
Fees/Admission
$40 Members
$50 Non-Members
