The Business Guide to Microsoft Office

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
$19
$50
62% off
Take This Course
  • Lectures 43
  • Length 7 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

The Business Guide to Microsoft Office

If you wish to be effective and efficient at work, this course will help you build the skills and knowledge you need.

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

All materials for this program are available online. The following textbooks are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Word 2013
  • Intermediate Guide to Microsoft® Word 2013
  • Advanced Guide to Microsoft® Word 2013
  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft® Excel 2013
  • Advanced Guide to Microsoft® Excel 2013
  • Beginning Guide to Microsoft® PowerPoint 2013
  • Advanced Guide to Microsoft® PowerPoint 2013

With this comprehensive, performance-based certification preparation online program, you can build and validate your business computer skills using Microsoft Office 2013 software. You'll cover basic through advanced topics. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

In Microsoft Word, you will cover important topics, including how to:

  • Format Text and Paragraphs
  • Get skilled at working with Text and Pictures
  • Learn how to create and format SmartArt
  • Understand how to use and edit Templates to create documents and resumes
  • Create a Mail Merge that sends a personalized invitation to each recipient
  • Learn how to select the Mail Merge recipients and troubleshoot errors
  • Create a Web Page that uses a Table for consistent layout

In Microsoft Excel, you will cover business topics, including how to:

  • Create formulas that use Relative and Absolute values and audit the formulas
  • Use and modify TEXT, DATES and FINANCIAL data with formulas
  • 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

In Microsoft PowerPoint, you will learn how to:

  • Know how to work with Text Boxes, Format Shapes and apply Themes
  • Insert, format and adjust Pictures with the Picture Tools
  • Insert and format Shapes and SmartArt to create an effective presentation
  • Use Tables and Spreadsheets to display data in a presentation
  • Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  • Learn how to design Slide Masters and apply slide Transitions
  • Apply Animations to images in a slide show and edit the timing


Microsoft Office Specialist (MOS) certification is the globally recognized standard for validating expertise with the Microsoft Office Suite. If you wish to prepare for Microsoft Certification Exams this course will help you build the skills and knowledge you need.

This course teaches the objectives for the following certification tests:
Core Certification: Pass any 1 test:
Word 2013 Core: Exam 77-418
Excel® 2013 Core: Exam 77-420
PowerPoint® 2013: Exam 77-422

What are the requirements?

  • This program can only be taken on a PC. It is not compatible with a Mac. It is compatible with Windows 7 and later operating systems and IE 7 and later browsers. You need a high-speed Internet connection and an e-mail account.
  • You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.

What am I going to get from this course?

  • Learn how to navigate online and submit assignments
  • Format Text and Paragraphs in Microsoft Word
  • Work with Text and Pictures in Microsoft Word
  • Learn how to create and format SmartArt
  • Use Quick parts to create professional documents
  • Create a professional newsletter that includes graphics and charts
  • Create a Mail Merge that sends a personalized invitation to each recipient
  • Create a Web Page that uses a Table for consistent layout
  • Create formulas that use Relative and Absolute values and audit the formulas
  • Use and modify TEXT, DATE and FINANCIAL formulas in Microsoft Excel
  • 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
  • Learn PowerPoint basics: Entering text in presentations
  • Know how to work with Text Boxes, Format Shapes and apply Themes in Microsoft PowerPoint
  • Use Tables and Spreadsheets to display data in a presentation
  • Learn how to add, format and edit Charts with the Chart Tools and Quick Clicks
  • Learn how to design Slide Masters and apply slide Transitions
  • Apply Animations to images in a slide show and edit the timing
  • Add videos to a PowerPoint presentation and trim the media
  • Add videos to a PowerPoint presentation and trim the media

What is the target audience?

  • This program is for you if you are an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Office skills immediately.
  • 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 be effective at work with Microsoft Office for Word, Excel and PowerPoint this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBooks (PDF) with detailed instructions
  • Sample presentations and images
  • Practice, Quizzes and Skill Tests

All materials for this program are available online.

The following resources are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Word 2013
  • Intermediate Guide to Microsoft Word 2013
  • Advanced Guide to Microsoft Word 2013
  • Beginning Guide to Microsoft® Excel 2013
  • Intermediate Guide to Microsoft Excel 2013
  • Advanced Guide to Microsoft Excel 2013
  • Beginning Guide to Microsoft® PowerPoint 2013
  • Advanced Guide to Microsoft® PowerPoint 201

