Mastering Worksheet (SEC-01 option A)

Introduction to Excel & Basics Formatting

8 topics

• Features of MS Excel, Excel Interface (Ribbon, Tabs, Groups), Workbook & Worksheet, Rows, Columns, Cells
• Data Types (Text, Number, Date)
• Basic Formatting (Font, Alignment, Borders)
• Saving & Opening Files, Excel Environment & Navigation, Custom Number Formatting
• Format as Table
• Cell Styles & Themes, Freeze Panes & Split Window, Page Layout & Printing Settings
• Headers & Footers
• Excel Shortcuts (Productivity Tips)

Advanced Formulas, Functions, Chart and Data Analysis

13 topics

• Cell Referencing (Relative, Absolute, Mixed)
• Basic Functions: SUM, AVERAGE, COUNT, MAX, MIN
• Logical Functions: IF, AND, OR, NOT, TRUE, FALSE
• Text Functions: LEFT, RIGHT, MID, CONCAT, LEN
• IFERROR
• Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
• Financial Functions: PMT, NPV
• Date & Time Functions: TODAY, NOW, DATEDIF
• Sorting & Filtering, Data Validation (Drop-down List)
• Conditional Formatting (Color Scale, Icon Sets), Remove Duplicates
• Pivot Tables, Subtotal Feature, Slicers & Timeline, Data Consolidation, Flash Fill
• Chart Types: Column, Bar, Line, Pie; Advanced: Combo, Waterfall, Radar
• Creating Interactive Dashboards, KPI Reports, Sparklines

Automation & Advanced Tools

6 topics

• Macro Recording
• Introduction to VBA Editor, Basic VBA Concepts
• What-If Analysis: Goal Seek, Scenario Manager, Data Table
• Power Query (Introduction)
• Power Pivot (Basic Concept)
• Workbook Security & Protection

Study this subject

Every topic above is a lesson you can read here, in English, Hindi or Gujarati. In Gri-Learn the same topics are graded decks: the self-checks are scored and your weak topics are tracked. Free, with nothing locked.

Already have an account? Sign in