How many sheets you can insert in a workbook ?

Know about Microsoft Excel

Worksheet in a workbook

Did you know about that Microsoft Excel
How many sheets in a workbook ?
You can make unlimited Sheets in a workbook depend on your system available memory. by default excel have an one sheet.

Excel Shortcut Keys: Ctrl + H (Find and Replace)

Excel Shortcut Keys

Ctrl + H

Displays the Find and Replace dialog box, with the Replace tab selected

Did you Know about Excel Rows and Columns

Know about Microsoft Excel

Worksheet Size

there are 1,048,576 rows and 16,384 columns in one worksheet

 

 

Using VLOOKUP function (step by step tutorial)

Excel Tutorial

Using VLOOKUP() function (step by step tutorial)

How to use VLOOKUP() function in Excel

using VLOOKUP function

Calculate growth formula in Pivot Table

Excel Tutorial

Calculate growth formula in pivot table

How to calculate growth formula in PivotTable

Ctrl + G (display GoTo dialog box)

Excel Shortcut Keys

Ctrl + G

Displays the Go To dialog box.

F5 also displays this dialog box.

 

Excel Game : Sudoku in Excel - Work and Play

Sudoku in Excel—Microsoft OfficeDocs.com

Excel Shortcut Keys: Ctrl+F (Find data)

Excel Shortcut Keys

Ctrl + F

Display the Find and Replace dialog box, with the Find tab selected.

You can find the data or text using the Ctrl+F

 

Excel Shortcut Keys : Ctrl + Shift + ) - (unhide Columns)

Excel Shortcut Keys

Ctrl + Shift + )

Unhide Columns

Unhide any didden columns within the selection.

 

exce0

Create a Pivot Table

Excel Tutorial

Create a pivot Table

How to create a Pivot Table in Excel