Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
Microsoft Certification Career Advancement
ITU’s Microsoft Certification Career Advancement Bundle is your ticket to success! This bundle offers certification courses in Excel, Access, Word, PowerPoint and Outlook that will help you prepare for the esteemed Microsoft Office Specialist (MOS) certification.
Included In This Course
Included In This Course
22 Training Hours
151 On-demand Videos
Closed Captions
15 Topics
220 Prep Questions
Certificate of Completion
Course Description
In today’s competitive economic climate, having certifications that validate one’s skills are essential to “set yourself apart from the pack” in the marketplace. Having Microsoft certifications not only increase one’s marketability but also validates an employee’s skills and experience to a potential employer. IT University is committed to helping all of our students in their given profession and has designed this bundle specifically to help any Business, HR, Sales, Office, Administration or Accounting professional gain the skills and certification they need to help them attain the positions they desire.
In today’s marketplace computers are a part of daily life for almost everyone in an office setting. Many people spend hours on projects that could take minutes if they had the necessary training to expedite their day to day tasks. ITU’s Microsoft Certification Career Advancement Bundle contains certification courses in Excel, Access, Word, PowerPoint & Outlook and allows you to prepare for your Microsoft Office Specialist(MOS) certification.
Proudly DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Course Outline
Microsoft Excel 2010 Course Content
Excel 2010 Basic
Intro to Excel Basic
Interface and Functions
Cells
Entering Data Into Cells
Basic Formatting in Excel
Creating a Worksheet
The Intelligence Of Excel
Customizing Rows and Columns
Creating Formulas
Summary Pages and Moving Workbook to Workbook
The Function Builder
Conditional Formatting
Sorting and Filtering Data
Printing with Excel
Conclusion
Excel Basic Flashcards
Excel 2010 Intermediate
Intro to Excel Intermediate
Charts
Headers Footers and Layout Options
What If
Basic Tables in Excel
Pivot Tables
Manipulating Data Within the Pivot Tables
Pivot Table Charts
Data Validation
Conclusion
Excel Intermediate Flashcards
Excel 2010 Advanced
Intro to Excel Advanced
Customizing the Ribbon and Cells
Creating and Managing Ranges
More Formulas
Data Analysis
Data From an Outside Source
Spark Lines
Macros
Conclusion
Excel Advanced Flashcards
Microsoft Outlook 2010 Course Content
Outlook 2010 Basic
Intro To Outlook Basic
Interface
Customizing Interface
E-mail 101
Organizing Inbound E-mails
Calendar Function
Task Lists
Contact List
Multiple Accounts
Conclusion
Outlook 2010 Intermediate
Intro To Outlook Intermediate
Message Functions
Calendar
More In-Depth Contact Functions
Email Message Options
Mail Rules
Customizing Options
Conclusion
Outlook 2010 Advanced
Intro To Outlook Advanced
Send And Receive
Account Settings
Calendars
Quick Actions Within Messages
Quick Steps
Conclusion
Microsoft Powerpoint 2010 Course Content
Powerpoint 2010 Basic
Powerpoint Basic Flashcards
Intro To PowerPoint Basic
The PowerPoint Interface
Creating A New Presentation With Templates
Slide Layout
Visually Appealing Presentations
Preview Mode And Page Setup
Transitions
Creating Custom Slides
Animating Text
Animating Objects
Animation Timing
Conclusion
Powerpoint 2010 Intermediate
Powerpoint Intermediate Flashcards
Introduction To PowerPoint Intermediate
Sections And Organizing Slides
Adding Autoshapes
Inserting And Editing Pictures
Inserting And Editing Video
Inserting And Editing Tables
SmartArt
Animating Smart Art And Inserting Audio
Headers And Footers In PowerPoint
Setup Slideshow And Rehearsal Timing
Conclusion
Powerpoint 2010 Advanced
Powerpoint Advanced Flashcards
Intro To PowerPoint Advanced
Master Slides
Styles
More Functions With Video In PowerPoint
Transitions And Action Buttons
Customizing The Show
Printing In PowerPoint
Conclusion
Microsoft Word 2010 Course Content
Word 2010 Basic
Flashcards
Intro to the Word Interface
Working with Templates
Creating a New Blank Document
Formatting a Document
More Formatting Options
Adding Shapes, Clipart, & Pictures
Page Layout
Conclusion
Word 2010 Intermediate
Flashcards
Introduction
Tracking Changes in a Document
Customizing the Interface
Working with Styles
Tables in Word
Endnotes, Footnotes, & Captions
Cover Pages, Headers, & Footers
Working with Sections
Headers & Footers
Cover Sheet & Table of Contents
Cover Letters & Mail Merge
Conclusion
Word 2010 Advanced
Flashcards
Introduction to the Word Interface
Customizing the Ribbon
Embedding Non-Word Documents
Working with Formulas
Citations
Comparing Documents
Forms & Content Controls
Master Documents & Subdocuments
Conclusion
Microsoft Access 2010 Course Content
Access 2010 Basic
Access Basic Flashcards
Introduction
Databases And The Access Interface
Spreadsheets And Tables
Entering Data In A Table
Relationships Between Tables
Editing A Form
Queries
Across The Tables
Creating Forms
Conclusion
Access 2010 Intermediate
Access Intermediate Flashcards
Introduction
Primary Key
Multiple Table Query
Creating Forms
Validation Within Forms
Adding Related Fields
Forms Created With Design View
Find Functionality
Creating Report
Conclusion
Access 2010 Advanced
Access Advanced Flashcards
Introduction
Customizing Access With Back Stage Options
Mailing Labels
Macros-Part1
Macros-Part2
Queries-Part1
Queries-Part2
Joining In Sequel
Navigation
Adding Chart With Specific Data
Action Query
Security
Conclusion
Your Training Instructor
Josh has 15 plus years in account management and client support with over 5 years specifically in the healthcare industry. Josh provides hands-on leadership to the healthcare team at NetDirector by focusing on client success and innovative solutions. As the Healthcare Operations Manager, Josh ensures that each client implementation is completed as efficiently as possible with the greatest impact to the client. He holds a Bachelor of Arts degree from the University of South Florida.
$49.00
OR
Subscribe To All-Access
Lock In $14.99 / Month Forever
Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.
$49.00 $14.99 Monthly
Microsoft Certification Career Advancement
Microsoft Certification Career Advancement
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.
Monthly All-Access Subscription
7 Days Free - $39.00 / month
A great option at an affordable monthly price.
Annual All-Access Subscription
$229 / year
A discounted price when paying for your All Access library on an annual basis.
Lifetime All-Access Library
$379 One time payment
Exceptional Value. Pay once, never have to buy IT training again.
Related Courses
$49.00
Master the art of network troubleshooting with Cisco CCNP Troubleshooting IP Networks 300-135 training. Enroll today!
The CCNP Troubleshooting IP Networks 300-135 exam ascertains that the candidate possesses the information and abilities required to regularly maintain complex enterprise routed and switched networks.
$49.00
Advance your IT career with Microsoft 70-412 training course. Learn how to configure advanced Windows Server 2012 services with ITU Online.
In this Microsoft 70-412: Configuring Advanced Windows Server Services course you will learn how to perform the advanced configuring tasks required to deploy, manage, and maintain a Windows Server 2012 infrastructure, such as fault tolerance, certificate services, and identity federation.
$49.00
Get your CompTIA A+ Certification with our 220-1001 Core 1 and 220-1002 Core 2 online course. Enroll now and get ahead in your IT career!
The CompTIA A+ 220-1001 & 220-1002 training for the Core Series covers topics that are growing in IT support, including expanded content on security baselines and a different way of assessing competence in operational procedures. ITU’s online learning environment is ideal for those with a busy schedule, offering convenience and flexibility, study when you want.
I’ve enjoyed the training so far. Wish it was more focused on Linux like other training, but still good.
The educators at ituonline.com are highly skilled but could improve their methods of instruction. In the CCNA 200-301 course, there’s a heavy emphasis on oral lectures, and it would be beneficial to include more in-depth visual aids. Annotating labs and graphics could also make the educational journey more effective. On the other hand, the N10-008 course instructor consistently offers top-notch material.
This course is super detailed but not boring, and they give you cool projects to actually practice what you’re learning.