Top Ten Tools in Microsoft Excel

Master the Options in Excel: TEXT, DATE, FINANCIAL, LOOKUP Table, CHARTS and Business Tools

   Watch Promo

Top Ten Tools in Microsoft Excel

Another Computer Mama Guide:

  • Step-by-step video demonstrations
  • Companion eBooks with detailed instructions
  • Sample spreadsheet and examples
  • Practice, Quizzes and Skill Test

The TOP TEN TOOLS in Microsoft Excel are:

  • Combine TEXT from different cells (CONCATENANTE)
  • Find the DATE: Month, Day, Year
  • Calculate the payment (FINANCIAL)
  • BONUS: Find the best payment with SCENARIOS
  • LOOKUP the information in a table
  • BONUS: LOOKUP the student records!
  • Visualize the data as a CHART

And the NUMBER ONE OPTION in Microsoft Excel...
Create an Interactive FORM with the Developer Tools!

If you wish to prepare for the Microsoft Certification Exams for Excel
Exam 77-420: Microsoft Office Excel 2013 OR Exam 77-427 Part 1 and 77-428 Part 2: Microsoft Excel 2013 Expert, our course will help you build the skills and knowledge you need.

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.

Course Curriculum

  Visualize the Data
Available in days
days after you enroll
  Business Spreadsheets
Available in days
days after you enroll
  Tables and Lists
Available in days
days after you enroll
  Form Design
Available in days
days after you enroll

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!