Many a times, it is good to Display the location of the file in Excel. Not just the file name, but the entire path of the file. It is a good reference to make sure you are working on the correct file, and is also good if you...
Before the year 2016 begins, Microsoft has already unveiled Microsoft Office 2016 suite – with a number of enhancements, features, and completely new things that extend the existing Excel and takes it to new levels. In the...Read More
We all are sitting on mountains of data, and new data arrives each day in the form of Reports, CSV files, Charts from Marketing, Logistics, Sales, Websites, Google Analytics… Before you can make any sense of it, even more...Read More
You have seen online application forms where the Country Names are selected from a drop-down box. Or to select the Name of an Employee, or Cost Center Codes, or Departments etc.? This kind of list serves 2 purposes: 1. It makes...Read More
It is quite easy to show or hide columns in Excel. Simply select a column, and press Control + 0 . The column is hidden from the view. You can make it out because of a dark line separating the columns. If you hide the B column,...Read More
For my small Training business, I haven’t reached the revenue target of Million Dollar...Read More
Each week I receive questions from people facing issues with Excel. Some need help on Excel Formulas, Pivot Tables or Macros. What issues are you facing in Excel? Solving Everyday Problems in Excel [Survey]Each week I receive...Read More
Who is Behind ExcelChamp
Excel Dashboards MasterClass
Get Excel Tips & Tricks Each Week
Online Advanced Excel Training by ExcelChamp Vinai Prakash
Learn about Formulas, Functions, Vlookup, Charting, Ranges, Pivot Tables, Sharing, Protection etc.
More info at Online Advanced Excel Training Program