Training

 


Learning
 back      
 

Excel 2007: Advanced Part 2: Worksheet Reporting Features and Tips (133036)

REGISTRATION STATUS: WAITING LIST - This course had greater registration than expected and is currently sold-out; we will do our best to accommodate you. If you choose to register now, we will notify you if space becomes available.

Date: Thursday, December 03, 2009
Time: 8:30am - 4:30pm (Registration at 8:00am )
Facility: MACPA Columbia Center, Columbia
CPE Credit: 8 Technology
Course Type: Computers
Provider: SCG Training & Consulting
Instructor: Judith E. Borsher, CPA, MBA
Field of Study: Technology, Computer Science
Level of Knowledge: Advanced
Fees: $330 MACPA Members, $480 Non-Members
Referral Discount: ($150)
Student Discount: ($150)
Reciprocal Discount ($150)

Click here to add this event to your electronic calendar (then click OPEN when prompted).

Bookmark and Share


Description:

Excel 2007 contains many valuable advanced features that will enhance your worksheet reporting capabilities, ensure that your work is protected, and save you time. This fast-paced hands-on course covers advanced level topics including: file collaboration features, cell, sheet and file protecting, custom views for report design/printing, scenario sets of input cells, creative time-saving uses of the macro recorder, macro buttons, building Excel financial and budgeting templates for your organization, and many other time-saving tips.

  • Complete the day having learned how to protect and secure your work in Excel
  • Master how to save time with macro recording examples
  • Take away macro examples to use immediately
  • Eliminate repetitive steps by creating new quick access tools
  • Take away template examples for financial reporting
  • Learn how to share templates in your organization
  • Learn Excel collaborating and file sharing features
  • Take away knowledge of many new time-saving features in Excel 2007

    Objectives:

    Protecting Features

  • Protect worksheet data by locking cells and setting worksheet and workbook protection
  • Create a protected data entry range
  • Lock a file with new encryption features
  • Explore security features for displaying in a web browser
  • Send spreadsheets as pdf files Collaboration Features
  • Use Excel's collaboration features including file sharing and tracking changes
  • Add Comments to cells and show/hide as needed
  • Create Excel templates to be private or shared
  • Explore financial analysis template examples
  • Modify the Excel autotemplate
  • Create scenarios to recall input values
  • Create a business dashboard to track key performance indicators Macro Recording
  • Record day-to-day repetitive steps as a macro
  • Record macro examples for printing, formatting and cell-pointer movement
  • Record macro examples of data cleanup and report generation
  • Understand the difference between absolute and relative macro recording for range selections with the Stop Recording toolbar
  • Create a macro button on a worksheet to run the macro Day-to-day Productivity Features
  • Use Custom Views to recall page setup dialog box or display settings
  • Email worksheet attachments and ranges directly from Excel using Outlook
  • Explore the new speech recognition enhancements
  • Understand many new features added to Excel 2007
  • Customize Excel features to suit the way you work

    Who Should Attend:

    Professionals needing to increase their knowledge of Excel features at an advanced level. This class will be taught using Excel 2007.

    Prerequisite:

    Excel Worksheets Refresher class or equivalent experience (NOTE: Excel Advanced Part 1 and Part 2 can be taken in any order)


    •  back