Excel & Excellence Basic to Advance
Please fill following information

Course Outline:
- Getting Start with Excel
- Basic Calculations
- Case Change
- Cell References relative & Absolute
- Join Text
- Text Apart
- Formula Bar
- Row, Columns, Cells
- Sheets, Zoom
- Hiding/Unhiding Columns/Rows
- Alignment
- Data Formation
- Format Painter
- Formatting Cell by fill & Border
- Formatting Cell by font
- Cell Margin
- Replace All
- Data Validation
- Find & Replace
- Paste Specials
- Case Change
- Freeze Panes
- Subtotal
- Data Summarizing
- Advanced Filter
- Filter Function
- Colour Filter
- Conditional Formatting
- Sum Function
- Consolidation
- SUM Product Function
- Accsending/Decsending
- Formate Table
- Dynamic Slice in Table
- Data Group/ Ungroup
- Working with Dynamic Formula
- Protect Sheet/ Unprotect Sheet
- Column Function
- Column Array Function
- Picture Reference
- Using Data Bars, Colors, Scales & Icon sets for great visual
- Dynamic Vlookup
- Hlookup
- IF functions
- Autofill options
- Flash Fill
- Nested IFO with other Functions
- Advance Analysis Tool & Reporting
- Using Data Bars, Colors, Scales & Icon sets for great visual
- Use of AND, OR, NOT
- Sumif, Sumifs
- CountIIFs And AverageIfs Functions
- Pivot Table
- Table, Slicer
- Average Value, Top/Bottom Analysis/Top/Bottom
- 3D Sum Function
- Concatenate
- Trim
Course Information
- Reg. Ends 25 November, 2022
- Start Date 26 November, 2022
- End Date 26 November, 2022
- Class Schedule 10:00AM to 6:00PM
- Total Hours 8 Hours
- Venue Title TBA