Contact Us

Comments

New comments are not allowed.

Popular posts from this blog

How to make Salary Slip in Excel with Formula?

Image
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...
Read more

PIVOT TABLE IN MS EXCEL

Image
PIVOT TABLE IN MS EXCEL Pivot Table with Detailed Explanation: https://youtu.be/52xH2t9IGiQ  Follow this link to get workbook used in the video: https://drive.google.com/file/d/1Q2FCcojb3BoU-nyA55DXBiJpwDWdFIry/view?usp=sharing Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them. GROUP OR UNGROUP IN PIVOT TABLE: Learn how to group products and how to group dates by quarters, months or years. Group selected items 1 Hold CTRL key and select two or more values 2 Right click of mouse and select group Ungroup selected items 1 Right click any item that is in that group 2 Select Ungroup Watch the video till the end to learn everything in d...
Read more

How to create a Macro Button in Excel?

  How to create a Macro Button in Excel? How to insert button in Ms Excel? MACROS IN EXCEL -  https://youtu.be/tvw6rPbJHtc If you have tasks in Microsoft Excel that you do repeatedly, you can record a  macro  to automate those tasks. A  macro  is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. Follow this link to get worksheet used in the tutorial: https://drive.google.com/file/d/1JAqx1ADxHbhPcOHNhS1dDiyYXRfkY7a3/view?usp=sharing # Some important point to remember before creating a Macro- ∆ If you want to save macros, then you must save your workbook in a macro-enabled format *.xlsm ∆ The macro name should not contain any spaces. ∆ Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing. MACRO BUTTONS Macros make life easier. Buttons make life easier.  You can literal...
Read more