Ibgwpajstuoon4vzdwln

Complete Excel 2013

Microsoft Certification Exam 77-420, 77-427 Part 1 and 77-428 Part 2 Expert: Excel 2013

   Watch Promo

Original Price Excel Beginning, Intermediate and Advanced: $600.
SAVE $200 when you buy these courses together.

Save another $100 with the Coupon!


"Excellent! Interactive and Easy to Follow."
(UDEMY)

The Complete Guide to Microsoft Excel 2013

Another Computer Mama Guide: www.thecomputermama.com

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 eBooks (PDF) with detailed instructions
  • Sample presentations and images
  • Practice, Quizzes and Skill Test

All materials for this program are available online.

The following resources are available to download throughout the lessons:

  • Beginning, Intermediate and Advanced Guides to Microsoft® Excel 2013 (PDF)
  • Microsoft Excel 2013 Beginning, Intermediate and Advanced Sample files

In Microsoft Excel Beginning, 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 pictures and graphics

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

  • 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

In Microsoft Excel Advanced, you’ll learn how to:

  • Analyze data visually with a PivotChart.
  • Create a PivotChart and Show the Field List.
  • Edit the Value Field Settings.
  • Filter the data in the PivotChart.
  • Edit the Chart Layouts and Chart Style.
  • Use Slicers

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


Your Instructor


Elizabeth Nofs
Elizabeth Nofs
Elizabeth Ann Nofs, The Computer Mama, developed the teaching methodology in the Complete Computer Guide series using breakthrough research in gender balanced training. Elizabeth has taught several thousand men and women from government, manufacturing, small business, and education in both online and hands-on classrooms. She is the author of more than 60 Microsoft Office Computer Guides as well as a Microsoft Certified Office Specialist.

Elizabeth earned a BA in Biology from the University of Michigan.

www.thecomputermama.com


Courses Included with Purchase



Beginning Excel 2013
Microsoft Certification Exam 77-420: Excel 2013
Elizabeth Nofs
$200
Intermediate Excel 2013
Microsoft Certification Exam 77-420: Excel 2013
Elizabeth Nofs
$200
Advanced Excel 2013
Microsoft Certification Exam 77-427 Part 1 and 77-428 Part 2: Excel 2013 Expert
Elizabeth Nofs
$200

Original Price: $600


Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Get started now!



Original Price Excel Beginning, Intermediate and Advanced: $600.

SAVE $200 when you buy these courses together.

Save another $100 with the Coupon!