Archives


  1. Top 10 Advanced Excel Charts and Graphs to Make You PRO Overnight: Even there are a lot of advanced charts and graphs which we can create in Excel, but these are the top 10 advanced chart which you can use in your dashboards and templates for...
  2. How to Calculate SQUARE ROOT in Excel: A square root is a quite common calculation which we do in our day to day work, and in Excel, you can calculate it with an ease and I've found that there total...
  3. How to Create Interactive Charts in Excel: In Excel, you can create Interactive [Dynamic] charts which can further help you to present more data in a single chart. Look at the below chart...
  4. How to Create a Dynamic Chart Title in Excel: By creating a dynamic chart title you can make your Excel charts more effective. Just think this way...
  5. How to Add a Vertical Line in a Chart in Excel: You can highlight a specific point on a chart with a vertical line and out of all the methods, I’ve found this method (which I have…
  6. How to Link/Connect a Single Slicer with Multiple Pivot Tables in Excel: Let’s say you are working on a dashboard where you are using multiple pivot tables and if you are able to connect slicer to all the pivot tables you can control...
  7. How to Automatically Update a Pivot Table Range in Excel: Every time when you add new data in the source sheet you need to update the source range for the pivot table before you refresh...
  8. How to Insert a Timestamp in Excel: And quickly I realized that she was talking about a timestamp. I’m sure you also use it while working in Excel. In general, it contains the current date and time, and...
  9. [Free Download] One Page Daily Sales Report Excel Template/Format: You can’t spend a lot of time every day to create a sales report, especially at end of the day. So today, I’d like to share with you one of my favorite template which I used to share with my boss at that time...
  10. How to Convert a Formula to Value in Excel: Sometimes it’s important to change a formula into its result value and I’ve found that there are six different methods which you can use for this...
  11. How to use Wildcards with VLOOKUP in Excel: When you combine an asterisk which is a wildcard character, you can get the marks of a student by just using a partial match...