Ms Excel tutorial- Advanced Excel- Excel for beginner

Complete Data Validation Hello Everyone, Welcome to Learn Xtra 😍 In this video, We'll learn Data Validation. We'll use some formulas also like Istext, Isnumber, etc. Learn how to use Custom, Date, Text Length, Decimal, etc in Data Validation. You just need to select the area when you want to edit and then go to DATA Tab and select Data Validation and then go to settings and from *Allow* select your desired word like Text Length, date, list, etc. Let's learn all these one by one- A) Text Length- It shows that what would be the length of your data. It can be either number or any text. B) Custom- You can type any kind of formula in custom. Like Isnumber formula, Istext formula and so on. C) Date- In date, you can select any date whatever you want. You can select 'Equal to' for selecting a particular data or You can select 'between' for selecting as many dates as you want between the 2 dates typed by you. D) List- You can make a list of texts or. Numbe...

Astonish Everyone with MIS Report in Excel Today we'll learn how to make MIS REPORT in Excel. Learn how to make Line chart in Excel. Become smart in Excel, learn everything to become Smart. MIS Stands for Management Information System. These MIS Reports are made by every top management after collecting, comparing and analyzing data. Like in our Example, We first collected the data of Sales of various products in 2 years and then we compared it with the help of Line Chart and then the top management will analyze the data to make decisions like where they need to improve, where they are strong, where they want to go i.e. what is their target and so on. In this video, We'll use Line Charts to create a amazing presentation. we'll compare sales of 2 years. You can also compare the sales of as many years as you want. We'll use 2018-19 ans 2019-20 to compare the Sales of different products of Nataraj Brand. We'll do this with the help of SUMIFS Function. Sumifs Formula ...

ADVANCED CONDITIONAL FORMATTING IN EXCEL We'll learn Advanced conditional formatting in Excel. We will use NEW RULE of conditional formatting. We'll use a formula in Conditional formatting in order to get the Rows or Columns highlighted. We will use a simple formula to highlight the cells i.e. only those cells we want to highlight. In this video, I have taken the example of GRADES of students of Class VI, Where they achieved 4 Types of grades i.e. A,B,C & D. We'll highlight all the GRADES separately with the help of a formula which we will use in New rule of Conditional Formatting. Please watch the video till the end. This will help you understand everything clearly. As a BONUS- I have also explained Nested IF function of Excel. So watch it till the end to understand everything. Check this video to get deep understanding of IF FUNCTION IF Function in Excel: https://youtu.be/EhzNZEibMtg Hope you all will like this video. If this video is helpful for you, Please Subs...

Send Email from Excel using Hyperlink Function (PART 2) In this Tutorial, you'll learn how to send Email from Excel using a Formula in Excel. You'll learn how to send Emails automatically to anyone. We'll use HYPERLINK Funtion of Excel in this video. I'll show you step by step everything like how to use Hyperlink formula. We'll learn How to type body of your email, How to type Subject for your email, and how to type CC for your Email using Hyperlink formula only. You simply need to follow the steps and do the same what i did in the video. So watch it carefully till the end. This tutorial will help you become creative with Hyperlink Formula of Excel. You just need to use this formula once and then simply Copy & paste it in other cells. We'll use some syntaxs like mailto: , ?subject= , etc. I have combined IF Function with HYPERLINK Function, Do watch the video till the end carefully to understand everything step by step. If you want to add a line break in ...

SEND EMAIL FROM EXCEL USING HYPERLINK FORMULA In this video, you'll learn how to send Email from Excel using a Formula in Excel. You'll learn how to send Emails automatically to anyone. We'll use HYPERLINK Funtion of Excel in this video. I'll show you step by step everything like how to use Hyperlink formula. We'll learn How to type body of your email, How to type Subject for your email, and how to type CC for your Email using Hyperlink formula only. You simply need to follow the steps and do the same what i did in the video. So watch it carefully till the end. This tutorial will help you become creative with Hyperlink Formula of Excel. You just need to use this formula once and then simply Copy & paste it in other cells. We'll use some syntaxs like mailto: , ?subject= , etc. If you want to add a line break in the BODY of your Email, you can use (%0A) before that line. Just watch it carefully in the video. This is the PART 1 of the video, so stay tuned...

How to rename sheets in Excel with Pivot table and VBA code? Most of us rename sheets by right clicking on mouse and the click on rename. See the image Below Rename of Worksheet Let's learn some tricks to do this process in seconds Learn how to rename sheets using VBA Code and Pivot Table https://youtu.be/FbL540jKZVU This is the link of the Video. WATCH THIS VIDEO AND FOLLOW THE STEPS I have given three tricks, follow all these tricks and do your work in seconds # TRICK 1 Step 1 Type your data which you want in your sheet names. Like I want all the month names in separate sheets. Step 2 Select your data. Go to INSERT Tab and then select Pivot Table. Step 3 Move the MONTH into the Report Filter box Step 4 Go to OPTIONS Tab- Options- Show Report filter pages Step 5 Now, you got your sheets RENAMED. #TRICK 2 Step 1 Select any Sheet and right click on it. Then select VIEW CODE. Step 2 Go to INSERT - Module. A new sheet will appear, COPY (Ctrl + C) and PASTE (Ctrl +v) the data given bel...

How to make Salary Slip in Excel with Formula? Salary Slip is made by every Organisation for their employees. It is very easy to make. You just need to follow the steps below and become an expert in making salary slip or pay slip. <iframe width="560" height="315" src="https://www.youtube.com/embed/oLdFnV2EavI" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> OR      https://youtu.be/oLdFnV2EavI Watch this video with the help of above link and follow the steps given below. You will learn it very easily with the help of these steps Steps for Making Salary Slip in Excel: Step 1: Make your Salary Sheet in Excel of all your employees.  Provide Employee ID, Employee Name, Working Days, Basic salary, House Rent Allowance,   TDS, Provident fund, Net Salary, etc in your salary sheet. Provide every data which you need in              your Salary She...