MS OFFICE ONLINE TRAINIG COURSE

MS OFFICE INTRODUCTION & COURSE DETAILS

  • ACCESS 2010
    • Make the switch to Access 2010
    • Design the tables for a new database
    • Create tables for a new database
    • Create relationships for a new database
    • Create queries for a new database
    • Create forms for a new database
    • Create reports for a new database
    • Add the web to your databases
    • Build and publish web databases
  • EXCEL 2010
    • Make the switch to Excel 2010
    • Get to know Excel 2010: Create your first spreadsheet
    • Get to know Excel 2010: Create formulas
    • Understand data at a glance with conditional formatting
    • VLOOKUP: What it is, and when to use it
    • Sparklines – Use tiny charts to show data trends
    • Use Excel tables to manage information
    • The IF function – What it is, and how to use it
    • How to create a basic chart in Excel 2010
    • Figure out dates by using formulas in Excel 2010
    • Plan payments and 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 and RSS – The Internet in your mailbox
    • Manage your mail and more with conditional formatting
    • Send 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 and Search Folders
  • POWERPOINT 2010
    • Make the switch to PowerPoint 2010
    • Create your first PowerPoint 2010 presentation
    • Use photos in PowerPoint 2010
    • PowerPoint 2010 tips and tricks
    • PowerPoint 2010 keyboard shortcuts
    • Charts and diagrams I: SmartArt graphics
    • Charts and diagrams II: Data charts
    • Broadcast a PowerPoint presentation
    • Add videos to PowerPoint 2010
  • WORD 2010
    • Make the switch to Word 2010
    • Create your first Word document I
    • Create your first Word document II
    • Use the Word Navigation Pane to search and move around in a document
    • Create visually compelling documents in Word 2010
    • Get control of page numbers, headers, and footers
    • Create accessible documents in Word 2010
    • Word 2010 keyboard shortcuts
    • Word 2010 tips and tricks
    • Add a table of content in Word 2010
  • GENERAL OFFICE 2010
    • Office 2010 Security – Protecting your files
    • Create accessible documents in Word 2010

CONTACT US