« Power Word webcast tomorrow! | Main | Advanced Tips and Tricks for Complex Word Documents: Financial Pitch Books Made Simple »

Thanks for attending today's webcast! ... and additional resources
January 24, 2006

Hi, everyone! Thanks to those who took time to attend today's webcast. If you wanted to, but didn't get a chance -- it will be available for on-demand viewing as of tomorrow.

The session today was an advanced Word session focusing on financial pitch books -- very complex Word documents containing lots of formatting and layout, tables, and graphics.

What I hope you saw in this session is that by getting comfortable with just a few key features, you can do so much more than you might imagine - in less time than you might expect.

If you had a question that didn't get answered, or questions came up after you left the LiveMeeting, please post them as comments here and I'll respond asap.

Before I get to additional resources, I do owe one question response that I promised to post here. Shorcut keys for changing case:

To toggle between cases (actually change the characters from lower case to upper case to title case to initial caps): Shift + F3

To apply ALL CAPS font formatting: Ctrl + Shift + A

... and keep in mind that you can search for Keyboard Shortcuts in the 'Type a question for help' box at the top right corner of any Office program window for pretty comprehensive keyboard shortcut listings for that program. Or, for quick access to all of them across Office 2003, click here for an Office Online article that has them all accesible for you from one place.

Now for those additional resources, as promised ...

Additional Resources

For quick access to the links I gave you at the end of the session, as well as some of my other favorites, click here for the links page on this blog.

For those who would like to review core concepts, such as the three levels of formatting - check out an earlier post on this blog - Word Philosophy 101.

For a review of formatting essentials, check out two excerpts from my book that are available on Office Online:
Making Your Word Documents Behave
Paragraph Formatting Essentials for Unbreakable Documents

For help with table basics, try my Office Online Training course, Tables I

For help and practice creating tables as page layouts and working with nested tables, check out my course Tables II

To review the shorcuts and steps for working with fields that we looked at today, check out an earlier post on this blog - Let's Talk About Fields, Baby

For those who want to begin their adventure in VBA, here are a few links from this blog, as well as a link to an earlier webcast I gave on the basics of VBA (using the sample I showed in today's session) ... and a couple of links to free content on MSDN.

Also, as mentioned in the session today, I will be giving an Office VBA basics webcast in just a few weeks - that will cover much of the content you'll find in the earlier webcast link below, along with additional tips including translating that information to VBA in Excel and PowerPoint as well. Stay tuned for links and info on that upcoming webcast. Meanwhile, here are your VBA links:

Webcast: Basics of using Word VBA every day
For the link where you can download samples used in that webcast, click here

Selected VBA posts on this blog:
Favorite everyday macros: using the Immediate Window
VBA does have some limits: understanding constants
Empower your macros with loops

MSDN links:
The MSDN library - where you can look up help on most any VBA question you have
Download the Word VBA language reference ... at the bottom of the page you'll get with this link, you will also find links to other Office program VBA language references

************************************************************

If the additional resources above didn't answer your question or you would like help or information on another topics, please post a comment and I'll be happy to help if I can. Meanwhile, hope to see you all on Thursday for some fighter-pilot-cool advanced Excel charting tips (I love this stuff! :) Here's the link to register for that one:

Advanced Tips and Tricks for Excel Charting
Thursday, January 26th at 9am Pacific, 12p Eastern. 90 minute session.


Happy Tuesday everyone!

Posted by Stephanie

Trackback Pings

TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt/mt-tb.cgi/194

Thanks for signing in, . Now you can comment. (sign out)

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)


Remember me?


Comments

Hi! I attended your Webcast today (1/26). I have a question that I was hoping you might be able to answer. I love doing charts in excel. When I am working on a presentation in Power Point I usually Insert a Microsoft Excel Worksheet into the presentation. I like to do my charts that way so that I can change the data easily....my boss is always changing his mind. There is one annoying problem that I find when I inset excel worksheets/charts in power point. The problem is that I go in and change data in a chart/worksheet and then when I come out of it the chart/worksheet changes size...and it screws up my presentation and I have to go and re-do certain parts. I thought that maybe your auto-size for font would work but, in my excel worksheets, I don't have that option with the font. Can you help?

Thanks!
Rachel

Posted by: Rachel | January 26, 2006 01:54 PM

Hi, Rachel,

Thanks for checking out the webcast today ...

I need a bit more info to be able to help you -

1 - I believe from your question that you're inserting charts or worksheets as embedded Excel objects, is that right?

2 - What version of Office are you using?

Once I have that info, I can definitely give you a couple of options for resolving this issue -

Best,
Stephanie

Posted by: Stephanie | January 26, 2006 02:17 PM

Stephanie -

Here are the answers to your qquestions:

#1 Yes, I am embedding the excel worksheet into powerpoint.

#2 We are using 2002

Thank you for your help!

Rachel

Posted by: Rachel | January 26, 2006 05:03 PM

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)