Category Archives: Excel-VB Solutions

Career Development, Entrepreneurship, Excel-VB Solutions, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

SDAc’s Microsoft Excel Heaven™ Visual Basic Automation Club & COMPETITION [Watch the Full Video Narration of 9 Page Slideshow – by Tayo K. Solagbade]

Leave a comment

On this page, you can watch the FULL series of video narrations by Tayo K. Solagbade, based on the 9 page slide show for my MS Excel Heaven VB Automation Club and Competition offer.

(a). The club offers serious minded business users a platform to learn useful spreadsheet automation skills using MS Excel-Visual Basic.

(b). The competition provides such business users with a REAL WORLD relevant challenge that they can use to test their new skills, thereby building the confidence to deliver greater value to their employers or clients – leading to increased productivity and income.

(c). The Kiddie’s arm of the club aims to promote zero cost spreadsheet programming skills development in kids, to solve everyday problems.

I’m offering FREE membership to pupils and students whose learning institutions (or centres/club) take up membership.

Interested individuals wishing to provide a platform for others to participate, can function as “club” e.g., YOU can organize for groups of people to come together to form a “branch” of the club, under you.

Each club “branch” simply pays the $65 USD annual membership fee and ALL learners who come through THAT “branch” get the full club membership benefits, outlined in the club flyer (click here to view full details).

[NB: I am also reaching out to sponsors to cover membership fees for them or to sponsor the competition – I have my own prize, so whatever sponsors bring in will just be extra (see details in the 9 page slide show – click here)]

Watch the videos below, to hear me explain the MS Excel-VB Club and Competition Offer in detail…

Video 1: Spreadsheet Automation Can Boost Your Success [What MANY African Professionals Are Missing]

Watch on Youtube: https://www.youtube.com/embed/jPeswWW6IgY

Video 2: Who is This MS Excel Heaven Visual Basic Club & Competition For and Why…?

Watch on Youtube: https://www.youtube.com/watch?feature=player_embedded&v=CvY5_kkqnoU

Click here to contact me about purchasing club membership ($65 USD) now….

Video 3: MS Excel Heaven Visual Basic Competition: To compete, you must be a member of SDAc’s Excel-VB club

Watch on Youtube: https://www.youtube.com/watch?feature=player_embedded&v=6OMBSiBQlu4

Video 4: MS Excel Heaven VB Competition: But Why a Competition on MS Excel-VB Automation?

Watch on Youtube: https://www.youtube.com/watch?feature=player_embedded&v=Yqqa6VdpOO8

Video 5: Eligibility and Features/Requirements for Membership

Watch on Youtube: https://www.youtube.com/watch?feature=player_embedded&v=Gmy9RchOLpM

Click here to contact me about purchasing club membership ($65 USD) now….

Video 6: What You Can Do: Participate or Partner…!

Watch on Youtube: https://www.youtube.com/watch?feature=player_embedded&v=RwNCLlEEXD0

Video 7: Get World Class Excel-VB Solutions Development When You Join My Club

Watch on Youtube: http://www.youtube.com/watch?feature=player_embedded&v=cxvuvBiends

NB: In the above video I mention my Excel-VB Election Results Compiler & Reports/Charts Generator, which I built to PROVE the point that MS Excel is NOT just useful for handling financial data, but it CAN (and is used worldwide) for everyday purposes in virtually any field.

See the videos and screenshots of the Election Results Compiler in use at http://tayosolagbade.com/erc/index.html

Click here to contact me about purchasing club membership ($65 USD) now….

Video 8: Brief Bio – About Me – In Paid/Self-Employment

Watch on Youtube: http://www.youtube.com/watch?v=EvIa0CtZ8S0&feature=player_detailpage

Learn more about my MS Excel Heaven Solutions at http://www.excelheaven.biz or http://www.excelheaven.tayosolagbade.com

 

