L04 Advanced Excel

L04 Advanced Excel - Horizontal analysis Percent change...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to Advanced  Excel Fall 2010 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The objective of this discussion is to teach you some Excel functions that are  useful in your XBRL project: Computing ratios Formula that references another  sheet Average function Control Totals Sum function Vertical analysis F4 key and copy command
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Horizontal analysis Percent change Quick copy Conditional formatting Company name Quick sort Custom Cell Formats Move/copy sheet Range names Vlookup function Other Control key Global deletions using find text and replace 2...
View Full Document

This note was uploaded on 06/14/2011 for the course ACCT 404 taught by Professor Tuttle during the Spring '11 term at South Carolina.

Page1 / 2

L04 Advanced Excel - Horizontal analysis Percent change...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online