| Overview: This one day course teaches participants the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web.
Duration: 1 day
Fee: $225 per person
Upcoming Dates:
Aug. 22, Oct. 16, Dec.16
Prerequisite: Microsoft Excel: An Introduction
|
|
Delivery: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities and assignments.
Materials: Participants receive reference materials related to course topics. Follow up support by email or phone, on topics covered, is available to participants for 90 days.
Further Learning:
Microsoft Excel: Advanced and Microsoft Excel: VBA Development.
|
|
Objectives: Upon successful completion attendees will be able to:
- Create and apply templates: create a workbook from a template, create a custom template, working with comments, create a hyperlink, use web-based research tools
- Create and modify charts: create a chart, format chart items, change the chart type, create a diagram
- Work with graphic objects: insert graphics, create autoshapes, format graphic objects, change the order of graphic objects, group graphic objects, move, copy and resize graphic objects
- Calculate with advanced formulas: ranges of cells, across worksheets, using date and time functions, with financial functions, with statistical functions, with lookup and reference functions, and with logical functions
- Sort and filter data: create and apply advanced filters, calculate with database functions, add subtotals to a worksheet
- Use Excel with the Web: export excel data, publish a worksheet to the web, import data from the web, create a web query
|
