Details
Learning Excel is an important first step toward an accounting career. As the most widely-used spreadsheet software, Microsoft Excel is used by accountants to analyze data, create reports, and prepare forecasts. This online accounting course suite will teach you fundamental accounting skills, while training you to use Microsoft Excel 2019.
Introduction to Microsoft Excel 2019:
Become proficient in using Microsoft Excel 2019 (now available through Office 365) and discover how to create worksheets, workbooks, charts, and graphs quickly and efficiently.
Intermediate Microsoft Excel 2019:
Take your Microsoft Excel 2019 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.
Accounting Fundamentals:
Gain a marketable new skill by learning the basics of double-entry bookkeeping, financial reporting, and more.
Accounting Fundamentals II:
Learn the high demand accounting skills needed at small-to-medium sized businesses.
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.
|
Enrollment Options:
Instructor-Led
6 Weeks Access Course Code: B9579
Start Dates* Nov 13 | Dec 18 | Jan 10 | Feb 07
*Choose start date in cart
$495.00
USD
Self-Paced
3 Months Access Course Code:
No Instructor, Start Anytime
$495.00
USD
Enroll before 31th May and get high quality lamination on your hardcopy certificate absolutely free! Use your certificate to your advantage by showing your certified credentials to prospective employers and recruiters.
|
Syllabus
- Accounting Fundamentals
- Account Classifications, Account Titles, T Accounts, and the Accounting Equation
- General Ledger Accounts and the Balance Sheet
- Journalizing Transactions and Posting to the General Ledger
- Journalizing and Posting Cash and Charge Purchases and Payments on Account
- Journalizing and Posting Cash and Charge Sales and Cash Received on Account
- Payroll and Various Deductions
- Banking Services and Reports
- Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable
- End-Of-Year Worksheet
- End-Of-Year Financial Reports
- Journalizing and Posting Adjusting Entries
- Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance
- Accounting Fundamentals II
- Accounts Payable
- Accounts Receivable
- Uncollectible Accounts Receivable
- Plant Assets and Depreciation
- Notes Payable and Notes Receivable
- Accrued Income and Accrued Expenses
- Dividends and Starting the Year-End Worksheet
- Complete Year-End Worksheet With Adjustments
- End-Of-Fiscal-Period Financial Reports
- Adjusting and Closing Entries and Post Closing Trial Balance
- Preparing a Payroll
- Preparing Federal Tax Deposits and Year-End Tax Reports
- Intermediate Microsoft Excel 2019
- Excel Charts and Graphs
- More Excel Charts
- AutoFilter and Sorting
- Goal Seeking
- Pivot Tables
- Advanced PivotTables
- Solver
- Sparklines
- Macros
- Introduction to Functions
- Math/Trig Functions
- VLOOKUP, INDEX, and MATCH Functions
- Introduction to Microsoft Excel 2019
- Excel Basics
- Creating a Worksheet
- Time-Savers
- Relative, Absolute, Mixed, and Circular References
- Three-Dimensional Workbooks
- Sorting, Subtotaling, and Filtering
- Charting Basics
- Advanced Charting Techniques
- Intro to Excel's Statistical Functions
- Financial Functions
- Worksheet Automation
- Mastering Excel's IF Function
|