craig brody c. brody associates excel tips for accounting

9
CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Upload: dominick-thornton

Post on 23-Dec-2015

215 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

CRAIG BRODYC. BRODY ASSOCIATES

Excel Tipsfor Accounting

Page 2: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

Agenda

Data and Formula TipsMultiple Spread Sheet TipsMiscellaneous TipsQ & A

Page 3: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

SECTION 1

Data and Formula Tips

Page 4: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

Excel Data and Formula Tips

AutoFill

Auto Sum

Quick Copies

Quick Formula Completion

Page 5: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

SECTION 2

Multiple Sheets

Page 6: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

Excel Multiple Sheet Tips

Navigate between Sheets

Inserting, Moving, Copying, Deleting, Other

Linking Sheets

Grouping Sheets

Page 7: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

SECTION 3

Miscellaneous Tips

Page 8: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

Miscellaneous Tips

Display Formulas

Charts

Sort, Filter

Pivot Tables

Page 9: CRAIG BRODY C. BRODY ASSOCIATES Excel Tips for Accounting

Prepared by Craig Brody: [email protected]

SECTION 4

Q & A