Excel logo 1.JPG

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