
Microsoft Excel Intermediate
Currently no public class is available but private class can be arranged
Duration: 1 or 2 days
Upon completion of this program, participants should be able to:
• Create simple to complex formulas and functions, like:
o COUNTA & COUNTIFS Function
o AVERAGEA &AVERAGEIFS Function
o SUMIF & SUMIFS Function
o IF Functions
o Nested Functions
o Database Function
• Validate data in a Worksheet
Filter data using Auto & Advanced Filters
• Advanced Chart Formatting
• Clean Duplicate Records
• Visualizing Data as a Graphics