Microsoft Excel - Level 2 / Med (2010, 2013, 2016)
Learn how to use formulas and advanced functions, create and format tables and protect and finalize a workbook.
GK# 7125
Learn how to use formulas and advanced functions, create and format tables and protect and finalize a workbook.
GK# 7125
This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook.
Items marked with an asterisk* are taught for 2010 only.
Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel- Level 2 2010, Microsoft Excel- Level 2 2013, or Microsoft Excel Level 2 2016.
Upon successful completion of this course, you will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions. You will work with functions and lists, create advanced formulas, protect your spreadsheets and work with custom view.
Use Tables
Formulas and Functions
Sort and Filter
Enhance A Workbook
Protect and Finalize
Views
The prerequisites for this course is an introductory Excel course, or equivalent working knowledge of the software.
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Learn advanced features of Excel such as PivotTables and macros with one of our advanced Excel courses.
This Office course comes with extended access to the following benefits:
This course is available in the following formats:
Receive face-to-face instruction at one of our training center locations.
Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.