About online professional development:

Online learning is a fun, enjoyable and very productive way to learn. Millions of people are learning online each year. You will engage with and get to know the instructor and other participants. It’s easy, and fun!

For a full listing of courses, visit our course directory.

How the courses work:

It is easy to participate in your LERN online course. After you register, you will be given a web address to access your online classroom. You will use your email address and a password to gain access.

Participate when you want:

You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you want to participate. For the best learning, participants should log into the course on 2-3 different days of the week. For best learning, you should make one or more comments at 2-3 different times each day.

What you will do:

• Access the online readings.
• Listen to the audio presentation for the unit and view slides.
• Take a self-quiz to see how much you have learned.
• Engage in written online discussion with your instructor and other participants.

The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again at your convenience.

Discussion:

The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or evening. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.

Explore noncredit certificate and noncredit course listings below.

You may enroll up to five days after the start date.

Business

• The Basics of Bookkeeping

  Read more about The Basics of Bookkeeping

  How do you keep track of the day-to-day financial transactions of a business?  Whether you are looking to advance in your career, or you’re an entrepreneur, (or maybe you are a part of a family business), this course will help you if you are looking to understand the numbers. The Basics of Bookkeeping course will help you understand, and know how to record, every penny that comes into your business and every penny that goes out of your business. This course shows you how to create a chart of accounts that meet your needs. All of the money you spend, and all of the money you earn, have a place to go. How do your record them? What are debits and credits? What do the numbers mean?  How do I label accounts? Even if you outsource your bookkeeping needs, you should still have a basic understanding of what happens with the money earned and the money spent. No one should be blind to their finances! In this course, you will learn where the numbers go, and why! You will learn the bookkeeping terminology, as well as what it means to keep track of the numbers. At the end of the cycle, what do the numbers mean? The Basics of Bookkeeping will show you how to keep track of the numbers and why!

• Understanding Debits and Credits

  Read more about Understanding Debits and Credits

  In this course, you will learn about the accounting equation and the five categories involved in every business (Assets, Liabilities, Owner’s Equity, Revenue and Expenses). Every financial transaction falls into one or more of these categories. Learn how to create a chart of accounts that meet the needs of your business. You will learn how double entry bookkeeping works and the process of recording debits and credits. This course will show you how to identify, analyze and record transactions using journal entries under the cash basis accounting method.

• General Ledger and Month End Procedures

  Read more about General Ledger and Month End Procedures

  In this course, you will learn how to post journal entries to the correct general ledger accounts impacted by each transaction. This course will show you how to make sure your general ledger balances at the end of each month by preparing an unadjusted trial balance. You will learn how to look for errors when you don’t balance, and how to determine to correct entries. After posting correcting entries and/or adjusting entries, you will verify debits and credits equal, with an adjusted trial balance. This course also goes through the steps of performing monthly bank reconciliations.

• Closing Procedures and Financial Statements

  Read more about Closing Procedures and Financial Statements

  This course shows you how to create a worksheet used to adjust the account balances and prepare the financial statements. Use your financial statements to measure performance, make improvements and set goals. The final step covered in this course is closing your books and preparing them for the next accounting period; this is done by journalizing and posting closing entries.

• Accounting and Finance for Non-Financial Managers

  Read more about Accounting and Finance for Non-Financial Managers

  Every successful person in the workplace utilizes financial information to aid effective decision making. Accounting and Finance for Non-Financial Managers explain the financial concepts and accounting processes used in most businesses and will provide practical techniques that will increase your effectiveness and career. Get a foundation to understand the seven steps in the accounting cycle and use financial information in decision making. Come away with the knowledge to analyze resource allocation and evaluate financial performance.

• Cash is King

  Read more about Cash is King

  Cash is arguably the most important factor in business success. D&B reports 90% of all small business failures are due to poor cash flow—more money gets paid out than collected. It is the non-financial manager who really makes a difference in the day-to-day cash activities. Discover how to maximize cash flow, learn the importance of cash and find out your role in cash flow success.

