Microsoft Office

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

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.

At the end of the training, participants will be able to:

Pre-requisite

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

Duarion

5 days

Course Outline

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

Reviews