3305 Main Street Ste 019 Vancouver, WA 98663

Excel Techniques

Here is a list of several Excel Techniques for  your use and benefit to expedite your time with Office Connector. Full details of each and their corresponding links can be found within the topics of this guide.
  • Filtering Dates Using the TEXT Function
  • Formatting Text Values to Remove Zeros
  • Copy Formulas Using the fill Handle
  • Volatile Functions
  • Modifying Query Parameters
  • Named Ranges
  • Insert Function and the Formula Bar