Look for these samples files in the Resources:

  • Microsoft Word 2013 Beginning Sample files
  • Microsoft Word 2013 Intermediate Sample files
  • Microsoft Word 2013 Advanced Sample files
  • Microsoft Excel 2013 Beginning Sample files
  • Microsoft Excel 2013 Intermediate Sample files
  • Microsoft Excel 2013 Advanced Sample files
  • Microsoft PowerPoint 2013 Beginning Sample files
  • Microsoft PowerPoint 2013 Advanced Sample files
  • Microsoft PowerPoint 2013 Beginning Sample files
  • Microsoft PowerPoint 2013 Advanced Sample files
06:48
Project: A sample document introduces the Home Ribbon in Microsoft Word


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: Hello, Microsoft Word!
08:45
Project: A sample document that introduces working with pictures and the Picture Tools

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.

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.

09:21
Project: A marketing flyer using Shapes, Quick Styles, Picture Tools and SmartArt.

Beginning Word Objectives

In this lesson, you will learn how to:
1. Insert a Shape
2. Apply Styles, Quick Styles and formatting to a Shape
3. Resize Shapes.
4. Add Text to and modify text in a Shape.
5. Insert SmartArt.
6. Add text to and modify text in SmartArt.
7. Access the SmartArt Tools Ribbon.
8. Format SmartArt shapes, layout, and colors.

09:55
Project: A newsletter formatted with two columns. The graphics include a satellite photo and a chart designed in Excel

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Enter, select and format headlines
2. Locate and insert a document
3. Identify the Show/Hide option and what it reveals
4. Use the Page Layout Ribbon to format two columns
5. Review how to insert and format Pictures
6. Use the Picture Tools to create a Watermark
7. Use the Page Layout Ribbon to add a Page Border
8. Investigate Paste Special options on the Home Ribbon
9. Update a Chart in Word

Section 3: Microsoft Word: Creating Business Documents
11:53
Project: A lesson in working with lists, tables and numbering

Advanced Word Objectives

In this lesson, you will learn how to:

1. Identify and adjust TAB stops.

2. Convert Text to Table, Table to Text, and Text to List.

3. Add, delete and move rows and columns in a Table.

4. Merge or split Cells in a Table.

5. Format Table and Cell properties.

6. Format bullets and numbered lists

11:31
Project: Create a calendar from a Quick Table and format it with the Table Tools for Layout and Design.

Advanced Word Objectives

In this lesson you will learn how to:

1. Insert a Quick Table.

2. Format table and cell size.

3. Format text direction in a table cell.

4. Apply Quick Styles to a table.

5. Format Table Borders.

6. Use Draw Table command.

11:55
Project: A custom FAX template and a Resume

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

14:54
Project: Create a web page using a table to organize layout

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Create and format a Table

2. Save a document as a web page

3. Create hyperlinks

4. Modify borders and shading options on a Table

5. Create bookmarks and navigate a document

6. Locate and use Advanced Layout options

7. View HTML Code Source

Section 4: Microsoft Word: Advanced Business Topics
11:40

Project: Several mail merge documents to publicize your business including letters, envelopes, labels and custom notes.

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Identify the parts of a Mail Merge
2. Start a Mail Merge
3. Use the Mailing Ribbon to create a new data source
4. Locate and add Mail Merge fields to a document

05:15

Project: Several mail merge documents to publicize your business including letters, envelopes, labels and custom notes.

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Identify the parts of a Mail Merge
2. Start a Mail Merge
3. Use the Mailing Ribbon to create a new data source
4. Locate and add Mail Merge fields to a document
5. Identify Mail Merge options for Envelopes and Labels
6. Create custom watermarks

10:41
Project: Create a Mail Merge and troubleshoot Mail Merge errors

Intermediate Word Objectives

In this lesson, you will learn how to:

1. Edit a new Recipient List for a Mail Merge

2. Insert a Table into a document

3. Identify and Access Table Tools Ribbon

4. Add rows and columns to a Table

5. Use the Mail Merge Wizard

6. Trouble shoot Mail Merge Errors

09:14

Projects: 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.

13:35
Project: Use the tools on the Review Ribbon to prepare a document for publication:

Advanced Word Objectives

In this lesson you will learn how to:

1. Use Proofing Tools.

2. Explore the Review Ribbon.

3. Use Track Changes.

4. Insert and remove Comments.

Section 5: Microsoft Excel: Hello, Excel!
05:58

Project: A sample spreadsheet that introduces the Home Ribbon

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.


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

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.

Section 6: Microsoft Excel: Business Spreadsheets
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 data

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 information.

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Practice modifying cell contents and formats.

