[FREE 4 Hour Crash Course]

This 4 hour training [FREE for members of my Excel Heaven Visual Basic Automation Club] will introduce you to the use of smart hacks, VBA code and advanced spreadsheet functions to extract data from your large spreadsheet database into dynamic menu-driven automatic ONE SCREEN report generation interfaces.

Date: Saturday 22nd June 2019

Time: 1 to 5p.m (To Be Agreed)

Venue: Sherryville Arcade

Fee: FREE [But text YES + your name, occupation, WhatsApp No. and email address to +234 803 306 1263 to book your place]

I will be using my popular Excel-VB Payslip Generator software as a basis for real life case study demonstration.

But attendees are encouraged to bring their own large spreadsheets (no matter the size) so I can show them how to replicate the automation they learn in their own spreadsheets.

You will go home with the improved version of the spreadsheet database you come with.

I have personally created a niched market in/out of Africa for myself by building custom applications to meet the needs of niche markets I identify e.g my popular Payslip Generator, Ration Formulator, and Poultry Farm Manager.

A medium-sized medical establishment paid me $1,000 USD equivalent in Naira, to build a custom app for its management reporting. That’s apart from income I earn selling my pre-built apps to clients across over 20 states in Nigeria, and other countries (Canada, UK, UAE, Tanzania, Uganda, Ghana, Guinea etc)

In teaching what I know, I draw DEEP on my over 2 decades of expertise and experience (7 years in paid employment, and over 15 years in self-employment) as one who has built high performing Excel-VB software (adopted for official use in a corporate multinational + purchased by clients in and out of Africa) to guide learners.

[Above] Quick Tip

Let’s say you – or an employee – want to know the exact details of his/her salary (breakdown) for a particular month, this query table comes in handy. ALL the cells colored black require entries to be made into them.

1. Click in the NAME field. Use drop menu button that appears to choose the name you want.

NB: If you are sure you know the correct spelling, you can type the name of the employee you want, directly into the field. Any other parameter can be used to extract information from a database of this nature – including NUMERIC values like Identification No. or Account No. and so on.

2. Click in the MONTH field and choose the month you wish to check salary for.

Summary : If you have correctly entered data in the Salaries Data table for the chosen employee, the table will return the appropriate values for him/her for the period specified.

PRINTING PAYSLIPs

1. You can print 15 pay slips at a time. Click in the first black colored cell in the row under the “Print Pay Slips For Staff Below” heading. Use drop menu to select name you want.

2. Move to next row, and choose another name. Delete ANY entries in the remaining cells below the last one you want to us.

This is NECESSARY to ensure the program does NOT print excess slips, that will be useless, and cause paper/ink wastage!!

3. Next, click the “View Pay slips” button above. The program will display the EXACT number of pay slips, each with the chosen employee’s name, at 6 pay slips per page. Scroll through to be sure all is OK.

4. Finally, click “Print Preview Pay slips” to print the prepared pay slips. Repeat process for the next 15.

Click “Home” to return to the query table view.

[Above] Quick Tip

This is the monthly summary table + the accompanying bar chart (below it). They show how much salary payment is made by department.

You may find this information/analysis of salary “spread” useful in your company’s decision making.

Summary : Click in the black colored cell and use the drop menu button that appears to choose the month for which you want to view salary information displayed by department.

The changes in data occurs within seconds in both the numeric report as well as the bar chart below it.

PRINTING: Click “Print Preview Summary” button to print the sumary table with the bar chart.