Course Code: B9093
Introduction to Microsoft Excel 2016
Do you work with numbers? Then you need to master Microsoft Excel 2016 — and this is the place to do it. In this comprehensive online course, you will discover dozens of shortcuts for setting up fully formatted worksheets quickly and efficiently. You will learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons.
Course Code: IX6
Intermediate Microsoft Excel 2016
Intermediate Microsoft Excel 2016 will teach you how to create informative charts and graphs; how to master charting; and the many ways to use PivotTables, Slicers, and Sparklines. You will learn to harness the power of Excel's data analysis tools and AutoFilter commands to create macros that eliminate repetitive tasks.
Course Code: NX6
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 will 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.
Course Code: FUN
Accounting Fundamentals II
This course will teach you how to analyze transactions and prepare various corporate financial reports. You will also gain practical experience working with dividends, plant assets, depreciation, accrued revenue and expenses, retained earnings, stockholders' equity, and more.
Course Code: AF2