
TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)
Please be sure to mention the version of Office you are using when you send your question.
I answer all e-mails that I receive via this form, as long as they are polite :)
Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.
Thanks for attending today's webcast! ... and additional resources
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!
TrackBack URL for this entry:
http://www.arouet.net/cgi-bin/mt2/mt-tb.cgi/168
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