Advanced Excel Topics for Spreadsheet Power Users
Available Until
Self-study
8.00 Credits
Member Price $199.00
Non-Member Price $259.00
Overview
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This course can help users who wish to improve their Excel skills to increase their productivity. The material starts by covering fundamental topics such as time-saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit significantly by taking this course.
Highlights
- Using Excel for graphical output and dashboard reporting
- Data tools and the Data Analysis ToolPak
- Advanced functions and complex formulas
- Working with Excel tables and PivotTables
Prerequisites
An understanding of Excel conventions.
Objectives
- Recall how to work with the charting tools in Excel and understand conditional formatting
- Indicate the benefits of using the Data Toolpak and such tools as descriptive statistics and regression analysis
- Identify ways to create complex, powerful formulas using advanced functions available from the Excel Function Library
- Recall four benefits of using Excel tables and understand ways that tables are helpful
- Recognize ways to work with PivotTables to summarize and present information and understand some of the many PivotTable features
Preparation
None.
Notice
This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.
Non-Member Price $259.00
Member Price $199.00