Title:
Intermediate Tips for Microsoft Excel
Video:
Description:3-10-10 In this session, we'll take a look at tools and techniques to help you work with Excel more efficiently. We'll cover techniques such as linking worksheets with 3-D formulas, sorting and filtering data using autofilters, commenting cells, using lookup functions, creating PivotTables for data analysis using the Banner reports SYRSTAN and SYROLLY. We'll also take a look at useful techniques to transpose columns and rows, discarding empty cells, and using Excel as a data source for Word mail merges. This touches on a few of the tools and techniques available for intermediate Excel users, and if time allows, we'll demonstrate other techniques.
Published:
11/Jun/2010
Intermediate Tips for Microsoft Excel
Video:
Description:3-10-10 In this session, we'll take a look at tools and techniques to help you work with Excel more efficiently. We'll cover techniques such as linking worksheets with 3-D formulas, sorting and filtering data using autofilters, commenting cells, using lookup functions, creating PivotTables for data analysis using the Banner reports SYRSTAN and SYROLLY. We'll also take a look at useful techniques to transpose columns and rows, discarding empty cells, and using Excel as a data source for Word mail merges. This touches on a few of the tools and techniques available for intermediate Excel users, and if time allows, we'll demonstrate other techniques.
Published:
11/Jun/2010
No comments:
Post a Comment