Skip Ribbon Commands
Skip to main content

Export Event

Title

Microsoft Excel 2010: Advanced Skills

Location

Eau Claire Business Education Center - Room 27

Start Date & Time

8/14/2014 8:30 AM

End Date & Time

8/14/2014 3:30 PM

Date Details

 

Description

After completing this course, you will know how to:
• Use the IF and SUMIF functions to calculate a value based on specified criteria; use a nested IF function to evaluate complex conditions; and use the ROUND function to round off numbers.
• Use the PMT function to calculate periodic payments for a loan; use Date and Time functions to calculate duration in years, months, and days or time; display, print, and hide formulas; create array formulas to perform multiple calculations on multiple sets of data at one time; and change calculation options and iteration limits.
• Use the VLOOKUP and HLOOKUP functions to find values in worksheet data; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position in a range; and use data tables to project values.
• Use the Data Validation feature to validate data entered in cells; and use advanced filter options to display the data you specify.
• Export data from Excel to other formats, and import data from a text file into an Excel workbook; import XML data into a workbook, and export data from a workbook to an XML data file; and use Microsoft Query and the Web query feature to import data from external databases.
• Use the Goal Seek utility to meet a target output for a formula by adjusting the values in the input cells; use the Analysis ToolPak to perform statistical analysis; and create scenarios to save various sets of input values that produce different results.
• Run a macro to perform tasks automatically; record macros; assign a macro to a command button and a button in the worksheet; use a button to run a macro; create an Auto_Open macro; edit a macro by editing VBA code; and create a custom function to perform calculations when built-in functions are not available.

All Day Event

 

Recurrence

 

Workspace

Register

Register Online

How to Register

Registration options:
1. Click the online registration button above to register and pay online.
2. Download the registration form below and mail or fax it in with payment.
3. Call 1-800-547-2882.
Please have payment ready at time of registration. If your company is paying for your course, a Third Party Authorization form is required so your company can be invoiced. You may add additional courses to your registration form if you are registering for more than one course.
Seminar  Continuing Education Form 01.28.14.pdfSeminar Continuing Education Form 01.28.14.pdfCVTC 3rd Party Authorization.pdfCVTC 3rd Party Authorization.pdf

Cost

$96.00

CEUs

0.6

CRN

80017

Training Area

Business Information Technology

ForHomepage

Yes

Attachments

Content Type: Event
Created at 8/20/2013 12:55 PM by cvtc\jcather
Last modified at 5/13/2014 10:41 AM by cvtc\jcather