Career Development

PII 028 [Case Study]: Using Excel-VB Automation for Smart Hospital Records Management (Featuring: A Custom app built for a Lagos based Medical Clinic)

August 22, 2016

This week's Performance Improvement Ideas (PII) newsletter features an article from my archives. It discusses one of several scenarios for potential application of custom Excel-VB programming as a low cost, user-friendly means to effective and efficient data handling and report generation in Patients Records Management for Hospitals/Clinics or Medical Centres. At the end, I append […]

Career Development

Protect Yourself from Macro Viruses [Potential Dangers of Enabling Macros in Excel-VB Workbooks From Unfamiliar Sources]

August 22, 2016

[This article was sent to members of my Excel-VB Club earlier today, and published here without password protection so interested others can benefit] In introducing you to Excel-VB Programming, over the past weeks, I've demonstrated (using screenshot images and video tutorials) the important steps regarding How-To "Enable Macro" code in a workbook to run in […]

Career Development

How I Built a Bank Transactions Monitor (BTM) ™Excel-VB Driven App as a Gift for a Client in 2006 [Another Example of Real Life Problem Solving with Excel-VB]

August 18, 2016

The app show in the screenshots below is called the Bank Transactions Monitor (BTM) ™. I built it in November 2006, for the Head of Accounts in a Medium Sized Lagos based hotel client. Above: The Login Screen The hotel's MD had hired me, on the recommendation of the company's audit consultant, to build a […]

Career Development

PII 027: Make Money Selling Spreadsheet Workbooks You Use

August 15, 2016

The key to making money is finding a solution to problems that others around us are prepared to pay us profitably for. If you know how to go about it, you CAN make good money selling the Workbooks you build for use in your work as a business user of MS Excel, or indeed any […]

Career Development

PII 026: You Can be Competent Yet Lack Confidence!

August 8, 2016

To boost your chances of making sales, you need to have sales conversations as often as possible. And that requires creating systems to generate a regular stream of sales leads/prospects. I learnt that truth the hard way, and today, I apply that learning with diligence. My ability to succeed in making sales in spite of […]

Career Development

Watch Screenshot Demonstration Video for ExcelVB Data Entry Form Driven "Simple Bookkeeping Spreadsheet"

August 8, 2016

Email sent to Excel-VB Club members last night (Sun 8th August 2016): Title: Watch Screenshot Demonstration Video for ExcelVB Data Entry Form Driven "Simple Bookkeeping Spreadsheet" 1. Click the link below to download the zipped folder. Note to reader: Fill/submit the form on the page linked below to request the actual download link […]

Career Development

[RECOMMENDED] How to Get Audience Attention at the Start of Your Presentation - By Efe Ohwofasa

August 6, 2016

When I started out in speaking, I did it all wrong! I did not know what to say or how to connect myself with the audience right from the beginning. It got to a point during a talk that some members of the audience walked out of the room while some got busy […]

Career Development

Attend Tayo Solagbade's FREE 1 Hour Talk on Potential Applications of Excel-VB Spreadsheet Automation: "Proven Strategies for Using MS Excel to Boost Employee and Company Productivity" [Sat 6th August 2016 & Sat 13th August 2016 in Ikeja-Lagos, Nigeria]

August 2, 2016

Invitation to CEOs/Independent Consultants, and other business users, as well as Trainers: Attend Tayo Solagbade's FREE 1 hour flagship talk linked below, on the tentative dates shown below, in Ikeja, Lagos... Title: Proven Strategies for Using MS Excel to Boost Employee and Company Productivity See details in talk's flyer at: http://tayosolagbade.com/sdnuggets/1-hour-talkno-5-proven-strategies-for-using-ms-excel-to-boost-employee-and-company-productivity/. […]

Career Development

PII 025: What Every Business User of Spreadsheets Needs to Boost Productivity

August 1, 2016

Quick Take-Away: This article will benefit ANY business user who wishes to understand how to get more productive work done by him/herself and/or others who work with/for him/her - using spreadsheets. My discussion is based on MS Excel, but the ideas I advocate apply to ANY spreadsheet application that offers code driven automation functionality. Over […]

Career Development

Test-Drive Tayo Solagbade's ExcelVB Automated Floating Data Entry Form Driven Version of the Accountinator.com "Simple Bookkeeping Spreadsheet"

July 31, 2016

[This post is based on an email sent to members of the Tayo Solagbade Excel Heaven Visual Basic Automation club] Few days ago, I hinted in a blog post that I was building an ExcelVB driven modeless Floating Automated Data Entry Form

Career Development

Facebook