Learn new ways to consolidate, analyze, and report on data using Microsoft Office 2019/Office365. This course provides hands-on exercises and expert instruction to help you master analysis tools, conditional formatting, Power Query and other advanced features to better serve your company.
This course must be taken on a PC. It is not suitable for Mac users.
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 (not included in enrollment)
Note: The "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.
Adobe Flash Player. Click here to download the Flash Player.
Adobe Acrobat Reader. Click here to download the Acrobat Reader.
Software must be installed and fully operational before the course begins.
Email capabilities and access to a personal email account.
A basic understanding of Microsoft Excel's uses and functions or completion of Introduction to Microsoft Excel & Intermediate Microsoft Excel.
Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.
Kathy Van Pelt has taught computer courses at a community college for the past 25 years. She specializes in Microsoft Office applications, Google Drive and Google Applications, the Windows and Mac operating systems, and keyboarding. She spent seven years teaching word processing and business classes at a private business college and loves being in the ever-evolving educational field.