MS OFFICE

Course Overview :

Microsoft Office 2013 training courses at Ecorptrainings offer you the latest version of MS Office Suite along with various upgrades to make your work easier and more streamlined. Taking up MS Office 2013 will not only make you aware of all the new tools and functions available but also help you make the most of your Office operations. The course focuses on Word 2010 Expert training, Excel 2010 Expert training and PowerPoint 2010 training.

Prerequisties

• General familiarity with Windows operating system is expected but no assumption of knowledge of specific tools or techniques is assumed.

Course Content

• 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