Before I hand over this guide to you and you start using VBA to create a pivot table let me confess something. I have learned using VBA just SIX years back. And the first time when I wrote a macro code to create a pivot table, it was a failure. Since then I have learned more from my bad coding rather than from the codes which actually work. Today, I will show you a simple way to automate your pivot tables using a macro code. Normally when you insert a pivot table in a worksheet it happens through a simple process, but that entire process is so quick that you never notice what happ ..read more

When I started using it in Excel 2010, there was only one issue that I faced to Enable PowerPivot. In Excel 2010, unlike earlier versions of Microsoft Excel, you have to activate it first before using it. If you are still using Excel 2010, this post is for you. System Requirement to Enable Power Pivot in Excel A Windows version of Excel, either 32-bits or 64 bits. Minimum of 1 GB of RAM (2 GB Recommended by Microsoft) 3.5 GB of available hard disk space in your system. Steps to Enable Power Pivot in Excel 2010-2013 In Microsoft Excel 2010, Power Pivot not comes with the main ..read more

[wp_ad_camp_5] The first step to create advanced Excel charts is to learn how to add a secondary axis in a chart. If you look at the below two charts, in the first chart you have two different data column series but the axis is the same. The problem with the first chart is, both of the series have a different data range but the same axis. But in the second chart, you have a different axis for both of the data series which makes it easy to understand. Adding a secondary axis in a chart is pretty simple. [wp_ad_camp_3] Steps for Adding a Secondary Axis in Your Chart Here are the ..read more

In high school, I used to solve mathematical equations where I have the result of the equation but don’t have the input value. So, if you think about solving the same kind of problems in Excel, you have a specific tool that can help you. Goal Seek Its basic idea is to find the input value that formula needs to get that result. In simple words, if you know what actual result value you want, you can use goal seek to find the best input value for getting it. For example: Let’s say you need to borrow some money from your friend. You know how much money you need, how long you want to take to pay of ..read more

In Excel, there is no direct function to get a quarter from a date. But you can create a formula for this. Yes, you can use a formula to calculate a quarter from a date. Even there is more than one method which you can use. Alright, as you know there is a total of four quarters in a year but the thing is you can get a quarter from a date in different ways. The first is, assuming a year on the normal calendar basis or the second one on the fiscal calendar basis. And in today’s post, I’m going to show you methods to get the quarter number using both of the calendars and I’ll also share more than ..read more

Experts know the importance of serial numbers. Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless. Yes, they are important. Because with a serial number you can have a unique identity to each entry of your data. But the sad news is, adding them manually is a pain. It’s really hard to add a number in every row one after another. The good news is, there are some ways which we can use to automatically add serial numbers in a column. 14 Ways to Insert Serial Number Column in Excel And today, in this post, I’d like to share with you 1 ..read more

Home I have a strong reason for you to use a dynamic chart range. It happens sometimes that you create a chart and at the time when you update it you have to change its range manually. Even when you delete some data, you have to change its range. Maybe it looks like that changing a chart range is no big deal. But what, when you have to update data frequently? You do need a dynamic chart range. Are you sure, I need a Dynamic Chart Range? Yes, 100%. Alright, let me show you something. Below, you have a chart with the month-wise amount and when you add the amount for Jun, chart values are the sa ..read more

Macro codes can save you a ton of time. You can automate small as well as heavy tasks with VBA codes. And do you know? With the help of macros... ...you can break all the limitations of Excel which you think Excel has. And today, I have listed some of the useful codes examples to help you become more productive in your day to day work. You can use these codes even if you haven't used VBA before that. But here's the first thing to know: What is a Macro Code? In Excel, macro code is a programming code which is written in VBA (Visual Basic for Applications) language. The idea behind ..read more

The post 100 Excel Tips and Tricks appeared first on Excel Champs ..read more

While working in Excel, sometimes, you need to think out of the box. It happens to me sometimes... ...when I share my dashboards and templates with other users and they made changes in it and all of my work break. Well, to solve this problem, I started to use live images of data tables instead of using actual data tables. This helps me to present my data to them and they can’t make changes in those visual references because those are just images (but live). And for this, I use the Camera Tool. Maybe you are hearing about this tool the first time but yes, there is an in-built camera in Excel ..read more