• Financial Analysis and planning for Non-Financial Managers

  Read more about Financial Analysis and planning for Non-Financial Managers

  With the demands of daily operations, non-financial managers may put financial reports on the shelf. But take a look at some of the most admired companies like Apple, Google, and Berkshire Hathaway. Sure, they are evaluated by their products, innovation, and culture but they would not be in the limelight without profits. Money matters! This course will help you build on your understanding of financial concepts and help you establish your role in the financial success of your organization. Designed for non-financial managers, business owners, entrepreneurs, and other decision-makers, this advanced course will take the mystery out of money matters. Throughout this course, financial information that drives your organization, as seen on the business’s reports, will be assessed and analyzed to understand it. An understanding of this information will help you make smart decisions when it comes to budgeting, setting goals, and assessing performance within your own area of influence.

Business Communication

• Business Writing

  Read more about Business Writing

  Take away the key practices you need to develop and hone your business writing communication effectively and successfully. Get the best practices for crafting effective, professional business documents. Find out how to avoid grammatical pitfalls and acquire business writing principles that will be good for years to come.

• Effective Copywriting

  Read more about Effective Copywriting

  Whether you are sending out a press release, communicating internally with a memo or promoting your own skills on LinkedIn, strong writing skills are the key to success. Come away with the tools and techniques you need to improve your copywriting skills and learn how to avoid the common writing mistakes that can hold you back.

• Writing News and Press Releases

  Read more about Writing and News and Press Releases

  Being able to write a good news story, press release or publicity notice is a skill that can set you apart in the workplace. Getting the word out is an essential activity for every organization. Acquire the skills good journalists have and learn how to craft a news story, press release or publicity notice that will get attention.

• Conflict Management

  Read more about Conflict Management

  A recent study conducted by the American Management Association (AMA) revealed that the average manager spends more than 20 percent of their day engaged in or reacting to a conflict situation. This study also identified that out of twenty-five management skills, conflict management was the only one positively correlated to higher earnings and promotion. Discover a workable conflict management model, discuss case studies in conflict management, and then take away successful conflict management strategies to apply in your workplace.

• Using Personality Profiles for Better Work Performance

  Read more about Using Personality Profiles for Better Work Performance

  Understanding yourself and others will increase your overall effectiveness at work, home, and in all of your relationships. Learn how to improve your communication with others, convey your ideas effectively, and improve your ability to understand what is important to those who don’t share your same style. Course fee includes your own DiSC Behavioral Personality Profile assessment and review.

Data Science

• Certificate in Data Analysis

  Read more about Certificate in Data Analysis

  Encompasses three courses: Introduction, Intermediate, and Advanced Data Analysis, which must be taken in this order.

  Students need to have Microsoft Excel installed to complete this certificate.

  Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio and make a big difference in the success of your organization by acquiring data analysis skills.

  Begin with gaining a basic understanding of how to analyze data in a business setting. Then, learn how many of your business decisions involve comparing groups for differences, and understand the statistics behind these group differences and relationships. Finally, discover how to perform inquiries that are useful to your business or organization and communicate these results through graphs and text that your fellow employees will understand.

  Whether your business is home-based or a large company, this certificate will take you to the next level where important decision-making is concerned.

• Introduction to Data Analysis

  Read more about Introduction to Data Analysis

  Data analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. This course will give you a basic understanding of how to analyze data in a business setting. Businesses look for candidates with an understanding of how to analyze the data they have been collecting; this course will help you start on that journey.

  Students need to have access to Microsoft Excel to complete this course.

• Intermediate Data Analysis

  Read more about Intermediate Data Analysis

  Many of your business decisions involve comparing groups for differences. For example, would men and women prefer different product features? In addition, you may look at relationships between variables. Does product recognition relate to subsequent product purchase? This Intermediate Data Analysis course will introduce you to the statistics behind these group differences and relationships. In addition, you’ll learn how to work with ratings, graphs and user-friendly reports of statistical results.

  Students need to have access to Microsoft Excel to complete this course.

• Advanced Data Analysis

  Read more about Advanced Data Analysis

  After taking this advanced course in data analysis, you will be able to perform inquiries that will be useful to your business or organization and have the skills necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on the statistically significant information. Whether your business is home-based or a large company, this class will take you to the next level where important decision-making is concerned.

  Students need to have access to Microsoft Excel to complete this course.

• Certificate in Mastering Excel

  Read more about the Certificate in Mastering Excel

  A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.
  
  Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks.
  
  Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques.
  
  Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence. Includes Mastering Microsoft Excel, Intermediate Excel, and Advanced Excel.

