Blog

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

Multi-Level Row Pivot Table

Posted on by DevPaulC
If in the previous example we studied how to create a simple pivot table from a simple data-set, in this example we add an additional column to categorize our products in order to create a Multi-Level Row Pivot Table Case Study A grocery store wants to keep track of daily sales of the main fruits thei are selling: Apples and Oranges. They start with a blank Excel sheet and each day add two lines. One for the sales of Apples and one for the sales of Oranges. Towards the end of the month, the store manager wants to summarize...read more

Conditional Formatting Columns in SharePoint

Posted on by DevPaulC
When working with SharePoint lists there are cases when you need to create a better visualization of data by using Conditional Formatting. Some of these cases would be to make overdue items in red or to highlight items based on their status. To do this in SharePoint Online, lets start with a simple example of a task list. To keep things simple and focus on understanding conditional formatting the list has only 3 columns. Title - a text field Due Date - a date field Status - a drop-down with Open, Closed, Pending Let's format by Status first. Let's...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

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