Internship← Computer Fundamentals & MS Office learning pathComputer Fundamentals & MS Office · Module 7 of 10
MS Excel: functions, charts and data
Analyse data like an office professional.
📖 Key ideas
- IF makes decisions: =IF(B2>=40,"Pass","Fail").
- VLOOKUP / XLOOKUP find a value from another table.
- Sort and Filter organise large lists.
- Charts (column, line, pie) turn numbers into pictures.
- Pivot tables summarise thousands of rows in a few clicks.
💡 Real-life example: A pivot table is a quick shop report: total sales by product and month without writing formulas.
IFReturns one of two results by condition
XLOOKUPFinds a matching value
Pivot tableSummarises data by groups
FilterShows only matching rows