Ever thought of creating an interactive form in Microsoft Excel? With clickable radio buttons, dropdowns to select from a predefined set of options, an image file picker to attach/import a passport photo, a calendar that pops up to let the user pick a date and many other useful features. Today is your lucky day.

You can watch the video tutorial here: https://www.youtube.com/watch?v=SRUiFpbtBgQ




All these amazing tools are housed in the Developer menu. So the first task you have to do is enable/activate the Developer menu. Go to File, Options, Customize Ribbon and tick the checkbox beside Developer.




In the Developer menu, you will see the controls that make interactive forms possible -- from radio buttons to checkbox to calendar to picture frame and many more.


Watch the video to see me do a comprehensive live demo. And I included a bonus on how to make what the user type in one part of the document appear in other parts of the document. This is a neat trick for creating legal or contractual documents. You ask for the other party's name and that name appears in all the necessary parts of the documents. And once you change the name in the first part, it changes in all the other parts.

You can watch the video tutorial here: https://www.youtube.com/watch?v=SRUiFpbtBgQ

Originally, I shared this on a Telegram Finance and Investment group (which you can join via https://t.me/joinchat/Gfyf4VFBAOHYM3kdc98QHA 


I have been watching RealVision.com series on the global economy and gleaned the following insights:

The global economy is slowing down. All the numbers are indicating that Germany is nearing a recession, US manufacturing is down. Europe, generally, is having a very tough time due to many localised issues across the countries there and it is generally weighing down the European economy. Global banks are shrinking their activities to avoid 2007/2008 styled contagion of financial distress.

China is slowing down at a rate more than what the government officially publishes. For the last one year, the govt controlled financial sector has been pumping cheap loan out to create artificial economic wealth — keep comatose companies alive, keep companies expanding, fund large scale infrastructure and mute the effect of lower consumer activities.

US Dollar is considered as overpriced (too strong). The negative and zero bond yields in Japan and Europe has driven a lot of demand for US financial market assets. The emerging and frontier economies have felt it the most, seeing their currency depreciate significantly in the last 2-4 years. There is a lot of push to weaken the US dollar — from the White House as that will make their trade war with China (and other countries) more effective as per their desired economic effect, for the Fed as that could provide the next economic boost, and for investors as it means general asset price/value increase.

Gold is considered as being underpriced due to monetary policies that are aimed at reflating the financial markets whenever there's some downturn. Also, the strong US dollar is muting the price level.

Bitcoin is considered as very underpiced. Bitcoin has a market cap of $149B. If it were a private company listed on the stock exchange or a startup, it would have valuations in very many multiples of that. It's userbase is well beyond than of many companies with larger market cap, it's adoption rate is very high and it is powered by technology+infrastructure that runs into billions of USD. 

Another angle of view of some of the portfolio managers is that Bitcoin is not correlated with the broader investment market and provides a better alternative to holding physical gold as against gold futures that many still see as tied to the financial markets systemic risks. 

One important consensus is that Bitcoin is gaining more ground in the mainstream investment funds world. More institutional investors and family offices are holding positions in it. And this would only continue to accelerate.

There is a new global drive towards another version of QE that is built on Modern Monetary Theory (MMT). So the concept is to remove the classical limitation to printing more money and expansionary spending by government because of inflation worry. The theory states that inflation is not directly/naively linked to printing more money as usually said. And the last 2 decades is a solid proof. The theory says as long as it is not done past the level where the economy reaches full employment and GPD potential, the printed money would only unlock greater factor utilization and economic growth.

So now central banks will start printing money more than ever before. Christine Lagarde is regarded as a monetary policy evangelist, so ECB will do even more than would have under Draghi. Japan is tilting towards deflation and they are now going back into aggressive QE. China is also being propped with articifical money which they are now doing more of as they try to devalue the yuan to mute the effects of US tarrifs and weaker exports.

The worries are that there is no proven method to ensuring the money printed primarily impacts the real economy and not just inflate financial assets prices. One thing is sure though, there will be more financial asset price propping. Even if/when a recession hits globally, these artificial supply of money will not let prices be as depressed as they ordinarily would have been nor stay depressed for as long as they historically would have (pre- QE)


Practical takeaways I am considering are:

1. Do more Bitcoin holding. If US dollar goes up, my Naira value of Bitcoin goes up. And if US dollar is devalued, higher chance of seeing it reflect in my Bitcoin value than in holding plain US dollar.

2. Hold and add to my Gold positions. Strong fundamentals and narratives for good upside.

3. Stay clear of Oil. Weakening global economy (especially the manufacturing, logistics and fossil fuel based sectors) limit the upside to Oil. Even despite the Saudi Aramco facility bombing, Iran tanker hit and other issues that typically create upside speculation, Oil price has gone down to below the Saudi Aramco cut price surge even though there are narratives that there is more supply from reserves than is claimed by Saudi in supply/production recovery.

4. Stay out of Nigerian stocks until price/volume action indicates a strong price recovery. It is not just enough to spot high dividend yields, it's the future guidance (future dividend yield) that matters and when compared with capital loss vs capital preservation and sure Fixed Income yield vs unsure future Dividend Yield; I will want to be less optimistic about stocks till I see improved economic fundamentals/policies and return of investment capital to equities. 

5. Do more of money market. I don't see yields going down as we will have to struggle to keep inflation from not rising while trying to attract FPI's with good real rate of returns.

6. Keep my expenses as low as possible and in Naira. PPP vs nominal exchange rate favours spending in Naira. 

7. Derivatives on NSE. Watch out for the derivatives NSE is saying they are launching soon (they still said it during last month's conference type event).

8. Add to my US treasury bond holding. There is a general consensus that the developed world is heading to zero percent interest rate in the short to medium term. So far US is the only one not yet there. And as the rate differential is being arbitraged away, the price of its bonds will go up.
Last year's was amazing. And we are planning towards having a more amazing one this year.



You can register to attend via https://meetup.com/Nigerian-Excel-Users-Meetup/events/265613996/ 

If you are interested in giving a presentation, then kindly fill the presenter's form via https://forms.gle/g2A2faEfM5BA2k8N7 

The full details are (till we get the verified presentation topics and presenters):


Nigerian Excel Users 2019 Meetup
The Zone Tech Park, Plot 9 Gbagada Industrial Scheme, UPS b/stop, Gbagada Expressway, Lagos.
23rd November, 2019 (09:00am to 3:30pm)

Start Time: 09:00am

1) Introduction and networking (25 mins)

2) General Discussions pt 1(Your Excel Journey, career advantage, Excel pet peeves, ideas, the esoteric, 30 mins)

