The Menu: Lunch & Learn Series
Microsoft Windows (Manage your filing cabinet) / MS Office 2007 (1 session)
- File Naming conventions
- Build folders, copy / drag files in Explore
- Image maintenance / file sizes
- Excel - Overview
- Access - Overview
- Powerpoint - Overview
- Word - Overview
- Vista - Overview
Microsoft Excel - Gain accuracy & speed (2 sessions)
- Keyboard Shortcuts
- Pivot Tables
- Subtotals & Filters; learn the value of visible cells
- Standard formulas - from simple to complex
- Advanced Formulas & Conditional Formatting
- Template Strategies with Access
- Charts - Basic & Custom; Macros
- Protect yourself! Strategies for sharing your work
Microsoft Access - Manage your Mondays! (2 sessions)
- Using with Retail Link
- Table structure
- Queries: ad hoc, make table, append, delete, update
- Building formulas in queries & reports
- Reports: tables & charts - a picture is worth 1000 calculations
- User forms
- Macros: automate your Mondays!
- Blend with Excel templates
Microsoft Map Point - Everyone loves maps! (1 session)
- Intro: Demonstrate national opportunities with maps
- Linking to standard database downloads
- Create effective market visits: Driving Directions
- Analyze "hot spots" with temperature graphs
- Create custom boundaries to uncover SOTC opportunities
Microsoft Power Point - Automate your line reviews / Standard decks (1 session)
- Spreadsheet linking
- Design Templates
- Slide Masters
- Basic Macros
- Smart Text
- Importing photos: size considerations
Microsoft Word - Layout room labels & Sr. Mgt. communication (1 session)
- Create Labels using Excel Files
- Link data to Excel
- Basic Macros
- Import photos
ASAP Utilities - Amazing Add-in, free download (1 session)
- Overview
- What does it do?
- Key Features
|
