Excel Shortcut Keys: Ctrl + L (Create a Table)

Excel Shortcut Keys

Ctrl + L

Displays the Create Table dialog box. To Make a Table

or Make your data into uniform to change your range into Table

 

 

Excel Shortcut Keys: Ctrl + K (Insert Hyperlink)

Excel Shortcut Keys

Ctrl + K

Displays the Insert Hyperlink dialog box

For new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

 

Happy Independence Day

Excel Shortcut Keys: Ctrl + I (Italic)

Excel Shortcut Keys

Explore Excel 2016

In this video, you will explore the Excel overview,  using the tell me box and add or delete a worksheet.





Click here to view the original source

Eid Mubarak

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