Skip to main content

Excel Power User Module 2: Fundamental Functions, Concepts, Techniques

Available Until

CalCPA Webcasts

Online, OK 00000

Get Directions

2.00 Credits

Member Price $69

Non-Member Price $89

Overview

Cover fundamental functions, concepts and techniques that provide a firm foundation for our workbooks. Continue to integrate these items as we proceed throughout the series. This is part 2 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

  • Better summing
  • Skinny row
  • Hide worksheets
  • Highlight input cells
  • Workbook organization
  • Worksheet organization
  • Nested functions
  • Selection groups
  • Workbook design principles

    Prerequisites

    Excel Power User Module 1 or knowledge of the topics covered.

    Designed For

    Accounting professionals who use Excel for Windows.

    Objectives

  • Determine why the SUBTOTAL function is preferred to the SUM function in many situations.
  • Identify a technique that helps ensure that a new row inserted between the last data row and the formula row is included in the total row formula.
  • Recognize at least three workbook design principles.

    Preparation

    None.

  • Non-Member Price $89

    Member Price $69