3) Presentation 1 (25 mins) + Q & A (10 mins)

4) Presentation 2 (25 mins) + Q & A (10 mins)

5) Presentation 3 (25 mins) + Q & A (10 mins)

6) Break (10 mins)

7) Presentation 4 (25 mins) + Q & A (10 mins)

8) Presentation 5 (25 mins) Q & A (10 mins)

9) Presentation 6 (25 mins) + Q & A (10 mins)

10) Break (10 mins)

11) Presentation 7 (25 mins) Q & A (10 mins)

12) Presentation 8 (25 mins) Q & A (10 mins)

13) General Discussions pt 2 (Your Excel Journey, career advantage, Excel pet peeves, ideas, the esoteric, 30 mins)

15) Close (5 mins)

End Time: 3:30pm (Networking continues)

There will be drinks and snacks.



Don't forget to register to attend via https://meetup.com/Nigerian-Excel-Users-Meetup/events/265613996/ 

A big thanks to all who were able to make the live broadcast. Especially, for bearing with the initial broadcast hiccups. You can watch the recorded session at: https://www.youtube.com/watch?v=CEAA7ar6xfM

Below are the slides and resources from the broadcast session. The next one would be on Equities Investing.















You can download the presentation slides at https://drive.google.com/file/d/14U6FNSPbqWGDZ5Lx11_ZKio_aUSwIqHX/view?usp=sharing

Here are the links to the tools mentioned:
Excel file for tracking expenses - https://drive.google.com/file/d/1413oVdQAtZQSQBgwaj_-rdN4nLUm8dBN/view

App for tracking expenses - http://wally.me/

Where to download real estate listing magazine - https://castles.com.ng/download-past-editions-of-castles-lifestyle/

Where search real estate price trends - https://www.nairaland.com/properties and (years past) https://www.nairaland.com/properties/1700 

Where to chek stocks and crypto price trends - https://www.investing.com/

Where to get stocks and macro-economic analysis - http://vip.urbizedge.com/economy

Join the large discussion community on Telegram via Telegram group at https://t.me/joinchat/Gfyf4VFBAOHYM3kdc98QHA and the meetup community at https://www.meetup.com/Financial-Modeling-Financial-Planning-Meetup-Group/


Enjoy!

