Aradhana Institute of Education | Free Computer Education | Computer Institute in Dadri | Computer Institute in Greater Noida | Computer Institute in Noida

₹1,500 ₹2,500

Certificate in Advance Excel

Interface: Ribbon, tabs, worksheets, cells, Name Box, Quick Access Toolbar.
Data Entry & Navigation: Entering text/numbers, moving, copying, cutting, pasting, undo/redo.
Formulas & Functions: Basic arithmetic (+, -, *, /), SUM, AVERAGE, MIN, MAX, COUNT, AutoFill, Flash Fill.
Formatting: Fonts, alignment, number formats (currency, date, percentage), borders, colors, Conditional Formatting (basic rules).
Worksheet Management: Adding, deleting, renaming, moving, hiding worksheets; freezing panes.
Data Management: Sorting (A-Z, Z-A), Filtering data, Remove Duplicates.
Cell Referencing: Relative, Absolute
Advanced Functions: IF, AND, OR, NOT, IFERROR, Text functions (LEFT, RIGHT, MID, TRIM, CONCATENATE), Date/Time functions.
Data Validation: Creating dropdown lists, custom rules.
Charts: Creating and customizing Bar, Line, Pie charts; Primary/Secondary Axes.
Tables: Creating Excel Tables, Table Styles, Table Design features.
Lookup Functions: VLOOKUP, HLOOKUP, INDEX, MATCH, Nested VLOOKUP, Reverse Lookups.
PivotTables & PivotCharts: Creating, formatting, grouping, calculated fields/items, Slicers, Timelines.