• Mastering Microsoft Excel

  Read more about Mastering Microsoft Excel

  A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.

• Intermediate Excel

  Read more about Intermediate Excel

  Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!
  
  This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

• Advanced Excel

  Read more about Advanced Excel

  We are faced with different types of business decisions each day that can change the data we work with, along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find the answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data, and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.

• Power BI Certificate

  Read more about the Power BI Certificate

  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 to Power BI, Intermediate Power BI, and Advanced Power BI.

• Introduction to Power BI

  Read more about Introduction to Power BI

  Gain insights into your data! Power BI (business intelligence) 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. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions.

• Intermediate Power BI

  Read more about Intermediate Power BI

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

• Advanced Power BI

  Read more about Advanced Power BI

  Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

Management

• Supervisory and Leadership Certificate

  Read more about the Supervisory and Leadership Certificate

  Your employees are your most valuable resources. Ensuring the efficiency of your team is the key to your success and is your most important responsibility. Get practical, easy to understand, and insightful methods for new and even experienced supervisors and managers.
  
  Learn about effective delegation, performance management, and writing performance reviews. Discuss the specifics of the supervisor's role and responsibilities, and strategies for improving your overall effectiveness as a leader. Take home practical information along with tips and techniques that can be applied at your job immediately.

• Management Boot Camp

  Read more about the Management Boot Camp

  Enhance your management skills through this course for supervisors, managers, and emerging leaders. Nothing creates success like a solid foundation. Discover the keys for effectively managing your employees. Find out how to create clear expectations, engage and motivate employees, and increase your effectiveness through use of the DiSC personality profile (included). By the end of the course we will have you managing like a pro - quickly and with confidence.

• Managing Generations in the Workplace

  Read more about Managing Generations in the Workplace

  Get an understanding of managing workers in different generations in the workplace. Discover what motivates each generation at work, what incentives they respond to, and what messages they value.
  Generations X and Y are significantly different than the Boomer generation. Each generation has different expectations and styles of work in the workplace. Come explore the characteristics of the different generations in the workplace. Discover the current motivations of Boomers, Gen Xers and Gen Yers and what messages they value. Then Identify practical, how-to tips and techniques for managing Boomers, Gen Xers, and Gen Yers in the workplace.

• Management in the 21st Century

  Read more about Management in the 21st Century

  Elevate your management style and leadership skills to meet the demands of today’s fast-paced workplace. Learn how to break through barriers, achieve organizational goals, and increase employee satisfaction and productivity.

  This course provides modern management strategies designed to help you enhance collaboration and strengthen team performance while developing innovative leadership techniques that drive success. You will learn practical approaches to improve employee engagement and workplace culture, as well as strategies to navigate challenges and implement effective solutions that support long-term organizational growth.

• Certificate in Workplace Communication

  Read more about Certificate in Workplace Communication

  Courses Included in This Certificate:

  • Conflict Management – Master techniques to resolve workplace disputes effectively.
  • Management in the 21st Century – Develop leadership and teamwork strategies for success.
  • Using Personality Profiles for Better Work Performance – Understand different behavioral styles to improve communication and engagement.

  Effective communication is essential for career success and plays a crucial role in teamwork, leadership, and workplace productivity. This certificate program provides hands-on training to help you develop conflict resolution, negotiation, and collaborative communication skills that you can apply immediately.

  In this certificate, you will gain practical conflict management strategies to navigate workplace challenges with confidence, along with collaborative management techniques designed to enhance teamwork and strengthen leadership. You will also explore personality profiling insights that can improve communication, increase understanding among colleagues, and boost overall performance.

New Media Marketing

• Improving Email Promotions

  Read more about Improving Email Promotions

  Discover new ways to improve your email promotions, including when to email, what to email, and testing email copy. Then, find out how to analyze your email response rates, including getting the benchmarks for open rates and click-through rates. Learn how to improve your email promotion and responses with tracking and testing.
  
  Get a basic introduction to email promotions. If you are advanced, your instructor is an email expert and can answer your toughest questions.

• Boosting Your Website Traffic

  Read more about Boosting Your Website Traffic

  Acquire the basic skills to boost your website traffic, including how to analyze your visitor traffic, how to use search engine optimization to get greater visibility and exposure in Google searches, and how to redesign your website copy to increase your visitors and results.
     
  There is no experience necessary, but if you are at an advanced level, your instructor is an SEO expert and can answer your toughest questions.

