vba

Excel For Everyone: A Guide that doesn't call you a Dummy

Excel book

An Excel guide that teaches you to be an Excel guru instead of just throwing a bunch of geek-speak at you. This book is backed with over 20 years of Excel and data analysis experience in a wide field of industries. Written in a casual and entertaining style which readers of all levels can appreciate. This isn't your grandpa's Excel for dummies book!


Anyone who knows me, knows I made my living as an Excel geek. But now in my waning years I am returning to my first love; writing. While I've already written and published over 5 books (paperback, ebook, & audiobook), I wanted to write a book that kind of turns the page on my Excel guru days. But my book on Excel isn't a "for dummies" book, but rather it's for all the people who I've helped and who have supported me along the way in my "Excel life".

Read More

Excel Help: Formulas and VBA

What if there was an Excel Tool that did most of the things you try to do each day? Comparing two columns to figure out which is different. Or close all your open workbooks, saving some and not others? How about increasing a range of cells by a certain percentage markup? Using my 20+ years with Excel proficiency I have developed a free Excel tool that I share with users. It's free because I want to help people who like me search for solutions from people rather than companies. You can get my XLSuperTool at this link. But what if you need more detailed help with your Excel spreadsheet or workbook project? I have helped people from all sorts of industries; Logistics, freight forwarding, banking and finance, personal fitness, warehousing, and sales. See experience. Since 2007, I have had a presence on MrExcel which is a very helpful forum for quick Excel-based questions.

Read More

Excel as a Database

Excel as database

So you want to use Excel to act like a database, after all a database is mainly a list of lists right? Well, most databases such as SQL databases are very complex and almost convoluted in how they relate to data via primary keys and such. Did I lose you? Okay, then back to Excel, something you and I both can understand right? I've been using Excel for over 20 years and have now designed an easy to use process to make Excel behave like a simple database. Granted, this wasn't really feasible in the past as not until Excel version 2007 could you store more than 65,536 rows of data on each tab. Now you can store 1,048,576 rows. Now we're talking!!!

Read More
Subscribe to RSS - vba