Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
Excel - The Fundamentals of Building Great Spreadsheets CXOXLS013W8
View Registrations Tell a Friend About This EventTell a Friend
 

This course is an 8-hour session on the fundamentals of using Microsoft Excel. It is an accumulation of several of our individual Excel courses.

 Export to Your Calendar 12/4/2017
When: 7:00 AM to 3:00 PM
Where: Webinar/Webcast
United States
Presenter: Bryan L. Smith, CPA.CITP, CISA
Contact: April Deneault
801-466-9070
« Go to Upcoming Event List  

Office 365

Field of Study

Computer Software & Applications - Non-Technical

Credit:  8

Level:  Basic

Designed for:

Anyone who wants to optimize their use of Excel to build better spreadsheets.

Objective

After attending this presentation, you will have the ability to …

  • Design spreadsheets that have greater meaning
  • Create calculations that are accurate
  • Create spreadsheets more efficiently
  • Distribute spreadsheets in the proper format
  • Use templates to increase your productivity
  • Use Defined Names to create formulas more efficiently
  • Use Excel Tables to improve spreadsheet accuracy
  • Use the structured calculations in Excel Tables
  • Print multiple spreadsheets
  • Embed Excel ranges into Word documents
  • Use cell formatting and styles
  • Use conditional formatting to make data standout
  • Print spreadsheets more efficiently

Description

The major topics that will be covered in this class include:

  • Understanding Excel and its user interface
  • Learning the basic tasks (fill command, range selection, quick entry)
  • Creating formulas (absolute/relative reference, copying & pasting, auto-complete)
  • Create a Default layout (sheets, Workbook, settings)
  • Using quick formatting tools (copy & pasting, Cell Styles, cell formats)
  • Printing your spreadsheets (page layout, printing to paper and PDF)
  • Group mode
  • Using and creating templates
  • Using Defined Names in formula creation
  • Learning how Defined Names can lead to more accurate spreadsheets
  • Structured calculations in Excel Tables
  • Utilize tips and techniques for printing your spreadsheets efficiently
  • Apply the best techniques to print multiple spreadsheets with a consistent format
  • Embed Excel ranges into Word documents to ensure your reports are complete and less prone to transposition errors
  • Understand and apply all cell formatting options
  • Apply and create custom cell styles
  • Identify and understand the benefits of conditional formatting options

 

Price:  $199.00

Link to register:  http://cpe.cpacrossings.com/CXOXLS013W8?partner=uacpa

Event Code:  7986

Keywords:

Excel Tables Defined Names Spreadsheet Conditional Formatting Excel Basics

Membership Management Software Powered by YourMembership  ::  Legal