Accounting with Excel 2016 Suite

Master the skills and develop the knowledge you need to increase your financial awareness, while taking your Excel skills to add time-saving functions to your repertoire.

SHARE
96 Course Hrs
Currently Enrolling
Offered in partnership with your preferred school

ed2go

Change School
Learning method

Course code: B9093

Introduction to Microsoft Excel 2016

Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016. By the time you're done, you'll be using Excel like a professional.

Intermediate Microsoft Excel 2016

Take your Excel skills to the next level! In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire. So get ready for six action-packed weeks that will make you an Excel expert!

Accounting Fundamentals

Demand for accounting professionals currently exceeds supply. If you're interested in increasing your financial awareness and accountability while also gaining a marketable skill, this course is for you. You'll learn the basics of double-entry bookkeeping, while also learning how to analyze and record financial transactions, as well as prepare various financial reports at the end of the fiscal period. Accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities will be discussed. We'll cover all the bases, from writing checks to preparing an income statement and closing out accounts at the end of each fiscal period.

Accounting Fundamentals II

While it is true that accounting professionals are scarce, those with corporate accounting experience are even more rare. This course will build on the knowledge you gained in our Accounting Fundamentals course to provide you with a solid understanding of corporate accounting practices. You'll be able to analyze transactions and prepare various corporate financial reports. You'll also gain practical experience working with dividends, plant assets, depreciation, accrued revenue and expenses, retained earnings, stockholders' equity, and more.

Please complete the courses in the bundle two months apart to avoid overlapping. Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

How the course is taught

  • Instructor-led online course
  • 96 course hours
  1. Introduction to Microsoft Excel 2016
    1. Excel Basics
    2. Creating a Worksheet
    3. Time-Savers
    4. Relative, Absolute, Mixed, and Circular References
    5. Three Dimensional Workbooks
    6. Sorting, Subtotaling, and Filtering
    7. Charting Basics
    8. Advanced Charting Techniques
    9. Intro to Excel's Statistical Functions
    10. Financial Functions
    11. Worksheet Automation
    12. Mastering Excel's IF Function
  2. Intermediate Microsoft Excel 2016
    1. Excel Charts and Graphs
    2. More Excel Charts
    3. AutoFilter and Sorting
    4. Goal Seeking
    5. PivotTables
    6. Advanced PivotTables
    7. Solver
    8. Sparklines
    9. Macros
    10. Introduction to Functions
    11. Math/Trig Functions
    12. VLOOKUP, INDEX, and MATCH Functions
  3. Accounting Fundamentals
    1. Account Classifications, Account Titles, T Accounts, and the Accounting Equation
    2. General Ledger Accounts and the Balance Sheet
    3. Journalizing Transactions and Posting to the General Ledger
    4. Journalizing and Posting Cash and Charge Purchases and Payments on Account
    5. Journalizing and Posting Cash and Charge Sales and Cash Received on Account
    6. Payroll and Various Deductions
    7. Banking Services and Reports
    8. Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable
    9. End-Of-Year Worksheet
    10. End-Of-Year Financial Reports
    11. Journalizing and Posting Adjusting Entries
    12. Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance
  4. Accounting Fundamentals II
    1. Accounts Payable
    2. Accounts Receivable
    3. Uncollectible Accounts Receivable
    4. Plant Assets and Depreciation
    5. Notes Payable and Notes Receivable
    6. Accrued Income and Accrued Expenses
    7. Dividends and Starting the Year-End Worksheet
    8. Complete Year-End Worksheet With Adjustments
    9. End-Of-Fiscal-Period Financial Reports
    10. Adjusting and Closing Entries and Post Closing Trial Balance
    11. Preparing a Payroll
    12. Preparing Federal Tax Deposits and Year-End Tax Reports

Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.

Nancy Koenig is an experienced industry professional with over 40 years in the workforce, including decades in finance. Nancy has worked in various finance roles in banking, insurance, and a hospital billing office. For the last 27 years of her career, she was an administrative assistant at a technical school, which involved running and overseeing the entire budget, amongst other duties. Nancy has also held part-time jobs as a bookkeeper for an auto parts store and a cable company, where she used QuickBooks computerized software. Over the past several years, she has also co-taught the Accounting Fundamentals and Accounting Fundamentals II courses with Charlene Messier.

Prerequisites:

There are no prerequisites to take this course.

Requirements:

Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.
  • Microsoft Excel 2016 (not included in enrollment)

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.