Excel Advanced Skills

As a student, you will: 

•  Employ built-in cell style templates, or produce a custom one, to streamline the data entry process
• Create a drop-down list to restrict data entry values
• Utilize the Conditional formatting feature to apply formats to a cell or a range of cells based on specific criteria
• Organize worksheet data using the Group Function
• Use the Consolidation Function to combine data from several worksheets into one
• Differentiate between and discern when to use a relative or an absolute reference in a formula
• Change the orientation of an array of data using the Transpose function
•  Use the Advanced filter Extract data from a data set based on complex criteria using the Advanced Filter tool
• Analyze data using Pivot Tables
• Calculate data across several worksheets with the same structure using a 3D reference
• Perform partial searches when filtering or analyzing data using wildcard characters

Who Should Enroll?

• Adult learners who already has a solid understanding of Excel's basic tools and functions and wants to learn more advanced skills and functions.