I have tried DSTV, Showmax (https://showmax.com/), DSTV Now (https://now.dstv.com/), YouTube TV (https://tv.youtube.com/), Hulu (https://www.hulu.com/) and Netflix (https://www.netflix.com). It's only Netflix I renew every month.

In today's post I am going to share the exciting tips I have snagged over the years of using Netflix (even before it was publicly available to us in Nigeria).

1. VPN opens you up to amazing new contents.
If you have always logged into Netflix from Nigeria, you are missing out on a lot. There are many wonderful movies (especially new and hit movies) that are geo-locked. Just logging in to your Netflix account from USA or Canada or UK or France or Germany or Australia opens you up to new great movies.

So how do I achieve this without leaving Nigeria? VPN. Specifically, I use ExpressVPN (https://www.expressvpn.com). After trying many VPN providers, they are the only provider that consistently worked.

I usually set my location to USA or Canada, they have the largest collection of interesting movies and more recent hit movies.

2. Pick a genre
The new layout of Netflix tries to guess what you'll like to watch. The problem is that after a while you would have watched all the good guesses. Why not pick the genre you love and focus more on discovering the exciting movies in that genre that the homepage list omits.



3. History
Ever wanted to recommend a movie you recently watched but can't remember the title? It has happened to me many times. Now I simply go to my viewing history to get the name. It's under Account.



4. Search actor or actress' name
When I am getting frustrated with the movies I am being presented with, I just hit the search on a favorite actor/actress. Interestingly, I have done this on Jason Statham, Nicolas Cage, Tom Cruise, Denzel Washington, Johnny Depp, Pierce Brosnan, Mel Gibson, Ryan Gosling, Will Smith, Leonardo DiCaprio, Ryan Reynolds and Matt Dimon. I also click on their names in the movie details to pull up other movies they were in.

5. Avoid movies (not series) produced by Netflix
The movies produced by Netflix are mostly crap. I always feel like I wasted 2hrs whenever I watch them. So I just completely avoid them. However, their series are good. 

6. You can download to watch later on the PC and phone apps
If you have great internet access somewhere (I didn't say your office), you can download movies when there to watch at the airport lounge, at night at home and somewhere else you do not have cheap data. I have too much data and too little PC/phone space that I don't do this. Nevertheless, it is a tip worth sharing.

Cheers.


Occasionally, we are contracted to train on the general Microsoft Office. And I see people amazed by how much they don't know exist in Microsoft Word and how very exaggerated is their assessment of their competence in Microsoft Word.

Over the next couple of weeks, once a week, I will share with you some of the amazing things I have shown people in Microsoft Word.

For today, which marks the start of this series, I will be showing you a secret Microsoft Word formula that you can use to generate random texts in Microsoft Word. It can be very useful in creating templates and the skeleton of an important document.

You can watch my 2 minutes straight to the point video on it: https://www.youtube.com/watch?v=HP1V9VUDE9k 




The formulas are:
=Rand() 
This generates 5 paragraphs.





=lorem()
This generates 5 paragraphs too




And for both, you can specify the number of paragraphs and sentences in each. Just use the following format =rand(3,5) or =lorem(3,5)

The first number is to set the number of paragraphs and the second number is to specify the number of sentences in each paragraph.






I gave an extra one in the YouTube video, so you might want to watch it for that extra one ( https://www.youtube.com/watch?v=HP1V9VUDE9k). Enjoy!
image: finglobal.com
There are two kinds of youths in Nigeria: those who are already processing their emigration and those who are yet to.

If you want to know if I am already processing my emigration, you will have to read to the end to find out.

Nigeria is certainly a tough country to live in. It requires deliberate optimism and a fat salary to not feel sad about being stuck here. I have both and in today's post I want to share that optimism.

I earn more than I spend. That explains the fat salary. I spend less than I earn.

I like a quiet life, a simple life and a creative life. Luckily, I get plenty of that here in Nigeria. I am writing a novel about what life is really like in Nigeria. Staying here will help me write it well.

I try to look for opportunities that open up due to the pessimism around. Everyday I monitor the stock market. I am building an analysis dashboard on the real estate market -- which locations are experiencing price increase over the last decade and which are over-hyped.

I examine gaps that the mass exodus is opening up. I look for which gap I can profit from. Maybe I should start a course for those needing to prep their CV for emigration. Luckily, I am in a field that gets a lot of foreign love. I just need to help others attract some of that love.

If you've got ideas of how people like me can make better value out of their staying, do please share. While I am still in the "yet" group, let me maximize my stay.