NYIM PowerPoint Group Class Training $50 Off for 9/21/16 and 9/22/16 Only!

PowerPoint

 

 

 

 

We offer the most practical PowerPoint class training in New York City. Our classes focus on the most useful functions in today’s business world. Learn how to manipulate master slides, insert animation and sounds, flash content and more!

To purchase before classes are full, visit our website at www.training-nyc.com or call 212.658.1918

NYIM – MS Outlook Tip of the Day – How to Create AutoCorrect Entries to Use as Email Templates

Outlook 2013 Training in NYC

Outlook’s AutoCorrect function is best known for automatically fixing typos and spelling, and expanding acronyms into plain text.

But did you know you can have Outlook insert whole blocks of text into your email by typing a few keys?

So easy and so efficient for those standard, repetitive email replies!

Here we go:

  1.  On the “Home” tab, go to “New Email”
  2.  Type in or copy/paste the text you want to insert automatically
  3.  Highlight the text
  4.  In THAT email window, Go to the “File” tab, select “Options”
  5.  At “Options”, select “Mail”, then click “Spelling and AutoCorrect” button
  6.  You should land on the “Proofing” tab at next screen, select “AutoCorrect Options”
  7.  You’ll see all existing AutoCorrect entries in grid at bottom of screen
  8.  At “Replace” field type a short word/phrase as the code for the text you want
  9.  At “With” field, select “Plain” or “Formatted” text (use formatted if there is bolding,  underlines, etc. in your text)
  10.  Click “Ok” button 3 times
  11.  Type the code word you created in a new email and – voila! there is your frequently-used text!

Don’t know how to use Outlook?  No worries!  Visit our website at www.training-nyc.com for a list of all our upcoming Outlook Essentials classes.  Call 212-658-1918, mention you saw this tip on Facebook, LinkedIn or Twitter account and receive a 20% discount on your Outlook Essentials training!

 

NYIM Corporate Group Class Discount!

Attention all HR and Corporate Training professionals:

Right now, purchase 5 or more Group Classes at a 20% discount – that’s like getting one class free!

Visit our site at www.training-nyc.com to view details on our MS Excel, Word, PowerPoint, Adobe, QuickBooks classes and more!

The fiscal year-end approaches, so rely on us to get the most value for your training dollars!

NYIM – Deal of the Day – August 23!

Our PowerPoint for Business Class on August 25, 2016 is on sale for $149! (reduced from $199)

We offer the most practical PowerPoint group classes and private training in NYC.

The PowerPoint class concentrates on the most common topics that we see NYC businesses using on a daily basis.

Visit us at www.training-nyc.com or call 212-658-1918 to enroll while the price is hot!

NYIM – Deal of the Day!

Our Keynote Group Class on August 23, 2016 is on sale for $149!  (reduced from $199)

We offer the most practical Keynote group classes and private training in NYC.

Learn how to create beautiful and engaging presentations with Apple’s Keynote software. Understand how to collaborate with PowerPoint users while maintaining the ease of use.

Visit us at www.training-nyc.com or call 212-658-1918 to enroll while the price is hot!

Outlook Validation for Forms and Zip codes [SOLVED]

Outlook Validation for Forms

We had a client where they had a very specific validation that needed to be applied to their contacts. The Zipcode field needed to start with a country Letter. Here is the validation necessary.

Watch the video

