Course Details
Advanced Excel + MS-Access
Designed for learners who want stronger spreadsheet, reporting, and dashboard skills.
Duration: Flexible Learning
Mode: Online Classes
Language: Hindi + English
Support: WhatsApp Help
Quiz Discount
Play Quiz For Discount On Course
Advanced Excel + MS-Access Content List
- Excel Structure
- Cell Properties
- Autofill Basic to Advance
- Flash Fill
- Operators Based Equation
- Math Function
- Text Function (Basic to Advance)
- Workbook Protect
- Protect Sheet
- Hide Formulas and Locked Cells
- Protect File With Password
- IF Function (Basic to Advance)
- AND, OR, IF Function
- XOR Function
- Pivot Table (Basic to Advance)
- Goal Seek
- Scenario Manager
- PMT (EMI Calculator)
- Data Table
- Pduration Function
- Print Option (Basic to Advance)
- Draw Tab
- Chart Preparation (Basic to Advance)
- Power Map in Excel
- Quick Analysis
- Filter (Basic to Advance)
- Sorting
- Group Ungroup and Subtotal
- Conditional Formatting (Basic to Advance)
- Data Validation
- Advance Math Function
- VLOOKUP (Basic to Advance)
- HLOOKUP (Basic to Advance)
- Index and Match Function
- Date and Time Function
- Macro Recording