Course: Excel Tools and Tips for CPAs - Video
Author: Patricia McCarthy, MBA,MOS 

 Student Comments:
" I took the course, and love the F12 (Save as), the Control+1 (formatting) and the workbook Pin tips!" K.K. Indiana

"I really liked [the course].  The best thing about it was that it is a video so if you miss something you can back it up and listen to it right then.  I have taken other excel classes as webinars and if you miss something you can't go back and hear it again.  I also liked the fact that you had printouts to follow along with and make notes on so it will make sense if I have to go back and look at it.  This had useful tips even for someone that uses excel everyday and thinks they have a good grasp on it." L.H., VA 

Course ID:EXMCTTAV

CPE Hours: 1

Video Run Time: 50 minutes

Format: Video

Price:  $8.00

Course Description: This video walks you through and demonstrates some useful tips that will improve your productivity including:

• Useful keystroke shortcuts
• How to efficiently select data
• Some advanced copy techniques
• How to navigate through and within sheets
• How to use the Watch window
• How to "pin" files you use all the time
• How to Remove Duplicates

This video course is still considered self-study since there is no instructor so you still need to take the exam to receive your certificate.   

Delivery: Internet/Interactive Self Study

NASBA Category: Computer Science/Specialized Knowledge

Level: Overview

Prerequisites: This course is designed for users of Excel 2007/Excel 2010
however, Excel 2003 users will find it useful and pertinent.
Remove Duplicates and Name Managers  are features not included
in Excel 2003. 

Learning Objectives:

• Learn some shortcuts that will improve your speed and productivity
• Learn some useful keystrokes to bypass menus
• Learn how to efficiently select and format data
• Overview some advanced ways to copy and group sheets
• Learn how to navigate quickly through sheets and how to "pin" a file that you use frequently for easy access
  
  

.