Webinar: Excel – Spreadsheet Design Techniques You Must Know

Description

This course is the first of a two part series to teach you the ten most important spreadsheet design techniques. Using a classic cash flow projection spreadsheet, each of the techniques will be demonstrated and provide you with a comprehensive guide to help you employ these features after the session.

Learning Objectives

Learn how to build spreadsheets in less time.
Learn how to design spreadsheets that are less likely to contain errors.
Learn how to design spreadsheets that are easier to update.

Major Topics

Defined Names – Learn how to use these to enhance the design of your spreadsheets to streamline the building of formulas, make your spreadsheets more flexible for expansion, provide better documentation of your formula logic; what they are about, how they are used, syntax rules, tips and tricks for using them.
Data Tables – The most practical features in all of Excel, learn how to create a data table and then utilize all of the tools to analyze and manage your table of data including; filtering, sorting, styles, total row and more.
Learn how to establish your default Excel spreadsheet settings using the template file.
Using variables in formulas, learn one of the most important spreadsheet design techniques in regards to using variable in formulas rather than “hard-coding” them.
Rounding and Precision – nothing is more embarrassing then having a financial spreadsheet that displays rounding errors. We will show you how to use the built-in functionality of Excel to prevent this from happening in your spreadsheets.

Provider
CPA Crossings, LLC
Course Level
Intermediate
CPE Field of Study
Computer Sciences
2.0
Instructor(s)
John Higgins
Prerequisites

None

Advanced Preparation

None

Register Now
When
Jun 29, 2012
8:00 am - 10:00 am
Location
Online
Total CPE Credits
2.0
Format
Webinar
Instructor
John Higgins

MEMBER


$ (% off)
$79.00

NON-MEMBER


$ (% off)
$79.00
Become a Member

Register for this Event

Webinar: Excel – Spreadsheet Design Techniques You Must Know


Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×