Training

 


Learning
 back      
 

Excel 2007: Advanced Part 1: Advanced Functions, Pivot Tables and Tips (133031)

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: Tuesday, December 01, 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 functions and features that will enhance your worksheets, your calculations and save you time. This fast-paced hands-on course covers advanced level topics including: range naming, decision-making IF and VLOOKUP functions, financial functions, dfunctions and their application in Pivot Tables, controlling calculation inputs with goal seek and solver, formula auditing, external formula linking, repair of broken formula links, and many time-saving multiple worksheet tips.

  • Master the ability to use advanced functions for If testing and Lookup
  • Understand how to use the Excel financial functions
  • Incorporate a variety of multiple worksheet tips
  • Understand how to calculate with dfunctions and Pivot Tables
  • Understand range naming, formula auditing, conditional formatting
  • Connect calculations to multiple files with external formula linking
  • Save time with the new Name Manager dialog box
  • Take away many immediately applicable examples

    Objectives:

    Functions

  • Use range names and the new Name Manager dialog box for quick cell/range identification and formula building
  • Use IF testing, new nested function rules, decision making functions and lookup functions
  • Use SUMIF, SUMPRODUCT and COUNTIF
  • Use financial function capabilities: FV, PV, PMT, compound interest, rate, per, nper, type
  • Explore the use of the dfunctions based on criteria: DSUM, DCOUNT
  • Explore how the dfunctions work in Pivot Table calculations
  • Understand how to use the new function help features Controlling Results
  • Apply new conditional formatting to change cell formats based on cell results
  • Suppress the display of Excel error messages in cells
  • Use the formula auditing toolbar to trace formula dependencies across sheets
  • Use the watch window to track calculations on one sheet while working on another sheet
  • Use the Data Validation feature to control user input
  • Group and outline according to formula structure
  • Use goal-seek and solver to test input values External Formula Linking
  • Create external formula links
  • Repair broken links quickly and easily
  • Control calculating the external links with the new user prompt controls Multiple Worksheet Features
  • Group worksheets to take actions on more than one worksheet at the same time
  • Use 3-dimensional functions across sheets
  • Copy sheets in the same file or to a new file
  • Save a workspace file for quick opening of multiple files New Features
  • Use the time-saving contextual ribbon tools and customize the quick access toolbar (2007)

    Who Should Attend:

    Professionals needing to increase their knowledge of Excel 2007 functions and 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