BA 2104 Lecture Notes - Lecture 1: Pie Chart, Sparkline
Document Summary
Auto fill select 2 filled cells, drag handle down. Custom lists file advanced edit custom lists highlight cells, import. Notes: comma will turn dates (1/1/2009) into a number; right-click & drag handle down will give more auto-fill options. Stay in same cell to solve ctrl+enter. Absolute addressing: auto-fill w/ a constant in formula (cell)*(cell of constant)+f4. Sum =sum(cell:cell) or autosum menu [in top right corner] Naming cells (cell) click name box [left corner] type name, enter. Entering in multiple cells highlight cells type number ctrl+enter. Naming ranges highlight cells click name box type name. Name different ranges highlight entire range formulas tab click create from selection, ok. Note: use name instead of cell ids to do calculations; use name manager to change name or edit cells. Conditional formatting home tab conditional formatting highlight cell rules select rule enter a number, ok. Conditional formatting home tab conditional formatting top/bottom rules top 10 rules change number, ok.