Excel tutorials, functions and advanced formula examples, page 22
How to count and sum cells by color in Excel
In this article you will learn how to count cells by color in Excel and get the sum of colored cells. These solutions work both for cells colored manually and with conditional formatting. You will also learn how to filter cells by several colors Continue reading
How to insert and run VBA code in Excel - tutorial for beginners
This is a short step-by-step tutorial for beginners showing how to add VBA code (Visual Basic for Applications code) to your Excel workbook and run this macro to solve your spreadsheet tasks. Continue reading
How to fix "Cannot start Microsoft Outlook. Unable to open Outlook window" error
Unable to open your Outlook? In this article you will find really working solutions for "Cannot start Microsoft Outlook" problem. The fixes will help you open Outlook again with no errors, the solutions work in all versions of Outlook 2016, 2013, 2010, 2007 and lower and on all systems. Continue reading
How to remove carriage returns (line breaks) from cells in Excel 2016, 2013, 2010
In this tip you'll find 3 ways to remove carriage returns from Excel cells. You'll also learn how to replace line breaks with other symbols. All solutions work for Excel 2013, 2010 – 2003 Continue reading
How to quickly reply to email using Template Phrases plug-in for Outlook
In this video I will show how you can speed up replying to your Outlook emails with the Template Phrases plug-in. It takes just one click to insert frequently-typed phrases into your e-mail messages. The plug-in works with all versions of Outlook 2013, 2010, 2007 and 2003. Continue reading
How to merge duplicate contacts in Outlook 2016, 2013 and 2010
In this article you will learn how to merge duplicate contacts in Outlook 2016 and 2013 without using any third-party tools, and how to keep your contact list clean in the future. Continue reading
Sync Google Calendar with Outlook 2016, 2013 and 2010
This article explains how to sync your Google Calendar with Outlook 2016, 2013 and Outlook 2010; it also provides an overview of free tools and services to help you choose the approach best suited for your needs. Continue reading
3 ways to remove spaces between words / numbers in Excel cells
3 quick ways to remove extra spaces between words to 1 or to delete all spaces from Excel cells. Using trim formula, using Excel Find & Replace, using special Excel add-in to clean up cells' content. Continue reading
Why an email gets stuck in Outlook Outbox and how to delete a hanging message or make it send
Email messages may be stuck in the Outbox folder for various reasons. In this article we will try to figure out why this happens and how to make a hanging message send. This will help you understand what exactly can force a message to hang and how to prevent this from happening in the future. Continue reading
How to quickly extract domain names from URLs in Excel
A few tips and pieces of advice will help you get domain names from a list of URLs using Excel formulas. Two variations of the formula let you extract the domain names with and without www. regardless of the URL protocol (http, https, ftp etc. are supported). The solution works in all modern versions of Excel, from 2007 through 2016. Continue reading
How to delete or resend an email message stuck in Outlook's Outbox
The article explains how you can quickly remove or resend emails that are stuck in your Outbox. The solutions work on all systems and all versions of Outlook 2016, 2013, 2010 and lower. Continue reading
How to change the row color based on a cell's value in Excel
Learn how to quickly change the color of the entire row based on a single cell's value in your Excel worksheets. Tips and formula examples for number and text values. Continue reading
Meet the new Ultimate Suite release
Change of the seasons is my favourite time for letting you know about the improvements we bring to Ultimate Suite. Here at AbleBits we’ve been testing and enhancing the tools you use daily. Today, we’re making the updates available to you! Continue reading
How to prevent duplicates in a column in Excel
Today I'll tell you how to prevent duplicates from appearing in a column of your Excel worksheet. This tip works in Microsoft Excel 2013, 2010, 2007 and lower. Continue reading
Two ways to change background color in Excel based on cell value
In this article, you will find two quick ways to change the background color of cells based on value in Excel 2016, 2013, and 2010. Also, you will learn how to use Excel formulas to change the color of blank cells or cells with formula errors. Continue reading
How to merge two columns in Excel without losing data
From this short article you will learn how to merge multiple Excel columns into one without losing data. Continue reading
How to remove duplicate emails in Outlook 2016 and 2013 quickly and safely
From this article you will learn why multiple copies of the same message appear, and how to find & remove duplicate emails in Outlook quickly and safely ensuring that all of your important messages remain intact. Continue reading
Out of office reply in Outlook without Exchange, vacation autoresponse for Gmail and Outlook.com
In my previous article I explained how you can set up out of office auto reply for Outlook Exchange accounts. Today I'm going to show you how you can set up your vacation auto-responder in Outlook accounts without Exchange as well as in Gmail and Outlook.com accounts. Continue reading
Set up out of office auto reply in Outlook (with an Exchange account )
This article will show you how to set up out of office auto reply in Outlook 2013, 2010, 2007 and Outlook 2013 with an Exchange server (Microsoft Exchange 2013, 2010 and 2007 accounts). If you are not sure which email account type you use, you will learn how to quickly find this out. Continue reading
How to remove all blank rows in Excel
In this quick tip I will explain why deleting Excel rows via select blank cells -> delete row is not a good idea and show you 3 quick and correct ways to remove blank rows without destroying your data. All solutions work in Excel 2016, 2013 and lower. Continue reading