([Business Address Country/Region] =”Austria” AND Left( [Business Address Postal Code] , 2 ) = “A-“) or ([Business Address Country/Region] =”Germany” AND Left( [Business Address Postal Code] , 2 ) = “D-“)  or ([Business Address Country/Region] =”Switzerland” AND Left( [Business Address Postal Code] , 3 ) = “CH-“)  or ([Business Address Country/Region] =”Italy” AND Left( [Business Address Postal Code] , 2 ) = “I-“) or ([Business Address Country/Region] =”Ireleland” AND Left( [Business Address Postal Code] , 3 ) = “IE-“)  or ([Business Address Country/Region] =”Iceland” AND Left( [Business Address Postal Code] , 3 ) = “IS-“)  or ([Business Address Country/Region] =”Netherlands” AND Left( [Business Address Postal Code] , 3 ) = “NL-“)  or ([Business Address Country/Region] =”France” AND Left( [Business Address Postal Code] , 2 ) = “F-“) or ([Business Address Country/Region] =”Spain” AND Left( [Business Address Postal Code] , 2 ) = “E-“) or ([Business Address Country/Region] =”Finland” AND Left( [Business Address Postal Code] , 3 ) = “FI-“) or ([Business Address Country/Region] =”Norway” AND Left( [Business Address Postal Code] , 2 ) = “N-“) or ([Business Address Country/Region] =”Denmark” AND Left( [Business Address Postal Code] , 3 ) = “DK-“) or ([Business Address Country/Region] =”Belgium” AND Left( [Business Address Postal Code] , 2 ) = “B-“) or ([Business Address Country/Region] =”Luxemburg” AND Left( [Business Address Postal Code] , 2 ) = “L-“) or ([Business Address Country/Region] =”Poland” AND Left( [Business Address Postal Code] , 2 ) = “PL-“) or ([Business Address Country/Region] =”Portugal” AND Left( [Business Address Postal Code] , 2 ) = “P-“)

 

Outlook Validation for Forms

How to Set default formatting Outlook 2010 contacts

How to Set default formatting Outlook 2010 contacts

Change the default Country/Region for addresses

Outlook gets the default country for contact addresses from the Region applet in Windows 8. In Windows 7 this is called Region and Language Options, and in Windows XP, it’s Regional and Language.

Check Address dialog

Open the Control Panel, find Region. If you use the Category view, it’s under Clock, Language, and Region, or use the Search field.

Select the desired country from the dropdown on the Format tab. In most cases, the change will take effect immediately, however, you will need to close and re-open contacts that are open.

Change the format on the Region dialog

Choose the correct Country or Region for your location in the Format dialog. Don’t choose the Country based on the date and number formats you prefer, those can be changed by clicking Additional Settings. See How to change the Calendar date format in Microsoft Outlook for instructions.

Change the Country/Region for phone numbers

The contact’s phone number field uses the Phone and Modem Location. In most cases, you will use the same country in Region options and as the Location in Phone and Modem Options, but if you want to use a different default Country for phone numbers, you’ll make the change in the Phone and Modem options dialog.

Check Phone Number

To change the phone location, open the Control Panel and find Phone and Modem. If you use the Category view, use Search to find it. Double-click to open Phone and Modem applet.
Dialing location dialog

If you are changing the current location, double-click on it or select and click Edit. Select the desired Country or Region from list on the General tab. If you need multiple locations (most people need just one location), Outlook uses the location that is currently selected as the default when adding phone numbers.

Edit location dialog box

How to Set default formatting Outlook 2010 contacts

Two ways to Turn off Excel’s “Protected View” Excel 2010-2013

Two ways to Turn off Excel’s “Protected View” Excel 2010-2013

Way #1 (Easier, but can be overriden by System Admin)

File > Options > Trust Center > Trust Center Settings > Protected View
Uncheck all three Enabled Protected View

Turn off Protect View

Turn off Protect View

 

 

 

 

 

 

 

 

Way #2

Try this: go to regedit and add this key: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation with “EnableOnLoad”=dword:00000000

How to Create a Basic Keynote Presentation

How to Create a Basic Keynote Presentation

Create a New Presentation

Before we begin, you must first choose a topic for your presentation. Once you have decided on a topic and gathered the necessary information relating to that topic, you are ready to create your presentation.

Step 1: Launch Keynote

Launch Keynote.

Click Keynote.

Click the Keynote icon in the Dock.

Step 2: Select a Theme

Select a theme.

Select a theme.

Select a theme and then click Choose. For the purpose of this tutorial, I have chosen White.

Step 3: Design

Create your presentation.

Create your presentation.

You are now ready to create your presentation.

Edit Slide

Start by editing the opening slide. As you can see, every Keynote theme includes a title and subtitle already pre-inserted into each slide, ready to be edited.

Double-click to edit.

Double-click to edit.

Double-click the text to edit.

Enter a title and subtitle.

Enter a title and subtitle.

Enter a title and subtitle.

Highlight to format.

Highlight to format.

