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!
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.
