Top Excel Tips and Tricks Webinar

Nov 14
10:00 - 12:00 p.m.

Online

2-Other
CPE Credits

Upon completing this course, you should be able to:

  • Describe how to use global rounding to eliminate rounding errors in Excel and eliminate positive and negative zeroes in worksheet reports
  • Explain the impact of the accounting format on underlines and cell alignment
  • Use the Camera to create dynamic reports from worksheet snippets and to paste Excel data into Word documents
  • Describe Data Validation and how to use it to automate data entry and reduce errors
  • Employ sum-through formulas more effectively using the SUM function rather than using an arithmetic formula

Highlights

  • Improving worksheet accuracy with global rounding
  • Using AutoCorrect and Data Validation effectively
  • Producing reports in less time and with less effort
  • Pasting Excel ranges into Word without losing formatting
  • Identifying cells and ranges with formulas or other specific characteristics
  • Registration

    PICPA Member: $79
    Nonmember: $104

    More Information

    Course No. WK2-TET174 Level: Intermediate

    Prerequisites: Good working knowledge of Excel

    Notes
    Your log-in instructions will be sent by K2 Enterprises at least 24 hours before the webinar.

    Speaker(s)

    Lawrence McClelland