This workshop includes tips and shortcuts that will help you work more efficiently with Microsoft Excel.
Topics include shortcuts for selecting ranges, using Autofill to create a series of dates or numbers, troubleshooting printing problems, 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 even 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.
A set of handy keyboard shortcuts will also be included in the workshop.