You can create a chart quickly in Microsoft Excel without having to use the chart button on the toolbar by using these two shortcuts whilst inside a range of data. The chart created is Bar chart which you can change as per your requirement.
Here are the shortcuts:-
This trick will let you hide the formulas & keeping the worksheet usable, by performing the following steps:
Press Control + F1 and ribbon disappears and press again to reappear ribbon. You can also have it disappear so it will come back with a single click on any tab name. To do this, double click a tab name and the ribbon disappears. Single click a tab name and it reappears - click again on the tab or in the document, and it disappears.
Repeat until you're tired of the magic! Double click or Control + F1 to go back to how it is.
You need to exercise caution when entering dates by using two digits for the year. When you do so, Excel has some rules that kick in to determine which century to use. And those rules vary, depending on the version of Excel that you use. Two-digit years between 00 and 29 are interpreted as twenty-first century dates, and two-digit years between 30 and 99 are interpreted as twentieth century dates.
For example, if you enter 12/15/28, Excel interprets your entry as December 15, 2028. But if you enter 12/15/30, Excel sees it as December 15, 1930. This is because Windows uses a default boundary year of 2029.
You can keep the default as is, or change it by using the Windows Control Panel (use the spinner in the Calendar area of the Date tab of the Regional and Language Settings Properties dialog box).
One of the most frustrating problems for Excel users is viewing all the information they need, especially because it often lives in different worksheets. Here you can know about this simple way to view multiple sheets, and you will love forever.
1. Click on the worksheet you want to view.
2. Choose New Window from the Window group of View Tab.
3. Repeat this process for each of the worksheets you want to display. (Excel opens each sheet in a window that sits on top of the previous one.)
4. To see them all at one time, choose 'Arrange All' from the Window menu.
5. Select Tiled, Horizontal, or Vertical.
6. Select the 'Windows Of Active Workbook' check box.
7. Click OK.
A leap year, which occurs every four years, contains an additional day (February 29). Although the year 1900 was not a leap year, Excel treats it as such. In other words, when you type 2/29/1900 into a cell, Excel does not complain. It interprets this as a valid date and assigns a serial number of 60. If you type 2/29/1901, however, Excel correctly interprets it as a mistake and doesn’t convert it to a date. Rather, it simply makes the cell entry a text string. How can a product used daily by millions of people contain such an obvious bug?
The answer is historical. The original version of Lotus 1-2-3 contained a bug that caused it to consider 1900 as a leap year. When Excel was released some time later, the designers knew of this bug and chose to reproduce it in Excel to maintain compatibility with Lotus worksheet files.
Why does this bug still exist in later versions of Excel? Microsoft asserts that the disadvantages of correcting this bug outweigh the advantages. If the bug were eliminated, it would mess up hundreds of thousands of existing workbooks. In addition, correcting this problem would affect compatibility between Excel and other programs that use dates. As it stands, this bug really causes very few problems because most users do not use dates before March 1, 1900.
Excel 2007 added the feature to filter table fields by the selected cell.
What does this mean?
Focus on analyzing data instead of defining filter criteria each time.
This quick filter method is ideal for selecting categories, for example: cities, products, subjects, suppliers, etc.
You can filter by:
1. Select the cell on which you want to apply the filter or right click directly on it.
2. Go to: Filter>Filter by Selected Cell’s value