This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.
Duration:
1 Day
Audience:
The class has been designed for users of Excel who have a basic knowledge of Excel.
Prerequisites:
Participants must have basic knowledge of entering data, formatting and simple formulas. Participants will need to be familiar with the topics covered in the Excel Introduction course.
Course Content:
- Tables Overview
- Table Structured Cell References
- Table Styles
- Table Options
- Table Slicers
- Converting Tables to Ranges
- Removing Duplicate Rows
- Range Names Overview
- Navigating Range Names
- Creating Range Names
- Creating Range Names in Bulk
- Assigning Range Names
- Using Range Names in Formulas
- Managing Range Names
- Functions Overview
- Functions vs Formulas
- Why Use Functions?
- NOW Function
- TODAY Function
- YEAR Function
- MONTH Function
- DATE Function
- DAYS Function
- SUM Function
- AVERAGE Function
- MIN Function
- MAX Function
- MEDIAN Function
- COUNT Function
- COUNTA Function
- COUNTBLANK Function
- CONCAT Function
- PROPER Function
- UPPER Function
- LOWER Function
- LEFT Function
- RIGHT Function
- MID Function
- TRIM Function
- LEN Function
- FIND Function
- SUBSTITUTE
- IF Function
- IFS Function
- Nested IFs Function
- AND Function
- OR Function
- COUNTIF Function
- COUNTIFS Function
- SUMIF Function
- SUMIFS Function
- AVERAGEIF Function
- AVERAGEIFS Function
- VLOOKUP Function
- HLOOKUP Function
- INDEX Function
- MATCH< Function
- Using Flash Fill
- Troubleshooting Flash Fill
- Limitations of Flash Fill
Bookings
This class is full. Bookings are closed for this class.