Highlight the text to format.

Edit the font, size, colour and alignment.

Edit the style of the text.

Edit the style of the text via the Format sidebar located on the right-hand side of the application.

Modify your presentation further.

Modify your presentation further.

Click Setup to modify your presentation further. From here, you can change the theme of your presentation, as well as the size of each slide and other related settings.

Add a Transition Effect

Now, it is time to add a transition effect so that each slide merges seamlessly into the next. Here’s how.

Step 1: Select a Transition

Click Animate.

Click Animate.

Click Animate.

Select a transition effect from the menu.

Select a transition effect from the menu.

Click Add an Effect and then select a transition effect from the menu.

Step 2: Edit Transition Effect

Edit the duration and delay of each transition.

Edit the duration and delay of each transition.

Edit the DurationStart Transition and Delay of your chosen transition, or click Change to select another.

Caption.

Example transition.

Create a New Slide

Next, I will show you how to create a new slide. You can create as many slides as you wish, although it is worth bearing in mind that your audience may lose interest if your presentation is particularly lengthy.

Click the + icon.

Click the + icon.

Click the + icon and then select a template.

View slides via the Slides sidebar.

View slides via the Slides sidebar.

Every slide included in your presentation can be viewed via theSlides sidebar.

Modify the appearance of each slide via the Format sidebar.

Modify the appearance of each slide via the Format sidebar.

You can modify the appearance of each slide via the Formatsidebar. Click Background to change the background colour, or tick the corresponding checkbox to add a title, body of text, and slide number.

Insert Image

Images can help illustrate certain information and are used to break up large walls of text. When inserting an image into your presentation, Keynote will automatically display your entire iPhoto library for you to browse, categorised by Event.

Step 1: Select an Image

Select an image of your choice.

Select an image of your choice.

Click MediaPhotos and then select an image of your choice.

Edit the appearance of your image.

Edit the appearance of your image.

Edit the appearance of your image via the Format sidebar.

Step 2: Add a Caption

Add a caption.

Add a caption.

Add a caption to accompany your image by clicking Text and then choosing a text style from the menu.

Double-click to highlight.

Double-click to highlight.

Enter your caption and then double-click to highlight.

Edit the appearance of the caption.

Edit the appearance of the caption.

Edit the text style of your caption via the Format sidebar.

Example slide.

Example slide.

Insert Effect

Effects are an excellent way of keeping your audience engaged, and will draw their attention to important information within your presentation.

Step 1: Add an Element

Add a new element.

Add a new element.

Add a new element or highlight a pre-existing one to animate.

Step 2: Select an Effect

Click Add an Effect.

Click Add an Effect.

Click Animate and then Add an Effect.

Select an effect.

Select an effect.

Select an effect from the drop-down menu.

Example effect.

Example effect.

Your selected effect will then be inserted into your presentation.

Add Audio

With Keynote, you can add audio to a single slide or your entire presentation, as well as record your own narration to introduce each slide.

Add Audio to a Single Slide

Click Media.

Click Media.

Click MediaMusic and then select a song from your iTunes library.

Highlight the Speaker button.

Highlight the Speaker button.

Once your chosen song has been inserted, highlight the Speakerbutton.

Edit inserted audio.

Edit inserted audio.

Edit inserted audio via the Format sidebar.

Add Audio to Entire Presentation

Click Setup.

Click Setup.

Click Setup to display the Setup sidebar.

Click Audio.

Click Audio.

Click Audio.

Drag and drop your selected song(s).

Drag and drop your selected song(s).

Drag and drop your selected song(s) into the Soundtrack box.

Adjust the soundtrack settings.

Adjust the soundtrack settings.

Adjust the soundtrack settings.

Record Narration

Click Setup.

Click Setup.

Click Setup.

Click Audio and then Record.

Click Audio and then Record.

Click Audio and then Record to record your own narration.

Hit the Record button.

Hit the Record button.

Hit the Record button to begin recording.

Press the Record button once again.

Press the Record button once again.

Press the Record button once again to stop recording.

Your recorded narration will then be inserted into your presentation.

Your recorded narration will then be inserted into your presentation.

Your recorded narration will then be inserted into your presentation.

Insert Video