GET FREE MEMBERSHIP OF THE MS EXCELVB CLUB: If you’re a student accountant (preparing for professional exams), or pupil/student (primary to secondary), you can join FREE by getting your centre or club to sign up!

Click to download flyer - Join My Spreadsheet Solutions Development Club and Boost Your Productivity

Microsoft Excel-VB Programming Coaching for Business Users (On Demand 4-Day Practical Workshop)

In this 4 day coaching workshop, I share practical tips on boosting your productivity using MS ExcelVB programming. If you use MS Excel for your work, what you learn will help you get MORE done, FASTER and with LESS effort. I use my commercial apps (e.g. Ration Formulator, Poultry Farm Manager, Payslip Generator, Automated Cash Book), and the new Election Results Compiler to show how it’s done!

NB: All members of my MS Excel-VB club get 50% discount to attend this workshop.

During this 4 day coaching you will learn to: click here to continue…

Click to download flyer - In this 4 day coaching workshop, I share practical tips on boosting your productivity using MS ExcelVB programming. If you are an expert and use MS Excel, what you learn will help you get MORE done, FASTER and with LESS effort. I use my commercial apps (e.g Ration Formulator, Poultry Farm Manager, Payslip Generator, Automated Cash Book), and the new Election Results Compiler to show how it's done!

NOW AVAILABLE: Excel-VB Elections Results Compiler & Reports/Charts Generator – Click now to view examples of summary reports and charts auto generated by this new Excel-VB driven app. I built it mainly to demonstrate how Excel can be used to boost productivity in everyday activities.

Screenshot 1 (Above): The Navigation Menu/Switchboard - a Custom Graphic User Interface (GUI) I create to help users find their way around quickly | Excel-VB Elections Results Compiler & Reports/Charts Generator - Click now to view examples of summary reports and charts autogenerated by this new Excel-VB driven app. I'm building it mainly to demonstrate how Excel can be used to boost producitivty in everyday activities.

Screen shot 1 (Above): The Navigation Menu/Switchboard – a Custom Graphic User Interface (GUI) I create to help users find their way around quickly

Click here to contact me about purchasing club membership ($65 USD) now….

Screenshot 2 (Above): The multi-clickable map of Nigeria, that I use to auto-generate reports for ANY state I click on the map.- another example of how I use Custom Graphic User Interfaces (GUIs) to help users find their way around quickly. The intuitive GUIs that I creatively incorporate is why I call my Excel-VB apps 'Excel Novice Proof!'. It's also why I use the tagline: 'If you can use a mobile (or smart) phone, you can use my custom Excel-VB apps'.

Screen shot 2 (Above): The above interactive map of Nigeria in my Election Results Compiler app, enables the user auto-generate reports for ANY state clicked on the map. Another example of how I use Custom Graphic User Interfaces (GUIs) to help users find their way around quickly.

Note that this interactive map feature can be EASILY customized for use by ANY business – even a multinational – to enable busy top decision makers/CEOs click to instantly view state-by-state summaries of sales, expenses, production etc data!

The intuitive GUIs that I creatively incorporate is why I call my Excel-VB apps “Excel Novice Proof!“. It’s also why I use the tag line: “If you can use a mobile (or smart) phone, you can use my custom Excel-VB apps“.

Join my MS Excel-VB Club and you will begin learning to automate Excel like I do. Attend my 4 day on-demand MS ExcelVB Programming Coaching Workshop and you will soon be building and selling YOUR OWN apps (like I’ve done for years), earning useful extra income – even if you’re still in paid employment!

Click here to contact me about purchasing club membership ($65 USD) now….

 

Career Development, Entrepreneurship, Excel-VB Solutions, General, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

[Video 4 of 9] MS Excel Heaven VB Competition: But Why a Competition on MS Excel-VB Automation?

Leave a comment

[Read this text transcript & watch the full video below] MS Excel is taught as part of basic computer appreciation in many schools today (even primary level). And most persons in paid/self-employment use it for various aspects of their work.

