The Advanced Guide to Microsoft Excel 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 Advanced Guide to Microsoft Excel 2013 to your Wishlist.

Add to Wishlist

The Advanced 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.
1 student enrolled
Created by Elizabeth Nofs
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Sort, Filter and Subtotal Data
  • Create and modify PivotTables
  • Analyze data visually with a PivotChart
  • Filter the data in the PivotChart
  • Create a Form using Data Validation
  • Prepare to share Excel spreadsheets
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 Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word.
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 332 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. Upon completion, you'll be prepared to earn your certification and gain an important edge in today's competitive job market.

In Microsoft Excel, you'll cover basic through advanced topics, including:

  • How to enter data and format cells and apply number formats
  • Practice how to create formulas and audit the cell references
  • Learn how to represent data as Charts
  • Use PivotTables and Pivot Charts to analyze data
  • Use Data Validation to create interactive forms that prompt users for the right data

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.

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

Who is the target audience?
  • 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.
  • This program is for you if you are 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 are looking to learn about this software and expand your job possibilities.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Getting Started
1 Lecture 02:44
+
Tables and Lists: Working with Tables
1 Lecture 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.

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.

Tables and Lists: It Works for Me
09:48
+
Tables and Lists: Sort, Filter and Subtotal
1 Lecture 06:55

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


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.

4. Use the Scenario Manage to define Best, Worst and Expected results by changing one or more cells.

Preview 06:55
+
Analyzing Data Visually
1 Lecture 09:15

Project: A spreadsheet that works with PivotTables in Excel. This lesson shows how to present data visually, format data as a PivotTable and display the Totals.


In this lesson, you will learn how to:

1. Identify the steps needed to create a PivotTable.

2. Use Row Labels to filter the data.

3. Use the Field Settings to Count Values.

4. Pivot the Table!

5. Format the PivotTable and Pivot Table Reports.

Preview 09:15
+
Analyzing Data Visually: PivotCharts
1 Lecture 08:17

Project: A spreadsheet that uses PivotCharts to present the data in an interactive format.


In this lesson, you will learn how to:

1. Analyze data visually with a PivotChart.

2. Create a PivotChart and Show the Field List.

3. Edit the Value Field Settings.

4. Filter the data in the PivotChart.

5. Edit the Chart Layouts.

6. Apply a Chart Style.

7. Use Slicers


PivotCharts: What Did You See?
08:17
+
Sharing and Collaboration
1 Lecture 10:27

Project: This lesson shows how to create and modify forms, enter data with Combo Boxes and form controls, ensure data integrity using data validation.


In this lesson, you will learn how to:

1. Enter data and fill a series.

2. Enter data in a reference list.

3. Create a drop-down list.

4. Identify options for Data Integrity and Validation.

5. Install the Developer's Ribbon.

6. Create a Control with VBA (Visual Basic for Applications.)

Preview 10:27
+
Prepare to Share
2 Lectures 10:38

Project: This lesson shows how to prepare a file for sharing including: proofing, comments, and tracking changes. The lessons will show how to protect and share a spreadsheet or a workbook.


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.


Prepare to Share
10:13

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,035 Reviews
16,128 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