The twitter experiment is now over. I used Tweetake to get my tweets into a CSV, which I then opened in Excel.
I tried to post every 1/2 hour. At the time of the post, I’d write what I did since the last post. Since I usually did more than one thing, I [...] Read More...
As many of you know, I don't do anything with technology 'in earnest', but love tinkering and it is great to have a 'project' with a functional 'end game'. Recently, I have been a little 'off' my usual Excel activity and developing (for fun) in the evening, on trains...
How do you communicate a pivot table to someone? I have a huge table of payroll transactions and I created a pivot table for my worker's compensation premium audit. Someone else who has Quickbooks could use this pivot table for their own purposes, but I don't know how to tell them how to [.....
Just as a test, I have uploaded Part 1 of a set of videos dealing with Pivot tables in Excel 2007. This first one simply takes you though the new interface, using external data and shows some of the new features, like context-sensitive sorting and filtering, compact view, data connection management and...