Excel Fundamentals

igmGuru’s Excel Fundamentals program takes you step-by-step from understanding spreadsheet basics to creating business-ready reports and dashboards. You start with interface navigation, data entry, formatting, and core formulas. Then you move into functions, logical operations, lookups, pivot tables, charts, and data validation. At the advanced stage, you work with automation, dashboards, data cleaning, and performance optimization.

Prerequisites

• Basic computer knowledge
• Familiarity with the Windows environment
• No prior Excel experience required

What Will You Learn

• Excel interface and ribbon navigation
• Workbook and worksheet management
• Data entry, formatting, sorting, and filtering
• Formulas and arithmetic operations
• Logical functions, including IF and nested IF
• Lookup functions such as VLOOKUP, HLOOKUP, and XLOOKUP
• Text, date, and financial functions
• Conditional formatting and data validation
• Pivot Tables and Pivot Charts
• Dashboard creation and dynamic reporting
• Data cleaning and Power Query basics
• What-if analysis and performance optimization
• Real-world business reporting project