I am happy with the progress I am making. Yesternight, I completed my iTunes Gift Card sales web app. I am taking out the manual processes I undertake in selling iTunes Gift Card.

Previously, a typical sales transaction will involve someone calling me on phone for the purchase of an iTunes gift card. I confirm if the one they want is available or not. Then I email them the scanned copy of the Gift Card. They load it and pay.

It worked well for close to a year. But then it was beginning to interrupt my core business. I would get calls at all times of the day, especially late nights. Then the money collection hasn't been very smooth with a few people still owing me. Now I am waving goodbye to all those challenges.

Via http://www.nigerianelite.com/iTunes/Card anyone can purchase the iTunes Gift Card. They get the peace of mind that is difficult when they've got to call me out of the blue and we spend the first minute establishing trust. Also, it makes it easier for them to see the price upfront, order, have a record of their transaction and get peace of mind.

Next on my web application idea list is a Nigerian World Clock. A one stop place for you to see the time difference between all the major cities/countries in the world and Nigeria. Plus it will show current time in Nigeria and those other cities/countries.
I'm finally done with the Fraud Report web app that allows you to report any fraud attempt on you. You can access it via www.nigerianelite.com and http://www.nigerianelite.com/Fraud/Report 



It is time for you to dig out those fraudulent SMSs you've received, those fraudulent emails you've received, details of those fraudulent phone calls you've received, details of people who charged you for a service and didn't deliver, details of people who bought your products/service on credit and ran off, details of people who tried to scam you.

Make a report about each fraud event/attempt. 

This is the beginning of something new and useful. 

I am already gathering mine and will report them -- the fake Arik Air HR guy who scammed two people through me, the fraudulent Poropo Kukurakey guy who bought iTunes gift card from me and ran away with my money, the fake job messages my younger sister received, and so many others.

It will help people see the patterns fraudsters use, identify some of them, avoid falling for the same scams others have fallen for and our ultimate goal of turning the authorities on the serial fraudsters. Imagine what help it would be for EFCC and Police when they are provided with evidence from hundreds, even thousands, of people scammed by the same fraudster.

Be a part of this, don't let fraudsters keep taking us for granted. Let's shine light on their ugly tactics and spoil market for them.

Report a fraud at http://www.nigerianelite.com/Fraud/Report 
Tell you family and friends about this. Let's make Nigeria safe again!


Starting from today and for the next five days, you can download for free my novel and Excel business data analysis book on Amazon.




If you prefer to read the novel in its unedited bits and pieces form, then you can access it on my blog at http://www.olafusimichael.com/search/label/Akin%20Smith

Same for the Excel book, you can access it in bits and pieces form via http://www.olafusimichael.com/search/label/excel 

I have announced the free book promo on about 20 international book promotion sites and people are already taking advantage of the promotion from across the world. I used KDROI.




If the Excel book is not showing free when you try to access it, just give it some hours more and retry. Due to the time difference between us and USA, the promo time is not synced automatically for all time zones.

Take advantage of these offers. Enjoy!

Download: my novel and/or 
Download: Excel business data analysis book 

image: doaikido.com
The most helpful lesson I have learned in my short period of being a full-time entrepreneur is that it pays to be bold.

If you don't like your job. Quit it.
If you want something. Go for it.
If you have a dream. Build it.
If you have an idea. Implement it.

In 2013, I had read too many books on entrepreneurship and the future with technology. I became unhappy with being an employee with most of my waking hours dedicated to working on a technology that is not cutting edge. I was learning of all these beautiful things that are possible through technology and I was too drained by my day job to be a part of that reality. There was another aspect to my frustration. I am a fast learner. I easily outgrow my jobs. I have had three full-time jobs with big companies and the beginning was always very tough as I had to learn lots of new things and be valuable. Then after three to five months, everything becomes uninspiringly dull. I catch myself doing the same things day in day out. So it was just natural that I would find solace and motivation from reading the stories of bold people who made bold decisions to strike out on their own. And in 2014, I joined that category of people. I took the bold decision to quit and start my own business.

For the first eight months it felt like a financially terrible decision. I was burning through my entire life savings and little hope of things getting significantly better was in sight. There were months that I missed the assurance of a monthly income. Yet I kept following my decision through with consistent actions. I kept trying to make it work.

Today, I feel more relaxed and happy that I made that bold decision and followed through even when things were tough and I got job offers.

