Adam Allard - Software Engineer Blogger for Pragmatic Ways

Extract text in Excel the Easy way

Here are 5 quick formulas for you to extract text from cells in Excel. Have you ever had a problem where you need to get a specific word from a string in another cell? This type of work is...

What is a pivot table and how does it work?

Looking for the quick and simple explanation on Pivot Tables for Dummies? Allow me to explain. What is a pivot table? A pivot table is a data summarization tool. That is, it allows you to take...

How to create a drop down list in Excel

It is unfortunately all too common for many people performing data entry work to suffer from Fat Finger Syndrome. Imagine creating a detailed sales report for your company, handing it off to your...

How to add a DatePicker (Calendar) to Excel Cells

Do you need a DatePicker Calendar in your Excel spreadsheets? Follow this quick and simple tutorial to find out how. (If you prefer video, scroll down to the bottom of the page!) Step 1. Enable...

About the Author

Hi, I'm Adam Allard. I'm a Full Stack Software Engineer for Northrop Grumman creating web applications for the DoD. At this time I'm primarily working with Java and Angular based applications, although I have some years of experience in various languages and frameworks from previous jobs where I dabbled with Python & Django, C# & Xamarin, PHP, and Bootstrap. My hobbies include time with my family, wondering when the Green Bay Packers will win their next Super Bowl, drinking over-priced beer, and of course learning and teaching.

Legal Foobar

Hi, my name is Adam Allard and I own and operate this site, Pragmatic Ways. Full Disclosure: I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. I also participate in other affiliate programs with NameCheap, Clickbank, CJ, ShareASale, and other sites. I get compensated a few pennies every time you click on one of these links and purchase a product or service. I promise to only promote products and services I use, trust, and stand by myself. If you continue to click on these affiliate links and purchase services from these vendors, I can continue to purchase enough coffee to help me keep writing new content for this blog.