Loading...

EXCL2: Microsoft Excel – Level 2/Med (2010, 2013, 2016)

Home / EXCL2: Microsoft Excel – Level 2/Med (2010, 2013, 2016)

This course teaches students some of the higher-level functionality in Excel to analyze and present data. Students will learn how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize their work. Students will also learn to work with functions and lists, create advanced formulas, and work with the custom view. Students will be able to leverage the power of data calculations and presentation in order to make informed, intelligent organizational decisions.

Course Length: 1 day(s)

Course Price: $275 CAD

Available Course Formats:

  • In-class
  • Instructor Led Online

Enroll Now

Course: EXCL2: Microsoft Excel – Level 2/Med (2010, 2013, 2016)

  • Use Tables
    • Create a Table From Data
    • Modify Table Format and Structure
    • Use Structured References in a Table
  • Formulas and Functions
    • Understand Mathematical Operators
    • Use AutoFunctions
    • Use Relative and Absolute References
    • Explore the Function Ribbon and Overview of Categories
    • Use the Insert Function Wizard and Dialog Box
    • Use Basic Text, Financial, Date, and Logical Functions
    • Name and Use Ranges of Cells in Formulas
    • Use Array Formulas
    • Audit Formulas
    • Trace and Remove Trace Arrows
    • Use a Watch Window
  • Sort and Filter
    • Use Basic Sort Options
    • Advanced Sort Options
    • Use Autofilters
    • Create Custom Autofilters
    • Use Advanced Filters
    • Use Data Validation
    • Use Database Functions
  • Enhance A Workbook
    • Insert Symbols and Characters
    • Add and Format Shapes
    • Manipulate Shapes
    • Use and Modify SmartArt
    • Add a Signature Line
    • Add and Format Text Boxes and WordArt
    • Use Screenshot
    • Link and Embed Objects
  • Protect and Finalize
    • Add Protection
    • Allow Edit Options within Protection
    • Info Panel Options*
    • Share Panel Options*
    • Use the Document Inspector
    • Check Compatibility and Mark as Final
    • Customize Excel Options
  • Views
    • Create Custom Views
    • Hide Workbooks, Sheets and Cells
    • Set File Properties
      *2010 version only

Audience

The course is designed for students who already have the foundational knowledge and skills in Excel.

Prerequisites

EXCL1: Microsoft Excel - Level 1 / Intro (2010, 2013, 2016) or equivalent experience

Instructor Led In Classroom

Newcomp can directly deliver courses through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.