• Online Advertising

  Read more about Online Advertising

  Get the keys to making online advertising work for you, and for your organization. See how pay-per-click advertising with Google AdWords works.  Find out how to test low budget AdWord campaigns. Learn how you can target local audiences. Then, discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach.
  
  There is no experience necessary, but if you are at an advanced level, your instructor is an online ad expert and can answer your toughest questions.

• Digital Marketing Certificate

  Read more about Digital Marketing Certificate

  Master the fundamentals of digital marketing and learn how to attract, engage, and convert customers online with this comprehensive certificate program. You will gain the skills needed to grow any business or organization by improving email marketing performance to increase engagement and conversions, analyzing website traffic to better understand visitor behavior, and applying SEO strategies to boost search engine rankings and visibility.

  In addition, you will learn how to implement successful Google Ads and Facebook Ad campaigns that drive targeted traffic and measurable results. This program is relevant for businesses, nonprofits, and government agencies alike, making it valuable across sectors. No prior eMarketing experience is required, and advanced learners will also benefit from expert insights and the latest strategies shared by industry professionals.

  Courses Included In This Certificate

  1. Improving Email Promotions – Master best practices in email marketing, from writing compelling copy to optimizing timing, open rates, click-throughs, and conversions.
  2. Boosting Your Website Traffic – Learn to use Google Analytics, apply effective SEO strategies, and enhance your website’s performance to attract more visitors.
  3. Online Advertising – Gain hands-on skills to create and manage Google Ads and Facebook campaigns, refine targeting and bidding, and measure ROI for maximum impact.

  Certificate Learning Outcomes

  1. Implement email marketing strategies that drive engagement and sales
  2. Track and analyze website traffic and visitor trends
  3. Optimize website content for search engine rankings
  4. Set up and manage Google Ads and Facebook Ad campaigns
  5. Evaluate online advertising ROI and refine ad strategies for better performance

  Who Should Take This Certificate?

  • Business owners looking to expand their online presence and increase conversions
  • Marketing professionals seeking to optimize digital campaigns
  • Entrepreneurs wanting to drive traffic and boost customer engagement
  • Website managers interested in SEO, email marketing, and online advertising
  • Anyone looking to develop essential digital marketing skills

• Podcasting

  Read more about Podcasting

  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.

Social Media for Business

• Introduction to Social Media

  Read more about Introduction to Social Media

  Get involved in the move from in-person to online communication. Learn what social media are and their role in your business and personal life. Find out the top sites and how businesses are using the sites for communication, customer retention, branding, marketing, market research, needs assessment and serving customers and clients. Explore the options for your organization, look at case studies of what other organizations are doing, and let your instructor guide your exploration of Facebook and YouTube. This course is ideal for anyone interested in social media.
  
  Your instructor is a nationally known speaker, consultant, and trainer on social networks and social media.

• Marketing Using Social Media

  Read more about Marketing Using Social Media

  Develop a two-way communication and marketing strategy for your organization using social media. Let your instructor guide you in exploring major social media, including Twitter, LinkedIn, and blogging. Learn quick, easy ways to use Twitter, blogs, and LinkedIn to engage your customers or clients and keep them interested in your organization or business. You’ll find out the advantages and disadvantages of each, and learn what’s right for your work and kind of organization.

• Integrating Social Media in Your Organization

  Read more about Integrating Social Media in Your Organization

  Take away a practical strategy and techniques for implementing a social strategy for your organization or business. Learn the top five considerations when starting a social network as well as tips to manage an online community. Discover how to create your own private social network using the Ning platform. Discuss the top tools to use to manage your social media life and build integration into your website. See how Google Docs and Calendars work and how to use online video to further your business goals. Hear about mobile check-in applications and how companies are using coupon and deal sites. Get your company listed properly on local search engines so more customers can find you. Discuss how web design has changed and get feedback on your website while discovering usability testing and user interface design. Finally, learn how to manage this influx of information created by the new media revolution. Develop a manageable workflow and get productivity tips to be more efficient. Learn what you might be doing wrong in social media as well as essential policies to have in place for your employees and company. See what trends are on the horizon and where your goals fit with those new trends.

