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.
Access 2019 Introduction
Course Code: ITSX-3053
Program Area: Computer Science & Information Technology
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.
Word 2019 Intermediate
Course Code: POFX-3042
Program Area: Computer Science & Information Technology
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.
Software Development Bootcamp Prep Course
Course Code: ITSX-3066
Program Area: Computer Science & Information Technology
Interested in making a career change to Software Development The Austin Community College Software Development Bootcamp and is an excellent choice for building skills in the high demand areas of software development. The ACC bootcamp covers Full stack Javascript Software, Git, and many more technologies.
In order to get prepared for the Bootcamp, ACC is offering a Bootcamp Prep Course. In this prep course, you will work on essential computer and math skills. This 2 week long course will help navigate the rigor of the Bootcamp.
Bootcamp Prep Course includes:
-Familiarity with web technologies: HTML
-Simple programming concepts using online gaming environments like MIT Scratch
-Use of computer tools including: Linux Command Line, Git/Github, Visual Studio Code
-Familiarity with your computer's operating system, including Windows 10, Windows Subsystem Linux and Mac OSX
-Refresh of basic math and logic skills that would help you get ready for a career in technology
PowerPoint 2019 Introduction
Course Code: ITSX-3037
Program Area: Computer Science & Information Technology
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.
Word 2019 Introduction
Course Code: POFX-3024
Program Area: Computer Science & Information Technology
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.
Excel 2019 Advanced
Course Code: ITSX-3049
Program Area: Computer Science & Information Technology
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.
Excel 2019 Introduction
Course Code: ITSX-3012
Program Area: Computer Science & Information Technology
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.
