Skip to main content

Microsoft Excel 2016 Series

ID : 25293   
« back to classes page
Each course within the Excel Series will build upon the last, giving you expert knowledge in navigating and using the software.
Introduction to Microsoft Excel 2016; In this comprehensive online course, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll learn the secrets behind writing powerful formulas, using functions, sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links, and creating macros and custom toolbar buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.
Intermediate Microsoft Excel 2016; In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016. Harness the power of Excel's data analysis tools and AutoFilter commands, and see how easy it is to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.
Advanced Microsoft Excel 2016; Maximize your investment in Microsoft Excel 2016 by mastering advanced features that most users don't even know exist. In this course, you'll discover how to use scenarios and data tables to quickly perform multiple what-if data analysis. You'll discover a variety of advanced techniques for PivotTables, and see how to work with the additional analysis tools provided by Excel add-ins. You'll master the art of conditional formatting to highlight duplicate entries, become adept at importing external data using Excel’s built-in Power Query tool, learn how use Excel's consolidation function to efficiently summarize data from multiple sources, and so much more.
Series bundles are not eligible for partial drops or refunds. Transfers are available to other open sessions. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Click here for class start dates, syllabus, requirements and student reviews.

Class Details

0 Sessions

Start Date:upon registration

 

Notice

Please read:  BSC has partnered with Ed2Go, one of the industry leaders in online learning for adults, to provide this online class. Most Ed2Go classes start either the 2nd or 3rd Wednesday of each month. All registrations after the class start date will be enrolled in the next month’s class session.

These six-week online instructor-led courses are the perfect way to learn a new skill or enhance your existing ones. You'll spend roughly two to four hours each week completing two engaging lessons in an enjoyable, interactive learning environment. Expert instructors develop and lead every course, and you'll be able to interact with them and with fellow students in online discussion areas. Upon completing a course with a passing score, you'll get an award of completion.

Fee: 

$324.00


Registration Closes On
Monday, June 30, 2025 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)