Excel formulas form the foundation of data manipulation and reporting. This course strengthens participants’ skills in using formulas across logic, lookup, date, text, and statistical functions. They will gain the confidence to automate calculations, troubleshoot errors, and improve accuracy in reporting tasks.
Learning Outcomes:
Apply common Excel formulas such as SUM, AVERAGE, IF, VLOOKUP, INDEX, and MATCH to solve data tasks.
Use logical formulas (IF, AND, OR, IFERROR) to create dynamic and condition-based outputs.
Create nested formulas to handle more complex scenarios and automate decision-making.
Key Topics:
Statistical and logical formulas
Lookup and reference tools
Text, date, and array functions
Error handling and validation
Formula auditing and efficiency tips
Module 1. Formula and Functions Basic
- Formula basics
- Using cell references
- Copy formula without changing cell reference
- Transpose formula
- Using nested functions
- Practice
Module 2. Statistical and Logical Functions
- Perform calculation using CountIF
- Perform calculation using SumIF
- Perform calculation using AverageA
- Using IF function to prevent division by zero
- Using IsError function to avoid error display
- Creating multiple conditions using nested IF
- Using logical function OR, And within IF
- Practice
Module 3. Lookup and Reference Formulas
- Using Vlookup to find specific data
- Using Hlookup to find values in rows
- Using Match and Index to retrieve data
- Practice
Module 4. Text Formulas
- Changing case of text
- Append text and numerical value
- Convert imported text format into numbers
- Break imported date field into individual columns
- Extract text within a cell
- Practice
Module 5. Date and Time Formulas
- Perform addition to Date fields
- Calculate difference between two Dates
- Perform calculations with Time fields
- Practice
Module 6. Array and Database Functions
- Using Array Formulas
- Calculate the difference between Maximum and Minimum values
- Using Frequency function to Count responses
- Using Database functions DSum and DCount
- Practice
Module 7. Efficiency Tips
- Shortening worksheets names
- Protecting cells containing formulas
- Using Data Validation
- Displaying Formula syntax
- Using Auditing Tools for errors checking
- Tracing precedent and dependent
- Adding comments to worksheet
- Practice
.png?width=50&name=Artificial%20Intelligence%20(AI).png)
-1.png?width=360&name=Server%20(4)-1.png)
/AI%20(6)-1-1.png?width=360&name=AI%20(6)-1-1.png)
/AI%20(8)-1.png?width=360&name=AI%20(8)-1.png)
-1.png?width=360&name=Automation%20RPA%20(2)-1.png)
/AI%20(5)-1.png?width=360&name=AI%20(5)-1.png)
