2017 Workshop: Microsoft Excel- Tips, Tricks & Shortcuts 10/19/17

  • Share:
  •  
Name: 2017 Workshop: Microsoft Excel- Tips, Tricks & Shortcuts 10/19/17
Date: October 19, 2017
Time: 9:00 AM - 11:00 AM EDT
Event Description:
Workshop: Tips, Tricks & Shortcuts in Microsoft Excel
Presented by: Pioneer Training


This 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 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: https://goo.gl/forms/My7lF9Xk1aB7xg0Q2


 
Location:
Northampton Chamber of Commerce
99 Pleasant Street
Northampton, MA
Date/Time Information:
October 19
9:00 - 11:00 am
Fees/Admission:
$35 Members
$45 Non-Members
RSVP required, space limited
Set a Reminder:
Enter your email address below to receive a reminder message.