Before we dive into learning about some of the most common types of code smells, let's first answer the important question: What are Code Smells? Code smells are common programming...

Complementary video tutorial on this topic found at the bottom of this article. What is the Factory Design Pattern? In short, the Factory Design Pattern gives you 3 main benefits: It...

What does SOLID principles mean? Proper planning prevents poor performance You don't want your software to have poor performance, do you? Do you want a poor design? An un-maintainable code base...

Object oriented programming (OOP) comes with many benefits, when implemented properly. However, designing OOP poorly will open the doors to a world of never-ending code smells. Design Patterns help...

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

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