The Intermediate Guide to Microsoft Excel 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.
2 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 10
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • 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 7/2015 English

Course Description

If you 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, this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with 245 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 Immediate Microsoft Excel, you will cover important topics, including how to:

  • 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
  • Excel Online: Use and modify Sparklines and hyperlinks
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

Expert Certification: Pass either test: Excel 2013 Expert Part 1: Exam 77-427 Excel 2013 Expert Part 2: Exam 77-428

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 Excel 2013 already installed.

What am I going to get from this course?

  • • 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
  • • Excel Online: Use and modify Sparklines

What 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 intermediate 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.

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
Getting Started
Preview
02:44
Section 2: Business Spreadsheets
14:08

Project: A spreadsheet that calculates the daily sales for three products and adds up the total on a summary spreadsheet.

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.

Section 3: Business Spreadsheets: This Little Piggy Goes to Market
06:28

Project: A spreadsheet that uses TEXT formulas to modify data.

In this Lesson You Will How To:

1. CONCATENATE (combine) data with a formula.

2. Modify and format TEXT with formulas

07:51

Project: A spreadsheet that uses DATE and TIME formulas to modify data

In this Lesson You Will How To:

1. Calculate the MONTH

2. Calculate the NETWORKDAYS with a formula

3. Use a formula to calculate the difference between the Start and End time

07:28

Project: Calculate a car payment

In this lesson you will:

1. Work with the FINANCIAL Formula: PMT

2. Use the Data Tools-Goal Seek and Scenarios- to calculate the Best Case and Worst Case Scenarios.

Section 4: Formulas and Data: Using Named Ranges
10:47

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

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

Section 5: Formulas and Data: Using Lookup Tables
12:36

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

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

04:00

Project: A Workbook that has Lookup Tables for Grades and Homeroom Teachers.

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.

Section 6: Excel and the Internet Excel in Print
08:51

Project: Format a spreadsheet so that it is as interesting and informative as a web page.

In this lesson, you will learn how to:

1. Use the Sparkline Tools to display Line, Column and Win/Loss Sparklines.

2. Format the Sparkline Line Style, Color and Markers.

3. Format the Sparkline Axis.

04:07

Project: Format a spreadsheet so that it is as interesting and informative as a web page.

In this lesson, you will learn how to:

1. Use the Sparkline Tools to display Line, Column and Win/Loss Sparklines.

2. Format the Sparkline Line Style, Color and Markers.

3. Format the Sparkline Axis.

4. Use hyperlinks in a spreadsheet to link to other data in your workbook or online .

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