Related Topics
- Excel Shortcuts
- Excel Functions
- Types of Errors
- Protecting Excel Workbooks
Numeric values are always right aligned. This is done so that floating point numbers will have the decimal points neatly aligned one below the other
Date values are also internally treated as numeric type so even they are right aligned. The default format is MM/DD/YYYY (It can defer from region to region)
When the column is too small to show a numeric value (Date values as well) it is represented using the # symbol
String values get cut of if it cannot fit the cell
.xltx: Excel Template Format
In Pivot Tables we can drill down into the data by Double clicking on value
It will open up a new sheet with detailed information about the value we selected
An formula that spans multiple sheets/ wordbooks is called a 3D Formula
Reference a cell in different worksheet: '<sheet-name>'!<cell-reference>
Name Range is an absolute reference
Formulas - Named Manager (Edit and Manage Named Ranges)