Blog

How to take a screenshot on a Windows 11 PC

Posted on by DevPaulC
Windows 11 took the Snipping tool to the next level in Windows 11. Not only the Snipping tool can take a screenshot of a part of your screen or use a delay to help you capture an open drop-down but now it can take short videos that you can use to demonstrate a short functionality to a colleague by quickly snipping a video and attaching it to an email or sending ti through a Teams chat. The Snipping Tool The Snipping tool helps you take a selective screenshot on a Windows 10 or Windows 11 PC. Instead of capturing...read more
what is a worksheet step 6

What is a worksheet

Posted on by DevPaulC
A worksheet is a tab inside a workbook in Excel. Think of it like a page in a notebook. Just as a notebook has many pages, an Excel workbook can have many worksheets, each used to store data and perform calculations. By default, a new workbook starts with one blank worksheet named "Sheet1" Adding More Worksheets To add more worksheets: Click the + icon next to the existing sheet tab (usually labeled "Sheet1"). Every time you click it, a new worksheet is created. Tip: You can have as many worksheets as you need within the same workbook. Each one...read more
what is a workbook step 6

What is an Excel Workbook

Posted on by DevPaulC
If you're new to Microsoft Excel, you might hear the term "workbook" often. So, what exactly is an Excel workbook? Let’s break it down! Excel Workbook vs. Excel Worksheet At its core, an Excel workbook is like a binder, and each worksheet inside is like a page in that binder. You can think of a workbook as a collection of worksheets, all housed within one single file. Key Features: Workbook: The entire Excel file (.xlsx) that contains one or more worksheets. Worksheet: Also known as a “sheet,” this is a grid of cells where you can enter data, perform...read more

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

What is xlookup in Excel

Posted on by DevPaulC
XLOOKUP is the newest addition to the lookup formulas in Excel. If VLOOKUP is a Vertical lookup function and HLOOKUP is a Horizontal lookup function, XLOOKUP is capable of replacing them both by performing the lookup both horizontally and vertically. What is the difference between VLOOKUP and XLOOKUP? VLOOKUP is structured like this VLOOKUP ( value to look for, in this big array where the value has to be in the first column, return the value in the X column on the right after the first column, exact or approximate match) Notice in bold the restrictions of VLOOKUP. you...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
Customer Call Scheduler

Customer Calls Scheduler

Posted on by DevPaulC
If you’re a fan of Excel, this call scheduler will take it to the next level. Here’s the problem with the other call schedulers. You setup a customer and a call schedule. Let’s say you want to call Ava every 6 months to discuss the problems she is having and potential solutions you may provide. It works great. First time, in January, you call her, have a nice chat and mark the call complete in your current call scheduler. In 6 months, in July, you’ll be reminded again. But wait, you have a product launch, you have some supplier...read more

How to open Excel Files downloaded from the Internet

Posted on by DevPaulC
You may have reached here because you purchased and Excel template from one of our Online Stores on Etsy, TeachersPayTeachers or Gumroad. Or maybe you downloaded a file from somewhere else and you want to open it. First of all, make sure you trust the source. We scan all our files with the latest anti-virus programs. It is also good, as an additional precaution to have your own antivirus and to scan any file that you may have received. The warnings below are usually showing when opening Excel files with macros. Here are some of the warnings you may...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