Data Validation
There may be situations when you want to prevent users from entering data that doesn’t meet the conditions you specified. Suppose that you…
Tag: added
Sparklines
Sparklines were introduced in Excel 2010. They are tiny graphics that look like miniature charts but occupy only one cell. Compared to standard…
Charts in Excel
A chart is a graphical representation of data. They are an integral part of spreadsheets and were present in spreadsheets even before the…
Quick Access Toolbar in Excel
Quick Access Toolbar was created to give users easy access to frequently used options and features. It is located above the ribbon, and…
Data Types
A data type is like a wardrobe for your data—it defines how your computer interprets and interacts with information. Just as you wouldn’t wear a…
Visual Basic Editor (VBE)
VBE (which stands for Visual Basic Editor) is a separate application, integrated with Excel. Here, you can write or edit your macros. In…
Text to Columns Wizard in Excel
In the previous lessons, you’ve learned how to merge data. In this lesson, you’ll learn quite the opposite. I will show you how…
Worksheets in Excel
Difference between a worksheet and a workbook With Excel, you can achieve high efficiency with little effort. However, before you start working with…
Excel Ribbon
The biggest change that has ever been done in the Office Suite user interface is the Ribbon. The first release of Excel that uses the…
AutoFill in Excel
AutoFill is a very useful Excel feature. It allows you to create entire columns or rows of data that are based on the…