Based on the above, adding Excel VBA programming education to what is being taught is only a logical progression.

My achievements prove ExcelVB training confers ready-to-use income earning application development skills useful in ANY socioeconomic environment.

Excel-VB programming works so well because MS Excel, the development platform, is familiar to most computer users across the world.

The best part is that just like any other programming language using in coding, Excel-VB proficiency can be developed by anyone with interest – who can read and write/type!

Now, there’s ONE unique advantage of developing apps with VBA compared to other programming languages

You can even start with the Macro Recorder – using it to record the steps you follow in carrying out your spreadsheet tasks, and then studying the code it generates to Learn How to Write VBA Code!

Click the links below to watch other videos in the series:

Videos 1 & 2: Spreadsheet Automation Can Boost Your Success [What MANY African Professionals Are Missing]

[Video 3 of 9] MS Excel Heaven Visual Basic Competition: To compete, you must be a member of SDAc’s Excel-VB club

You can download the FULL 9 page slideshow from http://tayosolagbade.com/excelcluboffer

Career Development, Entrepreneurship, Excel-VB Solutions, General, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

[Video 3 of 9] MS Excel Heaven Visual Basic Competition: To compete, you must be a member of SDAc’s Excel-VB club

Leave a comment

[MS Excel Heaven™ Club & Competition Offer: Part 3 of 9] : To compete, you must be a member of SDAc’s Excel-VB club.

This is part 3 of 9 of the video narrated version of the 9 page Slideshow about the Excel Heaven Visual Basic Club & Competition.

I explain why intending competitors must join the club – and what benefits…

Click the links below to watch other videos in the series:

Videos 1 & 2: Spreadsheet Automation Can Boost Your Success [What MANY African Professionals Are Missing]

[Video 4 of 9] MS Excel Heaven VB Competition: But Why a Competition on MS Excel-VB Automation?

You can download the FULL 9 page slideshow from http://tayosolagbade.com/excelcluboffer

Career Development, Entrepreneurship, Excel-VB Solutions, General, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

Video: Spreadsheet Automation Can Boost Your Success [What MANY African Professionals Are Missing]

Leave a comment

The Justification for Adopting Custom ExcelVB Spreadsheet Automation – Many Africans still don’t get it. Sometimes Off-The-Shelf Applications will NOT meet your needs well enough! There is an industry that is MISSING on the continent, that can help reduce unemployment: It’s the Excel-VB Solutions Development Industry!

Watch the videos below, to hear me explain in detail…

 

 

Click here to download the 9 page slideshow about the MS Excel Heaven™ Visual Basic Club.

It explains how you can participate in the competition…or how you can become a sponsor.

Learn more about my home study Excel-VB workbook (here) and video tutorials, my 4 day practical workshop as well as my custom Excel-VB software development service.

 

 

Career Development, Entrepreneurship, Excel-VB Solutions, Farm Biz, General, My DN Travel News, My Ideas for Making Nigeria Better, Parenting, Public Speaking, Self-Development, Writing/Blogging

SDAc’s Microsoft Excel Heaven™ Visual Basic Club & COMPETITION [For Business Users & School Kids] – Download 9 Page Offer Slideshow

Leave a comment

(a). The Microsoft Excel Heaven™ Visual Basic club offers serious minded business users a platform to learn useful spreadsheet automation skills using MS Excel-Visual Basic.

(b). The competition provides such business users with a REAL WORLD relevant challenge that they can use to test their new skills, thereby building the confidence to deliver greater value to their employers or clients – leading to increased productivity and income.

(c). The Kiddie’s arm of the club aims to promote zero cost spreadsheet programming skills development in kids, to solve everyday problems.

Cover for the 9 page PowerPoint slideshow - click to submit a web form request to get the download link

Who is this club/competition for?

a. Paid club membership is open to all business users in all fields e.g accountants/financial/tax consultants, sales/marketing professionals, corporate executives, Quantity Surveyors/engineers etc.

