Blog

Dinner Planner with Automation in Notion

Posted on by DevPaulC
This is a simple Dinner Planner made in Notion with a button automation. This list is a collection of favourite recipes (or could be take out items) sorted by the Last Made Date. The list is sorted Ascending so that the recipes or take out orders that you did not have in a while come up at the top and the most recent ones you had go to the bottom. The automation is a button with the text “Made that today”. When you push the button, the recipe’s “Last Made Date” will be updated with the current date. this...read more

5 simple Excel XLOOKUP examples

Posted on by DevPaulC
Let's put the new XLOOKUP in Excel to the test with these 5 simple examples. The data below represents a list of serial numbers shipped in boxes to various companies in several countries. For simplicity, we keep the dataset simple and on the same screen. The data set Example 1: Basic XLOOKUP In the first example, we will look for the country where a certain serial number is shipped. the XLOOKUP function will look like this: =XLOOKUP(F2,A:A,D:D,"not found") The function looks for the value in F2 "1125181" that can be found in the first column A:A and finds a...read more

Why is my iPhone Synced Media so big

Posted on by DevPaulC
You may have arrived here because, like me, you noticed that your iPhone Storage media is quite large. Synced Media Storage If you go to Settings - General - iPhone Storage (this is the same for iPad as well), you may notice this additional line item called Storage Media that is taking a lot of space. Apple iOS17 Synced Media Change It turns out, it’s not as bad as you think Before iOS 17, all media for the core Apple apps (Books/Music etc) was shown within that app’s storage. So for example, if you had a bunch of music,...read more

How backup a table in SQL with data

Posted on by DevPaulC
Before running and update or delete queries, make sure you backup your database. But sometimes you don’t want to backup the entire SQL Database. Sometimes you just want to backup a single table, run your query and revert to the previous version. Here is a simple method to do that. Step 1: Create an identical copy of the table including data Run this command in a new query USE [YourDB]GOSELECT * into YourTable_Backup from YourTableGO This will create an exact copy of your table and will also copy your data. Now you’ll have 2 tables. YourTable and YourTable_Backup Step...read more

11 Easy ways to speed up Windows 10

Posted on by DevPaulC
Make your PC faster even without installing an SSD. If your computer is starting to feel slower than when you first powered it up, here are some ways to make it faster 1. Disable Transparency Windows 10's Start menu may look good, but that transparency will cost you some resources that slow your PC slightly To reclaim those resources, you can disable transparency. Open the Settings menu and go to Personalization > Colors and toggle off Transparency Effects. 2. Remove Special Effects Windows 10 still has a lot of built-in special effects. Small animations, color changes etc. that make...read more

Google Sheets edit history

Posted on by DevPaulC
How many times it happened that you deleted or modified something in a Google Sheet or you shared a Google Sheet for collaboration and other people modified it. How do you go back? There is not Undo ? Well, now there is. Google Sheet Edit History For this example I wrote in a cell the following text: "This Cell". Then I typed over: "This Cell was modified". And then I typed over: "This Cell was modified 3 times" Click on the cell in a Google Sheet that you want to see previous values and right click for menu Click...read more

How to insert emojis in email on Outlook

Posted on by DevPaulC
Few may know that Windows applications like Outlook or any Office Applications have a quick shortcut to insert emojis. Next time you want to add a smiley face to your next email, use this little trick to add some of the most common emojis. Press the keyboard shortcut Win & . or Win & ; and get something like this Now you can do several things. You can pick one from your recently used (don't judge) or you can use the category search at the bottom to select a category or you can just type something and they will...read more

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