Microsoft Office Applications
 |
 |
|
| Introduction - 2016 (Online) | ||
| Intermediate - 2016 (Online) | ||
| Advanced - 2016 (Online) | ||
| Microsoft Office Specialist (MOS) Excel Certification | MOS Digital Badges |
We offer Microsoft Office 2013 , 2016 and 2019 group training. Contact Holly Beck at 215-504-8533 or holly.beck@bucks.edu
The following course sections are not part of the group training program, and are open to all students.
WCOAP 1580
MICROSOFT EXCEL 2019® BASIC (12 HRS) WCOAP 1580
This course will familiarize you with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2019, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, you will learn the basics of entering and editing text, values, and formulas, and how to save workbooks in the native Excel format, as well as in other formats. You will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. You will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. You will create and modify charts, and work with graphics. Finally, you will review workbooks for spelling errors, modify page setup, and print worksheets. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2019 (exam). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. the instructor will provide an online test preparation application for this course.
Textbook: Excel 2019 Level 1, Student Manual EXEL 2019-L1-R10-S
WCOAP 1581
MICROSOFT EXCEL 2019® INTERMEDIATE (12 HRS, CPA) WCOAP 1581
This course will teach you how to work with large worksheets in Microsoft Excel 2019, and use multiple worksheets and workbooks efficiently. It will introduce you to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, you will learn how to create outlines and subtotals, and how to create and apply cell names. You will sort and filter data, and create and format tables. You will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. You will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, you will customize the Excel environment, and create and modify custom templates. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2019 (exam). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. The instructor will provide an online test preparation application for this course. For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019.
Textbook: Excel 2019 Level 2, Student Manual EXEL 2019-L2-R10-S.
WCOAP 1582
MICROSOFT EXCEL 2019® ADVANCED (12 HRS, CPA) WCOAP 1582
In this course, you will further build on the skills acquired in the Microsoft Excel 2019 Basic and Intermediate courses. You will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation, and will use advanced data filtering. You will apply advanced chart formatting options, and create more complex charts. You will work with PivotTables and PivotCharts, export and import data, and query external databases. You will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, you will run and record macros, and explore VBA code. This course will help you prepare for the Microsoft Office Specialist core-level exam for Excel 2019 (exam). For comprehensive certification training, you should complete the Basic, Intermediate, and Advanced courses for Excel 2019. The instructor will provide an online test preparation application for this course.
Textbook: Excel 2019 Level 3, Student Manual EXEL2019-L3-R10-S.
WCOAP 1596
DATA ANALYSIS WITH MICROSOFT EXCEL 2019 PIVOT TABLES (4 HRS) WCOAP 1596
Students taking this course are looking to advance their data analysis capabilities.Upon successful completion of this course students will be able to use Excel 2019 advanced Pivot Table Functionality to analyze their raw data. They will be able to prepare data for Pivot Table reporting, create Pivot Tables from various data sources, analyze data using Pivot Tables and work with Pivot Charts.
Textbook: Microsoft Office Excel 2016/2019: Data Analysis with Power Pivot, Part number 091066S
Microsoft Office Specialist Excel Certification
Microsoft Office Certifications are administered through Certiport, a leading provider in certification exams. Buck's is a Certiport Authorized Testing Center offering test candidates certification exams for Microsoft Office Specialist®. Test candidates are required to purchase a voucher from certiport.com and pay a $25 per exam administration fee to the College. To schedule an exam, email Jim Nasta at james.nasta@bucks.edu. For more information, please visit www.certiport.com or call 1-888-999-9830.
Certiport's Excel certification program gives testing candidates practical, performance-based scenarios to gauge their real-world capabilities with project and standards-based outcome testing.
Certification candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.
To make the exam more helpful, we've replaced individual tasks with comprehensive, project-based testing. This live-in-the-application environment confirms that certified individuals have demonstrated the ability to complete a realistic Microsoft Office Specialist Excel project.
Exam objectives
Excel 2019
Download Exam Objectives Excel 2019
Download Exam Objectives Excel Expert 2019
Excel 2013
Excel Expert 2013
- Download exam objectives Part 1 for Excel Expert 2013
- Download exam objectives Part 2 for Excel Expert 2013