b. FREE membership open to persons preparing for professional examinations at accredited tuition centres. No payment is required from the students. However, the tuition centre is required to pay the $65 USD MS Excel Heaven Visual Basic Club annual membership fee . That single payment covers ALL student in that centre.

NB: Professionals (who have passed exams and already practicing) can also compete – but must join the club independently, by paying the annual fee of $65 USD per annum.

Sponsor the competition or the MS Excel-VB Club for Kids…

There are various ways you can come on board as a partner or sponsor (financial and non-financial) for the club and the competition. A special dimension is the MS Excel Heaven™ VB Club for Kids. Aimed at build income earning coding skills in school kids. Contact me for details of the foregoing and more.

The MS Excel Heaven™ VB Club for Kids:

No payment required from kids. Instead each school (or parent) pays ONE TIME membership fee.

That makes the school (or family) instant members – with FULL benefits.

Call Tayo Solagbade on +229-66-122-136 (Benin) or +234=803-302-1263 (Nigeria).

To learn more about how to join the club or compete, OR to be a SPONSOR, send a message/request the 9 page slideshow from www.tayosolagbade.com/excelcluboffer

Career Development, Entrepreneurship, Excel-VB Solutions, General, Self-Development

Microsoft Excel-VB Programming Coaching for Business Users (On Demand 4-Day Practical Workshop)

Leave a comment

In this 4 day coaching workshop, I share practical tips on boosting your productivity using MS ExcelVB programming. If you use MS Excel for your work, what you learn will help you get MORE done, FASTER and with LESS effort. I use my commercial apps (e.g Ration Formulator, Poultry Farm Manager, Payslip Generator, Automated Cash Book), and the new Election Results Compiler to show how it’s done!
Click to download flyer - In this 4 day coaching workshop, I share practical tips on boosting your productivity using MS ExcelVB programming. If you are an expert and use MS Excel, what you learn will help you get MORE done, FASTER and with LESS effort. I use my commercial apps (e.g Ration Formulator, Poultry Farm Manager, Payslip Generator, Automated Cash Book), and the new Election Results Compiler to show how it's done!

During this 4 day coaching you will learn to:

> Design your worksheets using best practice techniques (This is a crucially fundamental requirement for ensuring optimal producivity using MS Excel)

> Use range names to make your formulas more powerful – and also save you time in building them

> Use Index/Match Formulas and Sum Product Formuas to extract, organize and analyze data

> Record and Run Macros to automate spreadsheets

> View, edit (and ultimately WRITE your own) VBA code

> Create and work with Pivot Tables

> Design intuitive graphics enhanced with smart VBA automation to make life easy for users

> Work with multiple workbook using links

> Use comments/custom views and protect workbooks

> Save Excel worksheets as web documents

> Use Excel as a simple database to create reports and analyses

BONUS: FREE CD containing workbook tutorials covering major topics/exercises

During the 4 day coaching, you will perform extensive hands-on exercises to reinforce the knowledge presented in class.

Exercises include:

> Building an automated cash book for daily, weekly, monthly and annual business report generation. Attendees will leave with applications they create – as well as one of my Real Life Automated Cash Books

> Building a Membership Records Manager that can be used for ANY organization e.g schools, churchels, clubs, alumni associations etc (you get the Real Life app FREE)

Visit www.excelheaven.biz to watch different videos of my home study tutorials and bullet proof Excel-VB driven apps

CASE STUDY:

Step-by-Step demonstration of how I created an interactive map of Nigeria in my Excel-VB Election Results Compiler app, enabling a user generate instant summaries by clicking individual states. See www.tayosolagbade.com/erc. I explain how businesses can use it to generate national sales reports etc

NB: Join my SDAc’s Microsoft Excel Heaven™ Visual Basic Club and you will be able to invite me to conduct this event for 5 or more persons at 50% discount. Click here to contact me.

