Did you know that there's an
enhanced version of the Google
Document editor?
While on the main Google Documents
screen, click on Documents settings
on the top
right-hand part of the screen.
Then click Editing on the mid-left
part of
the screen. Select Create new
text documents using the latest
version of
the document editor. Now any
new word processing documents you
create will
be in the new version of the document
editor with an enhanced look and
more
features.
In order for the job to run
properly, you must bubble in key
options on the control sheet.
For test scoring jobs you must bubble
in "Control and Key" + the last
number used on the control
sheet. The last number used
reflects the number of test questions
on the instructor control sheet.
You can add your favorite macros
to your quick access toolbar so it's
available for all of your Excel
workbooks.
If you recorded your macro and stored it in your Personal Macro Workbook, then it can be selected to customize your quick access toolbar. Choose commands from: Macros and select the PERSONAL.XLSB! macro you recorded. Remember you can also change the icon once added to your quick access toolbar, by selecting it and click on Modify.
For more information go to: http://support.microsoft.com/kb/141576
Or attend our
Creating Macros class.
Did you know that you can set the
number or order of site tabs in
Sakai?
You can set the order and the number of site tabs in Sakai@UD. Go to "My Workspace > Preferences" and use the "Customize Tabs" option. This is particularly useful when you wish to site from previous semesters and prioritize some sites that require more attention. See http://www.udel.edu/sakai/help/content/current/sakai_iframe_myworkspace/... for details.
By preparing your PDF form with fillable fields, your clients will be able to fill out your form at their computer.
You can create a pdf form with fillable fields. You can add text fields, drop down lists, checkboxes or radio buttons. It's also possible to distribute, track, filter and analyse the data.
To view a video on the topic go to: http://tv.adobe.com/watch/learn-acrobat-9/getting-started-04-simplifying...
For detailed written instructions go
to:
http://www.adobe.com/designcenter/acrobat/articles/acr7formdesign.html
Did you know that you can use your
web browser to help troubleshoot web
site issues?
Have you ever wondered what your site would like like with a different font, a different color background, or even with entirely different text? You can do this from most standard browsers.
Most people already know about the Firefox Firebug add-on and may even know about Google Chrome "Inspect Element" option, but did you know that you can use the F12 key in Internet Explorer 8 to launch a Developer Tools dialog.
All three of these tools allow you to modify HTML and CSS within a locally cached copy of the web page being viewed. You can edit many elements in the page without effecting permanent changes to the website itself.
Want to learn more?
Use the =cell function to add the
filename and path to a cell in your
worksheet.
If you use =cell("filename"), then
Excel will automatically insert the
full path (where it's been saved) and
the filename in that cell. For
more Excel tips, come to our
Excel 2007: Tips and tricks
session.
Did you know that you can set the order and the number of sites tabs in Sakai@UD?
Simply go to "My Workspace > Preferences" and use the "Customize Tabs" option. This is particularly useful when you wish to prioritize some sites that require more attention. See http://www.udel.edu/sakai/help/content/current/sakai_iframe_myworkspace/arox.html for full detail.
Downloading to Excel from PS Query
is problematic with Windows 7 unless
you know this simple trick.
After getting results in PS
Query:
Click the download link.
When the hour-glass icon appears,
press the CTRL key.
Excel will open with your data.
Quickly fill cells in Excel with common data patterns (for example 1...100 or Jan...Dec).
This feature is called Auto Fill and isn't just for numeric information.
Excel can create some predefined lists for you. For example, days of the week, months of the year, 1st qtr. 2nd qtr. etc. You can even create your own custom lists. To learn how to do this use Excel's Help and search for Data Fill. Or, attend our Excel 2007: tips and tricks class.
