Advanced Microsoft Excel

Date: Thursday, October 14, 2010
Time: 01:00 PM ET / 12:00 PM CT / 11:00 AM MT / 10:00 AM PT [Prevailing Time]
Presenter(s): Debbie Madden, Corporate Trainer at Berry Dunn McNeil and Parker
Objective(s):
Debbie shares updates, tricks and tips for Excel users.
Field of Study: Specialized Knowledge and Application
Program Level: Advanced
CPE Credit: 1 Credit Hour
Delivery Method: Group Internet-based

No advanced preparation or prerequisites are required for this course.

Course Description

Discover some Excel® tricks and shortcuts that will make you instantly more proficient and productive.
Most Excel® users are under-utilizing this software. Learn cool Excel® 2007 tips and tricks that will
make you the 'go-to' person in your office! By learning these various tips, you will become more
efficient - hopefully saving you hours every week.

Agenda:
Secure your documents
Do QuickMath without functions
2007 new functions: CountIF, SumIF, AverageIF
Sheet Perfect

Plus a number of other tips that will make your Excel® experience easier.

Presenter and Moderator Bios
Debbie Madden is a Corporate Trainer at Berry Dunn McNeil and Parker. She is responsible for coordinating the training of all the CPA’s and administrative staff in the firm. In her role she is responsible for tracking all CPE credits, creating necessary classes, teaching classes, as well as finding the training necessary for all staff members. Working in the IT department, most of the training is of a technical nature but it also spans to cover Human Resource needs. She is the ‘go to’ person when it comes to MS Office products and is challenged daily with the questions from staff.

Debbie came into the training role while at Anthem Blue Cross and Blue Shield. She started as a computer programmer and the role transformed after 20 years of working with the programming staff and determining that it’s all in the training. She became a full time trainer in 1998 and has enjoyed dedicating her days to teaching adults ever since.

In 2004, Debbie left her corporate job to work in retail, running her own store. She rejoined the training arena in 2008 and has found a great fit with Berry Dunn McNeil and Parker. She is able to use her experience as a business owner and trainer to determine the needs of the staff.

When she is not working, Debbie enjoys spending time with her four children, playing taxi driver and attending the various sporting events her children are involved in.

Cost
$25.00 for CPAFMA Members / $40.00 for Non-Members / Free for PAFMs

Delivery System

  • All programs are delivered using the Zoom platform.
  • Confirmations will include log-in instructions.
  • Participants are able to participate using any device with an Internet connect (if the device does not have speakers, the participant can also dial-in) or they can participate with audio only by dialing in.
  • All registrants will receive a link to the MAPCast’s recording by email within 48 business hours of event’s conclusion.
  • There will be assistance available to help with technical and connectivity issues up to 10 minutes prior to the start of the presentation.

Registration

All registration is done on-line with the names and email addresses of each individual guest. Log-in details will be emailed to all registrants approximately 1-2 days prior to each session.

Refund Policy

CPAFMA will not issue refunds for MAPCasts. If a registrant is unable to participate in the MAPCast and sends written notice to info@cpafma.org 48 hours prior to the session, a credit will be provided for a future MAPCast. Alert the CPAFMA staff member monitoring the MAPCast if technical difficulties are encountered and technical support will be provided to eliminate problems with future MAPCasts.

Additional Information

Live participation is required for CPE credit and polling questions must be answered to show active participation. All registrants will receive an email following the session with links to the slides and/or handouts, and a link to the MAPCast recording (unless otherwise stated). If you are unable to participate in the live session, you can still watch the recorded session, but you will not be eligible for CPE credits.

For more information regarding CPAFMA MAPCasts or administrative policies such as complaint and refund, contact the CPAFMA Headquarters at 937-222-0030, or info@cpafma.org.

What is an CPAFMA MAPCast?
An CPAFMA MAPCast is a live, interactive 30 or 60-minute conference presented over the Internet. You can attend from any location that has Internet access from any device. You pay just one registration fee for as many participants as you wish at each location.

Note that high-speed Internet access is not mandatory.

Who presents at an CPAFMA MAPCast?
Your MAPCast will have one or more speakers who are recognized experts on the topic. MAPCasts typically include a Q&A session; you can ask questions by audio or chat options.

CPE Credits
CPAFMA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

MAPCasts with an HR focus have been approved for recertification credit hours toward PHR and SPHR recertification through the Human Resources Certification Institute (HRCI). For more information about certification or recertification, please visit the HRCI homepage at www.hrci.org. 

MAPCasts qualify for Public Accounting Firm Manager (PAFM) continuing education credit through the CPA Firm Management Association (CPAFMA). For more information about certification or recertification, please visit the PAFM section of this website.

Why CPAFMA MAPCasts?

Fast.
No wasted time. Get right to the heart of the matter in a 30 or 60-minute session designed to easily fit into your busy schedule.

Convenient.
No airlines. No travel. No time out of the office. Listen and follow along from the comfort and convenience of your own device or conference room.

Easy.
A device with an Internet connection is all you need. If your device does not have sound capabilities, the ability to dial in from a telephone is available.

Ideal for multiple attendees.
Use a speakerphone and projector/monitor and invite as many people as you want to participate - at no extra cost to you.

Affordable.
CPAFMA MAPCasts are a fraction of the cost of travel and attendance fees for other high-priced conferences or seminars. PAFMs attend for free. PCPS members are able to register at the CPAFMA member rate.

CPAFMA has partnered with the AICPA PCPS to offer PCPS members the same member rate for MAPCasts. PCPS members should indicate their membership when registering.