Microsoft Excel 2019 and Microsoft Access 2019 are two of the most used programs to track and manage data sets. This course will teach you how use Microsoft Excel 2019 and Microsoft Access 2019.
Introduction to Microsoft Excel 2019
Learn to quickly and efficiently use Microsoft Excel 2019/Office 365 as you discover dozens of shortcuts and tricks for setting up fully formatted worksheets. This course, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.
Intermediate Microsoft Excel 2019
Master new skills and harness the power of Excel to become a power user. This hands-on course provides in-depth knowledge of charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2019/Office 365 functions.
Introduction to Microsoft Access 2019/Office 365
Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job.
Intermediate Microsoft Access 2019/Office 365
Develop a fully functional database in this hands-on Microsoft Access 2019/Office 365 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch.
Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.
Introduction to Microsoft Excel 2019/Office 365
Intermediate Microsoft Excel 2019/Office 365
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.
Laurie Ulrich has been writing about and teaching people to use Microsoft Office for more than 20 years—including personally training thousands of students, writing hundreds of training manuals, and authoring and co-authoring more than 30 books on subjects including Word, Excel, PowerPoint, Outlook, and Access. Her books include 2000-page epics that document every button, bell, and whistle, as well as friendlier introductory and troubleshooting books for new users. Her most recent publication on Microsoft Access is Access 2016 for Dummies. In addition to writing and teaching, Laurie runs her own firm, Limehat & Company, providing training, marketing, graphic design, and web development services to clients throughout the world, with a focus on helping growing companies and non-profit organizations build their brand through effective promotions, outreach, and education.
Ken Cook has managed his own successful computer consulting business since 1990. He began as a trainer, instructing numerous users on a variety of software packages, specializing in Microsoft Office. Currently, his main focus is creating expert Microsoft Office solutions, Microsoft Access database solutions, and Microsoft SQL Server solutions for Fortune 500 and small business clients. He is also co-author of four "Access for Dummies" books.