Blog

Top 10 Excel websites

Posted on by DevPaulC
Are you looking to improve your Excel skills and become a spreadsheet pro? Look no further! In this blog post, we've compiled a list of the best Excel websites that offer a variety of resources for all skill levels. From video tutorials to online courses, these websites have everything you need to take your Excel knowledge to the next level. So whether you're just starting out with Excel or looking to brush up on your skills, these websites have something for you. If you prefer to learn using video, here is a list of the best Excel YouTube channels....read more

How to update Excel 365

Posted on by DevPaulC
If you think you may not be running the latest version of Excel as part of the Office 365 subscription, follow he steps below to check and update your desktop version. Note: If you are looking for an updated version of Excel to try the new XLOOKUP, you may not have it yet if you are on a Semi-Annual Channel. Learn about the Office update cycles and how you can still use XLOOKUP even if it's not in your desktop version of Excel. 1. Go to the file menu in Excel. Click on account 2. Click on the drop-down...read more

How to calculate age in Excel

Posted on by DevPaulC
To calculate age from date of birth in Excel, you must use one of the two formulas below =(TODAY()-DOB)/365.25=DATEDIF(DOB,TODAY(),"Y")where DOB is the range (cell) that has the Date of Birth value Age calculation can be done if you have a set of data containing the Date of Birth. Excel has two simple ways to do it. How to calculate age in Excel using subtraction Here is some sample data for the first formula (calculation was done on 2019-10-08, that is the value of TODAY()) How to calculate age in Excel using DATEDIF If you're asking yourself what is the...read more

How to copy files from WD My Cloud to the attached USB Hard Drive – the fastest way

Posted on by DevPaulC
I had a personal WD My Cloud for a while working as a NAS and I recently added a second Hard Drive for redundancy. I wanted to make sure my data is stored in 2 places in case one of the drives fails. When I connected this second Hard Drive, I mapped the new Shares onto my computer and started to transfer files. It takes FOREVER. So I researched for the fastest method to do that without keeping my computer occupied with this task. And here it is. How to copy files from WD My Cloud to USB drive...read more

Word Cyphers for children

Posted on by DevPaulC
Caesar Cipher: This is a simple substitution cipher where each letter in the message is shifted a certain number of positions down the alphabet. For example, if the shift is three, then A becomes D, B becomes E, and so on. Kids can use this cipher to encode and decode simple words and messages. Morse Code: Morse code is a system of dots and dashes that represent letters and numbers. Kids can learn the Morse code alphabet and use it to encode and decode words and messages. Binary Code: Binary code is a system of zeros and ones that...read more

Word Puzzles ideas for children’s parties

Posted on by DevPaulC
Crossword puzzles: create a simple crossword puzzle with easy clues that kids can solve. Use age-appropriate words. Word search puzzles: create a grid of letters with hidden words. Kids will enjoy finding the words and crossing them out. Jumbled words: scramble a word and ask kids to unscramble it. Start with simple words and increase the difficulty as they progress. Word ladder: create a ladder of words where each word is one letter different from the previous word. Kids must figure out the sequence of words to climb the ladder. Hangman: choose a word and ask kids to guess...read more

Power BI error: We’re unable to connect. Please delete your credentials and try again later. 

Posted on by DevPaulC
If you have this error in Power BI, there is a simple solution that might solve it. Before trying this make sure you use the latest version of Power Bi, as accepted by your organization and your Power BI tenant administrator. It will also help if you reboot your computer. If any of these do not solve your problem, follow the steps below. Step 1. Go to the File Menu - Options and Settings, and click on Data Source Settings Step 2. Select the Data Source causing you the error and Click on Clear Permissions Step 3. Go back...read more

What’s the Difference Between Restarting and Shutting Down your computer

Posted on by DevPaulC
It seems logical. When you leave for a long time, shut down and when you just installed your computer restart. It’s not that simple. What happens when you shut down your computer Up until Windows 8, it used to be that a shutdown would turn off the power of your computer completely, clear the memory and it would be a similar action with unplugging the computer. However 2 things changed with Windows 8.  More people started to use laptops, computers with a battery on board, therefore computers would now be capable of saving some of the data in memory...read more

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