Inserting a video into your presentation from your iMovie library will enhance your presentation further, and the video itself can be optimised for iOS to ensure smooth playback.

Select a video.

Select a video.

Click MediaMovies and then select a video.

Optimise for iOS.

Optimise for iOS.

Click Never OptimiseNot Now or Optimise to optimise for iOS.

Your video will then be inserted into your presentation.

Your video will then be inserted into your presentation.

Your selected video will then be inserted into your presentation.

Edit the appearance of your video.

Edit the appearance of your video.

Edit the appearance of your video via the Style tab located on theFormat sidebar.

Click the Movie tab.

Click the Movie tab.

Click the Movie tab to tweak your video further.

Add Presenter Notes

Presenter Notes are notes that appear in your presentation for you to read, but cannot be seen by the audience.

Click Show Presenter Notes.

Click Show Presenter Notes.

Click View and then Show Presenter Notes.

Enter a note.

Enter a note.

Enter a note to yourself.

Rehearse Slideshow

Before playing your presentation to a live audience, Keynote includes a feature to rehearse your lines ahead of time.

Click Rehearse Slideshow.

Click Rehearse Slideshow.

Click Play and then Rehearse Slideshow.

Navigate between each slide.

Navigate between each slide.

Navigate between each slide by clicking the cursor or pressing <and > on your keyboard.

Play Slideshow

Once you have finished rehearsing your presentation, you are ready to play it to your audience. Good luck!

Caption.

Click Play.

Click Play.

Your presentation will then play.

Your presentation will then play.

Export Slideshow

You can share your presentation with others by exporting it to a different format so that it can be viewed on multiple platforms.

Click File, Export To and then select an option.

Click FileExport To and then select an option.

Click FileExport To and then select an option from the menu. For the purpose of this tutorial, I am going to export my spreadsheet to PDF, although you can also export toPowerPointQuickTimeHTMLImages and Keynote ’09.

Modify the appearance and functionality of the final article.

Modify the appearance and functionality of the final article.

Click a checkbox to modify the appearance and functionality of the final article (optional), select the image quality and then click Next.

Click Export.

Click Export.

Choose a location to save your document and then click Export. Your presentation will then be exported to the format of your choice.

How to Create a Basic Keynote Presentation

Source: http://computers.tutsplus.com/tutorials/how-to-create-a-basic-keynote-presentation–mac-57364

 

Create and Schedule a New Project

Create and Schedule a New Project

Project

  1. Click the File tab, and then click New.
  2. Make sure that Blank Project is selected, and then click Create on the right pane.
  3. On the Project tab, in the Properties group, click Project Information.

  1. Schedule the project in the Project Information dialog box:
    • To schedule from the start date, click Project Start Date in the Schedule from box, and then select the start date in the Start date box.
    • To schedule from the finish date, click Project Finish Date in the Schedule from box, and then select the finish date in the Finish date box.

 TIP   Schedule from the finish date if you need to find out how late you can start a project. However, we recommend that you change this setting to schedule from the start date when work begins on the project.

  1. If you are using Project Professional 2010, you can include enterprise custom fields in the project. In the Enterprise Custom Fields section, click the Value field for a custom field, and then select the value.

 NOTE   You must enter values for required enterprise custom fields, marked by an asterisk (*), or you won’t be able to save the project.

If your plans change, you can change this initial project information at any time in the Project Information dialog box. However, if you have applied actual data, such as actual start or finish dates, to tasks, the tasks will not be rescheduled based on the updated project information. In addition, if you have put constraints on tasks, moving the project’s start or finish date won’t necessarily move all tasks relative to the new date.

A few notes for Project Professional 2010 users:

  • If you want to save the project as an enterprise project, you should connect to Project Server before creating the project.
  • If you create and save the project locally and then decide to save it to Project Server later, the project will be updated with settings from the enterprise global template. Your project may be updated with different views, tables, fields, and other items. In addition, any formatting that is inconsistent with the enterprise global template will be lost.

Create and Schedule a New Project

Source:

http://office.microsoft.com/en-us/project-help/create-and-schedule-a-new-project-HA010352371.aspx?CTT=5&origin=HA010352442#BMcreate