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

[This post is based on an email sent to members of the Tayo Solagbade Excel Heaven Visual Basic Automation club]

 

<a href=”http://tayosolagbade.com/sdnuggets/join-my-excel-vb-club-get-my-farm-business-software-free-3-great-bonuses-expires-midnight-monday-1st-august-2016/” target=”blank”>Few days ago, I hinted in a blog post that I was building an ExcelVB driven modeless Floating Automated Data Entry Form</a} into the “simple accounting spreadsheet” (featured at <a href=”http://accountinator.com/2012/11/simple-accounting-spreadsheet-excel/” target=”blank”>http://accountinator.com/2012/11/simple-accounting-spreadsheet-excel/</a>

 

I also wrote an email to that effect, to “Mark” the US based owner of the Accountinator.com accounting spreadsheet, adding that I could help him convert it to a full Excel-VB driven software, like mine, complete with smart data entry forms and dynamic report generation menus etc.

 

Attached to this email are the following:

 

1. a copy of the demo version of the spreadsheet with the fully functional auto form.

 

As you’ve done for other VBA coded workbooks, you’ll need to enable macros when you open this workbook – otherwise the macro buttons in it will not work.

 

2. Two screenshot images showing:

 

A. The Raw Data Entry Table with over 30 fields into which entries are to be made.

 

This version of the Accountinator.com spreadsheet allows for up to 15,000 rows of entries to be made. It can however be extended to take thousands more.

 

But the main benefit of automation added here is the modeless Floating Automated Data Entry Form which all entries can be made.

 

Click the Make Entries button at the top left of the spreadsheet table, to load the auto entry form.

 

Try posting entries using the drop menus and text fields on the form. The interface is intuitive, so I’m leaving you to play around with it for a few days, to see how it works.

 

NB: A short video showing me posting entries using the form will be emailed to you later in the week.

 

B. The Data Entry Table Title Settings Iinterface

 

To change any of the field/column titles in the data entry table, this is where you type your changes.

 

Once you’re done, click the sheet tab to go to the data entry table. There you’ll see the new title appear in the corresponding field heading.

 

The change you made will also show up in the drop menu on the floating form’s drop menu.

 

The above shows how one-size-fits-all automation can be used to save time and effort.

 

 

[MP3 Audio] The Secret to Succeeding Financially As a Service Provider

Preview: Why it never pays to price yourself cheap, and how to confidently offer fees that make you profitable, to clients you carefully recruit based on their need (ability to pay) for the solution you offer.

 

Format: MP3 Audio

 

Duration: 15 minutes

 

Filesize: 6.9 MB

 

Author: Tayo K. Solagbade

 

Web: www.tayosolagbade.com

 

E-Mail: Tayo at tksola dot com

 

Target Audience: Tayo Solagbade’s Inner Circle Members

 

Tip: The ideas discussed here can be successfully adapted for selling products as well.

 

Click here to request the audio

 

 

Join my Excel-VB Club & Get My Farm Business Software FREE + 3 Great Bonuses [Expires Midnight Monday, 1st August 2016]

Several variants of this time limited offer were sent out this morning, to different mailing lists of my clients, subscribers etc.

 

<blockquote>

 

I’m on a drive to recruit more members for my Excel-VB Automation club. To this end, I’m making promo offers to learning institutions (or departments within them), businesses as well as non-profits, to sign-up as “branches” of the club so they can get FREE access to weekly email. PDF, and video tips for their students/employees/staff.

 

Membership is $65 USD* per annum

 

*[Note that the equivalent fee to pay in Naira is N13,000.0 because I’ve resolved to continue – for THIS recruitment drive -using the same N200 to $1 USD rate I launched my club offer with in June 2015. Currently it’s N370 to $1 USD]

 

So simply pay N13,000.0 (Thirteen Thousand Naira) on or before midnight Monday, 1st August 2016, and get full membership, plus the 4 bonuses outlined below.

 

*****************************

Bonus membership benefit 1:

******************************

 

FREE copy of any of my software of your choice. See examples like my popular Ration Formulator, Poultry Farm Manager at <a href=”http://tayosolagbade.com/sdn-sell.htm” target=”blank”>http://tayosolagbade.com/sdn-sell.htm</a>.

Get 50% off for others like General Accounts Manager, Automated Cash Bank With Bank Reconciliation, Automated Payslip Generator etc at <a href=”http://excelheaven.tayosolagbade.com/” target=”blank”>www.excelheaven.biz</a>.

 