Now I am taking bolder decisions. I am no longer thinking about today, this week, this month or even next month. I have shutdown aspects of my business that easily generates me money and I am putting in my time and resources into building something more long term. A big bet. With high opportunity cost, high accounting cost, high time cost and high effort cost. From morning to night I am working on it and no longer actively marketing. I just try to get what is enough to keep the business going and cover expenses, while I sink in the time and resources that could have got me more into the big bet.

In 2014, I didn't like my job or any paid job. I quit, started my own business and it worked.
I wanted to be the foremost business data analyst in Nigeria. I went for it and got spectacular results. I now turn away more business than I take up.
I have a dream of building a very successful high revenue company. Now I am already working on the foundation and building that dream. I constantly review my business model and adjust it in such a way that I get to achieve that dream rather than just make easy money.
In 2010, I had an idea to brush daily with my left hand. In 2013, I had an idea to write daily. For the last two years, I have never been short of ideas. I now have a notebook I keep my ideas in. I know that I will implement them. I don't let my ideas die without trying them out.

I am not the boldest person I know. In person, I don't look bold at all. I make a lot of poor decisions. I don't have everything going great for me. But one thing I learned from all the inspiring books I read is that in the end it is not your excuses that matter but your actions. So be bold, don't let anything hold you back!
This second half of the year is starting more as a learning period for me. I have turbo driven my C# and web app development learning. I am currently learning and practicing Python for automating tasks and as Django for web app development.


image: techstricks.com
I have also been refreshing my knowledge of HTML5, CSS and JavaScript. I am gearing all my learning towards application. Everything I am learning is towards filling the missing pieces required to build the applications I have always been talking about.

I plan to use Python to create web scraping scripts that will daily gather the share prices of the companies listed on the Nigerian Stock Exchange. I have managed to do some relevant practice and now have the requisite theoretical knowledge to create the Python scripts required.

The Django I am currently learning and will end up spending today to complete my online training course on is to learn more about Python for web applications and possible use in building the IoT applications I have been dreaming about. I plan to set up an always connected, to internet, Raspberry Pi, have it do some interesting things and connect to a cloud database. I heard Python might be a much better and easier ways to build IoT projects with Raspberry Pi. So I'll give it a try.

I am already past the fundamentals part of my C# learning for web app development. Now I am focusing more on practicing by building the app ideas I have written down over the last two years.

The HTML5, CSS and JavaScript I am learning are for giving excellent front-end to my web applications. Also, I recently found out that I can build Excel applications with JavaScript. And I have been wanting to create commercial Excel applications for the Nigerian market. Now, I am getting closer to fulfilling that desire.

Why am I doing all these intense learning?

I have looked into the future and I see only benefits, especially of the commercial and financial type, to knowing all these things. The Nigerian market is lacking many basic applications that do helpful things. The reason is that the current entrepreneurs are mostly not technical people and only see non-technical market needs. Also, the people with the technical skills are not bold enough to strike out on their own, they are tied to the slow ships of the companies run by the non-technical people.

I have run some tests. I have done my market validation and testing. The market is ready, the delay is with people like me who can create the solutions they need. So for me, there is no end to the opportunistic activities and financial benefits to reap if I put in the time and dedication.

Usually, the thing that knocks us the hardest are not the very things we expect and prepare for. It's like fighting and beating a Goliath only to become the Goliath to something else much much smaller. You beat your own giants and get thoroughly beaten by something much much smaller.

I am currently experiencing this. I have managed to overcome my toughest challenges but getting overwhelmed and helpless against challenges that are comparatively much much smaller. Challenges that are more like difficult small knots, as you untie one you end up creating another. In the beginning you are not much bothered, you give it attention and try to get it all sorted out quick so you can move on with your life. But it doesn't go away completely, it just keeps evolving into something else and swallows up all your time. 

You look at your life and it's all perfect except for that small knot. You wonder why it just had to be there; why it doesn't want to go away. It makes you sad and demotivated. You try to ignore it and move on with your life. And it seems to be working better than giving it attention. Now you can do something more productive and not have your life shutdown. But once in a while you still remember that it is there, and the sadness returns.

Luckily, I have some books in my library that are specifically for moments like this. Books about the struggles of the people I most admire. So yesterday, I read from two of them -- Write Good Or Die and Mark Twain: A Biographical Summary. And as expected I got a very good lifting from them, especially the Mark Twain's one. 


