Microsoft Excel 2016: (B) Managing and Enhancing Workbooks - EOD

Back to List

Course: 2112887 - Microsoft Excel 2016: (B) Managing and Enhancing Workbooks - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more useful features of Microsoft Excel and spreadsheets to create and manage large workbooks, freeze and hide rows and columns, work with ranges, and protect files. Find out how to use functions to format text, work with styles and themes, add and delete watermarks, outline and consolidate data, create subtotals, as well as sort and filter data. Discover how to insert graphic objects. Table and chart creation and template use will also be covered.

Prerequisites

Course Outline

  • Formatting Worksheet Tabs
  • Manage Worksheet References in Formulas
  • Grouping, Repositioning, Inserting, and Deleting Worksheets
  • Hiding and Un-hiding Worksheets
  • Splitting, Freezing Panes, and Arranging
  • Applying and Editing Range Names
  • Using Range Names in Formulas
  • Using Specialized Functions
  • Using Nested Functions
  • Using Automatic Workbook Calculations
  • Enabling Iterative Calculations
  • Creating and Modifying Tables
  • Sorting and Filtering Data
  • Removing Duplicate Values
  • Using Subtotal and Database Functions to Calculate Data
  • Customizing Workbooks with Comments, Hyperlinks, Watermarks, and Background Pictures
  • Managing and Customizing Themes
  • Creating and Using Templates
  • Protecting Files
  • Preparing Workbooks for Multiple Audiences
  • Inserting Charts
  • Inserting and Modify Graphic Objects (Shapes, WordArt, Text Boxes, Images, and SmartArt)
  • Layering and Grouping Graphic Objects
Course Type: In Classroom
CEU: 0.60
Sections:
Section#: 4276
Section Meeting Dates and Times:
8/15/2017: 8:30 AM - 11:30 AM
8/16/2017: 8:30 AM - 11:30 AM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:


Section#: 4462
Section Meeting Dates and Times:
9/20/2017: 1:30 PM - 4:30 PM
9/21/2017: 1:30 PM - 4:30 PM

Location:
Suite 2201 - Lab 2202
General Services Complex (GSC)
750 Agronomy Rd.
Description:

Category: Technology Training - Spreadsheets

Register and View Schedule

Add to Course Waitlist