@negeen-dargahi,

Your comments helped me to clarify the reason I took the approach that I did. And I realized that I hadn’t done a very good job to advance that reason. Here it is:

When we make a pitch, prospects can have two significant doubts. They can doubt the sales person, and they can doubt themselves. So we need to reduce both types of doubt.

In my revised profile…
https://www.linkedin.com/in/charley-kyd/
…I promise that: I Can Help YOU Generate Dozens of Excel Reports, Forecasts, and Analyses in Less Time Than You Normally Generate Only One.

For most Excel users, that’s not a believable promise. So the purpose of my video is to (a) explain why I can make that promise, and, (b) reassure them that they can make it work for them.

Using a salesy video ignores their legitimate doubts. I’ve got to use that time to ease those doubts.

Charley

—————

Hi! This is Charley Kyd.

I can help you generate dozens of Excel reports, forecasts, and analyses in less time than you normally generate only one report.

And in less than one minute, I’ll show you how you’re going to do it after you subscribe to my training, or ask me to set up the initial system for you, or both.

This is the top of a daily report of business and economic data.

This is your Data Table. You’ll use Power Query to update it with one command.

This is your Metadata Table. That same command will update it, as well.

This is one of your staging tables. Here, Excel formulas return—from the data table—the data about the current price of crude oil. And the report will display that data in Figure 2.

This cell has a formula that returns the most-recent date for which we have crude oil prices. The formulas in the staging table look at that date and automatically adjust to show prices for the most-recent 31 weekdays of data.

And here’s the top-part of our report again, which shows the crude oil prices in figure 2.

When we launch the refresh-all command, Power Query updates the data table and the metadata table. The formulas in the staging tables recalculate. And then the report recalculates.

Not only does this reporting method slash the time you need to update your Excel work, it slashes your errors.

And because the updating process is so simple, we could use a simple macro to open the first workbook in a list, refresh it, print it or save it as a PDF, close it, open the second workbook, and so on.

My Excel Productivity training will teach you or your staff how to set up productive reports, forecasts, and analyses that update just as easily. Or, if you’re in a hurry to make your company’s Excel work MUCH more productive, I can set up the initial system for you.

To slash your Excel reporting times and error rates, shoot me a message NOW. Let’s talk.

@negeen-dargahi,

Which is more believable?: To TELL people that you can help them? Or to SHOW them?

Which is more memorable?: A DESCRIPTION of the Golden Gate Bridge? Or an IMAGE of it?

We BELIEVE our eyes. We REMEMBER images.

Showing proof through pictures is difficult for many services. But not for mine.

Because I’ve got it, I’ll flaunt it.

However, at 345 words right now, I DO need to make the script much shorter. At 150 wpm, that’s over two minutes of video. And I have three more images that I want to show, but only for about three seconds each.

Finally, the banner, the About, and the video will support each other. Particularly, the About will reference the video. And the video will reference the banner.

Thanks, Negeen.

Charley