Blog

How to use Search operators in Google

Posted on by DevPaulC
Google is the biggest and the best search engine in the world. Sometimes searching through the billions of search results can be tricky. Google search operators can help you modify the typical simple search to give you better and more precise search results. What are Google Search Operators Search operators are text modifiers to your search query that will modify your search to give you specific results. In other words, you can use Google Search Operators to make your search smarter and to find specific information or results on specific websites. Let's take a look in detail at the...read more

3 easy steps to install Windows 11 on unsupported CPUs

Posted on by DevPaulC
Windows registry hack makes the upgrade possible, but should you do it? You’re currently seeing this message: “This PC doesn’t currently meet Windows 11 system requirements” or “The processor isn’t currently supported for Windows 11”. In this post you will learn a registry hack that should instantly make things better and help you upgrade to Windows 11 with a 7th generation processor. You can go from “doesn’t meet requirements” to “ready to install” in minutes.(tested the method on a Lenovo Yoga i5-7300U. This processor in NOT on Microsoft’s compatibility list, even though this computer is 3 years old) Here’s...read more

How to Calculate BMI in Excel

Posted on by DevPaulC
The BMI calculation formula is =weight(kg)/height(m)^2. In this example, we'll apply this formula in Excel. The formula works for the metric measurements. If you have your measurements for height and weight in imperial units, you'll first have to convert them to metric. Step 1: Calculate BMI in Excel in the metric system. The weight is listed in cell A2, the height is listed in cell B2 and the BMI is calculated in cell C2. The calculation here is =A2/(B2*B2). Make sure you isolate the (B2*B2) to ensure the order of operations. Another way to write the formula would be...read more

Power BI Error: Information is needed in order to combine data

Posted on by DevPaulC
I had this happen to me on a dataset that was refreshing OK in the Power BI Desktop application but not refreshing in the service. The service was giving the error: "Information is needed in order to combine data" The dataset was a very simple combination of 2 tables. The 2 tables were a result of 2 API calls done with an API key on a cloud website. Error The error "Information is needed in order to combine data" was only happening on the Power BI service. When I was trying to refresh the dataset, it would not do...read more
Excel Task Planner for house chores

Excel Task Planner

Posted on by DevPaulC
If you’re a fan of Excel, this planner will take it to the next level. Here’s the problem with the other task planners. You setup a task and a recurrence. Let’s say you want to vacuum the house every 7 days and you plan to do it on Saturday. It works great. First Saturday, you vacuum the house and you mark the task complete. Now the next Saturday, you’ll be reminded again. But wait, we have to go to a birthday party, a new movie is in town, we can’t miss brunch with family. So you end up not...read more

Power BI – Filter SQL Data before import

Posted on by DevPaulC
Sometimes you need to filter the source data before loading into POWER BI Desktop. If you have a large SQL database with millions of records and you only need the records in the past few days it is not efficient to pull all the data and to filter it after. It takes a long time and it increases the Power BI service load. So here is how you do it. Step 1 Get Data from SQL server database and click Connect Step 2. Type in your Server Name and Database and click on Advanced Options Enter an SQL Statement...read more

Generate Sight Word Bingo Cards in Excel

Posted on by DevPaulC
In this tutorial you'll learn how to create from scratch a Sight Word Bingo Card generator so you can generate your own Bingo Cards. you'll be able to use our 180 words prepopulated in the file or use your own. What are Sight Words Most used in English, sight words are high frequency words that young children, in kindergarten or Grade 1 are exposed to. The goal is to improve reading by identifying these words quickly What is a Sight Word bingo game Sight word bingo is a game combining the game of bingo with learning of sight words....read more