Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you will see how to maximize this program's functions and capabilities.

Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

You will see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You will discover advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You will learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

Learn how Excel 2013 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you will be able to accomplish just about anything Microsoft Excel has to offer!

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/advanced-2016-excel-training/

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.

This course will help you master many features in Microsoft Excel 2019/Office 365 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019/Office 365 and will be able to better serve your company's data management needs.

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/advanced-microsoft-excel-2019-office-365/

When is hacking legal? When you use it to secure your own network. This course will teach you readily available hacking tools and techniques to audit your network so you can locate and close security holes. You will discover how to better protect your system against those who wish to gain unauthorized access.

In this course, you will discover the complex method of electronic breaking and entering. You'll learn the terms and programming behind the interaction between hardware and software when communicating through a network. Following packets of data from one point to another through an entire network, you will discover where the flaws exist for data loss and security breaches. You'll learn about the seven layers of the OSI model, and the dependencies of hardware and software interaction through packet transmission. Along the way, you will see how private data can quickly become public knowledge. Let this course establish the foundation of your network security. Learn how hackers think so you can harden your defenses against them!

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/advanced-pc-security/

Certificate in Healthy Aging

(10 contact hours) As the population in the United States ages, there are many opportunities to learn how to work with seniors to support quality of life. In the Certificate in Healthy Aging certificate, you'll gain an overview of specific aspects of aging, including the impact of nutrition and physical activity on the aging process, physiologic changes in the healthy aging brain, and the role of intimacy and sexuality in healthy aging. This program is designed for individuals who are working in the health care field, those who are interested in the topic, those who are working with the aging population, or anyone who wishes to prepare for a career in aging services or gerontology.Certificate in Gerontology

(25 contact hours) With the population aging at a rapid rate, the number of individuals over 65 will more than double by the year 2020. The demand for knowledgeable providers to meet the needs of this population is dramatically increasing. The Certificate in Gerontology represents a specialization in the field of gerontology. It is designed to enhance the knowledge and skills of health care professionals who work with the older adults.

Certificate in Brain Health

(10 contact hours) Can we program our brains for happiness? How do sleep quality and stress affect our mental and physical health? Can activities such as exercise, play, and even listening to music boost brain health? In this innovative certificate program, you'll gain insights into the amazing brain and explore how to support health and happiness through lifestyle choices that impact this remarkable organ. Based on recent scientific studies, this program is perfect for healthcare professionals or anyone who wants to better understand how supporting brain health can foster health, happiness, and wellbeing.

Accreditation:ALLEGRA Learning Solutions, LLC is accredited as a provider of continuing nursing education by the American Nurses Credentialing Center's Commission on Accreditation.ALLEGRA Learning Solutions, LLC was awarded Accreditation with Distinction, the highest recognition awarded by the American Nurses Credentialing Center's Accreditation Program.ALLEGRA Learning Solutions courses are acceptable for CE contact hours in all states.Provider approved by the California Board of Registered Nursing, Provider #CEP 14693, for the stated number of contact hours.ALLEGRA Learning Solutions courses are approved for continuing education credit for diabetes educators. All ANCC accredited courses are accepted for continuing education credit by the National Certification Board for Diabetes Educators (NCBDE).

No individual in a position to control content for this activity has any conflicts of interest or relevant financial relationships to declare.

There is no commercial support being received for this activity.

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.

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/aging-and-health/

Prepare for a rewarding career as a valued member of the physical therapy team while learning all about the human body, specific disorders, and the way physical therapists treat these disorders. You will explore the history of physical therapy and the relationships between physical therapists, physical therapist assistants, and physical therapy aides. You will learn how to communicate effectively with other health care professionals and patients. You'll also come to understand the medical documentation that physical therapists use and principles of ethics and law that affect the PT aide.

Physical therapists often use words and terms that may be unfamiliar to you, so this course will devote some time to learning much of the language of PT. You'll learn proper body mechanics and how to safely move patients. You will come to understand the normal gait cycle and how to help patients walk with assistive devices like walkers, crutches, and canes. You will also investigate various balance and coordination disorders. By the time you finish this course, you'll have gained valuable knowledge and be well on your way to becoming an important member of the physical therapy team!

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/become-a-physical-therapy-aide/

Good grant writing consultants are always in demand. Learn how you can use a basic knowledge of grant or proposal writing to become an expert in the red-hot grant consulting field.

The course will provide you with easy-to-follow instructions that you can use to start your own home-based business. You'll learn what services to offer, how to find clients, and how to set your fees. This is one field where your creative writing skills can literally touch thousands of people and make a true difference in their quality of life.

To register for this class go to https://www.ed2go.com/rsu19ae/online-courses/becoming-a-grant-writing-consultant/

Are you interested in making better business decisions to increase your company's profits, move you up the corporate ladder, and help you reach a better, personal financial position? If so, this course is for you.

Using practical explanations and real-life examples, this course will show you how money flows through a typical business. You will learn the basics of how a business operates, including how to develop successful business strategies and how to use financial statements to make better business decisions.

Whether you're an employee, sales executive, supervisor, or manager, this course will help you understand basic financial information and use that information to make decisions that will positively affect your company's financial situation.

This is a business finance course for non-financial employees and managers. By taking it, you will obtain significantly improved business acumen skills and financial understanding. Position yourself to be more confident in your business and financial decisions.

To register for this class go to www.ed2go.com/rsu19ae

This Business Writing Training class will give business professionals the tools they need to write effective, efficient business correspondence. Students will learn how to get started on a writing project, use appropriate business tone in the document, and discern between the different kinds of business correspondence. Students will learn how to decide what the appropriate vehicle is for written communication in business, electronic or hard copy

To register for this class go to www.ed2go.com/rsu19ae