Excel tutorials, functions and advanced formula examples, page 20
Three brand new tools for your Excel
We added 3 new tools to Ultimate Suite for Excel. They are Count and Sum by Color, Unpivot Table and Create Cards. Read on to learn how you can calculate cells by color, flatten your summary tables, and convert your data into label cards. Continue reading
How to freeze panes in Excel to lock rows and columns
In this short tutorial, you will learn how to quickly lock header row and first column in Excel. You will also see how to freeze several panes at a time to make Excel always show certain rows or/and columns when you scroll down or right. These tips work equally well in all modern versions of Excel 2013, 2010 and 2007. Continue reading
3 ways to count empty cells in Excel
If your task is to get Excel count blank cells in your worksheet, read this article to find 3 ways to accomplish it. Learn how to search and select empty cells with the Go to Special option, use Find and Replace to count blanks or enter a formula in Excel 2010-2013. Continue reading
How to count non-empty cells in Excel 2010, 2013
This articles looks at the ways to count non-blank cells in Excel 2010-2013. Below you'll find 3 methods for counting non-blanks: see the number on the Excel Status bar, employ the Find and Replace dialog or use a special formula. Continue reading
How to conditionally format dates and time in Excel - built-in rules and formulas
See how to apply Excel conditional formatting to dates. Learn how to use formulas to highlight weekends and holidays, format cells when a value is changed to a date, shade upcoming dates and delays, conditionally format dates based on the current date, and more. Continue reading
Easily print comments in Excel
How to print comments in Excel 2016-2010 in several clicks. Get cell notes to paper as displayed on your table or print them at the end of the page. Continue reading
Fastest ways to insert multiple rows in Excel
Inserting multiple rows in Excel may be one of the numerous tasks you come across daily. In today’s article, I hope to inspire shortcut-oriented users by showing some really quick ways to add new rows in Excel. You’ll also see how to solve this task using standard menus and Ribbon buttons and how to add empty rows between multiple data lines. Continue reading
How to import contacts to Outlook from Excel in 3 steps
In this article, I’ll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading
Excel formulas for conditional formatting based on another cell value
This tutorial explains how to use Excel formulas to format cells and entire rows based on the values you specify or based on another cell's value, and provides a handful of formula examples. Continue reading
What are Excel sparklines and how to insert them to analyze your data
Do you know what Excel sparklines are and how helpful they can be? Read this article and find the answers to these questions. You will learn how to insert sparklines in Excel 2016, 2013 and 2010; change their type, style and color; highlight the most important points and remove sparklines from cells. Continue reading
Excel conditional formatting Icon Sets, Data Bars and Color Scales
The article provides the detailed guidance on how use conditional formatting Icon Sets, Data Bars and Color Scales in Excel 2016, 2013, 2010 and 2007. You will learn how to apply icons in different ways based on another cell's value. Continue reading
How to use AutoFill in Excel - all fill handle options
This post looks at the AutoFill Excel feature. You will learn how to fill down series of numbers, dates and other data, create and use custom lists in Excel 2010, 2013 and lower. This article also lets you make sure you know everything about the fill handle, cause you may be surprised how powerful this tiny option is. Continue reading
How to use conditional formatting in Excel 2010, 2013 and 2016
The tutorial explains the basics of Excel conditional formatting feature. You will learn how to apply different formatting rules such as Icon Sets, Data Bars and Color Scales, how to do conditional formatting based on another cell, how to edit and copy your formatting rules in Excel 2007, 2010 and 2013. Continue reading
How to recover unsaved Excel file or restore its previous version
Do you want to protect your workbooks from unexpected computer crashes or power failures? This article explains how to recover unsaved files and restore previous versions of your workbook in Excel 2016 - 2010. You'll also learn different ways of file backup to your PC and to the cloud storage. Continue reading
How to make a Gantt chart in Excel 2010, 2013, 2016 and 2019
See how you can quickly make a simple Gantt chart in Excel, where you can download advanced Excel Gantt chart templates or utilize the online Project Management Gantt Chart generator. Continue reading
How to delay email sending in Outlook (schedule emails)
In this article I’m going to tell you how scheduling Outlook emails can improve your time management skills. Besides learning to delay messages, you’ll find links to some helpful 3rd party add-ins for scheduling reoccurring emails. The steps below are for Outlook 2016, they will also work for other versions of Office. Continue reading
How to create labels from Excel using Mail Merge
This tutorial explains how to mail merge and print labels in all versions of Excel 2010 to 2019. You will learn how to properly prepare your Excel file to make mailing labels, set up the main label document in Word and save it for later usage. Continue reading
Excel: How to add a hyperlink to another sheet
In this article I'll show you 3 ways how you can add hyperlinks into your Excel workbook to easily navigate between numerous worksheets. You'll also learn how to change a link destination and modify its format. If you don't need a hyperlink any more, you'll see how to quickly remove it. Continue reading
How to mail merge from Excel to Word
Mail Merge from Excel to Word can be a real time-saver when it comes to sending large mailings. This tutorial provides an overview of the main features and explains how to do a mail merge from Excel to Word step-by-step. Continue reading
How to insert comments in Excel, add pictures, show/hide comments
In this article you'll find out how to add comments to Excel cells, show, hide and delete them. You'll also learn how to insert a picture in a comment and make your cell note more eye-catching by changing its font, shape and size. Continue reading
