Excel

  • My own thoughts

    Regarding my previous question from the weekend about where you draw the line between keeping up a good relationship with your users and letting them walk all over you with non-work technology issues, I would mostly err on the side of letting them walk over you. There’s definitely a line that needs to be drawn…

  • Today’s survey

    In all your experience supporting users, which is the most mis-used application, Powerpoint, or Excel? Leave your comments below. I used to think it was Powerpoint, but then I saw this Excel workbook, multiple sheets with somewhere in the area of 120 columns on each tracking various financial data going back 19 years, with no…

  • Lightbulb moments

    I’m sure by now we’ve all heard the horror stories of working on a helpdesk, and after 7 plus months working on one I can totally see exactly where they’re coming from, and even have a few of my own. On the other hand, one thing that I get working on a helpdesk far more…

  • SUMPRODUCT

    Yes, it’s an Excel function. One I knew about, kind of, but had never needed to use, until today. Luckily, for all of us who were working on this formula, I found this page using Google and it made for an easy to follow example of summing the data in cells that matched mulitple criteria….

  • Week in review

    I tell you, working for a larger organization, supporting 10 times the number of users I used to support and supporting a wider variety of tools, sure keeps you on your toes. This week I spent time battling a spyware infection, troubleshooting Word macros, Excel formulas, PowerPoint graphics, Outlook options, printer connections, and Acrobat Reader…