image: emgn.com
Steady hard work will often appear slow but in the end it works. Works better than every other thing. One just have to look beyond the giants and the knots. Face them, ignore them and do whatever you feel is appropriate regarding them. Just don't make them your main focus. Set yourself a huge mountain to climb that will make your giants and knots look like molehills. Forget about a perfect life, it doesn't exist. What to aim for is a life you can be proud of. A well motivated life. Don't get sucked into the spinning tunnel of thoughts about how a perfect life should be.

Fill your days with steady hard work towards a mountainous goal. Progress will be slow but always remember that slow and steady still works. It still wins the race.

This is the second post in the Financial Modelling series. In the previous post, I talked about Accounting Equation, Journal, T-Account, Ledger And Trial Balance. The very things that form the foundation of any company's financial records. And today, I will be continuing by talking about the most important reports in Financial Modelling: the Income Statement, Balance Sheet and Cash Flow Statement. 

Together they show in details all that is happening financially in a company. When evaluated over the past years they shed light on management strategy and performance. When projected into the future, they show what the company is worth. And these are the entirety of what Financial Modelling is about.

charteredcorporateaccountant.com

The Income Statement is a record of the company's revenue and expenses over a specified period, usually a year, half year or a quarter. And for Financial Modelling, you will be concerned more about the year one.


The Balance Sheet is the record of the company's Assets, Liabilities and Equity at a particular point in time. So you'll usually see it written as Balance Sheet as at 31 December 2015.



The Cash Flow Statement is the record of cash inflow and cash outflow of a company within a specified period. Again, for Financial Modelling we care more about one year period.



If you looked at the screenshots of the Income Statement, Balance Sheet and Cash Flow Statement I inserted above, you will notice that they look different slightly from how companies outline theirs in their annual reports. It's deliberate and the usual case for all financial modelers. Mine are standardized to work for all companies (regardless of their industry) and optimized for forecasting (which is an important piece of Financial Modelling). In fact, the very one I posted above is what I use in teaching DCF Financial Model. DCF stands for discounted cash flow. That is why I have a line called UFCF (unlevered free cash flow) in the Cash Flow Statement.

Again, don't worry about the words you don't understand now. I will explain them in-depth in the future posts.

Gradually, I am starting to progress beyond taking classes on web application development to practicing what I have been learning and building something useful for me and everyone.

My first web application will be a Fraud Report application which I will later make into a phone application.

It will allow you to report any fraud attempt you are at the receiving end of. Well, doesn't make sense to report the ones you are at the perpetrating end of. You don't want to be like the guy recently in the news who stole a phone and uploaded a selfie to the phone owner's Instagram account. I am sure you don't scam or defraud people so you'll benefit positively from this application.

The idea is that rather than putting all the work of preventing scam/fraud on the people at the receiving end, this will be an avenue to report people trying to defraud you and then we can pass the details to the right authorities. Even if it is a very small fraction of the fraudsters that are caught, this will still achieve its aim of letting fraudsters know that their is a platform dedicated to actively pursuing them.

And more importantly are the tech-using fraudsters. The ones sending fraudulent job SMS, fraudulent bank emails and fraudulent chat messages. I personally will help dig out the details of those behind the fraudulent bank emails, using my knowledge of ethical hacking. And I am sure there are other people better than me who will be glad to help out too. That way we can expose them and at least make them fear that their virtual immunity is gone. Our authorities are too low level and not tech savvy enough to pursue most of them. We can and yes, we should, and then hand them over to EFCC to finish off.

When those lazy criminally minded people know that they can be outsmarted, pursued and caught, and by a community larger than the police or government authorities; they will go back to legitimate hustling like the rest of us. And the very young and very old who most fall victim to their scams can now take delight in reporting and watching them caught.

You can access the web application and monitor my progress at www.nigerianelite.com I am still building the backend, so the appearance isn't great for now. Skeleton first before skin, that's how applications are typically built. 

Please do let me know your suggestions and feedback. Thanks!
If you have got a recurrent report you make in Excel that follows the same steps, uses the same input type and the final report has a non-changing standard structure, then Excel Macros should be your friend. With Macros you can automate the report making steps so that every time you need to make the report, you simple provide the new input data, run the Macro and you'll have in seconds the output that probably used to take you hours to make.

The best part is that Excel Macros aren't that hard to make. Just like Excel, every level of user can make some productive use of it -- be you a beginner, intermediate or advanced Excel user. Also, it is with use of it that you become more proficient and maybe become like me, making money from building Excel Macros for companies.

Today I will be taking you through a practical example that will start you on your journey to harnessing the power of Excel Macros.

