Address
304 North Cardinal St.
Dorchester Center, MA 02124
Work Hours
Monday to Friday: 7AM - 7PM
Weekend: 10AM - 5PM
Getting Started with Microsoft Excel
Getting Started with Microsoft Excel
0/2
Basic Workbook Operations
Basic Workbook Operations
0/2
Working with Cells and Ranges
Working with Cells and Ranges
0/4
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
About Lesson
Advanced Functions
- IF: Performs a logical test and returns one value for TRUE and another for FALSE. Example: ‘=IF(A1>10, “Yes”, “No”)’.
- VLOOKUP: Looks for a value in the first column of a table and returns a value in the same row from a specified column. Example: ‘=VLOOKUP(A1, B1
, 2, FALSE)’.
- HLOOKUP: Similar to VLOOKUP, but searches for a value in the first row of a table and returns a value in the same column from a specified row.
- INDEX and MATCH: Used together to look up values in a table. Example: ‘=INDEX(B1
, MATCH(A1, A1
, 0))’.
