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.

For more info please click here.

Blogging and Podcasting for Beginners will teach you how to plan and create your very own blog and podcast. Through hands-on exercises, you will discover the benefits of using free web tools like Blogger, WordPress, Audacity, and YouTube. You will find that creating a blog and podcast is much easier than you ever imagined.

First, you will learn how to develop a plan for the content, setup, maintenance, and how to use free blogging software like Blogger and WordPress to put that plan into action. After that, learn how to record a professional-sounding audio podcast with a very simple recording tool you already have. You will edit the file with another free software program, add music to it, and then post it online for others to enjoy. Finally, you will find out how to record a video podcast. You will edit it, add special effects, drop in a podcasting-safe music file, and then publish it online.

Instructor-Led classes begin on Jun 14, Jul 12, Aug 16 and Sept 13

Self-Paced classes can begin at anytime.

For more information or to register please click the link.

Communicating successfully depends on effective use of communication strategies and behaviors. Words, facial and body movements, tone of voice, even clothing and situation, all form an intricate symbol system that must be quickly translated by those who want to communicate.

It has been said that there is no communication unless a mutual sharing of meaning takes place. It has also been said that one cannot NOT communicate. These two ideas seem to oppose one another, but they are two sides of the same coin. A smile can have many meanings, but so can silence.

This course will show you how to manage the conscious and unconscious codes of meaning people send to each other and how to respond with appropriate codes in turn. You will explore concepts of verbal and nonverbal expression, including personal style, listening, relationship dynamics, self-esteem, conflict management, and cultural and gender communication differences.

Instructor-Led classes begin on July 12, August 16 and Sept 13.  

Self-paced classes begin at anytime.  For more information or to register please click the link.

Rapid growth in the health, legal services, data processing, management, public relations, and other industries have created many new job opportunities for administrative assistants. This course will help you discover and master the essentials of managerial and staff support, information and records management, communications technology, travel and meeting coordination, space planning, and office ergonomics. You will become an indispensable member of your team by identifying opportunities and implementing solutions to turn your office into a high productivity machine.

This course and its follow up (Administrative Assistant Applications) may help you prepare for the internationally-recognized Certified Administrative Professional® (CAP®) exam offered by the International Association of Administrative Professionals® (IAAP®).

Note: This course is not affiliated with, nor has it been endorsed by, the International Association of Administrative Professionals® (IAAP®).

Instructor-Led dates are as follows Jun 14, July 12, Aug 16 and Sept 13.

Self-Paced classes can start at anytime.  For more information or to register please click the link.

Not sure what we have to offer you?Send us your info and we will contact you to schedule a time that works for you. Meetings can be on the phone, in person, on Zoom or via email.Get your questions answered and register for a training of your choice today!

In this course, an experienced grant writer will show you how to research and write winning proposals that get funded. You will become proficient in the proposal format used by the vast majority of public foundations. Learn what to do and what not to do on your cover sheet, narrative, background page, and your stakeholder and third-party evaluation plan. Discover the quickest and most efficient ways to gather the information you will need to develop your proposal's attachments, including information on your organization's structure, administration, and finances. Gain a full understanding of the criteria funders use to determine whether your grant proposal gets funded or rejected.

Before this course is over, you will have discovered a number of significant finishing touches that can give your project the edge over others. You will learn about the importance of obtaining community and political support before submitting a proposal to any government agency.

Instructor-Led dates are as follows Jun 14, July 12, Aug 16 and Sept 13.

Self-Paced classes can start at anytime.  For more information or to register please click the link.

Have you ever heard the old saying, "Buy low, sell high?" News stories about the softening real estate market might scare away some novice investors, but experienced investors recognize weak markets as opportunities to pick up bargains. In many areas, now is the time to buy before prices start climbing again. In this course, you will learn how to make money in any area, in good times and bad, even if you have little money to start with.

Real Estate Investing includes specially designed worksheets and hands-on activities to take the guesswork out of your investing efforts. Start developing a plan for your own investing efforts based on proven methods used every day by full-time, professional real estate investors. You will learn how to invest in foreclosures, manage a rehab project, and build your team of real estate professionals (title officers, lawyers, accountants, mortgage brokers, appraisers, and more). This course also explores the effects of higher interest rates and cover alternative strategies for a changing market. By the end of the course, you will be working toward your first (or next) deal.

For more information or to register please click the link.

To register or for more details visit:

https://www.ed2go.com/kae/online-courses/accounting-basics/

Accounting Fundamentals

In this course, you'll learn the basics of double-entry bookkeeping, as well as how to analyze and record financial transactions. You'll get hands-on experience with handling accounts receivable, accounts payable, payroll procedures, sales taxes, and various common banking activities. 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

This course will build on the knowledge you gained in Accounting Fundamentals, to provide you with a solid understanding of corporate accounting practices. You'll explore such topics as special journals, uncollectible accounts receivable, plant assets, depreciation, notes and interest, accrued revenue and expenses, dividends, retained earnings, and various financial reports for corporations.