addressalign-toparrow-leftarrow-leftarrow-right-10x10arrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcredit-cardcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1languagelaunch-new-window--smalllight-bulblinklocation-pinlockm-swarmSearchmailmediummessagesminusmobilemoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahooyoutube

Updated: Nigerian Excel Users Meetup Presentation List

From: Michael O.
Sent on: Thursday, April 20, 2017 7:13 PM

Date: Saturday, 22 April 2017

Time: 10:00am – 3:00pm

Venue: Microsoft Office, Civic Tower, off Law School, Ozumba Mbadiwe road, Victoria Island, Lagos

 

 

NIGERIAN EXCEL USERS MEETUP PRESENTATION LIST (to join the waiting list indicate interest at https://goo.gl/forms/rvivGngF2cyFxqIb2)

 

Presentation 1: Lean Six Sigma with Excel

 

Summary: How Excel aids operational excellence

 

Presenter: George Aremu

 

Profile: George is a Chartered Accountant with master degree in Economics and qualified Black belt lean sigma. He is currently working as a Manager Financial Planning and Reporting at Etisalat Nigeria.

Connect with him on LinkedIn: https://www.linkedin.com/in/george-aremu-msc-acca-icbb%C2%AE-aca-acti-01385810/

 

 

Presentation 2: Centograqs

 

Summary: Cryptography, cypher text, text analytics, predictive analytics, game design, and quantitative linguistics depend on relative and absolute relationship among text objects for the purpose of creating cyphers, new technology products, enhancing security systems, and providing artificial intelligence with data to predict likely behavior of animate and inanimate systems. This study, which was initially borne out of curiosity, studied a special class of English words using methodology as in similar studies with the aim of researching the fact that they have similar or dissimilar patterns and also provide comprehensive methodology of how to carry out this research and similar tasks using Microsoft® Excel. English words whose weighted-sum is 100 percent were studied to investigate the pattern of use of English alphabets for constructing such words and to see if these words differ in construction compared to free text and dictionary words. These words are colloquially referred to as centograqs for the purpose of simplicity in this study. In particular, the study looked at pattern of initial and terminal letters, word length, distribution of letters in terms of position within words, most used letters and words with unique letters i.e. non-repeated letters within words. The results show that compared to conventional study on the pattern of construction of English words there are both similarities and divergence in results especially with respect to word length, initial, terminal and population of common letters. For instance, the average word length in the English Dictionary is about 8, which is similar to our findings here but instead of the ‘ETAION’ which are most common letters in English text, ‘EAIRON’ are the most common letters among centograqs. Also it was established that ‘SPCAUM’ are the most common initial letter while ‘EYNDRS’ are the most common terminal letters. Finally, we were able to use the findings from the study to construct a new class of cypher text which would elude character frequency methods in deciphering encrypted messages completely.

 

Presenter: Omisile Kehinde Olugbenga

 

Profile: I om Omisile Kehinde Olugbenga. I have a Bachelor's Degree in Mathematics and Master's Degree in Biostatistics. I love computers, creativity and innovation, and data science. Although I have consulted for individuals and organizations vastly in building and maintaining information systems, conduct and analyze research, manage and analyze large volumes of data, my interest keeps coming back to research and development. I am working on a career in using products of data science to enhance development in Nigeria and Africa. Microsoft Excel has made me more money than all my other skills so I learn it everyday.

 

Connect with him on LinkedIn: https://www.linkedin.com/in/omisile-kehinde-olugbenga-29787b36/

 

 

 

Presentation 3: ModelOff International Excel Based Competition

 

Summary: Working through the 2014 ModelOff World Championship Round 1 task, available at http://www.modeloff.com/wp-content/uploads/2014/11/MO14-Dealing-With-Data.pdf

 

Presenter: Charles Otoighile

 

Profile: Mr. Charles Otoghile has a degree in Business Administration and majors in Operations Management and Business Information Systems. His is certified by Microsoft USA as A Microsoft Office Specialist for Microsoft Access and Microsoft Excel – Two of the most used data applications in the world.

 

Charles has been using these applications for over 9 years and has specialized in their use for Financial Modelling, Balanced Score Card Applications Development, Business Templates Development and Automated Management/Operations Dashboard Development for Operations control and decision support initiatives.

 

He is also a trainer in these applications, taking on intermediate to advanced spreadsheet classes within work organizations and in organized training sessions. Mr. Charles is a passionate contributor in such Linkedin Groups as Excel Hero, Nigerian Excel Users, Excel Trainers, Financial Modelling in Excel and VBA Hero. Currently, he works as financial planner for one of Nigeria’s big four telecommunications company but uses his off-work time for conducting training sessions

 

Connect with him on LinkedIn: https://www.linkedin.com/in/charlesotoghile/

 

 

Presentation 4: Excel vs Power BI vs Python vs R

 

Summary: There are no more boundaries. Making the most of your business data will require you using multiple tools and going beyond the conventional. For traditional reports and analysis in the business world, Excel still rules supreme. For strategic and exploratory analysis of your business and customer data to gain a competitive edge of the competition and optimize your operations, you can no longer ignore proper data science power tools. And for creating intuitive and management relevant dashboards, self-service BI tools like Power BI are now indispensable. If you want to stay relevant in 10, 5 and, perhaps, 2 years time you need to at least know where the future is heading.

 

Presenter: Michael Olafusi

 

Profile: Michael Olafusi is the founder and lead consultant for UrBizEdge, a business data analysis firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.

 

He is addicted to programming. He loves blogging daily at www.olafusimichael.com and loves helping people with their Microsoft Excel issues.

 

He can be reached at [address removed]

 

Connect with him on LinkedIn: https://www.linkedin.com/in/olafusimichael/

 

 

Presentation 5: VBA Coding Best Practices - a 'copy and paste' test case

 

Summary: We examine techniques and strategies for writing efficient and elegant code using timed iterations of a commonly encountered excel scenario - 'copying and pasting' data. We compare code execution times for three different approaches to the 'copy and paste' problem.

 

Presenter: Adeniyi Adeyinka

 

Profile: Niyi is a finance and IT professional with  broad experience in computer networks, security/penetration testing and systems optimization - he is obsessed with finding ever better ways of getting things done and universal answers to various life and work problems.

 

Connect with him on LinkedIn: https://www.linkedin.com/in/adeniyi-adeyinka-a6366021/

 

 

Regards,

Michael Olafusi, Microsoft Excel MVP, MOS Excel 2013 & Business Data Analysis Consultant

0700ANALYTICS | [masked] | [masked] | [masked]

UrBizEdge Limited,

20, Kofoworola street, Off Lagoon Hospital,

Obafemi Awolowo road,

Ikeja, Lagos. Nigeria

Access our entire collection of Excel, Power BI and Data Analysis tutorials for free

Sign up for our monthly webinar on Business Intelligence & Excel

 

People in this
group are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy