In this Microsoft Excel step-by-step tutorial, discover 30 Awesome Tips and Tricks that will make you look like a pro!

This video includes tips that are useful in day to day work.

⏰TIMESTAMPS⏰

00:21 – Tip #1: Select multiple cells
01:50 – Tip #2: Adding serial numbers
03:05 – Tip #3: Copying the sheet
03:44 – Tip #4: Moving multiple columns easily
04:20 – Tip #5: Moving to the first or last column
06:46 – Tip #6: Shorten the width of the columns
07:42 – Tip #7: Applying arithmetic operations
09:52 – Tip #8: Copy the formula to other cells
11:16 – Tip #9: Absolute cell reference
13:30 – Tip#10: Built-in formulas
14:20 – Tip#11: Use Built-in formulas to make your own new formula
16:10 – Tip#12: Make a Table
17:16 – Tip#13: Filters
19:03 – Tip#14: Sort the data of a table
20:00 – Tip#15: Remove duplicate data from a table
21:35 – Tip#16: IF function
25:26 – Tip#17: SUMIFS function
28:04 – Tip#18: Concatenate function
29:18 – Tip#19: Sort function
31:34 – Tip#20: Unique function
32:56 – Tip#21: Combine two functions
34:49 – Tip#22: Paste special
36:21 – Tip#23: VLOOKUP function
38:59 – Tip#24: Quick analysis
40:33 – Tip#25: Creating charts from the table
42:10 – Tip#26: Generating totals of columns
43:17 – Tip#27: Providing a drop down to a cell
45:16 – Tip#28: Flash fill
46:48 – Tip#29: Left and right functions
48:15 – Tip#30: View formulas

To get more of our best content on IT careers and IT certifications, go to https://www.skillsbuildtraining.com/blog

Be sure to leave any questions or comments below!

See More Videos and Subscribe: https://www.youtube.com/channel/UCQa4HENaBBB29aCMq7uJkqA/
Website: https://www.skillsbuildtraining.com/
Facebook: https://www.facebook.com/skillsbuildtraining/
Twitter: https://twitter.com/SkillsbuildT