2. Modify and format DATES with formulas.

07:28
Project: Use FINANCIAL 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.

08:51
Project: A sample project that investigates the options for Page Layout and Printing.

Intermediate 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.

Section 7: Microsoft Excel: Advanced Business Spreadsheets
09:48
Project: A spreadsheet that works with Tables in Excel.

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 Subtotals

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.

10:47
Project: A spreadsheet that uses Defined Names in formulas to conditionally summarize data.

Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Select and Name a RANGE of Cells.

2. Use the Named Range in a formula.

3. Use the Name Manager.

4. Use Defined Names in a formula.

5. Create Conditional Formulas.

6. Identify errors.

12:36
Project: Use Named Ranges to create Lookup tables. Use a formula to lookup the best answer.


Intermediate Excel Objectives

In this lesson, you will learn how to:

1. Create a Lookup Table.

2. Name the Lookup Table.

3. Use a VLookup Table in a Formula.

4. Use an HLookup Table in a Formula.

5. Use Logical Functions: IF, AND, OR, NOT.

10:13
Project: The lessons will show how to protect and share a spreadsheet or a workbook.

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.

3. Apply protection and sharing to spreadsheets and to workbooks prior to sharing your work.

Section 8: Microsoft PowerPoint: Hello, PowerPoint!
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.

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.

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

08:40
Project: A presentation that uses SmartArt to add interactive graphics

Beginning PowerPoint Objectives

In this lesson, you will learn how to:

1. Control the AutoCorrect options for a Placeholder, such as a Text Box.

2. Use the Design Ribbon to Promote and Demote bullet levels in a SmartArt graphic.

3. Identify and use the SmartArt Tools to edit a SmartArt graphic.

4. Change the SmartArt: Add more Shapes, Reorder the Shapes, and change the Layout.

5. Convert the SmartArt to Text or Shapes

Section 9: Microsoft PowerPoint: Business Presentations
10:54
Project: A sample presentation that includes a table and an Excel Chart

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Table Tools Ribbon to construct and modify Tables.

2. Modify the Rows & Columns in a Table with Borders, Shading and Effects.

3. Merge and Split Cells and modify the Cell Size.

4. Distribute and Arrange Rows, Columns and Tables.

5. Insert a Microsoft Excel spreadsheet into a PowerPoint presentation and edit the data.

12:21
Project: A simple presentation that includes Charts and introduces the Chart Tools.

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Insert and modify Charts in PowerPoint.

2. Use the Chart Elements to format the Chart Title, Axis Title and Data Table.

3. Format the Axes and the Gridlines.

4. Use the Chart Tools to change the Chart Type, edit the Chart data, and apply Chart Styles.

5. Use the Format Ribbon to Resize a Chart and edit the Position on the slide.

14:21
Project: An animated presentation that includes Slide Masters and Slide Transitions

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Create a Master Slide.

2. Use the Drawing Tools to create, resize, and position graphics on a Master Slide.

3. Apply Styles, Borders and Effects to a graphic.

4. Add Transitions to a Slide Show.

5. Modify the Transitions with Sound and Timing.

09:17
Project: A slide show that uses Animation and Custom Animation.

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Animations Ribbon to create an Entrance and and Exit.

2. Edit the Animation Effect and change the direction of the animation.

3. Change the timing and start options.

4. Create a Motion Path!

Section 10: Microsoft PowerPoint: Advanced Business Presentations
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.

10:24
Project: This lesson demonstrates how to show a PowerPoint presentation

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Presentation Tools to add pen and highlighter annotations.

2. Set up a Slide Show, play narrations and show the Media Controls.

3. Rehearse, adjust and use timings in a slide show.

4. Record a Slide Show

12:02
Project: Practice the Review options with a sample presentation.

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Use the Proofing tools on the Review Ribbon: Spelling, Research and Thesaurus.

2. Insert, Edit and Delete Comments.

3. Use Show Markup to make the Comments visible or hidden.

4. Compare two presentations and accept or reject the differences.

5. Protect a presentation with a password and mark your work as final.

10:05
Project: A new presentation to practice the print settings and review the Save As options

Advanced PowerPoint Objectives

In this lesson, you will learn how to:

1. Create Handouts, Outlines, Speaker Notes and adjust the Print Settings in the Backstage View.

2. Save a presentation in different file formats, including an OpenDocument Presentation (odp).

3. Save a presentation as an Adobe Acrobat PDF file or a Microsoft XPS file.

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