1 of 17

PORTOFOLIO MS. EXCEL

2 Weeks Intensive Bootcamp Ms. Excel by

2 of 17

PORTOFOLIO MS. EXCEL

3 of 17

Hi!�My name is Wilda

foto

Full Name: Wildani Mukhollafah�Purpose of Participating in the Bootcamp:�1. Learn to process data proficiently and familiarly with MS Excel.�2. Combine my English skill + Data skill for the digital era – a powerful combo�3. Grow as a bilingual talent with data confidence

4 of 17

Excel Skills Mastered

  1. Shortcut Ms. Excel
  2. Worksheet & Workbook
  3. SUM
  4. AVERAGE
  5. IF
  6. VLOOKUP
  7. INDEX MATCH
  8. Data Cells and Ranges (Formal cell, Absolute, Relative)
  9. Concat
  10. Round
  11. Count
  12. Kalkulasi Presentase

13. DATE FUNCTION

14. PIVOT TABLE

15. Grafik Dari Data

16. TEXT

17. COUNTIFS

18. AVERAGEIFS

19. SUMIFS

20. PIVOT CHART

21. SLICER

22. DATA VALIDATION

23. MACRO VBA

24. DASHBOARD

5 of 17

Bootcamp Summary

  • Organizers : Karirnex
  • Date : 14, 16, 21, 23 October 2025
  • Total Learning Hours: 10 Jam
  • Total Jam Mini Project :5 Jam
  • Key Results: Predicated Certificate, Mini Project

6 of 17

Dummy Data

Note : The data contains 2,000 transaction rows

7 of 17

Day 1

8 of 17

Result

=SUMIF(P:P;"Toko Hijau";K:K)

=AVERAGEIF(N:N;"COD";Q:Q)

=VLOOKUP("BB Cream - Brand B";E:F;2;FALSE)

=INDEX(F:F;MATCH("Body Spray - Brand B";E:E;0))

=INDEX(F:F;MATCH(U14;E:E;0))

​

9 of 17

Day 2

10 of 17

Result

11 of 17

Day 3

12 of 17

13 of 17

Day 4

14 of 17

15 of 17

ATTACHMENT

Here is the Ms. Excel file that I have uploaded to google drive as supporting data for the portfolio above...

https://bit.ly/3J6jXFa

16 of 17

Documentation

17 of 17