The College Guide to Microsoft Office 2013

Another Computer Mama Guide
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
0 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 30
  • Length 8.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

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

What are the requirements?

  • To enroll in the Microsoft Office Specialist 2013 program, you should have basic computer skills and should be comfortable using an Internet browser and selecting commands from a menu or toolbar.
  • You should be able to manage files, including saving, updating, and backing up files.

What am I going to get from this course?

  • Microsoft Word: Get skilled at working with Text and Pictures
  • Microsoft Word: Gain experience editing images and shapes with the Picture Tools
  • Microsoft Word: Use Templates and Quick parts to create professional documents
  • Microsoft Word: Use Styles to format a Document and create a Table of Contents
  • Microsoft Word: Use the Reference Tools to add Footnotes, Citations, create a Bibilography
  • Microsoft Excel: Create a spreadsheet that calcuates the SUM, AVERAGE, MAX, MIN and COUNT.
  • Microsoft Excel: Visualize the data as Charts
  • Microsoft Excel: Create Formulas that work with Text, Dates and Financials
  • Microsoft Excel: Work with Tables
  • Microsoft Excel: Create LookUp Tables to find the right answers
  • Microsoft PowerPoint: Learn how to format Text and Graphics
  • BONUS: Create an animated PowerPoint presentation that includes videos

What is the target audience?

  • This program is for you if you are a student in college who needs to use Microsoft Word, Excel and PowerPoint immediately to complete your course assignments.
  • This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
02:44

If you wish to prepare for college and life after college in a rewarding profession, this course has the resources you need.

  • Step-by-step video demonstrations
  • Companion eBooks with detailed instructions
  • Sample documents, spreadsheets, presentations and images
  • Practice, Quizzes and Skill Test

Look for the DOWNLOADS on the right side of the videos!

06:48
Project: A sample document that you do not need to save.

Beginning Word Objectives

In this lesson, you will learn how to:
1. Open Microsoft Word
2. Align Text center, left, right, and justified
3. Format Font color, size, face, and case
4. Identify the Home Ribbon, Font Group & Paragraph Group
5. Identify and apply Line Spacing options

Section 2: Microsoft Word: Working with Text
08:56

Project: A sample document that you do not need to save

Beginning Word Objectives

In this lesson, you will learn how to:
1. Use Copy and Paste commands on text & pictures
2. Use Drag and Drop editing on text & pictures
3. Insert Pictures from Clip Art
4. Apply position formatting to a picture
5. Access the Picture Tools Ribbon
6. Resize and move a picture


09:16

Project: A sample document that you do not need to save

Beginning Word Objectives

In this lesson, you will learn how to:
1. Identify and use the Mini Toolbar.
2. Identify and use Paste Options.
3. Use Spelling and Grammar checking tools.
4. Use AutoText and AutoCorrect.
5. Save a document using Office 2007-2013 format.
6. Save a document using Office 2003 format.
7. Use Save As to create a copy of a document.


10 questions

An assessment of the material covered in the beginning Word lessons.

Section 3: Microsoft Word: Working with Graphics
09:42
Project: Custom stationery using a template, Graphics, and Quick Parts.

Beginning Word
In this lesson, you will learn how to:
1. Use the Insert Date and Time options.
2. Insert a Text Box.
3. Format a Text Box: Shape, Quick Styles, Effects and Text Direction.
4. Create linked Text Boxes.
5. Use Quick Parts.

08:45
Project: A sample document that demonstrates the Picture Tools in Microsoft Word.


Beginning Word Objectives
In this lesson, you will learn how to:
1. Access the Picture Tools Ribbon.
2. Apply Pictures Styles and Effects.
3. Apply Borders to a Picture.
4. Use the Picture Corrections Tool.
5. Apply Artistic Effects to a Picture.
6. Compress a Picture for optimal size.
7. Remove the background of a Picture.
8. Crop a Picture and Crop to Shape.

5 questions

An assessment of the skills leaned in these lessons

Section 4: Microsoft Word: Business Documents
11:55

Project: Create a custom FAX and a personal Resume from a Template

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Open a new document from Template.

2. Edit the Building Blocks in a Template.

3. Add content to customize a Template.

4. Apply a Theme to a document.

5. Save a document as a Template.

6. Use a Template to create a resume.

7. Use Quick Parts to edit the resume

09:14

Project: A simple flyer in Word that includes hyperlinks to videos and pictures.

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Save a picture to a SkyDrive.

2. Use a Table to control the Layout.

3. Add Online Video to a document.

4. Apply a Theme and a Table Style.

5. Add a hyperlink to a picture.


5 questions

An assessment of the skills demonstrated in these lessons

Section 5: Microsoft Word: Using Styles
11:28
Project: Format a document with Styles and use the Styles to navigate to the main topics

Advanced Word Objectives

In this lesson you will learn how to:

1. Create, apply and update Styles

