The College Guide to Microsoft Office 2013

Another Computer Mama Guide

If you wish to prepare for college and life after college in a rewarding profession, this course will help you build the skills and knowledge you need.

Step-by-step video demonstrations
Companion eBooks with detailed instructions
Sample documents, spreadsheets, presentations and images
Practice, Quizzes and Skill Test
With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Word, Excel and PowerPoint 2013 software. You'll cover basic through advanced topics.
Upon completion, you'll be prepared to complete your college assignments and gain an important edge in today's competitive job market.

The College Guide to Microsoft Office 2013 -Table of Contents

I. Beginning Microsoft Word

•Format Text and Paragraphs

•Get skilled at working with Text and Pictures

•Use the Quick Click options and the mini Toolbar to format Text

•Gain experience editing images and shapes with the Picture Tools

•Use Templates and Quick parts to create professional documents


II. Intermediate Microsoft Word

•Understand how to use and edit Templates to create documents and resumes

•Create a Web Page that uses a Table for consistent layout

•Use Microsoft Word Online


III. Advanced Microsoft Word

•Learn effective methods for creating and formatting Tables

•Understanding Styles and how to use Styles to create a Table of Contents

•Apply professional document formatting including Headers and Footers, Citations and References

•Prepare to Share Documents by using the Proofing Tools


IV. Beginning Microsoft Excel

•Enter data and use basic text formatting in a spreadsheet

•Enter data, format labels and create formulas in a price sheet

•Use and audit formulas from Excel's formula library to calculate numbers, text, dates and financial payments

•Insert and modify Charts with the Chart Tools and the new Quick Click options

•Insert and format pictures in a spreadsheet


V. Intermediate Microsoft Excel

•Create formulas that use Relative and Absolute values and audit the formulas

•Use and modify TEXT formulas to combine cells (Concatenate) and format the data

•Create, use and troubleshoot Named Ranges and use Named Ranges in formulas

•Understand how to create and use Lookup Tables and use the IF functions

•Excel In Print: Use page Layout and Page Set up to modify print settings


VI. BONUS Microsoft PowerPoint

•Enter text and use basic text formatting in a presentation

•Format Pictures and apply Themes

•Use Videos and Animation in a Presentation