Microsoft Excel Advanced

Description:

Primary Topics Covered:

  • Using Excel Advanced Tools
  • Advanced Functions
  • Advanced Sort and Filter Options
  • Using Pivot Tables and Charts

Excel Advanced builds on what you learned in Intermediate. This class is for those already comfortable with formulas, the basics of charting, and managing data lists. We’ll spend six hours digging deeper into the possibilities of Excel. You’ll learn to link cells, sheets and workbooks using both 3-D formulas and Functions, as well as built in tools for consolidating data. The course will provide the opportunity to view large amounts of data using PivotTables and Charts for understandable reports. You’ll see how easy it is to drill down to just the data you need, filtering out the unimportant data.

Knowledge, skills and experience required for this course:

  • Excel Intermediate prerequisites
  • Ability to create formulas including those that use functions such as IF and VLOOKUP
  • Familiarity with data management tools such as sort and filter
  • Basic understanding of charts
Course Section
Course: TECH 303-00
Term: 2172
Section Number: 1
Schedule Number: 2172TECH303
Instructor(s): Diana Adams
Location: Redfield Campus, Redfield Campus RM 110
Dates: May 2, 2017 (Tue., 8:30 a.m. - 3:30 p.m.)
Units: Non-Credit
Contact Hours: 6.0 Contact Hours
Notes: Fee includes tuition and course materials. Parking at Redfield is free.
Required Fees: Price
Registration$125.00
Course Section Add to Shopping Cart
Course: TECH 303-00
Term: 2175
Section Number: 1
Schedule Number: 2175TECH303
Instructor(s): Diana Adams
Location: Redfield Campus, Redfield Campus RM 110
Dates: July 11, 2017 (Tue., 8:30 a.m. - 3:30 p.m.)
Units: Non-Credit
Contact Hours: 6.0 Contact Hours
Notes: Fee includes tuition and course materials. Parking at Redfield is free.
Required Fees: Price
Registration$125.00