Posts Tagged 'Excel tutorials'
How to square root in Excel: SQRT function and other ways
Squaring a number and finding a square root are very common operations if mathematics. But how do you do square root in Excel? Either by using the SQRT function or by raising a number to the power of 1/2. Continue reading
Video: Conditional formatting based on another cell
Learn how to quickly highlight entire rows based on another cell value in Excel. Continue reading
Excel Paste Special: shortcuts and features
Copy pasting in Excel is easy. Everyone knows the shortcut to copy a cell and another one to paste it. But dis you know that apart from copying/pasting a whole cell, you can paste only a certain attribute such as value, formula, formatting or comment? That's where Excel Paste Special comes in. Continue reading
How to create calendar in Excel (drop-down and printable)
The tutorial shows how to insert a drop-down calendar in Excel, and how to quickly create a printable calendar based on a template. Continue reading
6 ways to insert a tick symbol and cross mark in Excel
The tutorial shows 6 different ways to insert a tick in Excel and explains how to format and count cells containing checkmarks. Continue reading
How to add, copy and delete multiple checkboxes in Excel
The tutorial will teach you how to quickly add multiple checkboxes in Excel, change the check box name and formatting, as well as delete one, several or all checkboxes on a sheet. Continue reading
How to insert a checkbox in Excel - create an interactive checklist, to-do list and report
This tutorial will guide you on how to insert a checkbox in Excel and use the check box results in formulas to make an interactive checklist, to-do list, chart or report. Continue reading
Using Advanced Filter in Excel - criteria range examples with formulas
In our previous article, we discussed different aspects of Excel Advanced Filter and how to use it to filter rows with AND as well as OR logic. Now that you know the basics, let's have a look at more complex criteria range examples that may prove helpful for your work. Continue reading
Excel Advanced Filter - how to create and use
Excel Filter provides a variety of filtering options for text, numbers, and dates. The inbuilt filters can handle many scenarios. Many, but not all! When a regular AutoFilter can't do what you want, use the Advanced Filter and configure the criteria exactly suited to your needs. Continue reading
How to filter in Excel
If working with large data sets, it can be a challenge not only to calculate data, but also to find the relevant information. Luckily, Microsoft Excel makes it easy for you to narrow down the search with a simple yet powerful Filter tool. Continue reading
