# Use This Period To Brush Up Your Excel, Power BI and/or Financial Modelling Skills

, ,
I pray we all overcome the Covid-19 viral infection. I pray we all get through this period financially intact. I pray we all become better and grateful after this difficult period passes.

And as our own little contribution to helping you come out better, we have created free resources for you to use in improving your Excel, Power BI and Financial Modelling skills.

1. Weekly tasks to sharpen your real-world problem solving skills cutting across Excel, Power BI and Financial Modeling. If you haven't joined, then here's the link to enroll - (premium resource only for past participants of our training class)
2. Free registration to our Udemy course on Data Analysis (coupon expires on 2 April 2020) -- https://www.udemy.com/course/business-data-analysis-with-microsoft-excel/?couponCode=OVERCOMECOVID19
3. Improve your template creation skills with this first part video to creating a Startup financial modeling template -- https://youtu.be/6HtJRZhTV4o
4. Using Power BI to analyse stocks and macro-economic indices in Nigeria -- https://www.youtube.com/watch?v=bH4HzDzcFzI
5. XLOOKUP: Excel's new version of VLOOKUP -- https://www.youtube.com/watch?v=p8O_210q8NQ
6. Power BI DAX UNION formula -- https://www.youtube.com/watch?v=zNCYmSLM2cg
7. Solution to Week 1 task using SUMIFS, INDEX, MATCH, SUMPRODUCT -- https://www.youtube.com/watch?v=CyrIi0hUFcQ
8. New Excel Magic Formula: SORT -- https://www.youtube.com/watch?v=P8vJe9iW9VU
9. New Excel Magic Formula: UNIQUE -- https://www.youtube.com/watch?v=QLgwXVkALFg
10. Basic Investment and Financial Planning webinar -- https://www.youtube.com/watch?v=CEAA7ar6xfM
11. Formula to generate random texts and paragraphs in Microsoft Word -- https://www.youtube.com/watch?v=HP1V9VUDE9k
13. Creating interactive dynamic forms in Microsoft Word -- https://www.youtube.com/watch?v=SRUiFpbtBgQ
14. Power BI DAX SUMMARIZE formula -- https://www.youtube.com/watch?v=X8mqjSQ9gOo
15. Automating report data update for analysis using PowerQuery -- https://www.youtube.com/watch?v=mKEHb0OWuP8
16. Power BI DAX CALENDAR formula -- https://www.youtube.com/watch?v=oodi9Vz0eeQ
17. Power BI DAX VALUES formula -- https://www.youtube.com/watch?v=pLZhm0R2KrU
18. Power BI DAX CALCULATE formula -- https://www.youtube.com/watch?v=Vzro-tgDr_8
19. Power BI DAX CROSSJOIN formula -- https://www.youtube.com/watch?v=A_2GM4Ig24k
20. Power BI Row Level Security for report access control -- https://www.youtube.com/watch?v=8PPa5-37V18
21. Fuzzy Lookup in Excel for matching inconsistently spelled entries -- https://www.youtube.com/watch?v=nGDo6k5KMkM
22. PowerQuery and PowerPivot -- https://www.youtube.com/watch?v=qzPRxfEd7UA
23. Introduction to Excel Macros (VBA) -- https://www.youtube.com/watch?v=yHzAPGqT4f8
24. Creating a Data Entry application in Excel using VBA -- https://www.youtube.com/watch?v=vb9gFpEbdo8
25. Planning Tools in Excel (What-If-Analysis) -- https://www.youtube.com/watch?v=eE1yV9RNIko
26. Create a Birthday Reminder in Excel using VBA -- https://www.youtube.com/watch?v=DrK3uBqnRBs
27. Unpivot Column in Power BI -- https://www.youtube.com/watch?v=W6UeZCte9YM

Keep Excel-ling!