WITH allows writing auxiliary statements for use in larger queries. Auxiliary statements can be SELECT, INSERT, UPDATE, DELETE, or MERGE. WITH clauses can be attached to primary queries
PivotTables analyze data by comparing, summarizing, and visualizing patterns. Data should be organized in columns with a single header row. PivotTables can be created from existing tables or external data sources
Create separate sheets for each table to be merged. Select columns to combine in dialog box. Review merged table for correct data combination
Excel sorts dates by first number only. Excel shows dates as "date" in menu bar. Some dates convert to hashes when pasted
Insert new row above data by clicking row number. Double-click new cell to enter column title. Press Tab to skip to next title cell. Column headers remain unchanged (A-Z letters)
Excel can be accessed through Start menu or Finder. New workbooks can be created from templates or blank sheets. Data can be entered, copied, pasted, and deleted using keyboard shortcuts. Formulas can reference cells and other worksheets