30 Excel Functions
Category Archives: Excel Consulting
More Online Meeting Tests
Last week I tried WiZiQ for an online meeting with a client. There were a few snags, that I mentioned in the class evaluation form that popped up when I finished my session. The next day, someone in the WiZiQ … Continue reading
Posted in Excel Consulting, Excel training
4 Comments
Online Training For Clients
Do you do any online, real-time teaching or learning? A client wanted to learn a bit more about Excel VBA, so we arranged a phone call for today. He sent me a couple of workbooks to use during the session. … Continue reading
Posted in Excel Consulting, Excel training
9 Comments
I Have a Question
If you have an Excel blog, or have written an Excel book, or ever answered a question in an Excel newsgroup, you probably get questions in your email inbox. Most of the emails can be answered by pointing the person … Continue reading
Posted in Excel books, Excel Consulting
2 Comments
Thinking About Excel
My friend, Heather Mak, asked if I’d like to be interviewed for her new online magazine, Five Takeaways. What key things should people know about Excel? What are its Five Takeaways? The magazine’s first article was about American Chinese food, … Continue reading
Posted in Excel Consulting
2 Comments
Disaster Planning
Thirty years ago today, there was a huge explosion in Mississauga, when a train derailed, right in the middle of the city. I lived in Downsview, about 20 miles east, and felt the house shake, just before midnight, as though … Continue reading
Posted in Excel Consulting
Leave a comment
Working From Home
I’ve been travelling to a client’s office this week, finishing up an Excel project. Hope to have the work done soon, before the snow and H1N1 pandemic hit. It’s better to be working from home under those conditions! A short … Continue reading
Posted in Excel Consulting
Leave a comment
Vanity URLs for Facebook Pages
It looks like Facebook has finally lowered or removed the minimum number of fans required to register a vanity URL for a page. When the vanity URL feature was first announced, a page needed 1000 fans. Then they reduced it … Continue reading
Online Tool To Help Publish VBA Code
On the Contextures website, I’ve got many pages with sample VBA code for Excel. When I feel ambitious, I colour the code before I publish it, using green for the comments, and blue for the keywords. For example, here’s some … Continue reading
Posted in Excel blog, Excel Consulting
Leave a comment
How to Price Your Software
On my Contextures site you can download my free pivot table add-in, PivotPower. So far, I haven’t created an Excel product for sale, but a few of my Excel colleagues have. One of the challenges is in setting a price … Continue reading
Posted in Excel Add-ins, Excel Consulting
Leave a comment
Create a Facebook Page For Your Business
Instead of using my personal Facebook page for business news, I’ve created two pages for Excel related updates. One is for Contextures, and it has general Excel news and automatic updates from my Contextures blog. The other page is for … Continue reading
