Microsoft Excel and Access 2019 Suite

Microsoft Excel and Access 2019 Suite

Master the use of two of the most widely used data management programs in the world when you complete the Microsoft Excel and Access 2019 Suite. Discover dozens of shortcuts and tricks that can help you become more efficient, build a fully functional database, and learn some of the more advanced features that will have you using Microsoft Excel and Access like a pro.  
96 Course Hrs
  • Details
  • Syllabus
  • Requirements
  • Instructor

Details

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.

Enrollment Options:
Instructor-Led
Course Code: B14143
Start Dates*Oct 13 | Nov 17 | Dec 15 | Jan 12
*Choose start date in cart
$495.00 USD

Syllabus

Introduction to Microsoft Excel 2019/Office 365

  1. Excel Basics
  2. Creating a Worksheet
  3. TimeSavers
  4. Relative, Absolute, Mixed, and Circular References
  5. 3Dimensional Workbooks
  6. Sorting, Subtotaling, and Filtering
  7. Charting Basics
  8. Advanced Charting Techniques
  9. Intro to Excel's Statistical Functions
  10. Financial Functions
  11. Worksheet Automation
  12. Mastering Excel's IF Function

Intermediate Microsoft Excel 2019/Office 365

  1. Excel Charts and Graphs
  2. More Excel Charts
  3. AutoFilter and Sorting
  4. Goal Seeking
  5. Pivot Tables
  6. Advanced PivotTables
  7. Solver
  8. Sparklines
  9. Macros
  10. Introduction to Functions
  11. Math/Trig Functions
  12. VLOOKUP, INDEX, and MATCH Functions

Introduction to Microsoft Access 2019/Office 365

  1. Getting to Know Access 2019
  2. Controlling Your Access Table Fields
  3. Creating Tables and Relationships
  4. Building Powerful Forms
  5. Adding Versatility to Forms
  6. Interviewing Your Database
  7. Taking Queries to the Next Level
  8. MultiTable Query Control
  9. Reporting on Your Tables
  10. Creating QueryBased Reports
  11. Mastering Report Design
  12. Automating Your Database With Macros

Intermediate Microsoft Access 2019/Office 365

  1. Reviewing Terms and Importing Data
  2. Key Fields and Action Queries
  3. Relationships of the Database Kind
  4. Creating and Modifying Forms
  5. Subforms and the Tab Control
  6. Queries
  7. Query Calculations
  8. Summary Queries
  9. Building Reports That Pinpoint Key Information
  10. Run Reports from a Custom Dialog Box
  11. Using Visual Basic to Automate the Reports Dialog Box
  12. Putting It All Together

Requirements

There are no prerequisites to take this course.


Hardware Requirements:

  • This course must be taken on a PC. Macs are not compatible.

Software Requirements:

  • PC: Windows 10 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
  • Adobe Acrobat Reader.
  • Software must be installed and fully operational before the course begins.
  • Microsoft Access 2019 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019.
  • Microsoft Excel 2019 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional 2019.
  • *Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.

Other:

  • Email capabilities and access to a personal email account.

Instructional Material Requirements:

The instructional materials required for this course are included in enrollment and will be available online.

Instructor

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.