Office

Creating a Chart Using Excel: Using the Quick Analysis Button

Posted on by Jeff Feiertag

To Create a Chart in Excel Using the Quick Analysis Button:

  • Choose the data on the Excel worksheet that you want to include in your chart.
  • Choose the Quick Analysis icon.  A dialog box will appear on your screen.
  • Choose Charts option.
  • Preview the different types of charts by moving your  mouse over the various examples.  If you want to see more examples of charts, choose More Charts option.
  • Choose your chart layout from the options and click on it.  The chart will be inserted into your Excel worksheet.

Creating a Chart Using Excel: Using the Ribbon

Posted on by Jeff Feiertag

To Create a Chart in Excel Using the Ribbon:

  • Choose the data on the Excel worksheet that you want to include in your chart.
  • Choose the Insert tab on the Ribbon.
  • Choose Recommended Charts on the Ribbon under the Insert tab.  An Insert Chart dialog box will display on your screen.
  • Choose a chart from the Recommended Charts or choose All Charts to see the entire library of charts.
  • Choose OK.  A chart will be created and placed in your Excel worksheet.  A Chart Tool tab will also appear on your Ribbon.
    • The Chart Tool tab will allow you to add options to your chart including titles, apply filters, or change the look of your chart.

Using AutoSum to Total Cells Using Excel

Posted on by Jeff Feiertag

To Use AutoSum to Total Cells:

  • Choose the cell where you would like to display the total.
  • Choose the Formulas tab on the Ribbon.
  • Choose the AutoSum option on the Ribbon under the Formulas tab.  AutoSum will determine the formula to total the appropriate cells.
  • Hit the Enter key on your keyboard or click on the Checkmark to use AutoSum to calculate the totals.  The total will display in the cell you choose in the first step.

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.