You can view the YouTube recording of the webinar here. I talked extensively about the different major levels of data analysis -- Descriptive, Exploratory, Predictive and Prescriptive analysis. Then I focused on predictive analysis and the ones possible to carry out in Excel.

Some of you may already know that you can do moving average, simple exponential smoothing and regression in Excel. Well, in the webinar I showed that you can also use Excel for double exponential smoothing, triple exponential smoothing, sentiment analysis (using Azure ML add-in), decision tree (using an add-in) and other predictive analysis methods.


Here is the download link for the practice file and below are the PPT slides (in image format).










Most people use Excel for just descriptive analysis and are even unaware of its predictive analysis capabilities.

For this month's webinar, I will be showing you how you can use Excel for predictive analysis.

I will be walking you through time series prediction, regression and other predictive analyses you can carry out in Excel. And their application to sales forecasting, better planning and budgeting.

You shouldn't miss it!

Date: Wednesday, 31 May 2017
Time: 3:00pm to 4:00pm

To make it easy for you not to miss, you can set a calendar event for it with reminder notifications. To join in, click on the YouTube live link and you would be in on the day+time of the webinar. No need to install anything and it works even on phones. That is the amazing power of YouTube live broadcast.

As usual I will be using practical real-life mirroring examples. At the end of the webinar you would have taken your data analysis skills and Excel knowledge forward. You can also ask questions live during the webinar and benefit from the answers to other people's questions.



To always be in the loop of future webinars, you should sign up to the webinar directory list at http://eepurl.com/bKwoaT 
Tecno has become famous for producing high quality budget tablets for the African market. It is also an extremely fast-developing company with a great future.

Simply check out these three best Tecno tablets of 2017 that certainly deserve your attention! Find the latest Tecno tablets at the best price – visit https://jiji.ng/tablets/tecno 

Jiji features a huge selection of goods, cost-effective deals without overpaying, only real sellers, smart search system and the most effective anti-scam policy.



Tecno 8H DroiPad 8
The model will cost you around ₦26,000.00.
Tecno 8H has a large 8-inch display and front speakers. It operates on Android 5.0 (Lollipop). Its quad-core processor is clocked at 1.3GHz. DroiPad 8 has 1GB of RAM and 16GB HD. The battery is 5100 mAh to serve you even more.
DroiPad 8 has a 5 megapixels back and a 2 megapixels front cameras for cool pics and selfies as well as video calls.



Tecno DroiPad 10 Pro II
This gadget will cost you ₦90,000,00
Tecno DroiPad 10 Pro II runs on Remix OS and has a 10.1-inch IPS TouchScreen display with the resolution of 1280 x 800 pixels making it an ideal gadget for gamers and movie lovers.
The device’s 10 Pro II CPU is 64 Bit Quad-Core Cortex A53 (4 x 1.3GHz), GPU - Mali T720 MP2 (Dual-Core).
The Tecno DroiPad 10 Pro II can boast of a 7000mAh battery allowing you to use it for 51 days in a standby mode and 14 hours of active usage. It’s equipped with a 5-megapixel back camera and a 2-megapixel front camera and both of them have a LED FLASH.
DroiPad 10 Pro II has 2GB of RAM + LP DDR3 allowing decent multitasking and more economical battery consumption. It also features 32GB HD expandable to 256GB or even more.



Tecno WinPad 2
This model will cost you ₦120,000,00.
Tecno WinPad 2 will suit both businessmen and students. It has a portable keyboard and IPS technology for the HD display.
The Tecno WinPad 2 operates on Windows 10 OS with a 64-bit Intel Quad-core processor and 2GB RAM.
The back camera with auto focus is 5MP and the front camera is 2MP.
The gadget is compatible with 3G/4G LTE networks. It features 3 USB 3.0 ports, a Mini HDMI and a Micro SD.
The battery capacity is 7000mAh allowing up to 10 hours of active usage.




Tecno was the first brand on the market to offer decent tablets at affordable prices. Time flies, Tecno tablets are getting better, but their price stays reasonable. Therefore, make a wise choice to buy one of Tecno gadgets.






Culled from: https://ng.usembassy.gov/education-culture/exchange-programs/educationusa-student-achievers-program-edsap/

There are many determined and talented, low-income students in Nigeria who only require financial resources and access to information to better their educational future. For the 11th year, the United States Embassy, Nigeria seeks to identify academically qualified and highly motivated, low-income students in Nigeria to join the EducationUSA Opportunity Funds Program (OFP).
OFP’s mission is to assist talented and determined, low-income students who are good candidates for financial assistance from U.S. colleges and universities but lack the financial resources to cover the up-front cost of obtaining admission.
OFP works closely with students through regularly scheduled meetings and seminars to assist them throughout the application process to secure admission and scholarships to attend colleges and universities in the United States. OFP finances the cost of the application process, including registration fees for required standardized examinations and provides free membership to the U.S. EducationUSA Advising Center for its participants. OFP expects a sincere commitment from the students to give their energy and time to the program so that they may achieve their dreams of study in the United States.
Applicants are welcome from all the states in Nigeria. However, students must be able to reach our offices in Abuja or Lagos on a monthly basis during the program for full participation. Participants will work with our EducationUSA Advisors from June 2017 – August 2018 to try to secure places and financial assistance to begin study in the U.S. in August 2018.
NOTE: ENTRANCE INTO THIS PROGRAM IS NO GUARANTEE OF A SCHOLARSHIP OR FINANCIAL ASSISTANCE TO STUDY IN THE U.S.

