Excel - 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

Pragmatic Ways is dedicated to help developers write better code. Many developers in the real world either forgot the clean coding techniques they learned back in school or never learned them in the first place. On top of that, it's one thing to have learned about the basic Object Oriented Programming concepts, but it's another thing to know when, where, why, and how to actually use them writing complex, robust, and maintainable applications.

This blog focuses on Software Engineering best practices, design patterns, data structures and algorithms, refactoring legacy software, and other critical aspects every developer should know to help them write quality code.

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.