Excel Shortcut Key with Ctrl 

Excel Shortcut Key With Alt 

Excel shortcut key with shift

Excel shortcut key When "Inside The Cell" 

Excel shortcut key with function key 

Excel Shortcut key with function part 2

Excel shortcut key with formatting function 

In this video you will learn 

• What is Excel
• Key features of Excel
• Type of Ms- office 

This is video you will learn

• How to use Excel 365 free

How to Excel Work Part 2

In this video you will be learn

What is Absolute reference

Type of Absolute reference

How to use Absolute reference 

1. Home > Clipboard

2. Paste Special

Paste

---------------------------

Formulas

Values

Formats

Comment and Notes

Validation 

All Using Source Theme

All except Borders

Formula and Number formats

Values and number formats

Operation 

----------------------------

Note

Add

Subtract

Multiply

Divide

Skip Blanks

Transpose 

2. Home > Font 

Condition formatting 

• Highligh cell rules
• top/bottom rules
• Data Bars
• Color Scales
• icon sets
• Format as table & color style

Home > Cell 

• Insert > 
• Delete >
• Format > Cell Size > Row Height | Autofit row Height |
• Column Width,
• autofit column width ,
• Default width
• Visibility > hide & unhide
• Organize sheet > Rename sheet, 
• move or copy sheet, 
• Tab color

Editing - Fill > 

• Down 
• Right 
• Up 
• Left
• Accross Worksheets 
• Series
• Justify 
•  
• Editing > Flash Fill

Clear  > Clar all | Clear | Formats | clear contents | Clear comments and notes | Clear Hyperlinks | remove Hyperlink 

Shorts & filter 

Page Payout > Page Setup

Margins | Orientation | size | Print area | Break | Background | Print Title | scale to fit | Gridlines | headings  | Arrange  

Define name | name manager | Create from selection

Formula auditing - Trace precedents | trace depedents | reove arrows | evaluate formula 

Text toColumn | Remove Duplicate | Data Validation | Consolidate 

Page break preview | page layout | custome view | naviation | gridlines | formula bar | Headings 

All About Basic Function 

1. Get the LENgth of a text string

2. Change case to UPPER, lower, or Proper

3. CONCATENATE a text string

4. Use INDIRECT to create a reference from a text string

5. Use CHAR to return special characters

6. SUBSTITUTE text within a string

7. Use TRIM to get rid of extra spaces

8. Use FIND and SEARCH to get the position of text in a string

9a. Use MID, LEFT and RIGHT to extract text from a string

9b. New TEXTAFTER, TEXTBEFORE functions

10. Count the number of spaces in a string

11. Count occurrences of a string within text

12. Split text into columns using formulas

13. Get the last word in a string

14. Get the Nth word in a string

15. Convert a string to an array of words

16. Convert a string to an array of characters

17. Use EXACT for case-sensitive text comparisons

18. Create a SEQUENCE of characters

Conditional Formatting

• Highlight all the black cell
• Highlight all the text
• Highlight all the number
• Highlight all the errors
• Highlight all the odd rows
• Highlight all the even rows
• Highlight atternative cells (01)
• Highlight atternative cells (02)
•  

Conditional formatting 

• Highlight all the names started from "D"
• Highlight all the names ended at "a"
• Highlight all the names started from "D"
• Highlight all the five characters name whose 2nd character is "a"
• Highlight all the names not containing "E"

Advance option of conditional formatting 

Conditional formatting part 4 

• Highlight all the players name who scored a half
• Highlight all the players name who scored a century
• Highlight all the players name who scored the maximum no of runs.
• Highlight all the players name who scored the minimum no of 
• Highlight the 3rd highest scorers name
• Highlight the 2nd lowest scorers names
• Highlight all the players name and runs both who scored the maximum no of funs.

Important key point of custom symbol like Comma, Hash, at sign, Plus, Left parentheses, Right parentheses, Asterisk 

This macro code will automatically add serial numbers to your Excel sheet, which can be helpful if you work with large amounts of data.

This code helps you to enter multiple columns in a single click.

With this code, you can enter multiple rows in the worksheet. When you run this code, you can enter the number of rows to insert and make sure to select the cell from where you want to insert the new rows.

This code quickly auto fits all the columns in your worksheet.

You can use this code to auto fit all the rows in a worksheet.

This code will help you to remove text wrap from the entire worksheet with a single click.

This code simply uses the unmerge options which you have on the HOME‌ tab.

In Windows, there is a specific calculator and by using this macro code you can open that calculator directly from Excel.

This macro adds a date to the header when you run it. It simply uses the tag “&D” for adding the date.

When you run this code, it shows an input box that asks you to enter the text which you want to add as a header, and once you enter it click OK.

Formatting Codes

This macro will check each cell of your selection and highlight the duplicate values.  You can also change the color from the code.

I really love to use this macro code whenever I have to analyze a data table.

Just select a range and run this macro and it will highlight top 10 values with the green color.

If you are not sure about how many named ranges you have in your worksheet then you can use this code to highlight all of them

Once you run this code it will ask you for the value from which you want to highlight all greater values.

Once you run this code it will ask you for the value from which you want to highlight all lower values.

Select a range of cells and run this code. It will check each cell from the range and highlight all cells where you have a negative number.

Suppose you have a large data set, and you want to check for a particular value. For this, you can use this code. When you run it, you will get an input box to enter the value to search for.

To highlight all the cells with comments use this macro.

By highlighting alternate rows, you can make your data easily readable, and for this, you can use below VBA code. It will simply highlight every alternate row in selected range.

If you find hard to check all the cells for spelling error, then this code is for you. It will check each cell from the selection and highlight the cell where is a misspelled word.

To highlight and count all the cells in which you have an error, this code will help you. Just run this code and it will return a message with the number error cells and highlight all the cells.

This code will help you to count the cells which have a specific value which you will mention and after that highlight all those cells.

Sometimes there are some cells which are blank, but they have a single space and due to this, it’s really hard to identify them. This code will check all the cell in the worksheet and highlight all the cells which have a single space.

It will check all the selected cells and highlight the cell with the maximum value.

It will check all the selected cells and highlight the cell with the Minimum value.

This code will highlight all the cells from the selection which has a unique value.

Using this code, you can highlight the difference between two columns (corresponding cells).

And by using this code you can highlight difference between two row (corresponding cells).

Printing Codes