The Beginning Guide to Microsoft Excel 2013
4.5 (172 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.
6,071 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Beginning Guide to Microsoft Excel 2013 to your Wishlist.

Add to Wishlist

The Beginning Guide to Microsoft Excel 2013

Another Computer Mama Guide
4.5 (172 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.
6,071 students enrolled
Created by Elizabeth Nofs
Last updated 6/2017
English
English [Auto-generated]
Price: Free
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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 format pictures in a spreadsheet
  • Use, format and modify Shapes, SmartArt, and Views
  • Insert and modify Charts with the Chart Tools and the new Quick Click options
View Curriculum
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 Excel 2013 already installed.
Description

If you wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with 217 pages of detailed instructions
  • Sample spreadsheets
  • 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 Excel 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 Beginning Microsoft Excel, you will cover important topics, including how to:

  • 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
  • Use, format and modify Shapes, SmartArt, and Views

The Microsoft Excel 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-420: Microsoft Office Excel 2013 OR Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Office Excel 2013 Expert, will find beginning through advanced lessons that demonstrate these required MOS topics.

This course teaches the objectives for the following certification tests:

Core Certification: Pass any 1 test: Excel® 2013 Core: Exam 77-420

Who is the target audience?
  • This program is for you if you’re an office worker, manager, entrepreneur, or other professional who wants to start using advanced Microsoft Excel skills immediately. This program is also suitable for you if you’re looking to learn about this software and expand your job possibilities.
  • To enroll in the Microsoft Excel 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Getting Started
1 Lecture 07:28
Getting Started
07:28
+
Hello, Microsoft Excel!
1 Lecture 05:58

Project: A Sample Spreadsheet that introduces the Home Ribbon


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.

Hello, Excel!
05:58
+
Working with Data: It All Adds Up
1 Lecture 08:49

Project; A sample spreadsheet that calculates the wholesale and retail costs, and the profits.

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
+
Working with Data: A Question of Balance
1 Lecture 10:27

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

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
+
Presenting the Data Visually: Charts and Chart Tools
1 Lecture 08:56

Project: A sample spreadsheet that demonstrates the Chart Tools: Design Layout and Format.

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

Charts and Chart Tools
08:56
+
Presenting the Data Visually: Picture the Data
1 Lecture 07:12

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


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

Picture the Data
07:12
+
Presenting the Data Visually: Shapes, SmartArt Views
2 Lectures 07:21

Project: A practice spreadsheet with SmartArt graphics that you do not have to save.

In this lesson, you will learn how to:

1. Insert and Format Shapes.

2. Add Text to Shapes.
2. Edit the Text Direction.

3. Format Shapes with Quick Styles and Effects.
4. Create linked Text Boxes.
5. Use SmartArt.

6. Format and edit the SmartArt

Shapes, SmartArt and Views
06:56

Thank you for letting me be your guide.

I hope that you learned a few new skills that you can take to work with you.  You done good. Got cookies?

eBeth Elizabeth Nofs, the Computer Mama

THANK YOU COUPON: If you wish to enroll in another Computer Mama course for only $10.00 (SAVE $190.00) please use this code: COOKIES

Keep in Touch: https://thecomputermama.us

If you would like to stay in touch, please join me at my website for:

  • News and Course Announcements
  • Coupons and Freemiums
  • Guides and Mini-courses

New subscribers welcome!

Buy the books at Amazon: https://thecomputermama.us/books-page/

BONUS LECTURE
00:25
About the Instructor
Elizabeth Nofs
4.3 Average rating
1,037 Reviews
16,183 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).

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