Microsoft Excel

Blog categorized as Microsoft Excel

DeLisa's Favorite Excel Resources

02-05-20 11:14 PM By DeLisa Lee - Comment(s)
DeLisa's Favorite Excel Resources

Ever wonder where Excel experts go for help or which Excel sites they bookmark? In this post, DeLisa shares her favorite Excel websites, user forums, add-ins, and more! Feel free to share your favorites in the comments.

Excel 2013 Flash Fill

04-11-15 07:51 PM By DeLisa Lee - Comment(s)
Excel 2013 Flash Fill

Check out this great new time-saving feature in Excel 2013. Flash Fill will follow a pattern to insert, extract, format and concatenate data for you. It works with text, numbers, dates and much more! No formulas required!

Convert your Excel formulas to values

04-11-15 07:51 PM By DeLisa Lee - Comment(s)

Did you know you can replaces a formula with the value of the formula?

  1. Select a cell(s) containing a formula
  2. Copy
  3. Select your destination cell(s)
  4. Paste > Paste Special > Values
  5. Click OK

DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | www.djltraining.com | firstclass.djltraining.com

(c) Copyright 2010-2019 | All Rights Reserved