Blog

How to remove the Audible Originals from your library

Posted on by DevPaulC
Audible Originals are more like Podcasts than AudioBooks. But you'll notice there is no way to remove them from your mobile app on iPhone and Android. However, there is a way. To do that, you have to go on the computer to your Amazon Account. Go to Accounts and Lists and then to Manager Your Content and Devices Once you are there, select to Show Audiobooks from the drop-down and select the Amazon Originals episodes you want to remove and DELETE from your library using the Delete button. Although, I don't recommend removing Michele Romanow's "The Revisionaries". It is...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

What is Power BI Desktop

Posted on by DevPaulC
Power BI Desktop If you look in the Microsoft Store you will find two applications that you can install on your Windows PC. One is Power BI Desktop and the other is Power BI Mobile. Install the Power BI Desktop if you are planning to create reports in your organization. All Power BI products (Service, Desktop and Mobile) are used with the same Power BI Licence you have. Power BI Desktop is a Desktop application similar with Excel in some ways. It installs on your computer and you can import data, transform data using formulas, merge data, create data...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

What is the Power BI service

Posted on by DevPaulC
If you are just starting with Power BI you might be confused of all the Power BI products you encounter. Power BI Service Power BI Desktop Power BI mobile app The good news is, they are all part of the same product but they perform different functions. Click on them to find out what purpose they serve Power BI Service Microsoft calls Power BI service the web portal where all your Workspaces, Dashboards, Reports and Datasets are stored. To access the Power BI Service go to powerbi.microsoft.com and login with your Microsoft account. Based on your subscription, you would...read more

How to learn Power BI – Frequently Asked Questions

Posted on by DevPaulC
Power BI is a powerful reporting tool. It is part of the Microsoft Power Platform and works very well with a variety of Data Sources starting with text, coma separated value files, Excel files and all the way to massive cloud databases. What is Power BI used for? Power BI is the best tool for making sense of the data. instead of looking at tray data and spending time in Excel to filter and group data, you can easily build visualizations and filters in Power BI to make data easy to understand. Each team may be interested in a...read more

Filter Pivot Table with Slicer in Google Sheets

Posted on by DevPaulC
Pivot Tables are the most powerful tools that you can use in your Google Sheets. A slicer is the feature that can filter out Pivot Tables easily. Very useful when you need to keep all your data together but you want to present parts of it (slices) In a previous example you can see how to create a simple Pivot Table in Google Sheets. We used an Education case study where the teacher Amanda wanted to have a summary of their students grades ready for the Teacher-Parent conference. Amanda keeps track of the grades in a simple Google Sheet...read more

How to Use Pivot Tables in Google Sheets

Posted on by DevPaulC
Pivot Tables are one of the most powerful features that is mostly known in Excel. However, Google Sheets is becoming more and more popular. Google Sheets is very similar with Excel from many point of views and of course it has the very popular Pivot Table. If you want to learn more about Pivot Tables in Excel, find all the related posts in the Excel category. Case Study Amanda is a teacher and wants to keep track of the grades of her students in a Google Sheet. With every test, she writes a line with the test date, student...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