Topic outline

• How to join the Interactive Live Session?

  Collapse all Expand all

  Once you've entered the required information, click on the link below (visible after registration) & "Join" or "Enter" button. This will take you to the virtual meeting room. "Join Session" button will appear when session starts. 
  

• Module 1: Introduction to Microsoft Excel and Basic Spreadsheet Operations

  • Introduction to Microsoft Excel interface and navigation
  • Understanding cells, rows, and columns
  • Basic data entry and editing techniques
  • Introduction to basic formulas and functions
  • Formatting cells and data

  
  

• Module 2: Working with Data and Worksheets

  • Sorting and filtering data
  • Using basic data analysis tools
  • Managing worksheets and workbooks
  • Introduction to charts and graphs
  • Creating and formatting charts

  
  

• Module 3: Advanced Formulas and Functions

  • Working with logical functions (IF, AND, OR)
  • Using lookup functions (VLOOKUP, HLOOKUP)
  • Understanding and applying financial functions
  • Introduction to statistical functions
  • Practice exercises on advanced formulas and functions

  
  

• Module 4: Data Analysis and Reporting

  • PivotTables: Creating and analyzing data
  • Introduction to PivotCharts
  • Generating reports using Excel features
  • Introduction to Power Query for data analysis
  • Combining data from multiple sources using Power Query

  
  

• Module 5: Data Validation and Protection

  • Setting up data validation rules
  • Protecting worksheets and workbooks
  • Advanced data validation techniques
  • Protecting specific cells and ranges
  • Practice exercises on data validation and protection

  
  

• Module 6: Advanced Formatting and Customization

  • Using advanced formatting options
  • Customizing Excel with themes and templates
  • Creating custom number formats
  • Working with conditional formatting
  • Practice exercises on formatting and customization

  
  

• Module 7: Mid-Term Exam

• Module 8: Collaboration and Sharing

  • Sharing workbooks and collaborating with others
  • Tracking changes and comments
  • Using Excel in real-time collaboration environments
  • Introduction to Excel Online
  • Practice exercises on collaboration and sharing

  
  

• Module 9: Macros and Automation

  • Introduction to macros and VBA (Visual Basic for Applications)
  • Recording and running simple macros
  • Editing and debugging macros
  • Introduction to automation with Excel
  • Practice exercises on macros and automation

  
  

• Module 10: Advanced Data Analysis Techniques

  • Using advanced statistical functions
  • Performing sensitivity analysis
  • Introduction to scenario manager
  • Performing what-if analysis
  • Practice exercises on advanced data analysis techniques

  
  

• Module 11: Financial Modeling and Analysis

  • Introduction to financial modeling
  • Building financial models in Excel
  • Valuation techniques using Excel
  • Risk analysis and Monte Carlo simulation
  • Practice exercises on financial modeling and analysis

  
  

• Module 12: Project Management with Excel

  • Creating Gantt charts in Excel
  • Resource allocation and tracking
  • Critical path analysis
  • Project status reporting
  • Practice exercises on project management with Excel

  
  

• Module 13: Review and Final Project

  • Review of key concepts and techniques
  • Final project assignment briefing
  • Working on the final project
  • Final project presentation and evaluation
  • Course review, feedback, and certification

  
  

• Module 14: Final Exam