Community Search
CPB Certification   |   Annual Conference   |   Print Page   |   Contact Us   |   Sign In   |   Join IPBC
Online Store: IPBC Products and Services
Main Storefront

Microsoft Excel 2010 Webcast - Lesson 5 Functions and Formulas Part 3

Item Options
Sign in for your pricing!
Price: $45.00
Quantity: *
Microsoft Excel 2010 Webcast
Lesson 5 - Functions and Formulas Part 3

Who hasn't had to deal with payment plans?! Ever head of the terms "future value", "payment amount", and similar? In this lesson, learn how to apply the following functions: NPV, PMT, NPER, FV. Did you know that you can calculate the number of days between two dates? Find out how during this session. And last but not lease, have you ever been faced with text that needs to be "cleaned up" first before you can manipulate that data? This is your chance to find out how to apply text functions such as LEFT, RIGHT, PROPER, and TRIM, instead of manually retyping or using the "cut and copy".

Purchase Instructions

When you purchase this product, you will receive a receipt confirming your purchase. IPBC staff will be notified of your purchase and send you a follow-up email containing:

  • You will receive a complimentary recording of the lesson for your own personal use. It may not be sold or used for commercial purposes. The session is 60 minutes of instruction followed by up to 30 minutes of  Q&A.
  • You will receive homework to help reinforce each lesson.
  • You will receive written responses to the Q&A asked during the session.

Please contact IPBC staff if you have not received this email within one business day of your purchase.

Our Speaker

At age 28 Michaela came to Canada from Germany.Her career in Germany revolved around teaching on various topics.Since coming to Canada she spent 12 years in B.C. and 10 years in Manitoba working in the bookkeeping/accounting field.Her experience covers industries such as federal government, manufacturing, services, food & beverage, wholesale, and technology.

Over the years Michaela has trained many individuals and groups not only on job specific task but on software and how to get the most out of them.She held presentations on charities close to her heart and presentations on financial topics to educate non-accounting departments on how important the "bean counters” are to and for them.

Michaela retired as the director of finance with a Winnipeg based technology & software developer in December 2009.Shortly thereafter Michaela and her husband moved to Brandon, MB as their chosen retirement residence for the summer and setting up a puppy friendly home in Arizona for the winter.Full time retirement however, proved to be a challenge – if you ask Michaela why, then she will most likely just tell you that it was too boring.In June 2010 Michaela joined the IPBC and within weeks obtained her CPB certification.

Today Michaela is the sole proprietor of MD Accounting Resources.An opportunity presented itself to start teaching again and this time with topics specific to bookkeeping.Michaela quickly found her niche as she rediscovered her love for teaching.Michaela is actively teaching Simply Accounting courses in-class as well as online and is proud to add Microsoft Excel to her lineup of courses.





Value Pricing

Contact Us

Mission Statement


CPB Certification


Black Swan Project


Board of Directors

Regional Meetings

Member Offers

Who Should Join

Black Swan Blogs 

Membership Inquiries

Code of Conduct

Annual Conference



Black Swan Alumni

General Inquiries


 Award Ceremonies

Member Links


CPB Certification

Resource Links

Code of Ethics Complaints

6 - 6150 Highway 7,- Suite 418, - Woodbridge, ON - L4H 0R6  1-866-616-4722   |