Resources for MS Office workshop

 Resources for MS Office workshop

"WORK IS WORSHIP"

Link to shared folder

MS Excel

• Unique records
• Pivot table
• Data Validation
• Vlookup function

=VLOOKUP(for what, In what, which column, "FALSE")

• Hlookup
• Index function

=INDEX(In what, row, column)

• Match function
• Index + Match
• Xlookup/Vlookup/ Hlookup: 

  =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

• FORMULA as TEXT
• TEXT as FORMULA using INDIRECT

MS Word

• Use of styles to organize/ Navigate
• Use of Table of contents
• Use of Mail Merge

MS Powerpoint

• Use of canvas, shapes
• Use of animations

Academic Performance analysis of students