Skip Ribbon Commands
Skip to main content

Export Event

Title

Microsoft Excel 2010: Intermediate Skills

Location

Eau Claire Business Education Center- Room 222

Start Date & Time

7/29/2014 8:30 AM

End Date & Time

7/29/2014 3:30 PM

Date Details

 

Description

After completing this course, you’ll know how to:

 

  • Link worksheets by using 3-D formulas; add a Watch window; create and manage links between workbooks; and create a workspace.
  • Apply special and custom number formats; control the display of zero values; use functions to format text; create, apply, and modify styles; apply and modify themes; merge and split cells; change the orientation of data in cells; transpose data; use Paste Special operations, and add a background color and a watermark.
  • Create an outline and consolidate data; create subtotals in a list; use multiple subtotal functions; and create custom views to save different sets of worksheet display and print settings.
  • Define and apply cell and range names; use names in formulas; and define and apply 3-D names.
  • Sort data by columns; filter data based on complex criteria and copy filtered results to another range; create, format, and name a table, and add rows and columns; and used structured references.
  • Save and publish a worksheet as a Web page; insert and edit hyperlinks; publish a worksheet; and send a worksheet as an email attachment.
  • Format data points in charts; create combination charts and trendlines; insert sparklines; use chart templates; and add and modify drawing objects, shapes, and images.
  • Use auditing features; add comments to cells and workbooks; protect a worksheet or part of a worksheet; protect the workbook structure; share, merge, and track changes in a workbook; find and remove hidden and personal data in a workbook; and mark a workbook as final.
  • Change Excel’s default application settings and customize the Ribbon; work with Excel templates; and create and manage templates.
  • Create a PivotTable for analyzing and comparing large amounts of data; modify the PivotTable view by using slicers to filter data and by rearranging fields; improve the appearance of a PivotTable by changing its field settings and applying a style; and create a PivotTable to graphically display data from a PivotTable.

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.
CVTC 3rd Party Authorization.pdfCVTC 3rd Party Authorization.pdf

 

Cost

$96.00

CEUs

0.6

CRN

70297

Training Area

Business Information Technology

ForHomepage

Yes

Attachments

Content Type: Event
Created at 6/19/2014 10:52 AM by cvtc\jcather
Last modified at 6/26/2014 12:16 PM by cvtc\jcather