Introduction
  • Introduction
Spreadsheet Navigation & Formatting
  • Mastering the Interface: Learn to navigate menus, ribbons, and toolbars
  • Formatting Fundamentals: Discover how to format cells, rows, and columns
  • Data Entry & Editing: Quickly input and edit data, using shortcuts and technique
  • Quiz
Essential Formulas & Functions
  • Arithmetic Power: Master basic formulas like SUM, AVERAGE, and COUNT
  • Logical Lookups: Leverage VLOOKUP to find specific data
  • Date & Time Functions: Manipulate dates and times with ease
  • Logical Function: Using the IF function
Data Analysis & Visualization
  • Sorting & Filtering: Organize and analyze your data by sorting and filtering
  • Creating Charts & Graphs: Transform your data into visually compelling charts
  • Creating a Pivot Table and Pivot Chart
Automation & Efficiency
  • Conditional Formatting: Apply automatic formatting rules to highlight data
Practical Projects
  • Project: Creating a salary sheet in Excel