Skip to main content

Accounting with Excel Suite (online)

ID : 110956   
« back to classes page
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. 
 
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.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Just go to www.ed2go.com/kirkwood to register.
Call 319-398-1022 to register Send to Friend »

Class Details

0 Sessions

Location
ed2go

Instructor
. Ed2Go 

Start Date:upon registration

ClassRatingGraphic
Rated 0 stars by 0 Students

 

Notice

Please read:  Classes start each month. Go to www.ed2go.com/kirkwood to register. Suites/bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. No self-paced tutorials available for suites/bundles.

Tuition: 

$500.00


Registration Closes On
Tuesday, June 30, 2020 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s) Instructional Method
N/A - Online . Ed2Go  Online

Other Class Offerings

Accounting with MS Excel 2019 Suite (online)
ID: 110957

StartDate: upon registration

Complete within 6 week(s)

Location
ed2go

Instructor
. Ed2Go