This course will teach you advanced techniques in this powerful database program, including importing Excel spreadsheets as tables, creating query calculations to crunch numbers, and using Visual Basic to automate common tasks. From building reports to using conditional formatting, this course will teach you how to best present your data with Access 2019. Software requirements: PC: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Access 2019, or a subscription to Office 365. Suggested prerequisite: A basic understanding of Microsoft Access objects and their use or completion of Access Introduction.

Every industry can benefit from the use of Microsoft Access to organize, store, and document their essential information. This course will teach you one of the most useful skills for both job seekers and those looking for promotion. Learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management. Software requirements: PC: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Access 2019, or a subscription to Office 365.

With nearly 90% of web traffic coming from search engines, the most important thing you can do to increase your web site's traffic is to increase your search engine ranking. Learn proven, step-by-step strategies to achieve the highest possible position with the major search engines. Prerequisite: Completion of the Introduction to WWW Authoring and XHTML course or equivalent HTML experience.

This course provides a foundation in a practical knowledge of blockchain. Beginning with an understanding of blockchain technology and its intended purpose, the course progresses into blockchain architecture. You will review the enterprise implementation and practical use of blockchain, such as in banking, healthcare and government applications. Throughout the course, you will also learn how blockchain evolved from its beginnings with cryptocurrencies and the role it plays in the trading, distribution, and other transactions that occur with cryptocurrency.

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. Software requirements: PC: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Excel, a subscription to Office 365, or Microsoft Office Home and Student 2019. Suggested prerequisite: Excel 2019 Intermediate or understanding of Microsoft Excel use and functions.

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, and 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. Software requirements: PC: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Excel, a subscription to Office 365, or Microsoft Office Home and Student 2019. Suggested prerequisite: Excel Introduction or basic understanding of Microsoft Excel uses and functions.

This course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. Software requirements: PC: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Excel, a subscription to Office 365, or Microsoft Office Home and Student 2019.

Get started with Google Workspace by learning the basics of nine key Google apps: Gmail, Docs, Sheets, Slides, Drive, Contacts, Calendar, Meet, and Chat.

This course will introduce students to various forms of artificial intelligence (AI) and how we interact with AI as consumers in applications like chatbots and recommendation engines. Students will see how AI provides analytics in business and consider industries that may be transformed or even disrupted by AI implementations. Includes review of neural networks, machine learning, AI applications such as natural language processing, forecasting, and robotics as well as the AI development process and some of the ethical factors in AI deployment.

Learn how to use Adobe InDesign CC software to create professional-quality letterhead, brochures, forms, e-books, business materials and more.

Learn the fundamentals of computer networking in terms you can easily understand; learn why networks have become so important, how software and hardware makes networking possible, and how networks function.

Learn why you are at risk and what you can do to protect your personal and business data from the outside world. This course will bring you up to speed on the fundamentals of PC and network security. You will understand and explore the vulnerability of operating systems, software, and networks; you will find out why, where and how viruses, worms, and blended threats are created; you will learn a safe way to handle files and data across the internet through a virtual private network. Suggested prerequisite: A familiarity with general computing terminology, an understanding of any operating system you are using (Mac, Windows, or Linux) and an ability to locate programs and change settings.

Covers typical hardware and operating system problems encountered by technicians and teaches troubleshooting techniques to decipher basic and more advanced problems. The course also shows how to maintain and optimize a Windows PC.

Manage emails, meetings, and to-do lists. Use Microsoft Outlook 2019 functions and you increase your efficiency and productivity.

You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes. Software requirements: Windows 10 operating systems. PowerPoint 2019 is not compatible with earlier Windows versions. Browser: the latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft PowerPoint, a subscription to Office 365, or Microsoft Office Home and Student 2019.

In this course, you will learn to use Windows 11, a powerful new operating system, including customizing your desktop, managing files and folders, and navigating the web with the latest Microsoft Edge browser.

Wireless networking is a hot topic. Learn how wireless devices make connections, how the connections actually work, and how you can plan, deploy, and connect to wireless networks yourself. Prerequisite: ITNW 5028 Introduction to Networking or equivalent experience.

Create professional-quality documents efficiently and effectively. This online course will teach you how to use Microsoft Word 2019, the widely-used word processing software by Microsoft Office/Office 365. Through hands-on lessons and modules, you will learn how to use a number of shortcuts and time-saving techniques to create complex documents, create and organize tables, manipulate graphics, and merge spreadsheets. Software requirements: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Word, a subscription to Office 365, or Microsoft Office Home and Student 2019. Suggested prerequisite: Word 2019 Introduction or basic familiarity with Microsoft Word's word processing and editing.

This course will introduce you to the 2019 version of Microsoft Word, available through the Office 365 online platform. You will learn the basics of Word 2019 needed to write and edit text and to create, format, and organize documents. By the time you're done with these hands-on activities, you will be able to use Word confidently at home or on the job. Software requirements: Windows 10 or later operating systems. Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible. Microsoft Word, a subscription to Office 365, or Microsoft Office Home and Student 2019.