Category Archives: Uncategorized

The IF function in Excel is an inestimable ally when we need to implement conditional logic, that is when we need different results depending on a condition. The syntax is IF(logical_test, [value_if_true], [value_if_false]), where logical_test is an expression that evaluates to TRUE or

Project tutorials are a very popular way to start building your first few projects. But unfortunately most people go about it in the wrong way and don’t end up learning very much in the process. In this article, I will provide some tips on how to properly learn from tutorials

When dealing with Excel workbooks, data may be structured in a way that doesn’t fit your needs and objectives. Sometimes, you may need to split the content of one cell into different cells. You may also need to do the opposite, combining data from multiple columns into one. The

Machine learning and AI may dominate the tech headlines, but the most important skill in the data science industry is something much older — almost 50 years old, in fact! Despite its age, SQL is still the most important language for data work. How has a five-decades-old language managed to remain

What is a CDN?A Content Delivery Network (CDN) helps you deliver your content more quickly. You can serve any type of content that remains unchanged over a period of time, like images, videos, CSS, JavaScript, HTML files, PDFs, and more. A CDN is a group of servers that are

I have written about the Google Search Console before and covered how to use it from a 30,000 foot view. Now, I want to dive deeper into what the Search Console measures, and things I have learned while using it that can help you better leverage this tool. If

How do you make your React applications responsive for any sized device? Let’s see how to do so by making our own custom React hook. At the top of my React site is a Header component. As I decrease the size of the page, I want to show fewer links:

REST was not the first protocol for sending information over the web. But for over a decade, it has dominated the API landscape. More recently, GraphQL, a newcomer designed by Facebook, has become more and more popular. It is intended to correct some of REST’s weaknesses, but no technology