Before I bury you in the slides, here are the templates and resources I referred to in the slides. Enjoy!
  1. https://www.macrotrends.net/ for US stocks fundamental analysis data
  2. https://www.macrotrends.net/stocks/stock-screener to screen US stocks by fundamentals
  3. http://vip.urbizedge.com/economy for historical and macro analysis for Nigeria
  4. https://vip.urbizedge.com/add-in for Excel stocks analysis app for Nigeria
  5. https://vip.urbizedge.com/stocks for US stocks portfolio analysis and portfolio setup
  6. https://vip.urbizedge.com/fstocks for Fundamental Analysis checklist
  7. https://nairametrics.com/ for Nigeria stocks and macro news/analysis
  8. https://www.stearsng.com/ for Nigeria economic analysis
  9. http://seekingalpha.com/ for US stocks analysts' publications
  10. https://www.morningstar.com/ for US stocks fundamental analysis
  11. https://www.tradingview.com/screener/ for stock screening based on both fundamentals and technical signals
  12. https://www.tradingview.com/chart/ for charting
  13. https://finviz.com/ for US stocks signals and screener
  14. http://vip.urbizedge.com/economy for Nigerian stocks charts
  15. https://vip.urbizedge.com/stocks for US stocks portfolio setup & analysis
  16. http://www.investmentng.com/forum/12-annual-reports-and-financial-statements/ to download annual reports of companies in Nigeria
  17. https://www.annualreports.com/ to download annual reports of companies in the US



























👍
Today I went to a store that sells baking ingredients and asked for ingredients to use for baking meat pie. My wife is still surprised. I ended up buying the following:

  1. Flour
  2. Baking powder
  3. Nut meg
  4. Margarine
  5. Sugar
  6. Electric mixer
  7. Mixing bowls
  8. Measuring cups
  9. Carrots
  10. Meat (was told how to create minced/diced meat from normal meat, much cheaper)
  11. Potato (not sweet potato)
  12. Eggs
After some hours of reading online and watching YouTube videos with conflicting information, I created my first meat pie.



My wife loves its crunchy taste but I was hoping for a non-crunchy meat pie. I don't even eat crispy fried chicken. You should see how I fight KFC staff when they put crispy chicken instead of the regular chicken in my ordered food. So now, I am begging my wife to eat all the meat pie I have spent 5 hours (learning) to bake. She's the captain of the crunchy team.

I suspect it's the two tablespoons of baking powder I put that's made it more like a cookie pie. I am researching online. If that's the actual cause, may the Microsoft Excel of the owner of the website crash.

That minor issue aside, it has been a very enjoyable process. I am even to begin a one month baking school/class next week. I can't wait to stop paying Domino's Pizza. I came across a YouTube video of how to make pizza at home. Especially the pan pizza. I am definitely going to try it. Wanted to this night but when the lady started mentioning pizza sauce, cheese and those other stuffs I didn't have, I decided to stick with just the meat pie today.

I started with cooking the meat after slicing them thin to make dicing easier afterwards. I bought N1000 meat from my regular butcher/meatseller. He knows he cheats me because I always leave the person I meet there. He agrees to my price faster than he agrees to other peoples' price. I hope they just put a fixed price on meat like the suya sellers now do. I put in good amount of water in a small pot, added curry, added one cube of Maggi Naija Pot and added some salt. 30 minutes later, I had produced the nicest soft meat. I then diced the meat.

I used my wife's potato chipper to create easy to dice chips from the carrot and potato. She helped me dice them.

I then watched 4 videos trying to figure out which is the (most) correct one. The creators better stick to their baking and not go near computer programming. One said 4 cups of flour + 1 spoon of baking powder, another said 2 cups of flour + 2 table spoons of baking powder, still another said 3 cups of flour + 2 tea spoons of baking powder. 

In the end, I mixed the following:
  1. 2 cups of flour
  2. 2 table spoons of baking powder
  3. 1 small sachet of nutmeg
  4. Enough margarine to make the mixture feel like breadcrumbs (or garri, as one online teacher said)
  5. 1 table spoon of sugar
  6. A small pinch of salt
  7. 1 egg (used half for the mixture and the other half for the inner lining of the meat pie at the point of baking)
  8. Quarter of a cup of cold water (real cold water from the water dispenser). Don't know why it must be cold water, not warm water.
