• Welcome to the Excelguru Knowledge Base

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

    Welcome to the new and improved Excelguru Knowledgebase!

    Our 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.

    We are 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 our free help forums!

  • Recent Knowledge Base Articles

    Ken Puls

    Easy Outlook Email Integration

    Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.

    The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
    ... read more
    Ken Puls 2012-01-23, 05:52 AM

    Categories:

    Access - VBA Programming  Outlook - General Tips  Outlook - VBA Programming  PowerPoint - VBA Programming  Publisher - VBA Programming  Word - VBA Programming  Excel - VBA Programming 
    Ken Puls

    Prevent Printing In A Workbook

    If you'd like to prevent anyone from printing your workbook, this code will do the trick (subject to the caveat below).
    ... read more
    Ken Puls 2011-12-06, 05:36 AM

    Categories:

    Excel - VBA Programming 
    Ken Puls

    Trigger Conditional Formats Before Printing

    My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter data in has a green background. I also use blue backgrounds for "update these sometimes" cells, like tax rates. If cells are left with no colouring, though: everyone here knows that they should be left alone.

    Often, I have a few data entry cells or blocks on multiple worksheets. While this follows good spreadsheet design principles, it does have a bit... read more
    Ken Puls 2011-11-11, 07:56 AM

    Categories:

    Excel - General Tips  Excel - VBA Programming 
    Ken Puls

    Security In Microsoft Office

    Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.


    This chapter was obviously written for Excel 2007, and still holds true for Office 2010.

    In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these verions are Security Prior to Office 2007 and Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnigns in your programming environment, without having to sacrifice security by setting your security levels to low.... read more
    Ken Puls 2011-05-06, 06:13 AM

    Categories:

    Downloads - Learning Aids  Access - VBA Programming  Outlook - VBA Programming  PowerPoint - VBA Programming  Publisher - VBA Programming  Word - VBA Programming  Excel - VBA Programming  Excel - User Interface Customization  Works Published/Syndicated/Contributed 
  • MVP Logo

  •  Donations

    If you like our website and would like to give something in return, you can make a donation. All donations are gratefully received and go to support the site.


    Select your preferred currency and donation amount, then click the donate button.

  • Recent Forum Posts

    thedeadzeds

    Vba conditional formatting

    Hi All,

    I've got this code which works great but It works for the whole spreadsheet. How to I adapt it to work for cells a13 to ho140...

    thedeadzeds Yesterday, 09:34 PM Go to last post
    ref4ua

    Email completed PDF

    Ken,
    I'm needing to change the way this workbook emails out. Prior I was using Outlook, but I'm noticing that the email is sitting in the outbox...

    ref4ua Yesterday, 03:27 PM Go to last post
    Bob Phillips

    Calculating a Weighted Median

    Code:
    Public Function WeightedMedian()
Dim rngValues As Range
Dim rngWeights As Range
Dim rng As Range
Dim cnt As Long
    ...

    Bob Phillips Yesterday, 01:45 PM Go to last post
    sanchit16

    Thanks a lot ken u r real genius :)

    THANKS A LOT KEN U R REAL GENIUS ...

    sanchit16 Yesterday, 04:35 AM Go to last post
    kaybee

    Calculating a Weighted Median

    Hi All,

    I'm new to VBA programming and need some help determining the weighted median (NOT weighted average...I know there is an existing...

    kaybee Yesterday, 02:01 AM Go to last post
Gravatar by 1e2.it