You can watch the video for this practice here: https://www.youtube.com/watch?v=yHzAPGqT4f8 and the practice file is here: http://tinyurl.com/ExcelVideo23




To make the example sink well, let's assume you work for a car dealership and you are in charge of sales analysis. The company is obsessed about branding. They've got the office built to reflect the company brand, the security men even wear uniforms that are the company's corporate colour. The part that worries you though is that all reports are meant to have a particular company style format.

Font 12, Arial, Dark Blue and All Borders. That's the style format. 

There are many ways, in the practical world, to automatically apply those formats to your monthly sales report -- from creating custom styles to using copy paste formats. But today we will use Excel Macros. It is a perfect example to introduce Excel Macros without boring you will tedious irrelevant work.

So here is the table of the entire year's report. You will now use Excel Macro to store the formatting process and apply them whenever you want at the click of a button or keyboard shortcut.



First, you need to enable Developer menu.

Go to File, Options, Customize Ribbon and tick Developer in the middle right of the dialog box you get. Click on OK.




Now you have all the tools needed. You will be able to see a record macro button at the bottom left of your Excel and a Developer tab on your menu bar.



Next step is to have a Macro created for the steps we do to apply the company standard format.

Select the January's data, we will use Macro Recording to store our steps. Click on the record button at the bottom left.

Give the macro a name. Start with an alphabet and don't put space or any special symbol except underscore. Let's also tie it to keyboard shortcut CTRL + m (m for macro, but you can use any you prefer, just avoid using common ones used by Excel like CTRL + C or CTRL + V)



Now your steps are being recorded. Apply the company format style of Font size 12, Font type Arial, Font color deep blue and all borders.



Click on the Stop Macro record button. same button you clicked on to start the macro recording.

Let's test for another month -- February.

Select February's table and do CTRL + m. If you followed my steps correctly you will see Excel automatically repeat all your steps and apply the company format to the February table.



Congrats! Now you've created a Macro. You now understand the process. Next is to use the same concept/steps to create one more relevant to you. Automate those repetitive tasks you do. If I had a more complex task, it would have recorded it too and repeated my steps whenever I called on it.

Finally, let's tie the Macro to a button.

Click on the Developer tab, Insert and choose button under the Form Control section.



Draw a rectangle, in the dialog box that will pop up, select the macro you created and attach it to the button by clicking on OK.



Give the Macro button a name. And now test it by selecting March table, then click on the Macro button to watch it apply the company format to March table.




Finally, save your Excel file as a Macro enabled workbook. 




Congrats on your new Macro!

I have been having some trouble accessing my documents in my previous laptop hard disk which I swapped out on Monday in favour of the much faster Solid State Drive.

Windows would not let me access the files or even copy them out, it keeps giving an access is denied error due to file permission security settings from my previous Windows OS. I have tried to regain permission, changed ownership, used Command Prompt and even PowerShell. I only had some luck with PowerShell. It was able to get out some of my files before failing to work anymore (used the xcopy DOS command).

So I had to go back to the only tested and trusted solution I learned eight years ago -- Linux Live booting. I downloaded Ubuntu desktop Linux, created a bootable USB from it and booted into Ubuntu without installing.


It brought back pleasant memories. All the terrific (both good and bad) adventures I have had using Linux. The years I had five or six operating systems installed side by side on my PC. Usually three or four different Linux flavours and two different Windows versions. Ubuntu has been my easiest to use Linux while Fedora has been the most painful to use for me. In between are Kubuntu, OpenSUSE and Mandriva.


Today, when I booted up Ubuntu, one major thing caught my attention. It looked very familiar. I remember the 2012 version, this 2016 version still looks a lot like it and works like it. But over that same period Windows has changed dramatically. You can't put Windows 8 or Windows 7 beside Windows 10 and not immediately notice an all-round change. 

And most of these changes Microsoft is rapidly putting Windows through are good changes. For the first time, I am able to overcome the temptation to dual boot Windows and Linux. The temptation did come but this time I have strong logical reasons to not do it. My Windows 10 has all I need in an OS, much better to use and sleeker than Ubuntu (and every other Linux I know). Also, it is getting better faster and packed with more functionality than any out-of-box Linux.

It feels good to use Ubuntu again, and to even do this blog post from it, but Windows 10 is now much cooler.


I am almost done with copying out my files from my old hard disk, once that is done I will bid another farewell to Ubuntu till an unknown time and get sucked back into the now exciting world of Windows 10.