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.TECHNOLOGY NOTE: -Microsoft Excel is required.PREREQUISITE REQUIREMENT: -Students should have completed Mastering Microsoft Excel. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge (PMBOK) Guide. This basic information will assist you in learning the beginnings of Project Management, whether you are interested in project management, in a project management field, or in any line of work. Come away with a solid foundation of the five processes to learn and use when any type of project occurs in your employment arena.PREREQUISITE REQUIREMENT: -Students should have taken Introduction to Project Management. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in Project Management. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Now know how to work with more advanced QuickBooks Online topics. Become capable with such skills as how to customize settings, banking, credit cards, foreign currencies, statements for debts collection, using tags and projects. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in QuickBooks Online. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Dive deeper into the fascinating world of artificial intelligence. Explore machine learning algorithms, natural language processing, and neural networks, while gaining hands-on experience with popular AI frameworks and tools. Take your AI expertise to the next level.Prerequisite Recommendation: Participants are encouraged to complete Introduction to ChatGPT to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, AI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Master the art of document creation and take your professional skills to the next level with Microsoft Word, which is essential for success in the modern business world. Discover how to format text, paragraphs, images, and pages with ease. Get hands-on experience creating professional-looking documents, from resumes and cover letters to reports and brochures. Find out how to use templates and themes to save time and streamline your workflow. At the end of this class, you will be equipped with the skills to create, edit and share polished documents that will impress employers and coworkers and give you a competitive edge in the workplace.TECHNOLOGY NOTE: Students must have Microsoft Word to complete this class. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in Mastering Computer Skills for the Workplace. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

The benefits of social media make it an essential part of a business plan. Social Media Marketing has become more than running digital advertising campaigns; it allows your business to build a following of loyal customers through authentic posts and interactions creating excitement for your business as it grows. Each platform gives your business the tools to successfully build your brand, connect with your customers, and track analytics. This course will focus on Instagram, Facebook, TikTok, Pinterest, LinkedIn, Twitter, and Nextdoor. IMPORTANT INFORMATION: *This class is included in the full certificate course, Social Media for Business Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Take your AI skills to the next level with this hands-on course designed for professionals, entrepreneurs, educators, creatives, and anyone looking to use ChatGPT more effectively in their work. Building on the foundations of our Introduction to ChatGPT course, you'll learn practical strategies for customizing ChatGPT to your role and industry, analyzing information and uncovering insights, creating more effective content, and evaluating AI tools for different workplace needs. Through hands-on exercises, real-world examples, and practical applications, you'll gain the skills and confidence to integrate AI into your daily workflow, enhance communication and decision-making, and choose the right AI tools to solve real-world professional challenges.Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to ChatGPT before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, AI ChatGPT Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your e-mail in Arux if you prefer to receive your login information at a different e-mail.

To be successful, organizations must manage by fact. As such, organizations depend on the measurement and analysis of performance to make key decisions that affect the organization. This Intermediate Six Sigma Green Belt course builds on the ideas and skills learned in the Introduction to Six Sigma Green Belt course that organizations use, specifically their Six Sigma teams, to improve. In this second course in the certification program, participants will learn process analysis, data collection and analysis, probability and valid statistical conclusions, and hypothesis testing. Many participants find this course to be the most challenging of the certification courses. IMPORTANT INFORMATION: *This class is included in the full certificate course, Six Sigma Green Belt Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL and have competency in the Introductory level of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to Power BI before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, Power BI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Figure out how to calculate earnings, gross pay and net pay. Grasp an understanding about mandatory deductions and voluntary deductions. Gain the ability to calculate employee tax withholdings and employer payroll taxes. IMPORTANT INFORMATION: *This class is included in the full certificate course, Mastering Payroll Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Develop effective AI strategies to solve complex problems across various industries. Gain practical insights into how AI can be harnessed to enhance efficiency and drive innovation. By the end of the course, you will have the skills to create robust AI planning solutions that can adapt to dynamic environments and meet organizational goals.Prerequisite Recommendation: Participants are encouraged to complete Introduction to ChatGPT & Intermediate AI before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, AI Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. IMPORTANT INFORMATION: *This class is included in the full certificate course, Social Media for Business Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. TECHNOLOGY NOTE:*Students must have Microsoft PowerPoint to complete this class. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in Mastering Computer Skills for the Workplace. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

