Fibonacci sequence is a series of numbers in which each number is the sum of two proceeding numbers like 1, 1, 2, 3, 5, 8, etc.
Custom Lists option is used to create or delete your own lists.
Comments are used to add additional information about the cell’s value.
Skip blank option skips blank cells while data paste.
Transpose function helps to rotate a row into a column and vice versa.
Use Flash Fill and Auto Fill to automatically add repetitive information.
Formulas and Functions
Status Bar provides a quicker way to see the average, count, numerical count, minimum, maximum or sum of selected cells.
Percentage Formula is used to get relationship between two numbers in percentage.
Percentage Change Formula in Excel is used to find out percentage difference between two numbers.
The Paste Options appear in Excel when you paste data in cells:
- Copy and paste values only help to prevent formatting.
- Keep source formatting helps to keep source formatting (like column width even formulas etc. of copied data) in pasted section.
Design Workbook/ Worksheet
You can save a lot of time by performing tasks in different worksheets at the same time by group worksheets feature.
Instead of summarizing different workbooks one by one in a master worksheet, you can use consolidate workbooks to summarize at once.
Correct your spelling by using Spell Check feature.
Hide/ show columns and rows feature is used to hide/ show a column and a row.
Freeze Panes feature is used to keep a row or a column visible while scrolling down to another area of the worksheet.
If you want to view different distant parts of a worksheet at once, you can utilize split command.
Move or copy worksheet command is used to move or copy a sheet to the same workbook or another workbook.
Zoom in and out command in Excel is used to change the view of a spreadsheet.
Selecting cells, ranges, rows or columns.
Round a number to required decimal places, to disappear ###### symbols in cells.
Currency vs Accounting formats.
Date and time formats.
Convert text to numbers.
Convert numbers to text format.