******************************

Bonus membership benefit 2:

******************************

 

FREE time/effort saving Custom Automated Floating Data Entry Form incorporation into workbooks used by members for their work.

 

In other words, each member will be able to send in one workbook s/he uses for work, to have me incorporate intelligent data entry form based automation into it, to eliminate the need to manually interact with the spreadsheet, scrolling over large, potentially confusing areas.

 

Instead, s/he would simply be able to stay on the loaded form and post all needed entries into the spreadsheet without needing to go to each individual cell.

 

This feature can make doing your work many times more enjoyable than it currently is – and your productivity would skyrocket. You’ll be able to complete your routine spreadsheet data entry tasks in less than half the time you currently spend doing it.

 

To get an idea of how powerful this feature can be…

 

==================

Here’s a user guide video screenshot demonstration, for an app I built to take 1 year’s worth of income/expense cash book data:

==================

 

Name: Excel-VB driven “General Accounts Manager” with modeless floating automated data entry form

 

First built in 2007 for a medium sized hospital in Lagos, based on their paper based accounts & manual Excel reports.

 

See the video demo at

<a href=”http://

https://www.youtube.com/watch?v=lUl4_RAja-g” target=”blank”>http://

https://www.youtube.com/watch?v=lUl4_RAja-g</a>

 

*****************************

Bonus membership benefit 3:

******************************

 

Each member will also get copies of demo applications I build based on real life manual workbooks I find online.

 

