MS Office (Advanced Excel) Certification Training

What’s new in Word 2013
How to open new documents and existing documents
How to use templates
Basic and advanced text, paragraph, and document formatting
How to use Microsoft Word for desktop publishing
How to create brochures, flyers, and even business cards using MS Word
How to insert images, graphics, and video
How to create even more impressive tables than ever before using new formatting tools
How to solve mathematical equations using Word
Mail Merge
Macro

Create a spreadsheet
Format cells, rows, columns, and entire worksheets so they fit and match your data
Enter data into a spreadsheet
Use formulas and functions for math, accounting, and totaling
Create formulas and functions
Create charts and diagrams for your data
Create data lists and forms
Create and use pivot tables and pivot charts
Work with Excel templates
Share and protect your worksheets and workbooks
Use What-If Analysis to determine possible outcomes

Navigate the PowerPoint 2013 interface
Create new presentations from scratch – or use the beautiful template
Add text, pictures, sounds, movies, and charts to your presentations
Design slides using themes, colors, and special effects
Animate objects on slides to bring them to life. We’ll even show you how to make a ball bounce on a slide!
Add special effects to slide transitions to spice up your presentations
Work with Master Slides to make editing your presentation easy
Set up slide shows and rehearse timings for your slides
Collaborate using social media and PowerPoint together

Examine database concepts and explore the Microsoft Office Access environment.
Design a simple database
Build a new database with related tables
Manage the data in a table
Query a database using different methods
Design a form.
Generate a report.
Import and export data.
Access Basics
Design a Database
Build a Database
Work with Forms
Sort, Retrieve, Analyze Data
Work With Reports
Access with Other Applications
Manage and Access Database