2013

Enabling Visio to Open FRS Stencils (Shapes)

Posted on by Jeff Feiertag

Visio 2013, be default, will block the FRS Stencils/Shapes (which include gas, electric, connections, north arrow and more) since they were created in much older versions of the program. Follow these steps to tell Visio they are acceptable files to open. (Note: This must be done within the profile of anyone who logs in to use Visio for mapping, not just once per computer.)

  • Run Visio.
  • Click Blank Drawing and click the Create button.
  • Access the File tab and click Options at the bottom of the left-hand navigation.
  • Click Trust Center at the bottom of the left-hand navigation on the pop-up window.
  • Click the Trust Center Settings button on the right side of the pop-up window.
  • Click File Block Settings on the left side navigation.
  • Uncheck the boxes for all three rows. (A checked box means Visio should block it, not unblock it.)
  • Click the two OK buttons.

Marking a Message as Not Clutter

Posted on by Jeff Feiertag

If you would like to keep a message from being marked as clutter in Outlook, either right click on the message and choose Mark as not clutter or just drag it to the Inbox. If Office 365 is missing messages you want marked as clutter, right click and choose Mark as clutter or drag it to the Clutter folder.

If you are using Outlook 2007, 2010 or 2013 (Desktop), simply drag a message to the Clutter folder to mark it as clutter or drag it to the Inbox to mark it not clutter.

By dragging messages to the Clutter folder you will train the tool to spot similar e-mail in the future. The tool gets smarter over time, learning from your prior actions with similar messages.

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.