An example is the “simple accounting spreadsheet” (featured at <a href=”http://accountinator.com/2012/11/simple-accounting-spreadsheet-excel/” target=”blank”>http://accountinator.com/2012/11/simple-accounting-spreadsheet-excel/</a>) to which I recently added such a custom data entry form into.

 

<a href=”http://tayosolagbade.com/contact.htm” target=”blank”>Click here to request screenshot of the form during testing about 48 hours ago.</a>

 

It is now fully functional.

 

I have written to “Mark” the US based owner of the Accountinator.com accounting spreadsheet, about the “potential benefits of converting it to a full Excel-VB driven software, like mine, complete with smart data entry forms and dynamic report generation menus.

 

*****************************

Bonus membership benefit 4:

******************************

 

Note that members will be given the Visual Basic Editor password to be able to open and view the forms, the activeX controls as well as the Excel-VB code that makes them work the way they do.

 

They will also get step-by-step tutorials on how I built in the form based automation.

 

In other words, they will get real world relevant coding knowledge they can readily put to use in their work.

 

Final Words

 

The above bonuses cannot be combined with any other offers or benefits.</blockquote>

 

<h3><a href=”http://tayosolagbade.com/contact.htm” target=”blank”>Click here if you’d like to take up this offer</a></h3>.

 

Have a great weekend.

 

Tayo

 

3 Secret Keys to Make Your Website Sell Successfully

In this article I highlight 3 easily overlooked – yet crucially important – features that, if missing, can drastically limit the effectiveness of a website in generating the desired volume and quality of sales leads to the owner.

First, let me define what I mean by “Volume” and “Quality” of leads:

Volume of Leads:

The rule in online marketing is similar to that observed offline. Basically for every 100 persons exposed to your marketing message, only 1 to 3 can reasonably be expected to respond with an enquiry – which will not necessarily result in a sale.

That means only 1 to 3% of visitors to your site are likely to contact you. Given such low prospects it becomes crucial that you set your website up to harvest that small number of potential clients/buyers, for every 100 site visitors as often as possible.

Quality of Leads

Getting the desired number of prospects in is one thing, but even more important is getting the RIGHT quality of prospects!

This second aspect is also dependent on the “message” you communicate to those visitors that eventually become enquirers. What you tell them on your website, and how you say it will influence the impressions they get about what you can do for them, and ultimately move them to connect with you.

If you fail to do it right, you could end up attracting people with the wrong mindset and expectations from you.

That would mean your chances of converting them to clients after they make contact, will be reduced. And if you succeed in winning them over as clients, it’s likely you may be unable to satisfy them.

You don’t want do that to yourself. Which is why It is in your best interest to address the 3 important features I discuss below:

1. Article Marketing Highlights:

To succeed with markeing online, Article Marketing can boost your ability to generate leads.

To make the most of your writing, you need to publish your articles on a blog, linked to your site, with latest ones preferably auto-displayed on the website.

But how you do that also matters. Specifically, you must not make the mistake of serving article titles alone.

The display of new article titles on the site, without corresponding
display of brief previews under each, denies readers additional incentive to
click and read.

If they don’t have something that draws them in to read, they’re likely to spend less time and eventually click-away without connecting with you.

2. Opt-in form offerings:

You need to make opt-in form offerings that appeal to the range of potential clients you have.

For some of us, our target audiences are multiple in nature. We therefore need to make offers to appeal to their respective interests.

One possible way is to send confirmed subscribers an autoresponse email with
a link to access a downloads page where all the promised “gifts” can be
accessed by each subscriber.
The opt-in form’s “visual display”
will need to be designed to inform visitors of the multiple offers – each
targeted at the different audiences you serve.

If the functionality to put the above in place does not already exist on your site, you may need to have your developer incorporate it.

3. Clickable Slideshow Images:

To make optimal use of the space capital on your website, especially the home page, you can make use of a slideshow.

However, not just any – it’s best you make the individual images clickable in the slideshow.

And you need to know how to access the slideshow from the administrator back end of the site, to add the images you want along with their corresponding URLs.

If that’s not possible, or you can’t spare the time, be sure to retain the services of your developer to do that, because you will need to peridically make those changes, for marketing purposes over time.

Final Words

The 3 features discussed above, if missing from your site, will prevent you from making the most of visitor traffic we’re getting.

This is because you will not be serving them enough “response-generating” information, visually, to draw them in to the extent that they do more than just look around and leave.

You need visitors to feel a need to go a step further and make contact with a
view to learning more from you via other stuff you announce that you offer – apart from articles and other standard information.

A key measure of your success will the volume and quality of LEADS you generate.

1, 2 and 3 if correctly put in place, and used, can boost the results you get, with that regard, over time.

[Recommended] 10 Excel tricks for CAs (Chartered Accountants) – By Isabelle Bell, CA Today

*This article by Isabelle Bell, CA Today
contains potentially useful information – for ALL business users of MS Excel*

PREVIEW: Love it or hate it, Microsoft Excel is one of the most essential tools to any CA. We’ve asked some of our resident Excel wizards for their top tips to make your working life a bit easier.

Click here to continue reading

PII 024: Use Custom Modeless Floating Data Entry Forms to Effortlessly Post Unlimited Entries into Large Spreadsheets Without Stress (Video Demonstration from Real Life Apps)

This week, I’ve chosen not to write much. Especially because what I want to share is better appreciated audio-visually. That’s why I’ve added 2 of the user demonstration videos for my Excel-VB driven apps to illustrate my point.

And what is the point? It is that when you’re a business user of Microsoft Excel, especially as an accountant, you will find it periodically necessary to build and interact with large spreadsheet tables with lots of columns and rows.

 

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade's Performance Improvement IDEAS(PI Squared) Newsletter

Tayo Solagbade’s
Performance Improvement
IDEAS
(PI Squared) Newsletter

Monday 25th July 2016

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016.
I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

**********

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 024: Use Custom Modeless Floating Data Entry Forms to Effortlessly Post Unlimited Entries into Large Spreadsheets Without Stress (Video Demonstration from Real Life Apps)

This week, I’ve chosen not to write much. Especially because what I want to share is better appreciated audio-visually. That’s why I’ve added 2 of the user demonstration videos for my Excel-VB driven apps to illustrate my point.

And what is the point? It is that when you’re a business user of Microsoft Excel, especially as an accountant, you will find it periodically necessary to build and interact with large spreadsheet tables with lots of columns and rows.

Doing so will necessarily involve scrolling in different directions for long periods and that can sometimes get both confusing and tiring. It can also be quite hard to find specific data you’ve entered after some time.

In thc course of building bullet proof custom automated Excel-VB driven apps for clients, I discovered that some of them did not want to learn to do what I did. They just wanted me to do it all for them. And they were often prepared to pay to get an app that was novice-proof.

In order to deliver that kind of benefit to them, I had to come up with creative ways to enable them do their work using my apps. The result was that I began using modeless data entry forms, customized to do what the client wanted.

That included auto-scrolling to select specific cells in huge spreadsheets containing over 50,000 records, with over 100 columns of data.

They loved me for it. and told others about me as a result. In this edition I invite you to watch the videos below, and listen as I explain how my custom floating data entry and report generation forms work in the apps featured below.

If you’d like to know how I can help you incorporate such smart form automation into your existing workbooks, click here to send me a message.

1. Excel-VB Poultry Generating The Dynamic Farm Operations Reports & Key Performance Indicator (KPI) Charts for Layers and Broilers – Daily/Weekly/Monthly

2. Advanced Payslip Generator DEMO 1 : Modeless Data Entry Form MS Excel-VB Driven Version (2012)

SDN Blog™

New posts from last week*

Monday:

[Tuesday]:

[Wednesday]:

[Thursday]:

 

[Friday]:

N/A

[Saturday]:

[Tutorial 01 – ExcelVB Coding Tips & Tricks for Accountants: How to Enable Macros in different versions of MS Excel I.e 2003, 2007, 2010 and 2013!]

[Sunday]:

THE FARM CEO (Issue 55): On-farm biosecurity as perceived by professionals visiting Swedish farms, Protecting produce: Ten African countries get biosecurity investment, Australia and Africa to work together on plant biosecurity

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners).

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region.

