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 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
Course Section Add to Shopping Cart
Course: TECH 303-00
Term: 2178
Section Number: 1
Schedule Number: 2178TECH303
Instructor(s): Diana Adams
Location: Redfield Computer Room (TBA), 18600 Wedge Pkwy. Bldg. A
Dates: Dec. 5, 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 Campus is free.
Required Fees: Price
Registration$125.00
Course Section Add to Shopping Cart
Course: TECH 303-00
Term: 2182
Section Number: 1
Schedule Number: 2182TECH303
Instructor(s): Diana Adams
Location: Redfield Computer Room (TBA), 18600 Wedge Pkwy. Bldg. A
Dates: May 3, 2018 (Thu., 9 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 Campus is free.
Required Fees: Price
Registration$125.00
Course Section Add to Shopping Cart
Course: TECH 303-00
Term: 2185
Section Number: 1
Schedule Number: 2185TECH303
Instructor(s): Diana Adams
Location: Redfield Computer Room (TBA), 18600 Wedge Pkwy. Bldg. A
Dates: July 10, 2018 (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