Skip to main content

Microsoft Excel - Level 2

ID : 41126   
« back to classes page
This course is designed for intermediate to advanced users, as it takes learners beyond the basics. Learn tips and tricks for advanced database functions such as pivot tables, absolute references, linked workbooks and more in this one day workshop.
Database Functions
  • Work with Basic and Advanced Sorting
  • Learn Rules for Setting up a Database Area
  • Learn to Sort by Color or Icon Sets
  • Learn to Use Custom List When Sorting
  • Basics and Advanced Filtering
Database Functions (continued)
  • Pivot Tables
  • Use the New Table Feature
  • Use the New Remove Duplicates Feature
  • Learn to Separate Text Using Text to Columns
Understand Absolute References
  • Work with relative and absolute references
  • Create and use Absolute References
  • Create and use Named Ranges
Advanced Formulas
  • Using Insert Functions Dialog box
  • Understanding Basic Functions like SUM, AVERAGE, COUNT
  • Using the IF Function
  • Working with Vlookup
Other Functions
  • Working with Dates
  • The Now Function
  • The Today Function
  • Text Functions

Class Details

1 Session(s)
Weekly - Tue

Larry Hanna Training & Outreach Facility

Darla Cloud 



Registration Closes On
Tuesday, May 21, 2024 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s) Instructional Method
5/28/2024 - 5/28/2024 Weekly - Tue 08:30 AM - 04:30 PM Hobbs, Larry Hanna Training & Outreach Facility  Map Darla Cloud  ClassRoom