Event DescriptionWorkshop: 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.