craig brody c. brody associates excel tips for accounting
TRANSCRIPT
CRAIG BRODYC. BRODY ASSOCIATES
Excel Tipsfor Accounting
Prepared by Craig Brody: [email protected]
Agenda
Data and Formula TipsMultiple Spread Sheet TipsMiscellaneous TipsQ & A
Prepared by Craig Brody: [email protected]
Excel Data and Formula Tips
AutoFill
Auto Sum
Quick Copies
Quick Formula Completion
Prepared by Craig Brody: [email protected]
Excel Multiple Sheet Tips
Navigate between Sheets
Inserting, Moving, Copying, Deleting, Other
Linking Sheets
Grouping Sheets
Prepared by Craig Brody: [email protected]
Miscellaneous Tips
Display Formulas
Charts
Sort, Filter
Pivot Tables