Easy Explanation Notes with Examples

Basics of Microsoft Excel [For beginners]

This section is for beginners with no knowledge of Excel.

A workbook is a group of worksheets that are used to organize, calculate & analyze various kind of related information.

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 the 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 into cells:

Merge and unmerge cells combine more than one cells to a large one.

Cell Reference

a cell reference is an address to a cell or a range of cells on a worksheet, it uses in formulas so that Excel find those values that you want to calculate in a formula.

Naming a cell or a range in Excel

Change a cell reference

Relative, absolute, and mixed references in Excel

Sort Data

Sort data in a range or table

Sort by Color in Excel

Sort by dates in Excel

Filter Data

How to filter in Excel

Filter by color in Excel

Number and Text Filter in Excel

Date Filters in Excel

Advanced Filter in Excel

Named Ranges

A dynamic named range in Excel expands automatically when new values are added to the range. For Example, select the range A1:A6, name it ‘Data’ and then calculate the sum.

Use names in formulas: Formulas become much easier to understand and maintain when we use names instead of cell/range references.




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