Certificate In Advance Excel

Certificate in Advance Excel is offered by Certified Institute For Accounting (CIA). The main purpose of CIA ( Softango Education Pvt. Ltd) is to develop a new education environment especially in computer along with account filling the skill and demand gap.

Course 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