Self Study: Excel Power User Module 2: Fundamental Functions, Concepts, Techniques
Available Until
Self-Study
2.0 Credits
Member Price $59.00
Non-Member Price $75.00
Overview
This course is available until April 30, 2025.
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
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.
Notice
Online Self-Study
Non-Member Price $75.00
Member Price $59.00