Learn more at www.excelheaven.biz or www.excelheaven.tayosolagbade.com.

Career Development, Entrepreneurship, Excel-VB Solutions, Farm Biz, General, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

Join My Spreadsheet Solutions Development Club and Boost Your Productivity

Leave a comment

Join My Excel Heaven Visual Basic Membership Club: MS Excel is available on most PCs anywhere, and it has it’s own development platform. ANYONE competent in Excel VB programming can therefore earning income developing low cost custom applications at zero cost!

Click to download flyer - Join My Spreadsheet Solutions Development Club and Boost Your Productivity

There is a HUGE Excel-VB industry across the world that most people are not aware of.

Many professionals in various fields provide custom ExcelVB solutions to clients they support e.g. Accounts/financial consultants, engineers etc. I want to help such experts become more productive and profitable.

Whether you are in paid employment or run your own business, joining this club can help you.

Required Investment: $65 USD per annum

NB: Join my Inner Circle (Fee = $500 USD) & get LIFETIME Membership(no renewals) – See http://tayosolagbade.com/uploads/InnerCircle.pdf

Membership Benefits

a. You’ll be able to invite me to give a FREE talk on Potential Applications of Excel & you get FREE access to a Home Study ExcelVB workbook & video tutorial you want from my library (See some of my apps at www.tayosolagbade.com/sdn-sell.htm)

b. You get a full personalized home study tutorial, created by me at 50% discount, based on details you provide about a specific task you do routinely in MS Excel, which you want automated.

c. You get access to my custom Excel-VB software development service (& ANY of my products) at 50% discount.

d. You get FREE access to my online one-on-one coaching (via email) on MS Excel VB Solutions Development. Any day/anytime. Simply tell me what you do in MS Excel that you wish you could do faster/more accurately. I give you tips on what to do/how.

e. You will be able to invite me to conduct my 4 Day flagship Practical MS Excel-VB Programming Workshop to ANY small groups (5 persons minimum) at a location of your choice at 50% discount.

See the seminar PDF flyer (here), and the video demos/tutorial trailers at www.excelheaven.biz or www.excelheaven.tayosolagbade.com

How to Join the Club…*

Pay $65 USD or buy products/services worth $65 USD from me: You get ONE YEAR membership. Special Offer: Pay N5, 000.00 (Five Thousand Naira) before midnight Wednesday May 12, 2015, and get LIFETIME membership.

*MS Excel Heaven™ VB Club for Kids:

No payment required from kids. Instead each school (or parent) pays ONE TIME membership fee.

That makes the school (or family) instant members – with FULL benefits. Click here for details.

I have a special interest in developing Excel-VB coding skills amongst young people from an early age.

A child who leaves school with Excel-VB coding skills will be able to easily make him/herself useful to others engaged in serious vocations. Even starting from his/her school or instritution!

Tha above is why I’m launching the “kids” version of my club.

My custom Excel-VB apps have been purchased by buyers across Nigeria, and in Canada, Tanzania, UAE, UK etc.

Click here to contact me

Learn more at www.excelheaven.biz

 

Career Development, Entrepreneurship, Excel-VB Solutions, My DN Travel News, Self-Development

Get Excel-VB Home Study Tutorials Created Specifically for YOU!

Leave a comment

If you do routine data recording, analysis and report generation, using MS Excel, I can show you how to optimize and automate your work, to achieve HUGE savings in time, effort and even money! The best part is you do can learn from me in the comfort of your home or office. Anytime of the day.

Over 2 decades of experience in developing custom Excel-VB Solutions for business users equip me to develop solutions for clients, and also to teach them to do so for themselves.

That’s because I create custom learning resources based on the work you do in form of videos, workbooks and web pages for you to study. Plus, you get email, chat and telephone coaching.

My tutorial workbooks come with videos showing me creating the workbooks I send you from scratch.

