How to Add Developer Tab In Excel Ribbon for Window & Mac

    Developer tab in excel is one of the most important & highly useful options in excel. But, before using this gem you have to activate it in your Excel. In this post, I will show you how to Add Developer Tab In Excel in windows as well as in excel 2011 for mac. How To Show It In Your Excel […]

    Check it out now

    How To Use Format Painter In Excel For Quick Formatting

      How To Use Format Painter In Excel For Quick Formatting

      If you have a cell with some specific font style, having a specific background color & you want to copy that formatting to some another cell, you can use format painter to do so.

      Check it out now

      How To Use Fill Justify In Excel

        Fill Justify is a Life Saver. The single core motive to use fill justify in excel is to merge the data from multiple cells into a single cell. And, if you think you have any other idea to merge text into one cell, leave it. Using fill justify is a better option. So, today in […]

        Check it out now

        10 Useful Excel Shortcuts for Excel Rock-stars [My Favorite]

          Useful Shortcuts Keys To Change Zoom

          Keyboard shortcuts are awesome. By using keyboard shortcuts, you can not only increase your speed but you can also increase your efficiency and productivity. So today, I’ll show you my favorite keyboard shortcuts for Excel. You can learn these shortcuts to drive your skill to next level. And, I am sure you will love each […]

          Check it out now

          A Ultimate Guide To Learn About VBA MsgBox Function

            vba msgbox function in excel

            Here is your ultimate guide to master VBA Msgbox Function. You can use VBA Msgbox Function in excel to get a simple popup box on your excel’s window. If you really think about VBA MsgBox Function, it has two main roles in your VBA. Deliver a message to the user. Get a simple response from the […]

            Check it out now

            How To Use Default Data Entry Form In Excel [Hidden Feature]

              Do you know there is no need to write a single line of coding for a user form? Yes, there is no need to write any type of code for a user form. This is a firm truth that data forms are widely used to enter data into the spreadsheets. It is also very right, […]

              Check it out now

              How To Create VBA ON-OFF Button In Excel

                Today, we will learn that how to create an on-off button in excel. Okay. So, Let’s start our hunt for an on-off switch. How will an on-off switch be usable? It can help you to control two macros with one button. You can also use it to start or stop a macro. Points to consider It should […]

                Check it out now

                5 Custom Date Formats You Have To Learn Today Right Now

                  excel custom date formats

                  Few, days back, I had explained about how to convert non-standard date formats to standard date formats in my post. But, Sometimes it is required that we use some off track date formats rather than using simple date formats. As we know, excel blessed us with highly flexible options & Custom Date Formats is one […]

                  Check it out now

                  Internet Radio in Excel – Play Music Directly From Your Spreadsheet

                    Peter is talking about his new internet radio in excel. Steps to Create an Internet Radio in Excel Go to Developer Tab -> Controls -> Insert -> Active X Control -> More Control. Select Window Media Player from the list. Now, double click on the window media player. And, By clicking on it, you will […]

                    Check it out now

                    How To Calculate Age From Date of Birth In Excel

                      How To Calculate Age From Date Of Birth In Excel

                      In this post, you will learn about how to calculate age from date of birth in excel using a simple formula. We will use that formula to calculate age by using the date of birth. And, we will get the result in years, months and days. But before telling you how to calculate age from […]

                      Check it out now