Professional Development Center of Glendale Community College

Click to call. 8189570024

THE PDC OF GLENDALE COMMUNITY COLLEGE

The PDC Creates Custom Training Programs that Address ALL of Your Company's Training Needs.

Length

12 weeks
1 session per week
4 hours per session
48 total class hours


Audience

This course is designed for any individual interested in increasing their knowledge and proficiency with Excel 2013, students transitioning from Excel 2003/2010,  and anyone wishing to move their Excel skills to a higher level.


Recommended Prerequisites

Prospective students should be familiar with basic computer terminology, be proficient with the use of the mouse and keyboard, and have at least 6 months experience using Microsoft Excel. Participants should understand basic mathematical principles.


Topic

2007 /2010 to 2013 Skills Migration

  1. Learning the new 2013 interface. How to adapt what we know about 2007/2010 into 2013.
  2. A tool that maps 2013 commands to 2007/2010 will be given to class members.
  3. Shortcut keys for navigating the new ribbon interface will be discussed and practiced.

Range Names, Lists, and String Functions

  1. Use of range names for navigation, formula simplification, and using range name constants.
  2. 2013 range name scopes will be discussed.
  3. Use of the new Names Manager.  MID, LEFT, RIGHT, CONCATENATE, TRANSPOSE.

Functions

  1. SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS.
  2. Nesting functions.
  3. Various LOOKUP functions will be discussed.
  4. Combined with the previous weeks named range concept and a new “list” tool, participants obtain a useful and commonly used skill set.

PivotTables and PivotCharts

  1. PivotTables and PivotCharts with emphasis on the differences in 2013.
  2. Formatting options, including the use of the new conditional formatting features.
  3. More PivotTables and PivotCharts.

Data Management

  1. Proper data design principles.
  2. Adding, deleting records, sorting, filtering data.
  3. Advanced querying, Outlining, Data Tables.

Charting

  1. Explore the new charting features in Excel 2013. Some emphasis on using Excel charts in PowerPoint presentations.
  2. Linking charts to PowerPoint presentations.

Managing Multi-Sheet Workbook

  1. Using multi-sheet and multi-book formulas.  3D formulas and linking.  Array functions.

Excel Macros

  1. Learn the process of recording “keystroke” macros and analyzing the results.
  2. Learn to modify and enhance the recorded macros.
  3. Create macros from scratch.

Review


Employee Application Company Application

  • Class Selection

    Please fill out our form for more information and to be contacted by school representatives.

  • This field is for validation purposes and should be left unchanged.
JOIN OUR MAILING LIST
OUR PROGRAMS
CONTACT US
PDC BROCHURE
uxicached