ACCESS 2010
- Making switch to Access 2010
- Designing tables for a new database
- Creating tables for a new database
- Creating relationships for a new database
- Creating queries for a new database
- Creating forms for a new database
- Creating reports for a new database
- Add the web to your databases
- Build and publish web databases
EXCEL 2010
- Making switch to Excel 2010
- Get to know Excel 2010: Create your first spreadsheet
- Get to know Excel 2010: Create formulas
- Understanding data at a glance with conditional formatting
- VLOOKUP: What it is, and when to use it
- Spark lines Use tiny charts to show data trends
- Using Excel tables to manage information
- The IF function – What it is & how to use it
- How to create a basic chart in Excel 2010
- Figure out dates by using formulas in Excel 2010
- Plan payments & savings in Excel 2010
- Excel 2010 keyboard shortcuts 1: CTRL key shortcuts
- Excel 2010 keyboard shortcuts 2: ALT key shortcuts
ONENOTE 2010
- Make the switch to OneNote 2010
OUTLOOK 2010
- Make the switch to Outlook 2010
- Tame your Outlook 2010 Inbox
- Get familiar with the Outlook Calendar
- Use e-mail signatures in Outlook 2010
- Use electronic business cards in Outlook 2010
- Outlook & RSS – The Internet in your mailbox
- Manage your mail & more with conditional formatting
- Sending the Automatic Replies when you’re away
- Save time with templates in Outlook 2010
- Mailbox Management 1: Use views to stay organized in Outlook 2010
- Mailbox Management 2: Instant Search & Search Folders
POWERPOINT 2010
- Make the switch to PowerPoint 2010
- Creating your first PowerPoint 2010 presentation
- Use photos in PowerPoint 2010
- PowerPoint 2010 tips & tricks
- PowerPoint 2010 keyboard shortcuts
- Charts & diagrams I: SmartArt graphics
- Charts & diagrams II: Data charts
- Broadcast a PowerPoint presentation
- Adding videos to PowerPoint 2010
WORD 2010
- Make the switch to Word 2010
- Creating your first Word document I
- Creating your first Word document II
- Use the Word Navigation Pane to search & move around in a document
- Create the visually compelling documents in Word 2010
- Get control of page numbers, headers & footers
- Creating the accessible documents in Word 2010
- Word 2010 keyboard shortcuts
- Word 2010 tips and tricks
- Adding table of content in Word 2010
GENERAL OFFICE 2010
- Office 2010 Security – Protecting your files
- Create the accessible documents in Word 2010
