How to compare two columns in Excel for matches and differences
How to compare 2 columns in Excel row-by-row When you do data analysis in Excel, one of the most frequent tasks is comparing data in each in...Read More
Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts
Use the PROPER function to capitalize names in Excel
When you think about Excel functions, you probably think about performing calculations with numbers. While it's true that you can use fu...Read More
CONCATENATE: Excel's duct tape
MacGyver used it. The Apollo 13 crew used it. Whenever people are in a bind and need to stick two things together, they reach for the duct ...Read More
Use SUMPRODUCT to calculate weighted averages
Excel makes it extremely easy to calculate the average of several cells: Just use the AVERAGE function. But what if some of the values have ...Read More
How to count cells with COUNTA
You may already know Excel can perform calculations with numbers. But did you know it can also perform calculations with other types of info...Read More
Subscribe to:
Comments
(
Atom
)
