The free guide

Excel

Functions

Date & Time functions in Excel

Financial Functions

Information Functions

Statistical Functions

Text Functions

Logical Functions

Ranges

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:

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.

Format Cells

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.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved