Excel tutorials, functions and advanced formula examples, page 20
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
Get the new Ultimate Suite and save another 10 minutes every day.
For the last 6 months we have been working on a new version of Ultimate Suite that includes 20 helpful add-ins for Excel. We tried to get the most out of Excel to achieve our main goal: speeding up Ultimate Suite for you to get really quick results with less time and energy invested! Continue reading
Ablebits add-ons go to the cloud
Have you heard the news? Ablebits add-ons are now available in the new Google Sheets. Use this exclusive opportunity to try out your favorite tools in the cloud for free! See the first add-ons that made the move and let us know what you think. Continue reading
Alternate row color and column shading in Excel (banded rows and columns)
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
How to convert rows to columns in Excel
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 2016, 2013, 2010, 2007 and lower, cover many possible scenarios, explain most typical mistakes and provide good examples of using Excel's Transpose function. Continue reading
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
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 2010 and 2013. Continue reading
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
How to create and use e-mail templates in Outlook 2016 and 2013
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
Outlook BCC - how to add Bcc recipients in Outlook
Do you know what the blind carbon copy in email messages is and in what way Bcc is different from Cc? Do you know how to automatically add Bcc on all email messages you send in Outlook and how to always Bcc yourself? If not, you will find all the answers in this article. Continue reading
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
How to configure Outlook Junk Mail Filter to stop spam email
This article explains how to configure Outlook Junk Mail Filter properly to stop as many junk emails as possible. You will also learn how to keep your filter up to date, take a good message out of the Junk folder and ensure that no legitimate e-mails will get there. Continue reading
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
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 2013 and 2016. 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
Working with Maps in Excel 2013
Yes, now it is possible to work with nice charts that have Maps in Excel 2013. The latest version comes with the Power View. It is an extremely powerful reporting tool. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers. In this article you will learn how to create cool reports in Excel. We will show countries, cities and specific geographical points. This article is for newbies who want to learn about this exciting area. Continue reading
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 2016-2010 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
Hyperlinks not working in Outlook? How to make links open again in Outlook 2016, 2013, 2010 and lower
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
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
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 2016, 2013-2003. Continue reading
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
