Dekka-Tek A professional services organization providing the technical and functional expertise to develop business solutions for large multi-national companies and smaller private platforms

Upcoming DT-2 Classes

This is the second of three levels of Excel training we offer. You will learn to create and apply templates, modify and generate charts, continue developing your skills in VBA, and demonstrate advanced understanding of DT-1 concepts like named ranges and the logical functions. You are likely qualified to be an analyst.

Course Outline

Calculating Data with Advanced Formulas

• Manage Cell and Range Names (Continued from DT-1)
• Calculate Data Across Worksheets
• Use Specialized Functions
• Analyze Data with Logical and Lookup Functions (Continued from DT-1)

Organizing Worksheet and Table Data

• Create and Modify Tables
• Format Tables
• Sort or Filter Worksheet or Table Data
• Calculate Data in a Table or Worksheet

Presenting Data Using Charts

• Create a Chart
• Modify Charts
• Format Charts

Analyzing Data Using PivotTables and PivotCharts

• Create a PivotTable Report
• Analyze Data Using PivotCharts

Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt
• Draw and Modify Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

• Customize the Excel Environment
• Customize Workbooks
• Manage Themes
• Create and Use Templates

Streamlining Workflow

• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings

Collaborating with Others

• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
• Administer Digital Signatures
• Restrict Document Access

Analyzing Data

• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak

If this sounds too tough, think about taking DT-1.