Spanish Language Courses

• Beginning Conversational Spanish

  Read more about Beginning Conversational Spanish

  This course is designed for beginners or those needing a refresher. You’ll practice foundational Spanish including essential vocabulary, grammar, pronunciation, and everyday expressions to help you hold simple conversations with confidence.

  Who Should Take This Course?

  • Adult learners and professionals seeking basic Spanish for everyday use
  • Travelers or volunteers preparing for Spanish-speaking environments
  • Lifelong learners looking for a flexible, engaging introduction to Spanish
  • Anyone who studied Spanish in the past and wants a structured refresher

  What to Expect in Both Courses:

  Asynchronous format with weekly guided modules.
  Flexible, self-paced learning (2–3 hours per week).

• Spanish for Medical Professionals

  Read more about Spanish for Medical Professionals

  New this summer! Designed specifically for healthcare professionals, this course helps bridge the communication gap between providers and Spanish-speaking patients. You’ll learn medical vocabulary, practical phrases, and cultural insights essential to delivering quality care.

  Who Should Take This Course?

  • Nurses, physicians, and medical support staff
  • Healthcare administrators and front desk staff
  • EMTs, social workers, and mental health professionals
  • Anyone in healthcare aiming to improve communication with Spanish-speaking patients

  What to Expect in Both Courses:

  Asynchronous format with weekly guided modules.
  Flexible, self-paced learning (2–3 hours per week).

Technology Skills

• Mastering Computer Skills for the Workplace

  Read more about Mastering Computer Skills for the Workplace

  Must-have skills to succeed in the workplace include the ability to create, edit and manage presentations in MS PowerPoint, documents in MS Word, email and calendars in MS Outlook, and spreadsheets in MS Excel. Microsoft Office Suite of applications is the most used software tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of MS Office change over time. Master the most common uses so that you can work faster and more efficiently and can take your computer skills from plain and drab to exciting and engaging. You will leave class with a set of skills that are a workplace requirement in today’s fast paced ever-changing environment and will enable your future career success.

• Mastering Microsoft PowerPoint

  Read more about Mastering Microsoft PowerPoint

  Bring your ideas to life and leave a lasting impression with Microsoft PowerPoint. Master the tools and techniques that turn humdrum slides into dynamic presentations that will captivate your audience. With hands-on practice and real-world examples, learn design principles and multimedia elements such as images, videos, and charts that elevate you to the next level. Acquire critical know-how to deliver your presentations with confidence and ease. Whether you're a beginner or a seasoned user, you'll find new ways to work smarter, not harder. You'll leave class with in-demand skills and the ability to create professional, visually appealing presentations that will engage your audience and help you stand out.

• Mastering Microsoft Word

  Read more about Mastering Microsoft Word

  In this hands-on course, you’ll learn how to create, format, edit, and share polished documents that stand out. From resumes and reports to brochures and newsletters, you’ll gain practical experience crafting a wide range of business-ready documents. You’ll explore Word’s core and advanced features, including templates, themes, styles, tables, charts, and collaborative editing tools. By the end of this course, you’ll be equipped to streamline your workflow, automate repetitive tasks, and present your ideas with clarity and professionalism.

• Mastering Microsoft Excel

  Read more about Mastering Microsoft Excel

  In this course you’ll build a strong foundation in spreadsheet creation, data management, and analysis, while learning how to enhance your work with visual elements like charts, graphs, and formatting tools. You’ll explore how to create and manage worksheets and workbooks from the ground up, understand Excel’s layout and functions, and apply advanced tools such as formulas, filters, and live connections across documents. You’ll also learn how to share your work seamlessly and integrate Excel with other Microsoft Office tools like Word, PowerPoint, and Outlook. By the end of this course, you’ll be equipped with high-demand Excel skills to improve productivity, support business operations, and make data-driven decisions in any professional setting.

