Excel Tips & Tricks for the Non-Accountant

Instructor

Dr. Chris
Harper

You don’t need an accounting degree to harness the power of Microsoft Excel. This course shows how Excel makes sense beyond dollars and cents. We will focus on fundamental concepts for creating, editing, and utilizing Excel content. Participants will learn how to use Excel’s menus and other functions to craft Excel workbooks. Because this course is designed for newer users, we intentionally offer a broad overview of Excel’s numerous capabilities with in-depth coverage of selected resources tailored for non-accounting applications.

Learning Objectives

Create an Excel workbook
Enter, import, and utilize data
Locate and utilize resources available within major Excel menus
Edit and format worksheet contents
Utilize selected formulas
Recognize and implement best practices

Major Topics

Understanding the workbook and worksheet environment
Obtaining and utilizing data
Editing and formatting
The “Insert” Menu
The “Page Layout” Menu
The “View” Menu
Selecting and using formulas
Shortcuts and tricks

CPE Credits Available

2 CPE Credits

2: Computer Software & Applications

Things to Know About This Course

Course Level

Basic

Professional Area of Focus

Computer Software & Applications

Advanced Preparation

None

Intended Audience

Designed for non-accounting personnel who have limited experience with Microsoft Excel. Accounting personnel and other experienced Excel users may also benefit from creative ideas and techniques.

Provider

ACPEN