2. Control pagination with a Page Break

3. Practice navigating with the Document Map

4. Use the Reference Ribbon to create References

5. Identify Editing options for Find, Replace and Go

12:02
Project: Format a business proposal with Styles and use those Styles to create the Table of Contents. This document will include Headers, Footers, Page Numbers, Section Breaks and References, too.

Advanced Word Objectives

In this lesson you will learn how to:

1. Apply Styles.

2. Navigate with Styles.

3. Insert and format a Footer.

4. Insert , format and remove page breaks.

5. Use the Table of Contents and Index commands.

6. Insert and edit citation and bibliography entries.

7. Insert and edit captions.

10 questions

An assessment of the skills desmonstrated in these lessons.

Section 6: Microsoft Excel: Getting Started
02:44

If you wish to prepare for college, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBooks with detailed instructions
  • Sample spreadsheets and images
  • Practice, Quizzes and Skill Test

Look for the Course DOWNLOADS in the Resources.
All materials for this program are available online.

The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft® Excel 2013
  • Advanced Guide to Microsoft® Excel 2013
05:58

Project: A sample document that you do not need to save.

Beginning Excel Objectives

In this lesson, you will learn how to:
1. Open Microsoft Excel.
2. Align Text in a Cell center, left, right, and justified.
3. Format Font color, size, face, and case.
4. Identify the Home Ribbon, Font Group & Alignment Group.
5. Identify and apply Alignment options.

Section 7: Microsoft Excel: Working with data
08:49
Project: A sample spreadsheet that calculates the wholesale and retail costs, and the profits


Beginning Excel Objectives

In this lesson you will:

1. Practice entering the labels and data.

2. Use the Home Ribbon to apply number formats.

3. Create a formula to calculate the retail price.

4. Use the AutoSum to calculate costs.

5. Use the AutoSum to SUM the profit.

6. Use the Home Ribbon to format cell borders.

7. Investigate options to hide and unhide data.

8. Identify and use the Cell Styles.

10:27
Project: A checkbook and a spreadsheet that compares employee salaries to the average

Beginning Excel Objectives

In this lesson you will learn how to:

1. Review how to enter labels and data.

2. Review how to calculate the balance.

3. Identify methods to audit your equations.

4. Use currency formatting on the Home Ribbon.

5. Identify the options that format the decimals.

6. Use formulas for SUM, AVERAGE, COUNT.

7. Learn the COUNTA Function.

8. Practice the Max and Min Functions.

9. Use the IF Logical Function.

10 questions

An assessment of the skill demonstrated in these lessons

Section 8: Microsoft Excel: Presenting the Data Visually
08:56
Project: A sample spreadsheet that demonstrates the Chart Tools: Design Layout and Format

Beginning Excel Objectives

In this lesson, you will learn how to:
1. Present data visually in a Chart

2. Create and format a Pie Chart

3. Edit the Chart Layout

4. Design and edit a Column Chart

5. Format the Shape Styles and Shape Fill

07:12
Project: An introduction to the Picture Tools and using pictures in a spreadsheet

Beginning Excel Objectives

In this lesson you will learn how to:

1. Add pictures to a spreadsheet.

2. Use the Picture tools to format the Picture Style and Picture Effects.

3. Use the tools to format the Picture Size.

4. Crop a Picture and Crop to Shape.

5. Make Picture Corrections by adjusting the Brightness, Contrast, Color Saturation and Tone.

6. Apply Artistic Effects.

7. Use the Adjustment tools to Compress a picture for Print, Screen, E-mail, or use the document resolution.

5 questions

An assessment of the skills demonstrated in these lessons

Section 9: Microsoft Excel: Business Spreadsheet
14:08
Project: A spreadsheet that calculates the daily sales for three products and adds up the total on a summary spreadsheet.

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Format data and content.

2. Fill a series with AutoFill.

3. Calculate revenue with a formula.

4. Summarize the data.

5. Identify Relative References.

6. Identify errors and troubleshoot equations.

7. Use the Auditing Toolbar.

06:28
Project: Use formulas to format and modify TEXT, DATE, and TIME.

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Practice modifying cell contents and formats.

2. Use the Paste Special options.

3. CONCATENATE (combine) data with a formula.

4. Modify and format TEXT with formulas.

07:51

Project: Use formulas to format and modify DATE, and TIME

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Practice modifying cell contents and formats.

2. Use the Paste Special options.

3. CONCATENATE (combine) data with a formula.

4. Use DATE and TIME formulas.

07:28
Project: Use formulas to calculate a car payment

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Practice modifying cell contents and formats.

2. Use FINANCIAL formulas to calculate a payment

10 questions

An assessment of the skills demonstrated in these lessons

Section 10: Microsoft Excel: Tables and Lists
09:48
Project: A spreadsheet that works with Tables in Excel. This lesson shows how to present data visually, format data as a Table and calculate the Totals.