His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter.

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts

he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to

SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas

THE FARM CEO (Issue 55): On-farm biosecurity as perceived by professionals visiting Swedish farms, Protecting produce: Ten African countries get biosecurity investment, Australia and Africa to work together on plant biosecurity

This week’s theme for the Farm CEO newspaper is Biosecurity.

1. On-farm biosecurity as perceived by professionals visiting Swedish farms

On-farm biosecurity is an important part of disease prevention and control, this applies to live animal contacts as well as indirect contacts e.g. via professionals visiting farms in their work.

The objectives of this study were to investigate how professionals visiting animal farms in Sweden in their daily work perceive the on-farm conditions for biosecurity, the factors that influence their own biosecurity routines and what they describe as obstacles for biosecurity.

Click here to continue.

2. Protecting produce: Ten African countries get biosecurity investment | Global Development Professionals Network | The Guardian

The Australian International Food Security Research Centre recently announced the launch of a two-year, $800,000 initiative for sub-Saharan Africa. The project aims to help 10 countries become better equipped to combat plant biosecurity threats.

So, what is biosecurity?
Biosecurity broadly refers to ways of preventing or mitigating the threat of pests and diseases affecting animals, plants and humans. It can include food safety hazards, animal diseases and plant pests.

Click here to continue.

3. Australia and Africa to work together on plant biosecurity

PRESS RELEASE

29 October 2014

A cadre of ‘change champions’ are to be trained to improve plant biosecurity in ten east and southern African countries.

Plant biosecurity specialists in national plant protection organisations, and in trade and private sector organisations have identified plant biosecurity training needs for ten African countries. Matched training in Australia will follow, with the resulting ‘biosecurity change champions’ working to improve regional biosecurity to impact farmer incomes, food security and safe regional trade of agricultural products.

The Australia-Africa Plant Biosecurity Partnership held a workshop on 27-28 October in Nairobi that has pinpointed key areas where Australian expertise can strengthen African biosecurity. East and southern African countries that are included at this stage are Burundi, Ethiopia, Kenya, Malawi, Mozambique, Rwanda, Uganda, Tanzania, Zambia and Zimbabwe.
Click here to continue.

