The College Guide to Microsoft Office 2013
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.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add The College Guide to Microsoft Office 2013 to your Wishlist.

Add to Wishlist

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.
1 student enrolled
Created by Elizabeth Nofs
Last updated 4/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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.
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

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 08:31:37
+
Getting Started
2 Lectures 09:32

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!

Preview 02:44

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

Preview 06:48
+
Microsoft Word: Working with Text
2 Lectures 18:12

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


Horses and Zebras
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. 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.


Mice and Men
09:16

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

Microsoft Word: Working with Text
10 questions
+
Microsoft Word: Working with Graphics
2 Lectures 18:27
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.

First Impressions
09:42

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.

BONUS: Fancy Colors
08:45

An assessment of the skills leaned in these lessons

Microsoft Word: Working with Pictures
5 questions
+
Microsoft Word: Business Documents
2 Lectures 21:09

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

Open for Business
11:55

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.


Online, All the Time
09:14

An assessment of the skills demonstrated in these lessons

Microsoft Word: Business Documents
5 questions
+
Microsoft Word: Using Styles
2 Lectures 23:30
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

Doing it with Styles
11:28

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.

Going in Style
12:02

An assessment of the skills desmonstrated in these lessons.

Microsoft Word: Using Styles
10 questions
+
Microsoft Excel: Getting Started
2 Lectures 08:42

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
Getting Started: Excel
02:44

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.

Preview 05:58
+
Microsoft Excel: Working with data
2 Lectures 19:16
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.

It All Adds Up
08:49

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.

A Question of Balance
10:27

An assessment of the skill demonstrated in these lessons

Microsoft Excel Working with Data
10 questions
+
Microsoft Excel: Presenting the Data Visually
2 Lectures 16:08
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

Preview 08:56

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.

BONUS: Picture the Data in Excel
07:12

An assessment of the skills demonstrated in these lessons

Microsoft Excel Presenting the Data Visually
5 questions
+
Microsoft Excel: Business Spreadsheet
4 Lectures 35:55
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.

Legs, Eggs and Pigs
14:08

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.

Piggy Goes to Market: TEXT Formulas
06:28

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.

Piggy Goes to Market: DATE and TIME formulas
07:51

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

Preview 07:28

An assessment of the skills demonstrated in these lessons

Microsoft Excel Business Spreadsheets
10 questions
+
Microsoft Excel: Tables and Lists
2 Lectures 16:43
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

Works for Me: Using Tables
09:48

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

Work Smarter, Not Harder
06:55

An assessment of the skills demonstrated in these lessons

Microsoft Excel: Tables and Lists
10 questions
4 More Sections
About the Instructor
Elizabeth Nofs
4.5 Average rating
701 Reviews
12,395 Students
18 Courses
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.  We have our own school at thecomputermama.teachable

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