eUM Systems
eUM Financials Tutorials
Using Excel with RAVEN Data
RAVEN and Excel Basics (Click to View / Total Viewing Time: 29:56)
The first tutorial covers some of Excel's basic features. You will see and hear how to use Excel features that will make your work with RAVEN data easier. Features covered in this tutorial are:
| Freeze Panes | Sort Data |
| Resize Columns and Rows | Format Cells |
| Move and Delete Columns | Highlight Cells to Draw Attention |
| Use Auto Calculate | Page Break Preview |
Preparing Your Report (Click to View / Total Viewing Time: 9:27)
The second tutorial in the RAVEN-Excel series focuses on preparing your downloaded data for further analysis. Features included in this short tutorial are:
| Adjust Columns and Rows | Repeat Row 1 for Multi-Page Printing |
| Change Page Orientation to Landscape | Customize Headers and Footers |
| Locate Online List of eUMB Accounts | |
Data Analysis and Collaboration (Click to View / Total Viewing Time: 16:12)
The third tutorial will take you through several features that can help you focus on specific data for analysis. Features covered in this tutorial are:
| Apply and Use AutoFilter | AutoSum |
| Apply and Use Custom Filter | Data Snapshots and Collaboration |
Pivot Tables in Excel 2003 (Click to View / Total Viewing Time: 14:12)
Pivot Tables in Excel 2007 (Click to View / Total Viewing Time: 12:32)
The fourth and fifth tutorials in the RAVEN-Excel series focus on Pivot Tables: what they are and how to build, modify and use them in Excel 2003 or Excel 2007. Features covered in these tutorials are:
| Creating Pivot Tables | Building Pivot Tables |
| Working with Pivot Tables | Auto Filter and Double Click Trick |
| Adding Fields and Removing Sub-Totals | |
Here's a key to the control panel for the above tutorials.
We are always interested in your feedback and your experience. Email Robin Reid to share your feedback and ideas.
