Tag Archives: Excel

Excel: Primitive Bar Graph and Roman Numerals

Excel has a repeat function called REPT that will repeat a text character any number of times.  It’s format is REPT(TEXT, Value) where Value is the number of times that TEXT is repeated.  You can use “i”, “o”, “-“, or any other letters/symbols … Continue reading

Posted in Excel, software | Tagged , , | Leave a comment

Excel Tip: Convert Number to Text

Here are four basic ways to convert a number in a cell to text. Method (1) Format Cells 1) Right click cell(s) of interest and click on “Format Cells…” 2) Under the Number tab Choose Text as your Category Method (2) Text function … Continue reading

Posted in Excel, software | Tagged , , , | Leave a comment

How Do I Average In Excel?

  A very common question for Excel is, “How do I average in Excel?”  The simplest way to do this is to use the AVERAGE function.  In the example to the left, cell A5 has the following formula:  =AVERAGE(A1:A3) This returns … Continue reading

Posted in Excel, software | Tagged , , | Leave a comment