Place of work 2010 Class # 23: Excel Features & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF
Excel 2010 Principles Collection reveals a systematic description of what Excel can do from beginning to finish. Down load files at: folks.highline.edu initial 2: Matters coated in the video clip. Functions: three SUM (create) 4 COUNT (Count Figures) 5 COUNTA (amount of non-empty cells) six MIN (minimal value) 7 MAX (optimum appeal) 8 COUNTIF (count with a issue or criteria) nine SUMIF (sum with a situation or requirements) 10 STDEVP (normal deviation of the population) eleven Compatibility features 12th Like a number of cells with defined names function 13 names. Insert Operate = Shift + F3 keyboard 14th Keyboard = F3 Paste Identify 15th Identify Manager Keyboard = Ctrl + F3 16th Generate Names From Variety Keyboard = Ctrl + Shift + F3 seventeenth Use 18th Defined names in formulas Understand a lot more about Identify Supervisor

