Excel Power User Module 1: Fundamental Features | EPU1OD15

Product Code :
Format :
Level :
Designed For :

Accounting professionals who use Excel for Windows.

Field of Interest :
Computer Software And Applications
Prerequisite :


Credits :
2.00 CPE
Description :
The Excel Power User series is designed to help improve your Excel proficiency and enable you to get your Excel tasks done more quickly. In the first session, we'll cover the fundamental features that help build a solid foundation. We'll continue to integrate these features as we proceed throughout the series. Note: This session is presented with Excel for Windows, and items covered may not be available in Excel for Mac. Originally presented February 03, 2015. Note: There is a minimum passing rate of 70% for this course.
Objectives :
• Recall at least three shortcuts to improve your speed.
• Recognize which feature allows you to control what a user can type into a cell.
• Identify the feature that enables you to name cells and ranges.
Major Topics :
  • Selected shortcuts
  • Named references tables
  • Data validation
  • Conditional formatting basics
Advanced Prep :
About the Author :
Lenning Jeff S - Jeff Lenning of Click Consulting, Inc., is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. His firm specializes in providing computer consulting services to CPA firms and their clients. Web site: http://www.clickconsulting.com