www.accountingadvisors.com About the speaker: David is owner of - - PowerPoint PPT Presentation

▶

Oct 29, 2023 356 likes •594 views

Slide ID: 445 Written and Presented by David H. Ringstrom, CPA Accounting Advisors, Inc. www.accountingadvisors.com About the speaker: David is owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started

SLIDE 1

Written and Presented by David H. Ringstrom, CPA Accounting Advisors, Inc. www.accountingadvisors.com

About the speaker: David is owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Microsoft Excel, and written dozens of freelance articles about spreadsheets. He offers Excel and Access training and consulting services nationwide.

Last Revised: 07/30/14

Slide ID: 445

SLIDE 2

Excel Versions

Slide ID: 368 2 of 22

SLIDE 3

Getting Oriented in Excel

Slide ID: 2639 3 of 22

SLIDE 4

Saving Excel Files

Slide ID: 2640 4 of 22

SLIDE 5

Managing Column Widths

Slide ID: 2643 5 of 22

SLIDE 6

Formatting Percentages

Slide ID: 2644 6 of 22

SLIDE 7

Formatting Numbers

Slide ID: 2645 7 of 22

SLIDE 8

Calculating Our Loan Payment

Slide ID: 2650 8 of 22

SLIDE 9

Formatting Worksheet Cells

Slide ID: 2646 9 of 22

SLIDE 10

Center Text Shortcut

Slide ID: 2647 10 of 22

SLIDE 11

Copying Formulas

Slide ID: 2648 11 of 22

SLIDE 12

Excel's Order of Operations

Slide ID: 2651 12 of 22

SLIDE 13

Absolute References

Slide ID: 2652 13 of 22

SLIDE 14

Numbers Presented as # Signs

Slide ID: 2653 14 of 22

SLIDE 15

Summing Numbers

Slide ID: 2657 15 of 22

SLIDE 16

Managing Worksheets

Slide ID: 2661 16 of 22

SLIDE 17

Keeping Certain Rows On Screen

Slide ID: 2658 17 of 22

SLIDE 18

Managing Print Settings

Slide ID: 2659 18 of 22

SLIDE 19

Applying Borders and Color

Slide ID: 2660 19 of 22

SLIDE 20

Filtering Data

Slide ID: 2527 20 of 22

SLIDE 21

Quick Analysis

Slide ID: 2291 21 of 22

SLIDE 22

Questions? Spreadsheet Consulting help?

 I’m happy to hear from you (e-mail is best):

David Ringstrom Accounting Advisors, Inc. 614 Park Avenue SE Atlanta, Georgia 30312 404-784-0275 david@acctadv.com

 Get notified when I write new articles about Excel, et. al.:

Slide ID: 485

www.twitter.com/excelwriter www.facebook.com/accountingadvisors

www. linkedin.com/in/davidringstrom