| Overview: This one day course teaches participants the skills necessary to use various functions and PivotTables. Anyone who works with multiple workbooks or needs to create and manage high end macros work with advanced features of Excel and various advanced techniques for analyzing and manipulating data in Excel.
Duration: 1 day
Fee: $250 per person
Upcoming Dates:
Sep. 3, Oct. 17, Dec.17
Prerequisite: Microsoft Excel: Intermediate
|
|
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. Sample files used in class are available by email, or on disk. Follow up support by email or phone, on topics covered, is available to participants for 90 days.
Further Learning:
Microsoft Excel: VBA Development.
|
|
Objectives: Upon successful completion attendees will be able to:
- Apply conditional formatting
- Add data validation criteria
- Collaborate with others using workbooks: protect files, share workbooks, merge workbooks/span>
- Administer digital signatures
- Audit worksheets: locate errors in formulas, locate invalid data and formulas
- Trace Cell Precedents and Cell Dependents
- Analyze data: create a trendline, perform What-if analysis
- Develop PivotTable and PivotChart Reports
- Work with multiple workbooks: Consolidate data, link cells in different workbooks, edit links
- Import and export data: Export to MS Word, Import a Word table, Import text files
|
