Applying a Function Using Excel

Posted on by Jeff Feiertag

To Apply a Function Using Excel:

  • Choose the cell where you want to use the function.
  • Choose the Formulas tab on the Ribbon.
  • Choose the Insert Function option on the Ribbon under the Formulas tab.  An = sign will appear in the cell to let you know that a formula will follow.  A Insert Function dialog box will also appear.
  • Type the description of the function you want to use and choose Go to see a list of possible functions.
  • Choose the Function you want to use in your Excel document and choose OK.  A Function Argument dialog box will appear on your screen.
  • Choose the cells for each argument.  When you finish building the arguments, choose OK.

 

Creating a Formula in Excel

Posted on by Jeff Feiertag

To Create a Formula to Perform a Calculation in Excel:

  • Choose the cell where you would like to apply the formula.
  • Type = into the cell.  You will be able to see the formula that you are inputting in its entirety in the Formula Bar, as well as in the cell.
  • Choose the cell that you would like to include as the first cell in your formula.  Excel will automatically place the cell into the formula.
  • Choose an Operator to be used in the formula (+, etc.).
  • Choose the next cell that is to be used in your formula.  Repeat the above step and this step for each cell and operator that needs to be added to your formula.
  • Hit Enter on the keyboard or the Check Mark on the Formula Bar to accept your formula.

Freezing Column and Row Titles on the Screen

Posted on by Jeff Feiertag

To Freeze a Column and Row Title on the Screen when Using Excel:

  • Choose the cell to the right of the column and below the row you want to be visible on the screen at all times in order to freeze both a column and a row.
  • Choose the View tab on the Ribbon.
  • Choose the Freeze Panes option on the Ribbon under the View tab.
  • Choose Freeze Panes to freeze both the column and the row.  If you would like to freeze just the row of column headings, choose Freeze Top Row, or if you would like to freeze the column of row titles,  choose Freeze First Column.    Freezing Column and Row Titles does not affect the printing of the document.

Sending an Attachment Using Outlook

Posted on by Jeff Feiertag

To Send an Attachment Using Outlook in Your Email:

  • Compose a new email message including recipient’s email address, subject of the email, and the email message.
  • Choose the Message tab on the Ribbon.
  • Choose Attach File on the Ribbon under the Message tab.  An Insert File dialog box will be displayed.  Choose the file you would like to attach to your email message from the Insert File dialog box.  The file attachment and file size will be displayed below the subject box of the email.
  • Choose send to send the email with the attachment to the recipient.

Creating New Tasks Using Outlook

Posted on by Jeff Feiertag

To Create a New Task Using Outlook:

  • Choose Tasks in the Navigation Bar on the bottom of your screen.
  • Choose the New Task option.  A window will display for you to input the New Task information.
  • Input the information for the task including the subject, date, priority, etc. If the task occurs on a regular basis, choose the Recurrence option on the Ribbon.  A Task Recurrence dialog will be displayed.  Choose the Recurrence Pattern and click OK.
  • Choose the Save & Close option on the Ribbon to save the task.

Creating a New Contact

Posted on by Jeff Feiertag

To Create a New Contact in Outlook:

  • Choose People in the Navigation Bar on the bottom of your screen.
  • Choose the New Contact option.  A window will display for you to input the New Contact information.
  • Type in the contact information including name, email address, phone numbers, etc.
  • Choose the Save & Close option on the Ribbon to save the contact information.

Using Outlook Calendar to Schedule an Appointment

Posted on by Jeff Feiertag

To Schedule an Appointment Using the Outlook Calendar:

  • Choose Calendar on the Navigation Bar on the bottom of the screen .
  • Choose the date for your appointment.
  • Choose the New Appointment option on the Ribbon to display an Appointment Window.
  • Fill in details in the Appointment Window including name, start time, end time, reminder setting, notes, etc.
  • Choose the Recurrence button on the Ribbon if your appointment will occur regularly
  • Choose the Save & Close on the Ribbon.

Outlook will show the appointment on the calendar.  If you would like to view the details of the appointment, use the mouse to double click on the appointment.

Reorganizing Slides in a PowerPoint Presentation

Posted on by Jeff Feiertag

To Reorganize Slides in Slide Sorter View:

  • View slides in the Slide Sorter View.
  • Choose the slide you would like to move and drag it to the new location in your PowerPoint presentation using your mouse.
    • You may choose to move more than one slide at a time.  To move more than one slide at a time, press the Control key and use the mouse to click on each slide.  Use the mouse to drag the slides to the new location in your PowerPoint presentation.

To Reorganize Slides in Normal View:

  • View slides in Normal View.
  • Choose the slide you would like to move and drag it to the new location in your PowerPoint presentation using your mouse.
    • You may choose to move more than one slide at a time.  To move more than one slide at a time, press the Control key and use the mouse to click on each slide.  Use the mouse to drag the slides to the new location in your PowerPoint presentation.