ShiningWiki ShiningWiki
  • Tech
    • Win10
    • Win8
    • Win7
    • CentOS
    • Network
    • App Guide
    • --afterfx
    • ---audition
    • ---firefox
    • ---notepad++
    • ---xampp
    • Hardware Guide
  • Photo
    • Intro to Photography
    • Photo Format
    • Photo Printing
    • More...
  • Music
    • More...
  • Graphic
    • python:maya
    • python:nuke
    • python:fusion
    • javascript:afterfx
    • javascript:photoshop
    • javascript:illustrator
    • More...
  • Dev
    • Python Guide
    • Python + Qt
    • Python for Web
    • More...
  • Recent
  • Themes
    • Bootswatch Themes
    • Darkly
    • Lumen
    • Slate
    • Superhero
    • Yeti
  • Expand/Reduce
  • Log In

  1. Trace
  2. excel

appwiki:excel

  • Show pagesource
  • Old revisions
  • Backlinks
  • Rename Page
Table of Contents
  • Excel Text Generating Format
  • Excel formulas
  • Excel shortcuts
  • Excel Data Creation
    • excel to xml

Excel Text Generating Format

  • text cell combine:
    ="preText"&A1&B1&C1&"endText"

Excel formulas

  • Date minus Date gets days (A1 as fixed date; A2 as date to compare)
    =DATEDIF(A2,$A$1,"d")
  • today's date
    =TODAY()

Excel shortcuts

Data insert

ctrl+; insert date
ctrl+shift+; insert time

Excel Data Creation

excel to xml

  • appwiki/excel.txt
  • Last modified: 2016/10/20 01:17
  • (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International