Upper/Lower/Proper Case in Excel
In this article, we will learn how to convert text strings in Excel to Upper, Lower, and Proper cases. Upper function will convert the...
Get Day Name from Date (TEXT formula)
Have you ever needed to find the day name (i.e. Monday, Tuesday, Wednesday, etc…) from a date? Well, the solution is very simple. You can...
How to insert a picture into an Excel comment
Quick tutorial on how to insert a picture into Microsoft Excel Comment 1. Right click on the cell where you would like to insert a...
=VLOOKUP(One Function to Rule Them All...)
Microsoft Excel has a very powerful function that helps users combine data from multiple sources into one table in a spreadsheet. For...
Prevent Data Input Errors in Excel Using Data Validation Feature
Have you ever needed to control what type of data is entered into an Excel Spreadsheet? Excel’s Data Validation tool can help you do just...
Excel Trick To Easily Spot Trends In Your Dataset
A Sparkline is an amazing trick in Excel that enables you to easily and almost instantly create visual representations of data with a few...
Write a Simple Macro in Microsoft Excel 2010
If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks using macro. A macro is an...
