Excel Power User Module 1: Fundamental Features | EPU1OD19

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.

This is part 1 of a 10 part series
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 S Lenning is a CPA and published author. He has written several articles for the Journal of Accountancy and other publications. He specializes in providing computer consulting services to CPA firms and their clients.