[Tutorial 01 – ExcelVB Coding Tips & Tricks for Accountants: How to Enable Macros in different versions of MS Excel I.e 2003, 2007, 2010 and 2013!

[*Hint: See PDF tutorial attached to email sent to you announcing this blog post]

To get started using Excel Visual Basic you have to access the Visual Basic Editor (VBE) interface in your copy of Microsoft Excel.

The VBE and related tools are not visible by default – you need to know how to get them to display.

The steps described in the attached “ExcelVB Tutorial 01 for Accountants” PDF will guide you to do it for any version of MS Excel you have to work with, from 2003 up till the latest version.

Note that the steps for enabling macros in Excel 2003 apply to earlier versions.

Next week, in Tutorial 02, I will describe the steps involved in Creating a Macro to do a simple task like formating a cell or current selection using the Currency style and Accounting Format to improve the appearance of Excel reports you prepare.

Below: Two Real Life Examples That Confirm Excel-VB Coding Skill Will Make ANY Accountant Highly Valued In Paid or Self-Employment, Worldwide!

For those still not sure how useful Excel-VB coding skills can be to them on the jiob, and in boosting their careers to the next level, below are links to 2 different websites that offer concrete evidence of the value placed on possession of Excel-VB coding competence by an accountant.
1. First is this introductory course priced at approximately £1,000.0 GBP.

Title: AUTOMATING YOUR REPORTING WITH EXCEL VBA MACROS (AN INTRODUCTION) OVERVIEW

Preview: You could make Excel work harder, particularly repetitive reporting tasks. This course introduces Visual Basic for Applications (VBA) – the language used to write macros.  

Through the use of hands-on examples the course will illustrate the process of creating bespoke reports from large quantities of data (no previous programming experience required).
http://www.accaglobal.com/uk/en/discover/events/england/professional-courses/vba-reporting-macros-jul.html

2. Secondly, this article offers information about learning institutions that teach coding to accountants, as well as high profile international organizations like KPMG, that regularly scout for competent accountants with real world relevant coding skills.

Title: Sure, Accounting Students Should Learn How to Code (And a Lot of Other Things, Too)

Preview: While very few accounting programs require students to learn to code, some strongly encourage students to consider it. Brigham Young University’s School of Accountancy is creating several master’s-level classes on dealing with data in accounting.

These classes will focus not only on manipulating, analyzing, and reporting data, but on coding as well.
David Wood, Ph.D., an assistant professor who is one of the faculty members designing this coursework, said the classes will include learning some SQL and Visual Basic for Excel, and other programming concepts.

“Writing code is a tool, and if you have that tool, it provides you an opportunity to do things that others can’t,” he said. “Would coding benefit an accountant? There’s no question it can help.
http://goingconcern.com/post/sure-accounting-students-should-learn-how-code-and-lot-other-things-too

[PROMO] Purchase 1 Year Membership of My ExcelVB Club as a GIFT for Professional Accounting Exams Student(s), and I’ll Give You My Custom Excel-VB Software FREE

As I said in my newsletter this past Monday, I’ve been promoting new offers of my Excel-VB solutions to a potentially lucrative niche market I’ve identified.

In other words, apart from Farm CEOs, I now have another primary target audience: namely Professional Accountanting Firms/Individuals.

Tomorrow I will publish excerpts from an elaborate 2-in-1 offer I’ve been making to a carefully profiled group of accounting firms.

Suffice to say, for now, that the responses from the Managing Partners has been phenomenal. Details tomorrow.

In the rest of this article, I announce the public version of an offer I’ve already made to members of my Inner Circle:

[PROMO] Purchase 1 Year Membership of My ExcelVB Club as a GIFT for Professional Accounting Exams Student(s), and I’ll Give You My Custom Excel-VB Software FREE

I’m preparing to give out 1 Year FREE membership of my Excel VB Club to randomly selected accountants preparing for professional (e.g ICAN/ATS) exams in tuition centres.

To this end, I’ve been meeting tuition centre CEOs to formally make this offer, in order to encourage the centres to purchase membership as club branches.

This will afford learners at their centres FREE access to my tutorials while there.

How it works:

I’m offering clients/others the option of sponsoring 1 or more slots in exchange for a product or service GIFT from me.

If you purchase membership for 1 or more persons, for instance, I would GIFT you a custom version of any app you choose that is of equivalent value.

Take for instance my Hotel, Restaurant & Bar Manager Software.

This app is already fully functional. The Restaurant & Bar module allows the user to add/select product names, prices using drop menus and various automated charts and report summaries can be generated with few clicks.

It’s an improvement over the first one I built for a small restaurant in Gbagada-Lagos upon my return from my 2005 trip to Ghana

I mentioned it in this old article: Click here to read.

Standard Selling Price = N50k

Members of my Inner Circle, get 65% discount, which means they can have it for N17.5k.

Now 1 year membership of my ExcelVB club is $65 USD.

But the current exchange rate makes a mockery of the conversion value.

So for this promo I offer the N200 to $1 USD rate I launched my club with – meaning it comes to N13k Naira equivalent.

So a member of my Inner Circle would only pay N13k, instead of N17.5k to get the app. The idea is to reward you for agreeing to sponsor a new club member slot.

That means money paid will be for membership (naira value for 1 to 2 or more slots) of the club, while I will give you the app of equivalent naira value, less discount – FREE.

I’ll personalise and send you the app, with details about your restaurant business that you supply. There will also be a PDF step-by-step guide as well as downloadable video tutorials for users.

Most importantly, I will announce to the beneficiary of the FREE club membership that YOU are his/her kind sponsor. And I will send you a photo showing us meeting for the first time at which time I will present him/her a letter reflecting your “donation” – copy via email to you.

Click here to let me know if you have questions or require clarification..

You Need to Be a Consummate Professional to Succeed as a Service Provider

service provider, my experiences – and studies of the writings of reputable others – have taught me that in order to excel in serving clients, one must continually strive to be a Consummate Professional (CP).

I describe a CP as an expert who passionately – but intelligently – channels his/her quality time, effort, and resources towards supporting (and empowering) clients to do what they do better.

This is something I’ve done for years – and I happen to do it quite well too. So well in fact, that I’ve built long term friendships with many clients, most of who have never even met me in the flesh – yet they tell others good things about me!

Let me explain what being a Consummate Professional entails – based on what I do:

1. Thinking like a Consummate Professional

You will actively devote quality time and intellectual effort to thinking up new and creative ideas to help him/her get optimal value from his/her investment in your services.

This can be hard for many experts, because most of us tend to settle into a formal routine for doing what we do.

So once we get hired, we just pull up our template and fit the client in, then do it.

The truth is however that every client, being a unique human being, will often be better served, with a unique and original solution tailored to meet his/her stated needs.

I’ve found that doing that never faills to wow the serious minded results focused clients I work with.

That’s why I recommend that you do it as well.

2. Acting like a Consummate Professional

In this regard, you will seek every opportunity that presents itself, to communicate insights your “thinking” generates, to the client, subtly coaching and nudging him/her to use them to advance in the direction of the goal(s) s/he has told you s/he wants.

You will also relentlessly prepare and deliver to the client, every single benefit you promised him/her at sign up.

You will do all of that – without fail – regardless of whether or not s/he remembers the exact details of what you promised to deliver, or what was agreed.

But that’s not all…

Probably the most important aspect of acting like a Consummate Professional will be your demonstrated commitment to CONTINUE doing all of the above no matter what goes wrong.

In other words, you would do this regardless of any ups and downs that may happen in your relations with the client, or indeed with other clients/persons – including family.

That sounds easier than it really is to do. I say this from years of doing it!

It takes deep passion and a steely brand of integrity to do it as described above – especially when things are not going too well in other aspects of your life.

Imagine for instance, having to finish a book writing project before the deadline in a 2 week period, when you’ve run badly short of cash needed to keep things going smoothly on the home front.

This can be quite hard to deal with, especially if you have dependants e.g a spouse/kids leaning on you for financial support.

That, as you can undoubtedly imagine, – can make CONTINUING to be a CP in the mould I recommend here, much harder!

Trust me when I say this…

I’ve been there countless times, and I can tell you it takes major mental stamina to keep doing a good job under such stressful psychological circumstances!

Then if – on top of that – you find yourself having domestic problems or worse – unexpected setbacks with regard to work related resources (e.g your computer develops a fault or crashes!) – it can feel like the whole world is against you.

When it gets that bad, if you’re superstitious (like some people are), you might even begin to imagine “evil” forces controlled by persons who dislike you are responsible :-)

