Skip to content
Pragmatic Ways Site Logo
Search
  • Home
  • Clean Code
  • Refactoring Code
  • Design Patterns
  • Data Structures

Category: Excel

link to Extract text in Excel the Easy way

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

Continue Reading
link to What is a pivot table and how does it work?

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

Continue Reading

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

Continue Reading
link to How to add a DatePicker (Calendar) to Excel Cells

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

Continue Reading

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.


Search and buy domains from Namecheap

Newsletter

© 2022 Copyright Pragmatic Ways


Free WhoisGuard with Every Domain Purchase at Namecheap

If you’re on this site, then you’re probably a developer. If you’re probably a developer, then I probably don’t need to remind you that virtually all websites use cookies to collect and send data to log files and databases. This website is not an exception. You probably have the option to turn this off via your browser, or if you really cared, you probably should just stop using the internet.