Skip to main content

EXCEL to the Max!

ID : 8421   
« back to classes page
Take your daily Excel journey to new heights resulting from a deeper dive into the many powerful and advanced features it has to offer. It is simply not enough to know the various features of Excel. An advanced user knows how to use Excel efficiently. Acquire the knowledge and skills associated with these under-utilized Excel features:
 
  • Advanced filter with function driven criteria and post results to different worksheet
  • Sort using conditional formatting, by columns, and by custom list
  • Consolidate
  • IF, SUMIF, COUNTIF, DATEDIF, AND OR, FIND LEN
  • VLOOKUP exact, VLOOKUP inexact
  • MATCH AND INDEX
  • Linked drop down lists
  • Pivot Tables – Creating and Modifying, Grouping by date or text, Calculated Field & Item, with Slicers, and Dashboard
  • Macros – Recording, Saving and Shortcuts, and Editing

Class Details

1 Sessions
Weekly - Wed

Location
LRC - Learning Resource Center

Instructor
Nancy Firebaugh 

CEUs : 0.4

Tuition: 

$69.00


Registration Closes On
Wednesday, March 25, 2020 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
3/25/2020 - 3/25/2020 Weekly - Wed 8:30 AM - 12:45 PM Abingdon, LRC - Learning Resource Center  Map, Room: LRC 227 Nancy Firebaugh