Introduction to Microsoft Excel 2019/Office 365

This course focuses on the fundamentals of Excel 2019. You will first learn how to quickly and efficiently create fully formatted worksheets. You will then learn common formulas and functions, sorting and analyzing data, custom charts and graphs, and how to create three-dimensional workbooks. This course also introduces you to Quick Analysis, Flash Fill, and other powerful charting tools, which are further explored in the intermediate course.

Intermediate Microsoft Excel 2019/Office 365

This course builds on the fundamental techniques you learned in the introductory Excel 2019 course. You will master charting and then learn more of Excel's time-saving features like PivotTables, Slicers, and Sparklines. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands 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.

Advanced Microsoft Excel 2019/Office 365

This course will help you make the most of your investment in Microsoft Excel 2019. You will master advanced features that most users don't even know exist, such as scenarios and data tables to perform what-if data analysis. You will learn advanced techniques for PivotTables, conditional formatting to highlight duplicate entries, and importing external data using Excel's built-in Power Query tool. By the time you finish this course, you will know all the possible features and functions of Microsoft's powerful spreadsheet software.

Series 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 Series bundles.

This course has rolling start dates, generally, a new course begins every month.  

Some of the world's most widely used software programs are part of the Microsoft Office suite. This course bundle will teach you how to use Word 2019, Excel 2019, and PowerPoint 2019, Office's top business productivity programs. You will learn the basic features of each program and gain skills applicable to most professional settings.

Non-profits today need to be run like a business in many respects. You have competition, a need to generate income and a surplus, and staff need to be even more productive. Get the best training on revenue generation for nonprofits, and program evaluation for nonprofits, with our Certificate in NonProfit Administration.   You will come away with the latest best information from instructors who train people in nonprofits. 

CEUs/ILUs: 4.8

Length (in hours): 48

Price in USD $595

Offered 4 times/year, call for dates.

For those new to teaching online, or those already teaching online. Get the best instruction from the foremost authorities in online learning. Thousands of people have taken this fundamental yet advanced training in teaching online. From building an online course to improving an online course, from fostering online discussion to encouraging student interaction, from traditional assessment to online tests, the program will give you both the fundamentals of teaching online, as well as the most advanced tips and techniques in the business. Your instructors are authors, speakers, and consultants in online learning and teaching.

CEUs/ILUs: 4.8

Length (in hours): 48

Price in USD $495

Offered 4 times/year, call for dates.

Do you have clear financial goals? Are you confident you will be able to retire someday? How can be sure you are making the right investments? Do you know how to change your credit report to reduce your expenses and increase your financial security? Do you know how to keep good financial records?

This course will prepare you for a lifetime of worthwhile personal financial planning. The tools you will learn are useful, realistic, and easy to work into your regular routine. They will help you gain control over the financial impact of the choices you make. You will learn to create and use a budget, borrow and invest wisely, make intelligent decisions about insurance, and plan for your financial future. You will develop a retirement savings plan, and you will be better prepared to make large purchases and plan for taxes. You will learn the essentials of household bookkeeping, recordkeeping requirements, and much, much more.

This course has a new start date available each month.

Work One-On-One with a Pharmacy Technician Trainer and entirely online with support from a Pharmacy Technician and Trainer.  The Pharmacy Technician is one of the fastest growing jobs in health care today.  In this course, you will learn everything from the role of the technician in the pharmacy setting, to the basic sciences at the core of pharmacy practice, to preparing for the PTCB exam.  You will learn complete drug information that includes proper name, spelling and pronunciation, drug class, generic and trade name, route of administration, dosage and more of hundreds of drugs.  You will be able to identify pills on sight with pill photos, gain a better understanding of how certain drugs work within the body with a concise review of relevant anatomy and physiology, and stay up to date with cutting-edge pharmacy practice with the latest information on new drugs, regulations, HIPAA guidelines and safety procedures.  You will be ready to pass your PTCB national certification included in cost.

New grants are available for Medical Assistant, Pharmacy Tech, and CNA training programs, call us to see if you qualify for FREE training.

Open enrollment. Payment plans are available. Call the Adult Education office for more information.

Businesses are turning to podcasting to grow their brand and connect with customers. People with a niche hobby are turning podcasts into a business. Podcasting is experiencing a rebirth as mobile devices are everywhere. The intimate nature of the audio medium allows potential clients to get to know who you are and determine if you are the kind of company with which they want to do business.  Learn how to take your business or hobby and turn it into a podcast.  This step-by-step class will take you from start to finish and cover the required elements needed to get your show online.  Come to class with your idea and end with your show online for all to hear.

CEUs/ILUs: 1.6

Length (in hours): 16

Price in USD $245

Offered 4 times/year, call for dates.

Gain insights into your data using business intelligence software – Power Business Intelligence. Power BI is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free.

Discover the process of creating interactive reports. Integrate financial, marketing, or any other source data in your accounting system, Excel, or on the Web. Streamline the data to what is needed using Power Query. Create charts, maps, and other visuals to see your data in real time.

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using relationships and DAX (Data Analysis Expressions). Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports and analyze your results.

This certificate will enhance your skills in data analysis, giving you greater insight into your organization’s performance and allowing you to make more informed decisions.

This Certificate must be taken in the following order:

• - Introduction
• - Intermediate
• - Advanced

CEUs/ILUs: 4.8

Length (in hours): 48