Book Cover

Excel for Accounting

Accounting

ISBN:

978-1-952023-79-8

cfwf default

Excel for Accounting

Nick Ball, PhD Gove Allen, PhD

Excel is the everyday tool of the accounting profession, and fluency with it sets accounting graduates apart. Lessons start with the basics and build to the skills accountants use on the job: formulas and functions, charting, financial modeling, what-if analysis, statistics, PivotTables, and Solver optimization. Three final lessons introduce SQL, so students can query and join the large databases behind accounting data. Every lesson includes instructional readings, videos, and practice problems, and each assignment is graded automatically in a hands-on Excel environment with immediate, detailed feedback. Students who pass Exam 1 and Exam 2 instantly earn a MyEducator Certificate of Completion they can share with employers.

  • Free instructor demo access to full resource
  • Plug-and-play solution for instant adoption
  • Lifetime access for students

Course Objective

This Excel training course for accountants covers basic to advanced topics, including business modeling and PivotTables, with lessons featuring readings, videos, practice problems, and automated grading for immediate feedback.

Table of Contents

Introduction: Introduction and Device Setup Lesson 1: Excel Basics Lesson 2: Formulas and Functions Lesson 3: Logic and Reference Functions Lesson 4: Date, Time, and Text Functions Lesson 5: Charting Lesson 6: Modeling Basics Lesson 7: Advanced Modeling Lesson 8: Statistics Lesson 9: Analyzing Data with PivotTables Lesson 10: Optimization Analysis Appendix A: Shortcuts

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

(students: reach out to your instructor for assistance with accessing your textbook, or view this walkthrough.)

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

cfwf default

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

cfwf default

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

cfwf default

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

cfwf default

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

cfwf default

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.

Related Courses

Catalog
What is MyEducator?
How much does MyEducator cost?
How long do students have access, and what about updates?
Are resources customizable?
How long is setup—what is the adoption process?
What LMS do you integrate with?
Do you provide sample syllabi, guides, and other instructor materials?

Ready to get started?