Apr
15
Send secure email in Outlook using digital signature
Learn about Outlook digital signature, encrypting email connections with SSL, and other ways to send secure email messages in Outlook. Continue reading
Tutorials for Excel, Outlook and Google Sheets, page 21
Apr
11
Email encryption in Outlook: how to encrypt messages with digital ID
Learn how to use Outlook email encryption to protect your email messages against unauthorized reading in Outlook 2016 and 2013. What Exchange hosted encryption is and how send secure encrypted emails between Outlook and other emails clients. Continue reading
Apr
9
6 Reasons Why Your VLOOKUP is Not Working
The VLOOKUP function is the most popular lookup and reference function in Excel. It is also one of the trickiest and the dreaded #N/A error message can be a common sight. This article will look at the 6 most common reasons why your VLOOKUP is not working. Continue reading
Apr
4
Writing persuasive request letters: tips and samples
Do you know how to write business letters to convince your recipient to respond or act? And what is the correct letter format? Read the article to find the answers as well as examples of persuasive request letters such as character reference, letter of recommendation, request for information, donation /charity request and more. Continue reading
Mar
28
Move Excel spreadsheets online, share and embed web app in your website
With the emergence of Excel Online, you no longer need cumbrous HTML code to export your tables to the web. Just save your workbook online and access it literally from anywhere, share with other users and work on the same sheet all together. Continue reading
Mar
21
How to convert Excel tables to HTML
If you created a pretty Excel table and now want to publish it online as a web page, the simplest way is to export it to an old good html file. In this article, we are going to explore several ways of converting Excel data to HTML, determine pros and cons of each, and walk you through the conversion process step-by-step. Continue reading
Mar
13
How to color alternate rows in Excel: highlight every other row
See how you can quickly alternate row and colomns colors in your worksheets by using Excel Table Styles. You will also learn a few smart formulas to highlight banded rows and columns with 3 different colors and to shade groups of rows based on a value change. Continue reading
Mar
6
How to convert rows to columns in Excel (transpose data)
In this article, you will find several ways to convert rows to columns and columns to rows in Excel. These solutions work in all versions of Excel 365 - 2007, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading
Feb
27
How to split cells in Excel: Text to Columns, Flash Fill and formulas
In this article you will find several options to split cells and entire columns in Excel 2016, 2013, and lower. See how to use Text to Columns to split cell contents by delimiter, Flash Fill to separate cells automatically, and formulas to extract names, text and numbrs in different cells. Examples and screenshots will help you choose the right approach for splitting your data in Excel. Continue reading
Feb
26
How to get email read receipt and delivery receipt in Outlook
Do you want to make sure that people get your emails? Outlook delivery and read receipts will notify you when your message is delivered and opened. In this article you will learn how to track sent messages and disable read receipt requests in Outlook. Continue reading
Feb
21
How to print row and column headers of Excel spreadsheets on every page
Today I'd like to tell you about a small but important feature tucked away in Excel 2013 and its previous versions. In this article you'll learn how to make header rows and column headers print on each page. Continue reading
Feb
20
How to create and use Outlook email templates
Rather few people know that email templates exist in Outlook and even fewer know how to create and use them in the right way. In this article you will learn how to create, save and use standard Outlook email templates. You will also find how to reply with template in Outlook 2016, 2013, 2010 and lower or automatically add a template of your choosing to all new e-mail messages, replies or forwards. Continue reading
Feb
13
How to add and view BCC (blind carbon copy) in Outlook
If your work is related to email communication in any way, you may often hear this request from your co-workers: "Would you mind sending me a BCC copy?" Or, something less polite from your boss: "Be sure to BCC me on each and every email you send to this client!" Continue reading
Feb
6
How to merge rows in Excel without losing data
This article provides solutions for 4 different scenarios of merging rows in Excel. See how you can quickly merge multiple rows without losing data; how to combine duplicate Excel rows, how to repeatedly merge blocks of rows, and how to consolidate matching rows from two different spreadsheets. Continue reading
Jan
31
Setting Outlook spam filter to stop junk email
Outlook provides various tools and techniques to help you fight spam. If you're working in a corporate setting, it's likely that your Exchange server has an anti-spam filter to block unwanted emails. However, for your personal computer, it's up to you to set up your own filter. Continue reading
Jan
23
How to swap columns by dragging and other ways to move columns in Excel
In this article you will learn a few methods to move columns in Excel tables. You will see how to drag columns with a mouse and how to swap several non-contiguous columns. The latter is often considered unfeasible, but I'll show you a tool that allows moving even non-adjacent columns in Excel 2016, 2013, 2010 and lower. Continue reading
Jan
22
How to view, change and remove document properties in Excel
The time has come to tell you about different types of document properties, the ways of viewing and changing them in Excel. In this article you’ll also learn how to protect your document from any modifications and remove personal information from your Excel worksheet. Continue reading
Jan
20
How to add titles to Excel charts
If you don’t want to get lost in all the charts in your Excel worksheet, then spend some minutes to read this article and learn how to add a chart title in Excel and have it dynamically updated. I’ll also show you how to add descriptive titles to the axes or remove a chart or axis title from a chart. There’s nothing to it! :) Continue reading
Jan
16
Hyperlinks not working in Outlook? How to make links open again
The article explains why hyperlinks may not be working in Outlook and provides several solutions to fix the issue. These methods will let you open links in Outlook again with no problem, no matter which version you use - Outlook 2016, 2013, 2010, 2007 or lower Continue reading
Dec
18
How to filter and sort by cell color, font color and icon in Excel
From this short tip you will learn how to quickly sort cells by background and font color in Excel 2016, Excel 2013 and Excel 2010 worksheets. Continue reading
Dec
13
How to replace formulas with their values in Excel
Here are good tips to save your time - 2 fastest ways to replace formulas in Excel cells with their values. Both hints work for Excel 2019, 2016 - 2003. Continue reading
Dec
12
How to sum and count cells by color in Excel
Even though Microsoft Excel has a variety of functions for different purposes, none can count or sum by color of a cell. Aside from third-party tools, there is only one possible solution - create your own functions. Continue reading
Dec
6
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
Dec
6
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
Dec
3
How to remove carriage returns (line breaks) from cells in Excel
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
Nov
29
How to remove, merge and clean up duplicate contacts in Outlook
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
Nov
20
Sync Google Calendar with Outlook
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
Nov
15
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
Nov
12
Why an email gets stuck in Outlook and how to 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
Nov
8
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