• Certificate in QuickBooks Online

  Read more about Certificate in QuickBooks Online

  Courses Included In This Certificate:

  • QuickBooks Level 1 – Learn the essentials of QuickBooks, including setting up accounts, managing income and expenses, and tracking business finances.
  • QuickBooks Level 2 – Advance your skills by exploring payroll, inventory, budgets, and customized reports to maximize QuickBooks’ capabilities.

  The Certificate in QuickBooks Online is designed for small business managers, owners, bookkeepers, and accounting professionals who want to enhance their financial management skills. This certificate program combines Level 1 and Level 2 courses, providing a comprehensive understanding of QuickBooks Online, the leading cloud-based accounting platform.

  Participants will gain practical knowledge of essential accounting tasks such as entering sales, purchases, payments, and inventory, and develop advanced skills in customization, banking, project tracking, and more.

• QuickBooks Online Level 1

  Read more about QuickBooks Online Level 1

  In this course, you’ll gain a comprehensive understanding of this leading cloud-based accounting platform. Ideal for small business managers, owners, bookkeepers, and accounting professionals, this course covers the basics of using QuickBooks Online. Through four hands-on units, you’ll learn to enter sales and purchases, receive and make payments, and add and manage inventory. By the end of this course, you’ll have the foundational skills needed to confidently use QuickBooks Online for essential business accounting tasks.

• QuickBooks Online Level 2

  Read more about QuickBooks Online Level 2

  This course takes your skills to the next level with advanced features of this cloud-based accounting platform. Participants will learn how to customize settings and workflows, manage banking and credit cards, work with foreign currencies, create statements for debt collection, and use tags and project tracking. This course equips participants with advanced tools to optimize QuickBooks Online for professional and business needs.

• SQL Certificate

  Read more about SQL Certificate

  Courses Included In This Certificate:

  • Introduction to SQL – Explore relational database structures, the history of SQL, and learn to write basic queries.
  • Intermediate SQL – Work with multiple tables, modify data, and expand your query skills.
  • Advanced SQL – Master transactions, joins, and stored procedures for complex data analysis.

  The SQL Certificate is designed to provide a comprehensive foundation in Structured Query Language (SQL), the industry-standard language for interacting with databases. This three-course program covers foundational through advanced SQL concepts to enhance your technical expertise and competitiveness in roles involving data management and analysis.

  Through this certificate, you’ll learn to understand relational database structures and the history of SQL, building a strong foundation in database management. You will gain the ability to write SQL queries to create, manage, and analyze databases effectively. As you progress, you’ll explore advanced techniques for querying multiple tables, processing transactions, and creating stored procedures to enhance your technical expertise and problem-solving skills.

• Introduction to SQL

  Read more about Introduction to SQL

  Introduction to SQL provides a comprehensive foundation in Structured Query Language. This course covers relational database structures, SQL history, and how to use SQL to create databases, add records, and retrieve data with basic queries. Through four interactive units, you’ll learn to create and manage relational database structures, write simple SQL queries to retrieve meaningful data, and add, modify, and delete records in database tables.

• Intermediate SQL

  Read more about Intermediate SQL

  Intermediate SQL builds on introductory concepts to teach more powerful queries for retrieving meaningful data from databases. You will create calculated fields, concatenate columns, and apply aggregate functions such as SUM, AVG, and COUNT for statistical analysis. The course emphasizes organizing and filtering data with GROUP BY, ORDER BY, HAVING, and WHERE clauses to perform more advanced queries. Students will also gain hands-on experience combining data across multiple tables using INNER, OUTER, and SELF joins, and learn to write subqueries to handle complex and nested logic.

• Advanced SQL

  Read more about Advanced SQL

  Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution. Students should have a competency in the Introductory and Intermediate levels of SQL.

  Requirements:
  Windows 10 or later. Macs are not compatible.
  Necessary rights (local administrative rights) to install programs on the computer.

You may cancel your registration up until you receive your login in and password from LERN and receive a full refund minus any credit card processing fees. After that date, no refunds will be given. Cancellations must be received by the program manager, Shelly Schuetz, via email.

In the unlikely event that this program is canceled or postponed due to insufficient enrollments or unforeseen circumstances, VCU Continuing and Professional Education will fully refund registration fees, but cannot be held responsible for any other expenses, including change or cancellation charges to include but not limited to airlines, hotels, travel agencies, or other organizations.

VCU Continuing and Professional Education offers a variety of noncredit online courses and noncredit online certificates in partnership with The Learning Resources Network (LERN).

Some VCU Continuing and Professional Education offerings are ineligible for waiver use due to partnership agreements. The following text will appear on the registration page: “*exempt—this offering is ineligible for waiver use.”