Course Content
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Formulas and Functions
Formulas and Functions
0/3
Data Analysis Tools
Data Analysis Tools
0/3
Creating Charts and Graphs
Creating Charts and Graphs
0/2
Advanced Excel Features
Advanced Excel Features
0/3
Collaborating and Sharing Workbooks
Collaborating and Sharing Workbooks
0/3
Microsoft Excel Course
About Lesson

Basic Formulas

  • Creating Formulas: Start with an equal sign (‘=’) and enter the formula using cell references and operators. For example, ‘=A1+B1’ adds the values in cells A1 and B1.
  • Using Cell References: Use relative references (e.g., A1), absolute references (e.g., $A$1), and mixed references (e.g., A$1 or $A1) to refer to cells in formulas.