Let me tell you this: No matter how you feel about difficulties you’re going through, it is never wise to let it affect the work you do, if yiu can help it.

What’s more, you are unlikely to end up okay if you choose to tell your client you’re having such problems.

Why?

Because your private affairs have little to do with him/her. S/he is not paying you to come tell him/her stories about what’s not working for you. Instead s/he is expecting you to SOLVE his/her problem as agreed – and for which s/he is paying.

That’s not to say s/he won’t sympathize with you, if you told him/her. It’s just that THAT will not address the need s/he felt strongly enough to hire you to meet in the first place.

What I do, and recommend to others is: go ahead, no matter how hard it gets, and finish the job to the client’s satisfaction, BEFORE (if at all ever) mentioning such problems to him/her.

You see, your competence as a professional will reflect in the way you manage yourself in tough times, while delivering your service to the client.

a truly CP would do it so well that the would never be the wiser!

Guess what?

If you suceed in doing that to the very end, you’ll emerge a much stronger person, with even greater ability to do the same thing again and again – for that client, and others.

The best part is you’ll also end up with a string of satisfied clients, raving about your ability to deliver what you promise unfailingly. That kind of reputation has a way of attracting new and repeat business – which in turn has a way of helping to resolve problems one has in other areas of life e.g low/no cash etc!