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.

Click here for more information on start dates, specific course information and registration.

Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you.

You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.

This is a Instructor led or self-paced class.  When registering please make sure you check which one you would prefer to do.  For more information or to register please click on the link.

If you're an animal lover, find out how you can start your own pet sitting business to translate your passion into a profitable career! In this course, you will master the essentials of running a cat and dog sitting business. You'll begin with pet care, including nutrition, exercise, first aid, and the identification of common diseases. You will learn the basics of first aid and find out how to administer pills, liquid medications, and injections to an uncooperative cat or dog. You will discover how to handle home visits and impress your potential clients. You'll also explore sticky situations that can arise, such as lost pets, pets that die unexpectedly, and pets that need immediate veterinary care.

In addition, you will delve into finances and explore start-up costs, accounting, fee setting, business plans, and low-cost marketing. You will discover how to obtain required insurance, hire employees as your business expands, and entice financial institutions to loan you money. Then, you will look at opportunities for expanding your pet sitting services. Is a dog-walking service right for you? Can you train puppies? Do you want to look after other animals, including horses? By the end of this course, you will have all the knowledge you need to become a professional pet sitter. In addition, you will discover how your pet sitting business can grow to continually challenge and satisfy you.

For more information or to register please click the link.

Learn how to create presentation slides that complement your message and engage your audience. This introductory-level course covers the basic tools and functions required to craft custom slides using Microsoft's PowerPoint. Functions covered in the course include inserting text boxes and images, presenting information with tables, charts, and SmartArt, incorporating transitions and animation, and formatting slide layouts. During the course, you will learn how to build a presentation from start to finish and will gain a greater understanding of the most popular PowerPoint tools.

For more information or to register please click the link.

As technology continues to change the way that we engage in business communications, the art of presenting has also undergone a shift. No longer can presenters rely solely on their spoken words to deliver their messages. Now, audiences expect to see multimedia slideshows that both inform and entertain. This course will consider how to plan and design effective slideshow presentations using Microsoft's PowerPoint software. It includes practical tips and examples for mapping the presentation, incorporating research, using templates, selecting visual elements, and delivering the presentation.

For more information or to register please click this link.

QuickBooks® Online Basics is an introductory-level course designed to build a foundation of essential skills in QuickBooks® Online. In this course, learners will develop a greater understanding of the basic bookkeeping and accounting functions that the software enables. The course content focuses on mastering the fundamental tasks performed in QuickBooks®, including setting up a company file and chart of accounts, entering customer and vendor information, recording sales, creating invoices, managing payables and receivables, creating and customizing reports, and using the Audit Log.

Note: To complete the exercises in this course, learners will need to set up their own access to the QuickBooks® Online platform. A subscription to QuickBooks® Online is not included with this course.

For more information or to register please click the link.

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst.

You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables.  You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.

Click here for more information on start dates, specific course data and registration.

Financial institutions are unlike any other business. To someone new to the world of banking, it can seem puzzling. However, financial institutions play a key role in maintaining thriving communities and economies. The welfare of the nation depends on the banking industry. In this course, learners will examine types of banking, customer groups, the business of banking, and the role of banks in a community.

For more info please click on the link.