Transcription of Advanced Excel Part 2 - Core-CT
{{id}} {{{paragraph}}}
Example: bankruptcy
Advanced Excel Part 2 - Core-CT
1 | P a g e Advanced Excel part 2 Instructor Notes September 16, 2016 1) INDEX and MATCH .. 1 2) Dynamic Tables - Introduction .. 3 3) SUMIFS using a Table .. 5 4) Running Totals (Run_Tot) .. 6 5) Dashboard / 7 6) INDEX/MATCH: Dynamic Table .. 10 7) SUMIF .. 11 8) Array Formula .. 12 9) Using INDEX/MATCH as an Array .. 13 10) SUMPRODUCT .. 14 11) HLOOKUP .. 15 12) Miscellaneous .. 16 13) FRP312 Formula .. 16 1) INDEX and MATCH a. INDEX takes a defined block of data (usually a table) and returns a value to a cell based on coordinates 1. Syntax: =INDEX(Range,RowNumber,[ColumnNumber]) (1) [ ] indicates optional. 2. For example, if you have a 10 x 10 range and the function was =INDEX(range,1,1) then INDEX would return the top left cell contents. =INDEX(range,10,10) would return the bottom right cell contents. 3. When setting up a range, do not include row or column headers.
Advanced Excel Part 2 Instructor Notes ... Excel does not consider upper or lower case lettering (c) Excel does not look at formatting 4) Running Totals (Run_Tot) a. SUMIFS can also be used with dynamic tables in a more traditional sense: using the standard argument structure.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: