Excel - Improve Your Proficiency
Total Credits: 1 including 1 Computer Software & Applications - Non-technical
- Average Rating:
- 161
- Categories:
- Technology
- Faculty:
- Jennifer Johnson, CPA
- Course Levels:
- Basic
- Duration:
- 1 Hour
- License:
- Access for 90 day(s) after purchase.
Tags: Dallas Chapter TXCPA Produced
Description
Join Jennifer Johnson, a CPA and professor at UTD as she takes you through some very functional tips and tricks in Excel. The items she covers range from solving common formatting issues to sorting items when the common alphabetical and numeric ordering solutions just don't work for what you need and lots of things in between. If you use Excel regularly, you won't want to miss this course!
LEARNING OBJECTIVES:
- Hiding gridlines
- Comma format without decimals
- Sorting with custom lists
- Grouping sheets
- Skipping blanks
- Conditional formatting with icon sets
- Getting rid of that pesky DIV/0! error
- Using data validation
- Hyperlinks
PREREQUISITES: It is helpful to have access to Excel and a basic knowledge of using its features.
Course Materials
| Excel - Improve Your Proficiency Handout (993.6 KB) | Available after Purchase | ||
Faculty
Jennifer Johnson, CPA Related Seminars and Products
Sr. Lecturer II
University of Texas at Dallas
Jennifer Johnson is a CPA licensed in the state of Texas and is currently an Associate Professor of Instruction at the University of Texas at Dallas where she teaches accounting information systems courses and related software courses, cost accounting and seminars in Excel and QuickBooks. In 2017 she was named as an Outstanding Accounting Educator by the TXCPA and is a co-author of Computerized Accounting with QuickBooks Online. Prior to joining the University of Texas at Dallas in 2009, Jennifer spent time in both public accounting and industry as an auditor with PwC, an Assistant Controller at regional financial services firm and a Finance Manager at Dr Pepper Snapple Group. Jennifer holds both a BBA and MS in Accounting from Texas A&M University. Jennifer is a Certified QuickBooks User and is actively volunteers for the TXCPA and TXCPA-Dallas. Jennifer has a passion for using systems and accounting to communicate the language of business.
Reviews
| 5 |
|
| 4 |
|
| 3 |
|
| 2 |
|
| 1 |
|