Using Excel for Corporate Accounting

Course Overview
The course provides the foundation for financial professionals who use Excel in their day-to-day activities. This course provides opportunities for you to learn how to create a basic worksheet, identify its parts, and how to use basic functions to create accounting formulas. This course also provides best practices when creating and working with spreadsheets specifically for financial professionals.

Learning Objectives:

Upon successful completion of this segment, you should be able to:

  • Recognize the design and key elements of basic financial spreadsheets
  • Identify and locate key spreadsheet components
  • Recognize how to create and use basic formatting functions in spreadsheets
  • Identify methods to secure spreadsheets
  • Differentiate between common Excel functions and formulas

Content Partner:

SmartPros Ltd.

SmartPros Ltd. is a leader in online and offline continuing education for
accounting, finance and engineering professionals. With over 2,000 hours of
content, SmartPros has been providing mandatory continuing education
products since 1981. SmartPros provides services and content to its
professional and corporate clients, in a variety of media including Web, CD
ROM, and video. In the accounting market, SmartPros also has a predominant
news and information portal which receives 200,000+ visits per month and
provides services to over 100,000 subscribers. SmartPros' customers include
50% of the Fortune 500, as well as the major firms and associations in each
of its professional markets.

Prerequisites/Advanced Preparation:


Speaker / Author:

Shahara M. Ruth, M.Ed. is currently the Lead Instructional Specialist at Cybervista/Kaplan IT Training. Her past experience includes over 20 years of corporate and nonprofit IT training. She also worked as a public-school educator for 10 years. Shahara earned her Bachelor's degree in Communication from Oglethorpe University and a Master's degree with a concentration in Instructional Technology from Troy University. She is also an accomplished writer and documentary filmmaker.

Software & Hardware Requirements:

  • 56k or Greater Internet Connection
  • Adobe Acrobat® Reader for the .pdf files
  • Modern DHTML Compatible Browser
  • Ram: 256 MB minimum
  • Sound card with speakers/headphones
  • Windows or Mac OS


Price (USD)

Standard Rate: $49.90


Course Code : 99RUT02

Release Date : 06/10/2019
Expire Date : 06/10/2021
Credits :
CPE 2.00
QAS 2.00

Course Level : Basic
Course Type : Self-Study
Length : 1hr 40min
Passing Grade : 70%
Field Of Study : Computer Software & Application
Theme : Miscellaneous

Format Type : eLearning
Mobile Compatible

Included In

Returning Subscribers

- OR -