I mixed them. And mixed them. And mixed again until it looked like what I saw in the YouTube videos. I then placed the dough in the refrigerator for 30 minutes. 

It's so rich, you can see the nutmegs

I put small oil in a small pot. Placed on the cooker. Poured the diced carrots, diced potato and diced soft nice meat into it. Stirred for 4 minutes. Added small salt and black pepper. Added small water. Left for 8 minutes. Added 2 spoons of flour. Stirred for 3 minutes. All looked awesome. I could see the meat pie coming together. Baker's Street would want my special meat pie fillings recipe. Without exaggeration, it is patent worthy. Just take a look at it.


I took a glass bottle of groundnut and rolled out nice circular flat thin doughs from small cuts from the entire dough. 



Put them in our halogen oven set to 170 degrees centigrade. Went back to the videos to sort out which to follow regarding number of minutes to set it to. Everyone agreed on the temperature but duration was as wide apart as 25 minutes is from 60 minutes. I went with 30 minutes.





I hope I have delighted you with my personal story of how I made my first meat pie. I also shared the photos with the owner of the baking school I have paid to begin class next week. I want to go pick up my Suzuki 600cc (power) bike from my trainer this week so can't afford to start the baking class this week. With my work load, I can only squeeze out small time for one small side class at a time and settle with sleeping very late at night.



Growing up I was the dreamy type. I would watch a movie and dream it a sequel overnight. I would read a book and suddenly become close to the characters in the book. I loved rearranging events with my eyes wide open.

Today, I no longer dream. I have too many chats/emails/requests to respond to. Work to do. Meetings to wake up to.

Growing up I knew there were enough opportunities, wealth and fame to go round. Nobody's ever dimmed mine. When I met very successful people, I saw them as only ahead of me. Maybe by a few steps or a few years.

Today, I see too many lost and out-of-reach opportunities that I simply shift my gaze to things to be thankful for.

I try to not grow up anymore. It is very hard. I try to dream again. I try to see the opportunities beckoning me.

I still want to write novels, write books that have nothing to do with work or data analysis or computers.

I still want to see events with no sense of conclusion. To not have an explanation for what is happening. To journey through each day with a creative mind and naivety.

I try to tell myself that I still have more years than I have spent already and can do all what I once dreamed of doing. That I can become fluent in French. That I can be an accomplished artist. That I can be child I once was.

I want to talk without having an agenda. I want to teach what I do not know. I want to write my deep thoughts, the ones beneath the thoughts about money and responsibilities. I want to have a clear mind, a dreamy mind that is more interested in what can be rather than what has been.

I want to try out new things regularly. To be able to pour myself into an interesting task for a year or two and then completely switch to something else.

I want to be able to look in the mirror and see the 12 year old me.

I want to ungrow.
https://class.urbizedge.com


We have had 6 Office Hour sessions around Business Intelligence, Financial Modeling and Business Data Analysis with Excel.

You can watch the previous sessions at https://www.youtube.com/playlist?list=PL0kdLm6FekrMWYBcervKPF_eAZk9dnoSI

These are the resources mentioned/shared during the sessions.

Power BI Value Proposition slides: https://urbizedge.blob.core.windows.net/urbizedge/Power%20BI%20Value%20Proposition.pdf

Victor Momoh's Excel Journey Slides: https://urbizedge.blob.core.windows.net/urbizedge/My%20Excel%20Journey_Victor%20Momoh.pptx

Kehinde Omisile's Excel Journey Slides: https://urbizedge.blob.core.windows.net/urbizedge/Kehinde%20Omisile%20-%20Microsoft%20Excel%20and%20Data%20Analysis%20Office%20Hour%205.pptx

Manufacturing Company Startup Financial Model Input template: https://urbizedge.blob.core.windows.net/urbizedge/CK%20Healthcare%20Limited%20-%20Financial%20Model_Model%20Input.xlsx

SaaS (software as a service) company startup financial model input:
https://urbizedge.blob.core.windows.net/urbizedge/SaaS%20Model%20Input.xlsx

You can join the communities via
https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/
https://www.meetup.com/Power-BI-Learning-Community/ and
https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/


Looking forward to seeing you in the coming Sunday edition!

P.S.> You can also try out our free courses https://class.urbizedge.com/p/free-teaser-power-bi-and-dashboards-for-the-busy-professional and https://class.urbizedge.com/p/free-teaser-financial-modelling-financial-planning-and-dcf-valuation

