Blog

Dock keeps moving on the other monitor on MacBook

Posted on by DevPaulC
Do you use a MacBook with an external monitor and have the issue that the dock keeps moving to the other screen? Apparently, this is not a bug but a feature. Apple designed the Dock to move where you "need" it. If you want to force it back to the MacBook main screen, all you have to do is to go back the the screen without the dock, and move your mouse to the bottom of the scree trying to drive it outside the screen. The dock will magically appear on that screen. If you found this useful, please,...read more

10 BEST Excel YouTube Channels

Posted on by DevPaulC
Hello and welcome to our list of the top 10 YouTube channels for learning Excel! Whether you're a beginner looking to get started with spreadsheet basics or an experienced user looking to take your skills to the next level, these channels offer a wealth of resources and tips to help you master the powerful spreadsheet software. From step-by-step tutorials and exercises to helpful tips and tricks, these channels have something for everyone. So without further ado, let's dive in and explore the best YouTube channels for learning Excel. The best way to be introduced to these channels is to...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

A Simple Excel VLOOKUP example

Posted on by DevPaulC
In this example, I will show you a simple way to use VLOOKUP that even a beginner would understand. VLOOKUP represents Vertical Lookup. That means Excel will look for a value on the vertical, from top to bottom, and return the corresponding value from the same row where the value is found. Simple Enough? Let's see it in action In the table below in cell B2, I'm looking to write a VLOOKUP formula to get the color of the fruit Banana. As you can see, I have a reference table with fruit colors. Banana is in the table and...read more

How to use VLOOKUP in Excel

Posted on by DevPaulC
Excel Vlookup is the most powerful formula in Excel. Also vlookup is one of the formulas that are least used because so many users are scared of it. In this tutorial you will learn: how to use vlookup in Excel what is the vlookup syntax how to do a vlookup between two spreadsheets why is my vlookup not working why is xlookup coming and how will it improve vlookup If you know vlookup and pivot tables you will find the most value out of Excel. How to use vlookup in Excel We'll continue with our example of the Grocery...read more

Excel Bingo Card Generator – Sight Words

Posted on by DevPaulC
Are you a teacher or parent looking to help your students or children learn to read faster and more efficiently? Our Sight Word Bingo Card Generator in Excel is the perfect solution! Our generator is an easy-to-use Excel spreadsheet that allows you to quickly and easily create custom Sight Word Bingo cards for use in your classroom or at home. You can use our 7 pre-loaded lists based on the Dolch Sight Words Lists or simply enter the sight words you want to include on the cards, and the generator will automatically create the cards for you. You can...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

Apple iCloud Photos or Google Photos for photo storage

Posted on by DevPaulC
If you are like me, you might have an iPhone or iPad for your mobility devices but still use a Windows computer for your productivity or work needs. So you may be wondering how to manage your photos. Should you use iCloud or Google Photos? Is iCloud better than Google Photos If you are using an iPhone to capture your photos, you may be inclined to think that iCloud is the best Photo storage solution. iCloud has many advantages. ability to upload photos directly from your iPhone automatically ability to see previews of your photos and download a high-resolution...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