PTS Chart Utilities: Waterfall, Cluster-Stack Column, Box and Whisker, Marimekko

  • Welcome to the Excelguru Knowledge Base

    by
    Ken Puls
    Published on 2011-08-26 07:22 AM      Number of Views: 451293  

    Welcome to the new and improved Excelguru Knowledgebase!

    My favourite definition of the word Guru is "Remover of darkness"; A guide. A teacher. It is in this spirit that the ExcelGuru website was created: to help remove the mysteries of Excel, help you find solutions, help you to be more proficient or accomplish certain tasks.

    I am a firm believers that properly set up, a computer can process numbers and data far more efficiently and accurately than any human, and that human brainpower should be devoted to solving problems, not data input. Did you know that the only thing that can't be automated in Excel is the input of raw data... and that even that can sometimes be done? If you perform repetitive tasks in your Excel spreadsheets, you may be wasting both your time and business resources performing unnecessary work. Let us show you how to save both your time and money by helping you automate your tasks today!

    The Excelguru Knowledgebase is packed with numerous articles on how to accomplish specific tasks in Microsoft Excel, Microsoft Access and other programs included in the Microsoft Office suite. It also includes examples on a select few non-Microsoft Office programs, and many general tips as well.

    If you notice errors in any of the articles, or have suggestions for improvements, please feel free to leave a comment on the article's page. And if you need any help modifying the articles to suit your needs, then please, post in my free help forums!

  • Recent Knowledge Base Articles

    Ken Puls

    XLG File Tools Add-in

    XLG File Tools is a FREE add-in which was created to increase the functionality of Excel and address the plethora of extra clicks that were introduced begining in Excel 2007. It's current feature set is designed to make the job of opening existing files and creating new files more efficient.

    XLG File Tools is easy to use, and is guaranteed to make you more efficient. In addition, it's a snap to install and requires no administrative priviledges to do so.
    ... read more
    Ken Puls 2012-04-04, 05:36 AM

    Categories:

    Excel - General Tips  Downloads - Utilities 
    Ken Puls

    Sorting A Column Of PowerPivot Data By Another Column

    One of the things that used to drive me crazy about working with PivotTables in PowerPivot’s initial (2008) release was summarizing dates by month. With a standard PivotTable, we can use the built in Group functionality to group dates by Years, Quarters and Months. But in PowerPivot, that functionality wasn't implemented. To deal with this, we have to provide our own date table, but the months never really sorted well, and we had to resort to tricks to coerce them into the right order.
    ... read more
    Ken Puls 2012-03-28, 06:16 AM

    Categories:

    Excel - General Tips  Excel - PowerPivot  Excel - PivotTables 
    Ken Puls

    Displaying “Last Updated” Date And Time In PowerPivot

    We use PowerPivot to display key information in dashboards, some of which can be refreshed right up to the current second. Naturally, one of the first questions asked when looking at the reports (particularly if they get printed) is “When was the data last updated?”
    ... read more
    Ken Puls 2012-03-28, 05:49 AM

    Categories:

    Excel - General Tips  Excel - PowerPivot 
    Ken Puls

    Approximate Matches With VLOOKUP

    The purpose of the VLOOKUP function is simple: it looks up data in tables and returns results from a different column. So if you have a table of products, for example, you could ask VLOOKUP to return the price for an item given the ID of the product.

    But VLOOKUP is more than just that; it is the gateway to real Excel knowledge. The VLOOKUP function contains everything that a function can throw at you: multiple required parameters, optional parameters with defaults, and needs both ranges and numeric data in its input strings. If you can master this function, you can master ANY other function in Excel.
    ... read more
    Ken Puls 2012-03-22, 06:00 AM

    Categories:

    Excel - Formulas  Excel - Interactive Pages  Syndicated Articles 
Gravatar by 1e2.it