Advanced Excel Objectives

In this lesson, you will learn how to:

1. Create a Table.

2. Identify the Header Row with the Table Tools.

3. Locate the Quick Style Formats.

4. Use the Table Tools to add a Total Row.

5. Convert Tables to Text.

6. Convert Text to Tables

06:55
Project: A sample spreadsheet that uses Outlines and What-If Scenarios to analyze the data

Advanced Excel Objectives

In this lesson, you will learn how to:

1. Use the Data Ribbon to Sort and Filter the data.

2. Outline the data with the Outline Tools and use the Outline to Show or Hide Rows of information.

3. Use the Data Tools to perform a What-If Analysis and use Goal Seek to see how that goal can be met

10 questions

An assessment of the skills demonstrated in these lessons

Section 11: Microsoft Excel: Prepare to Share
08:51
Project: A sample project that investigates the options for Page Layout and Printing

Microsoft Excel Objectives

In this lesson, you will learn how to:

1. Use the Page Layout options to prepare a professional print out.

2. Edit the Page Setup including the Orientation, Margins, Size, Background, and Titles.

3. Create custom Headers and Footers with different Odd and Even pages

10:13
Project: This lesson shows how to prepare a file for sharing including: proofing and comments.

Advanced Excel Objectives

In this lesson, you will learn how to:

1. Use the Review Ribbon to proof a spreadsheet.

2. Insert, edit, view and manage reviewer's comments.

10 questions

An assessment of skill demonstrated in these lessons

Section 12: Microsoft PowerPoint: Getting Started
02:44

BONUS Lessons: Microsoft PowerPoint. This has everything you need:

  • Step-by-step video demonstrations
  • Companion eBook with detailed instructions
  • Sample presentations and images
  • Practice, Quizzes and Skill Test

Look for the DOWNLOADS in the course Resources.

The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® PowerPoint 2013
11:04
Project: A simple presentation that demonstrates how to edit text on slides.

PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Home Ribbon to add a new slide.

2. Enter Text on a slide.

3. Use the Font Group to format the Text: Bold, Italic, Underline, and Color.

4. Use the Font Group to modify the type face.

5. Modify the Font Size: Increase and Decrease.

6. Find More Font Options.

5 questions

An assessment of the skills demosntratede in these lessons

Section 13: Microsoft PowerPoint: Creating Presentations
12:57

Project: A presentation that uses custom text editing with the Paragraph options

Beginning PowerPoint Objectives

In this lesson, you will learn how to:

1. Review the Spelling and Mini Toolbar options.

2. Locate the Outline and use the Home Ribbon to add new slides to the Outline View.

3. Use the Paragraph Group to format the Bullets.

4. Modify the Bullets and choose a different symbol.

5. Use the Paragraph Group to change the indentation on the bulleted lists.

6. Format and modify a Numbered List.

7. Edit the Line Spacing between the paragraphs.

8. Modify the Text Alignment, Direction and position within a Text Box

09:45
Project: A simple presentation that uses the Drawing tools to format 4 slides.

Beginning PowerPoint Objectives

In this lesson, you will learn how to:

1. Identify and use the Drawing tools to apply formatting to a Text Box.

2. Format the Text Box with Quick Styles.

3. Create a custom Text Box by editing the Shape Fill with Color, Gradient, Texture, Patterns and Pictures.

4. Format the Color, Weight and Style of the Text Box Outline.

5. Work with Shape Effects: Shadow, Glow, and 3D Rotation

5 questions

An assessment of the skills demonstrated in these videos.

Section 14: Microsoft PowerPoint: Working with Graphics
10:54
Project: A PowerPoint slide show that uses pictures to tell the story

Beginning PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Picture Tools Ribbon to format the Picture Styles.

2. Modify the Picture Borders and Picture Effects.

3. Crop and Resize a picture.

4. Apply image Corrections such as Soften/Sharpen, Brightness/Contrast, Artistic Effects

09:10
Project: An animated presentation that includes embedded videos

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Video Play Ribbon to adjust the playback options.

2. Trim a video and edit the Fade in and out.

3. Apply a Style to a video or audio content.

4. Use the Video Format Ribbon to size and arrange the multimedia content

Look for the DOWNLOADS in the Resources!
This lesson includes everything you need in a zipped folder:

  • Step-by-step video demonstration
  • Companion eBook with detailed instructions
  • Sample presentation, steam engine video and train images


5 questions

An assessment of the skills demonstrated in the videos

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Elizabeth Nofs, The Computer Mama

Expert in Instructional Technology and Online Learning

Incredible ability to teach technology

Developed a successful method for teaching visually that is based on observation, orientation and notation. The method is very effect for teaching concepts and skills.

I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS).

There are over 60 Computer Mama courses available through ed2go and World Education.

During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads.

I enjoy teaching Microsoft Office and look forward to working with you. eBeth

Ready to start learning?
Take This Course