If you’re interested, I can also create for YOU, videos showing the steps I followed in building ANY of my existing apps, that you choose. You will be able to see EXACTLY what you need to do to create them yourself.

A good example is my very popular Payslip Generator which comes in 2 versions – Basic and Pro. The latter features a powerful floating, modeless data entry form that handles routine entry and editing of salary information.

The graphic user interfaces of my apps are also quite intuitive, making it easy for a complete Excel novice to learn to use them in a short time (often ONE day).

When you learn from me, I show you how to make your apps user-friendly in the same way. Your colleagues will LOVE you for it, as did mine when I was an employee!

Get Everything I Teach You, On a Branded Autorun DVD

Click here to continue reading…

Click to visit my Facebook page (opens in new browser window)

Career Development, Entrepreneurship, Excel-VB Solutions, Farm Biz, My DN Travel News, My Ideas for Making Nigeria Better, Self-Development

[2 Part Video] Tayo Solagbade’s Excel-VB Elections Results Compiler & Reports/Charts Generator – Based on INEC Nigeria’s Summary of Results for the March 28th, 2015 Presidential Elections

Leave a comment

In this 2 part video demonstration, summary reports and charts are auto generated by my new Excel-VB Elections Results Compiler & Reports/Charts Generator, which I built mainly to demonstrate how Excel can be used to boost productivity in everyday activities.

[I began building the app around 25th April 2015. Today, 7th May 2015, I’m putting up the 2 part demonstration video, below, of the fully functional app, ready for use]

The idea here is to show the potentially limitless ways you can use Excel to boost your routine data recording, analysis and report generation in ANY field you work.

Most people think Excel is only useful for financial reporting.

NOT TRUE!

In reality ANY activity in which data handling/manipulation for trending and decision making happens CAN be improved with use of MS Excel …especially when smart functions and intelligent VBA coding is employed by competent persons.

Imagine your organization being able to click each state (or LGA, Zone, even country) on ANY map to generate instant tables and charts of products sales totals, marketing expenses and other data across your sites nationwide, for a day, week, month, year etc?

That’s what I’m trying to show with this app!

Click here to watch the 2 part video demonstration of this app in use

If you’d like to own a copy of the fully functional version, click here to let me know.

Screenshot 1 (Above): The Navigation Menu/Switchboard - a Custom Graphic User Interface (GUI) I create to help users find their way around quickly | Excel-VB Elections Results Compiler & Reports/Charts Generator - Click now to view examples of summary reports and charts autogenerated by this new Excel-VB driven app. I'm building it mainly to demonstrate how Excel can be used to boost producitivty in everyday activities.

Career Development, Entrepreneurship, Excel-VB Solutions, General, My DN Travel News, Self-Development

Become a SUPER Accountant, Engineer, Marketer or Insurance Broker

Leave a comment

Many financial reporting apps allows users to EXPORT their data into MS Excel. That’s because it’s data handling and report generation capabilities are unrivalled. But Excel is so versatile that it is also used for many non-financial purposes as well.

Since 2004, Chartered Accountants, Quantity Surveyors, Insurance Brokers, Marketing managers and owners of SMEs have hired me to develop Excel-VB apps.

Many were good with MS Excel, but lacked my ability to “program” Excel. My mission is to coach those interested to program Excel like I do, so as to spawn a new breed of skilled professionals that will expand the market I have created for spreadsheet solutions out here.

NB: For those who may not have the time or interest to learn, I can build the app you need: ( Contact me)

Does your work require you to carry out elaborate data collection and anaysis for formal report generation purposes?

Do you wish you could do so faster, with less effort and in less time?

Do you in fact wish you could AUTOMATE most of what you routinely do with MS Excel so that you could get more work done?

Many professionals, like those I have mentioned above, do their work using MS Excel without knowing how to program it.

I discuss real life examples for EACH group, in a special podcast I’m publishing next week.

Click here to let me know if you want to be notified when it goes live.