HOW TO APPLY

OFP is accepting applications from prospective undergraduates and graduate students.
Send an email to AbujaEducationusa@state.gov or LagosEducationusa@state.gov requesting an electronic undergraduate or graduate application form.

SELECTION CRITERIA

The selection of finalists for OFP is highly competitive, given limited funding. We look for applicants with:
  • Strong academic record/ transcript
  • Robust participation in extracurricular activities
  • Involvement in leadership roles
  • Excellent community service participation
  • Financial Need
NOTE:  Undergraduate Applicants– If WAEC results are not available; the student must be currently in SS3. If WAEC results are available, they must be from May/June WAEC.
Students who have already started a University education are NOT eligible to apply.

Requirements

  • Academic Results:Undergraduate Applicants– Attach a copy of your WAEC “O” Level results (from WAEC website).  Include Cambridge A’Level or IGSCE results if applicable or available.
    Graduate Applicants– Attach a copy of your Final year results and degree results (if available) First Class only (STEM majors preferred).
  • Letters of recommendation:Undergraduate ApplicantsRequest a teacher or your school principal to complete a letter of recommendation form, attesting to your character, talent and skills.  Please do not include a basic testimonial that does not talk about you as an individual.
    Graduate Applicants: Provide the details of a lecturer, professor, or Head of Department (HOD) that we can contact to find out more about you.
  • Transcript:Undergraduate Applicants: Send a scanned copy of your transcript from JS1 to SS3 including your mock and first term results, if possible.
    Graduate Applicants– Send a scanned copy of your transcripts that show a GPA of 4.5 or above on a 5.0 scale. 
  • Essays:Write two essays, one from Group A and one from Group B, each of about 250– 300 words. The essay topics will be on the application form you receive. (Essay topics will be found on the form)
Send a scanned copy of any relevant supplementary certificates of achievement
NOTE: Please send all documents to AbujaEducationusa@state.gov or LagosEducationusa@state.gov  as attachments with proper titles e.g. “Femi King Transcript”, “Femi King WAEC” etc
Abuja Address:
EducationUSA Advising Center
Public Affairs Section
Embassy of the United States of America
Plot 1075 Diplomatic Drive
Central District Area, Abuja.
Tel: 09-4614251; 09-4614241
E-mail: AbujaEducationusa@state.gov
Lagos Address:
EducationUSA Advising Center
Public Affairs Section
U.S. Consulate General
2, Walter Carrington Crescent,
Victoria Island, Lagos
Tel: 01-4603801; 01-4603803
E-mail: LagosEducationusa@state.gov

APPLICATION DEADLINE- JUNE 16, 2017
image: thefreshexchange.com
"Youth and Useful!" That was the theme of Chapel of Faith Youth Fellowship (CYF) for 2005. The student fellowship I attended from 100 level to 500 level. Why I am able to remember this theme was our president then, Tosin Ojajuni, centered it around enjoying the christian journey. We often get too hung up on the destination that we forget to realise that God counts the journey just as important.

I try to extend that theme to every year of my life.

I am naturally not an adventurous person. My idea of fun is eating what I feel like eating, sleeping for long hours, reading and working. Going out and having fun is not fun to me. So I am probably not the person you would expect to delight in journeys.  But because of that amazing realisation that 2005 theme awaken in me, I have been one of the humans who are obsessed with following the right and fun path than just arriving at the dream destination.

My work is completely guided by my passion. I do just the very things I am passionate about. And since I recently came to another important realisation that it just takes a few millions to be rich, I have become more deliberate in the path I follow to wealth. I want to get there right.

I want to create amazing contents. Write all I can. Live fully. Enjoy the little moments. Value the occasional disappointments. Do everything I admire in my heroes. Be a sincere person. Have no secrets. Keep no memories. Think only of today and tomorrow, and what more value I can fill them with. And share the journey with as many people as possible.

Whatever your dream is, do try to also enjoy your journey there.
image: investing.covestor.com
You can access the Excel file here: NSE Daily Trade Data

The Market Highlights:

The market was bullish today. The NSE rose by a whooping 2.10% (it has risen this high only five times this year and three of which were this month!).
The market capitalization rose to N10.05 trillion and the index rose to 2,9064.52 The last time it got this high was on 1st of July, 2016 (almost a year ago!).
Many stocks got to their 52 weeks high today: First Bank, Guaranty Trust Bank, Nestle, Pharma Deko, Presco, Tourist and Zenith Bank.
The top gainers were: First Bank (10.14%), Oando (7.66%), Guaranty Trust Bank (5.00%), Ecobank (5.00%), Zenith Bank (4.99%), Flour Mills (4.98%), AXA Mansard (4.97%), Airservice (4.48%), Eterna (4.87%), PZ (4.76%), Jaiz Bank (4.40%), Fidelity Bank (4.12%) and Okomu Oil (4.11%).
The top losers were: Mobil (-5.00%), Learn Africa formerly Longman Nigeria (-4.94%), NAHCO (-4.93%), Vitafoam (-4.92%), AFRPAINTS (-4.86%), Cadbury (-4.85%), NEM (-4.67%) and NPF Microfinance Bank (-3.82%).

What do I think?

I think this is just the beginning. Over the last 10 years, the economy has roared on and inflation has been double digits and company profits have been growing impressively but the stock market has been doing the opposite. Most companies are selling at huge discounts.