Excel Tips and Tricks
Developing Applications with Tabular Data
Excel uses a grid structure for its interface for a good reason: Data is usually best collected and analyzed in a compact table to allow for easier analysis. Because of this, Excel is the platform of choice for collecting data in many applications like cost tracking,...
Merge Two Columns in Excel
Merge Columns Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it's a tedious task to merge columns of data. To merge two columns in excel, you can use a formula combination that will save you time and...
How to Add Double Quotes in Excel
Excel uses double quotes to identify text; you need a different approach. This article shows you How to use double quotes in Excel formulas in two ways: with and without a function. Syntax ="""" =CHAR(34) How to use Double Quotes in Excel? There are two ways to use...
How to SUM Cells in Excel by an Equal Criteria
Do you have a data table where you need to pick all the highest, lowest, best, worst, or equal to 2? SUMIF and its bigger brother SUMIFS formulas can help sum cells of your choice. Follow the instructions below to learn how to sum cells in Excel. Syntax...
How to Roll Dice in Excel in 3 Ways
The dice roll is a common way of generating random numbers. It's unnecessary to talk about dice's role in board and role-playing games. Although a simple formula can give what you need easily, you can make the dice rolling fancy in Excel. In this guide, we’re going to...
How to Highlight Cells in Excel Based on Value
Highlighting cells is a good way to visualize content and locate areas needing attention. Excel's Conditional Formatting feature is a great tool for this job. How to highlight cells by values article will show how you can create highlight cells based on different...
How to get size of an array in Excel
An array is a collection of similar values or objects in computer science. This isn’t different for Excel. The only caveat is that Excel has two definitions for arrays, one for workbooks and the other for VBA. In this guide, we will show you How to get the size of an...
How to Copy Formula in Excel
In the intricate landscape of Microsoft Excel, the convenience of copying formulas across workbooks often comes with an unintended challenge – the creation of links between worksheets. These links can be troublesome, requiring meticulous efforts to break or eliminate...
Online Calculator Creation with Excel
Many businesses use custom calculators externally and internally in finance, real estate, insurance, return investment, energy industry and several others. What if a bank could save you hundreds of dollars every year by choosing another mortgage plan? You would...