Certificate in Advance Excel
Courses Module
- Overview of the Basic Excel
- Working with functions-Writing conditional expressions (using IF) ~ Using logical functions (AND, OR, NOT),Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX),Using VLookUP to consolidate Data from Multiple Sheets
- Data Validations-~ Specifying a valid range of values for a cell ~ Specifying a list of valid values for a cell ~ Specifying custom validations based on formula for a cell
- Working with Templates-~ Designing the structure of a template ~ Using templates for standardization of worksheets
- Sorting and Filtering Data-~ Sorting tables ~ Using multiple-level sorting ~ Using custom sorting ~ Filtering data for selected view (AutoFilter) ~ Using advanced filter options
- Working with Reports-~ Creating subtotals ~ Multiple-level subtotals ~ Creating Pivot tables ~ Formatting and customizing Pivot tables ~ Using advanced options of Pivot tables ~ Pivot charts
- More Functions-~ Date and time functions ~ Text functions ~ Database functions ~ Power Functions (CountIf, CountIFS, SumIF, SumIfS)
- Formatting ~ Using auto formatting option for worksheets ~ Using conditional formatting option for rows, columns and cells
Course Fees
10,500 + 18% GST
Course Duration
150 Hrs.