Tomorrow, Sunday 12 July 2020, we will be having a very interactive session on Microsoft Teams normal meeting (not a webinar that's mostly one way communication). We will learn from one another, I will answer questions and we will get all more enlightened on data analysis, new powerful Microsoft Excel features, Power BI and Financial Modeling.

You don't want to miss this.

Financial Modeling Office Hour 6
Time: 2:00pm to 3:00pm
Date: Sunday, 12 July 2020
Venue: Online at https://vip.urbizedge.com/fin-mod-live

Microsoft Excel and Data Analysis Office Hour 6
Time: 4:00pm to 5:00pm
Date: Sunday, 12 July 2020
Venue: Online at https://vip.urbizedge.com/excel-live

Power BI Office Hour 6
Time: 6:00pm to 7:00pm
Date: Sunday, 12 July 2020
Venue: Online at https://vip.urbizedge.com/power-bi-live

Join and be abreast of what's new and trendy in these spaces!




You can also check out our free trial courses, learn some of what our paid students learn but without paying:  https://class.urbizedge.com/p/free-teaser-power-bi-and-dashboards-for-the-busy-professional and https://class.urbizedge.com/p/free-teaser-financial-modelling-financial-planning-and-dcf-valuation

View recording of past sessions at https://www.youtube.com/playlist?list=PL0kdLm6FekrMWYBcervKPF_eAZk9dnoSI

See you tomorrow!

Today at 7:00pm Nigerian time I will be a guest on the Brasilian Cristiano Galvao's Excel Turbo show.

I have been doing some Portuguese lessons and intend to speak a few sentences I have learned. Come and watch me say Oi and Tchau (at the minimum).

Joining link is https://www.youtube.com/watch?v=dvRSlfHxnr4

I will also be sharing some personal stories that you probably don't know some of even if you have been reading my blog for 5 years now. I hope so, 'cos these days I find that difficult to achieve. Seems I have been oversharing on this blog before. 😁

I will also be sharing some uncommon Excel feature. Something I assure you that you've not tried before. So you don't want to miss all these.

See you this evening at https://www.youtube.com/watch?v=dvRSlfHxnr4

Te vejo em breve!



Join us this Friday as we take you through the career journeys of three experts who will show you practical insights into building your career in this exciting field of data analysis, business intelligence and financial modelling. These sessions are brought to you by UrBizEdge, do checkout our courses (we have online classes and physical classes)

Session 1: Financial Modeling Office Hour 5 (https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Abraham Durosawo
2. Industry Deep Dive
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live

Abraham Durosawo is a veteran investment advisory professional. He possesses years of financial advisory and capital raising experience across power, oil & gas, infrastructure, insurance, manufacturing, technology, agriculture, financial services and real estate projects. He was a member of the team that developed the Economic Recovery and Growth Plan of the Federal Government.

He is a Certified Management Consultant and Fellow, Institute of Management Consultants. Enrolled in a dual Executive MBA at the Business School Netherlands and Quantic School of Business and Technology. He is a candidate in the CFA Program. He is a Director at Unicorn Capital, Consultant to the Investment Banking Institute New York, Business Mentor with the Bid Network Foundation, Netherlands, and a Mentor with the Google Launchpad Start. He is also the convener of the Finance Professionals Network, a community of future global leaders in finance. He is a specialist in equity and debt investment instruments with a core focus on private equity and venture capital investments. 

Abraham is an award-winning YALI Fellow, The Young African Leaders Initiative, where he won the 2018 star of Entrepreneurship.


LinkedIn https://www.linkedin.com/company/careers-in-finance/ 
Twitter: @FinProNetwork


Session 2: Microsoft Excel and Data Analysis Office Hour 5 (https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Kehinde Omisile
2. Special Demo
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live

Kehinde Omilise has a Bachelor's Degree in Mathematics and Master's Degree in Biostatistics. he developed flair for Excel as a diploma student of Agricultural Engineering sometime in 2003. First learnt to use Excel for analyzing Analysis of Variance (ANOVA). He uses Excel regularly for research, business solutions, visualization and analytics in the nonprofit sector.

You can connect with him via LinkedIn: https://www.linkedin.com/in/omisilekehindeolugbenga/
and
YouTube: https://www.youtube.com/c/OmisileKehindeOlugbenga 


Session 3: Power BI Office Hour 5 (https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbzb/)




Agenda:
1. Expert Journey Interview - Ahmed Oyelowo, MVP
2. Live Demo
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live

Ahmed is a Microsoft Most Valuable Professional (MVP), Microsoft Certified Solutions Associate (BI Reporting), Microsoft Certified Trainer (MCT) and a Certified Advanced Financial Modeler (AFM) from the Financial Modeling Institute, Ontario, Canada.

He has developed cutting edge solutions for companies and trained over 3,000 people on Business Intelligence and Financial Modeling.

He is also a contributor to the Power BI Community blog where he writes technical "how-to" articles. This combines with other articles he publishes on his blog and videos he posts on his YouTube channel.

His business website is https://foresightbi.com.ng/ and you can get more of his amazing tutorials on YouTube https://www.youtube.com/channel/UChdiVx41iPzoucPBiI_jy_A

image: forumchristian.org

Join us today at 2:00pm (WAT), 4:00pm (WAT) and 6:00pm (WAT) as I bring you exciting interviews and demo sessions from awesome data analysis experts who are making waves in their space.

Session 1
The first is my session with the special Bernard Obeng Boateng whose impact stretch from Ghana to Nigeria, claim your participation slot at https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbqb/

Agenda:
1. Expert Journey Interview - Bernard Obeng Boateng (BEST)
2. AFM (Advanced Financial Modeler) Certification
3. Other Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live

Bernard Obeng Boateng is a Financial Modeler and Data Analyst with work experience in Banking, Insurance and Business Development. Bernard is skilled in Business Analytics, Dashboards and building financial models for budgeting, business valuation, scenario planning and investments. He also provides consultancy services for SMEs (startups and existing) in financial management, business planning and research.

He is certified in Business Analytics, New Venture Financing and Risk Modeling and provides training in Financial Modeling, Analytics and Microsoft Excel for individuals and organizations.

Bernard is co-founder of Business Evolution Systems and Training Ltd (www.best-gh.com) an approved training provider in Ghana for the Financial Modeling Institute, Canada.

You can connect with him on LinkedIn at https://www.linkedin.com/in/bernardobengboateng/ and you should subscribe to his YouTube channel to get super useful Excel tips, https://www.youtube.com/channel/UC9wBo_091Lu_rvLSqDIoo6A


Session 2
Then, there is the session with MVP David Abiola at 4:00pm and you can claim your participantion slot at https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbqb/

Agenda:
1. Expert Journey Interview - David Abiola, MVP (Excel Jet Consult)
2. Excel Tricks
3. Other Questions & Answers

See you in the online live class session!


Abiola David is the founder of Excel Jet Consult. He has trained professionals from many organizations in Nigeria including Senior Staffs at Federal Ministry of Petroleum Resources, Rose of Sharon Foundation, Access Bank to mention few.

His love for Excel and desire to upscale the Excel knowledge of Nigerians, made him to partner with NGOs to deliver free Excel and Power BI training for students at different Federal Universities in Nigeria pro bono. An avid blogger, he regularly share his wide technical expertise on his website which attract thousands of visitors from around the world.

Abiola David has published two books on Excel: Microsoft Excel for Professionals and Microsoft Excel Advanced Masterclass for Professionals.

He is an active contributor in the Microsoft Forum and regularly share technical videos on Youtube, https://youtube.com/user/Born2begrait


Session 3
And at 6:00pm we get to hear from the indefatigable MVP Ayodeji Folarin you can claim your participantion slot at https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbqb/

Agenda:
1. Expert Journey Interview - Ayodeji Folarin, MVP
2. Live Demo
3. Other Questions & Answers

See you on the online live class session!


Ayodeji is a Microsoft Certified Trainer, BI Developer, Data Platform Evangelist, Data warehouse and Dashboard/Business Reporting Expert

With over 23 years in the computing arena, Ayodeji has focused on data platform solutions around Microsoft Azure and Office 365. He has helped many companies to migrate their systems to the cloud and get insight from their data source for the past 10 years.

Ayodeji has passion for teaching and community engagement. He is a well-known speaker at many local and international conferences like MCT Summits, Power BI User Groups, PASS Local Groups, Microsoft Student Partners Events and other meetups. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. He loves traveling for work and to engage with local user groups, so always watch out for his next event around you.

Ayodeji has been certified as a Microsoft Trainer for over 5 years. He has been involved in presenting, community speaking and helping other professionals in the better usage and taking advantage of Microsoft's data solutions from flat files to RDBMS for example Excel, Access, SQL server, Power BI, MSBI, Azure SQL and many more.

Starting as a developer back in 1994, programming COBOL, BASIC and FORTRAN, Ayodeji has helped companies in multiple countries in many business areas to design and deploy their computing solutions. His love for spreadsheet and application development made him develop a spreadsheet application with VB4 to compete with Lotus 123 then.

Achieving his first Microsoft certification in 2010 as SQL Server 2008 Database Administrator and DB Developer, that same year he got his certification on Microsoft.NET Framework 3.5 web and Desktop developer track. He now decides to focus his career around Microsoft's data platform. He is certified in recent release of SQL and Microsoft Power BI (Excel and Power BI Desktop).

You can connect with him on Linkedin via https://www.linkedin.com/in/ayodeji-folarin/ and be wowed by his one of a kind website, https://dejifolarin.com


Today we are running three special expert interview sessions. If you've ever felt lonely and almost frustrated in your data analysis mastery/competency journey then these sessions are the very medication you need to regain your motivation and get timely career help.




Session 1: https://www.meetup.com/Financial-Modeling-Valuation-Learning-Community/events/ncwlsrybcjbhb/

Friday, 5 June 2020 @ 2:00pm GMT+1

Agenda:
1. Expert Journey Interview - Charles Otoghile (High5)
2. Financial Analysis vs Financial Modeling
3. Questions & Answers

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live



Session 2https://www.meetup.com/Microsoft-Excel-and-Data-Analysis-Learning-Community/events/hmzlsrybcjbhb/

Friday, 5 June 2020 @ 4:00pm GMT+1

Agenda:
1. Expert Journey Interview - Victor Momoh (ExcelMoments)
2. Pivot Table Tricks
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live



Session 3: https://www.meetup.com/Power-BI-Learning-Community/events/cmzlsrybcjbhb/

Friday, 5 June 2020 @ 6:00pm GMT+1

Agenda:
1. Expert Journey Interview - Evans Otalor
2. Power BI Admin Portal
3. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live

About our special guest:
Evans Otalor is currently a Data Science Consultant with Sterling Bank, before that he was Head of Data Analytics at IHS Towers, Nigeria. He is also a part-time lecturer at two foreign universities.

He is an experienced analytics professional with demonstrated track record successfully structuring and managing analytic projects across Banks, TELCOs, and FMCGs.

Evans holds a BSc in Industrial Mathematics from Ambrose Alli University and an MSc in Actuarial Science from Glasgow Caledonian University, Glasgow.

Highly skilled in the application of Mathematical and Statistical Methods to collect, organize, interpret, and summarize data for quantitative modelling projects that include both Data Analysis and Predictive Modelling to aid insight extraction, Risk Disclosure, Reporting, Measuring, Monitoring, and Predicting. Evans have over 10 years’ experience training in the Data Science space with over 13 years industry experience

Expert user of Python, R, Microsoft Applications (Including MS Excel, Power BI), SPSS Modeler, Alteryx, Knime, Tableau, and various Data Analytics/Visualization tools.



(c) www.urbizedge.com
For the Financial Modeling and Valuation training/support live session: https://vip.urbizedge.com/fin-mod-live



We would be handling questions people have asked:
1. Why we do not use TODAY() for the model date stamp
2. How to access the support resources
3. Calculation of the WACC
4. Understanding the Cashflow Statement
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/fin-mod-live



For the Power BI and Dashboards training/support live session: https://vip.urbizedge.com/power-bi-live




Agenda:
1. Making use of the shared Power BI pro account
2. Connecting Google Sheet to Power BI
3. Understanding the difference between the Power BI Desktop and Power BI Service
4. Access the practice files
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/power-bi-live 


For the Microsoft Excel and Data Analysis training/support live session: https://vip.urbizedge.com/excel-live



Agenda:
1. New Excel formulas
2. Connecting Google Sheet to Microsoft Excel
3. Downloading the training resources (practice files)
4. Using the new Excel Add-in store
5. Other Questions

See you in the online live class session!

Joining link is https://vip.urbizedge.com/excel-live


Cheers!