In this video, I will show you some quick and easy tricks for Microsoft Excel. These include shortcuts, time-saving tips, tips for working with data and getting your work done faster. Join me as I show you how to work smarter with these Excel tricks.

👉 Join now our QnA Community - https://bit.ly/335Fic7

0:00 Introduction to Excel Data Analysis
0:53 How to extract the information in MS Excel
1:11 Press Ctrl + E (To extract the data in Excel)
1:59 Press Ctrl + Shift + 3 ( Numbers Convert to Date Format)
2:08 Press Ctrl + H (To activate Find and Replace in Excel)
2:53 How to find Day by using Date in Excel
4:31 How to use Value Function in Excel
5:07 Press Shift + Ctrl + Down Arrow (To select the data in Excel)
5:11 How to activate the Pivot Table in Excel
6:31 Press Ctrl + Shift + 1 (To correct the format with 2 decimal in Excel)
6:42 How to use Conditional Formating in Excel
6:57 How to use Sparkline Function in Pivot Enable Excel
7:36 How to use Analyze Function in Excel
8:11 How to create a chart in MS Excel
8:43 Best Trick of the Day

#exceltricks #exceltips #excel

👉 Check out Excel tutorial Playlist -    • Excel Tips & Tricks  

Let's Connect:

👉 Follow us on Instagram   / yodalearning  
👉 Follow our boards at   / pins