This fundamental course covers Adobe Photoshop CC most commonly used tools, menus and panels. You’ll learn all the basics of Photoshop to effectively work with selection and editing tools, layers, and masks to edit, retouch and enhance existing images or create your own composite digital art work. Impress your business organization, friends and family by enhancing their photos and create magazine cover quality enhanced images. Access to Adobe Photoshop software required.TECHNOLOGY REQUIREMENT: -Access to Adobe Photoshop software required. IMPORTANT INFORMATION: *This class is included in the full certificate course, Graphic Design Software Essentials Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

In today’s business environment, there is a need for good project management. Project management provides visibility of project health to the business and the customer. Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholders for quick resolution, including project cancelation. The Project Management Professional community does this through the five (5) Project Management Processes supported by the ten (10) Project Management Knowledge Areas. This course introduces the student to the ten (10) Project management Knowledge Areas and their support role and relationships to the five (5) Project Management Processes.PREREQUISITE REQUIREMENT:-Students should have taken Introduction to Project Management & Project Management Processes. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in Project Management. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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. IMPORTANT INFORMATION: *This class is included in the full certificate course, Bookkeeping Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

In this introductory course, you will learn how to style web pages using Cascading Style Sheets (CSS) coding language. Topics include using inline, internal, and external CSS, web typography, formatting text, working with web colors, using Google fonts, working with id and class selectors, working with elements, creating page layouts using elements, and CSS box model.PREREQUISITE REQUIREMENT:-Students should have taken Introduction to Coding & HTML Fundamentals. IMPORTANT INFORMATION: *This class is included in the full certificate course, Coding Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Employer state and federal tax filings, preparing and reading the payroll register, and how to prepare the journal entry for payroll. You will also learn about payroll service companies and the benefits of outsourcing your payroll needs. IMPORTANT INFORMATION: *This class is included in the full certificate course, Mastering Payroll Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

This course covers all the basics of HTML coding language. You will learn building simple web pages by hand coding, using HTML tags to create paragraphs, heading, lists, links, insert images and tables and more. We also cover creating a simple multi-page website with images, text and a navigation bar.PREREQUISITE REQUIREMENT:-Students should have taken Introduction to Coding. IMPORTANT INFORMATION: *This class is included in the full certificate course, Coding Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Adobe InDesign is the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. This course is a comprehensive exploration of InDesign tools and capabilities to create professional documents. You will learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. TECHNOLOGY NOTE:-Access to Adobe InDesign software required. IMPORTANT INFORMATION: *This class is included in the full certificate course, Certificate in Mastering Computer Skills for the Workplace. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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 those 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. TECHNOLOGY NOTE: Students must have Microsoft Excel to complete this class. PREREQUISITE REQUIREMENT: -Students should have completed Mastering Microsoft Excel & Intermediate Excel. IMPORTANT INFORMATION:*This class is included in the full certificate course, Certificate in Mastering Excel. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

Move beyond individual prompts and learn how to build repeatable AI-assisted workflows for complex professional tasks. In this advanced course, you'll learn how to design effective AI workflows, create reusable prompt systems, manage larger projects and information sources, and establish quality-control processes that improve consistency and productivity. Through practical examples and hands-on activities, you'll develop strategies for integrating ChatGPT into ongoing work processes while maintaining appropriate human oversight and judgment.Prerequisite Recommendation: While not required, participants are encouraged to complete Introduction to ChatGPT & Intermediate ChatCPT before enrolling to maximize their success in this course. IMPORTANT INFORMATION:*This class is included in the full certificate course, AI ChatGPT Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.

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.TECHNOLOGY REQUIREMENTS:- Windows 10 or later. Macs are not compatible.- Necessary rights (local administrative rights) to install programs on the computer.Prerequisite Requirement: Students should have taken Introduction to SQL & Intermediate SQL and have competency in the Introductory and Intermediate levels of SQL. IMPORTANT INFORMATION:*This class is included in the full certificate course, SQL Certificate. If you would like to register for the full certificate course, please search the name of the course here.*A digital badge will be issued when the class has been completed.*LERN (Learning Resources Network) will send login information to the primary e-mail listed in your Arux account. Please update your email in Arux if you prefer to receive this login information to be sent to a different e-mail.