E

1

AETG Engineering Level 1 Certification

Almost every company uses the Microsoft suite of tools such as Word, Excel, and PowerPoint. Engineers utilize these tools on a daily basis to gather, manipulate, and convey data to peers and management teams within an organization. This course focuses on all the key features, shortcuts, and ways to work more efficiently within these programs. The lessons in this course relate directly to relevant tasks performed on a daily basis by engineers. Engineers and other technical individuals who become highly proficient in these programs will improve their throughput and accuracy, which will allow more time for focus on more critical tasks. This course also dives into the generation and interpretation of drawings, as well as interpreting and applying Geometric Dimensioning and Tolerancing (GD&T) in accordance with ASME Y14.5.

After taking this eight week course, students will be more proficient compared to 90% of engineers with over 10 years of experience.

Students who have completed this course will also get a 3 year full access membership.

32 Hour Course

Microsoft Excel Curriculum (8 hours)

Bill of Material Generation/Manipulation
Data Validation
Conditional Formatting
Complex Formulas (IFs, COUNT, COUNTIFS, SUMIFS, XLOOKUP, VLOOKUP, CONCATANATE)
Pivot Tables
Status Tracking
Graphical Representation of Data
Do's and Don'ts
Tips/Tricks/Shortcuts/Hotkeys

Microsoft PowerPoint Curriculum (4 hours)

Setting up slide master
Customizing Quick Access
Importing and manipulating images
Utilization of Drawing commands
Embedding objects and excel tables
Adding and modifying Animation
Tips/Tricks/Shortcuts/Hotkeys

Microsoft Word Curriculum (4 hours)

Setting up templates
Customizing Quick Access
Modifying Styles
Importing and manipulating images
Utilization of Drawing commands
Embedding objects and excel tables
Utilization of Captions
Writing for your audience
Review with Track Changes
Do's and Don'ts
Tips/Tricks/Shortcuts/Hotkeys

Generating and Interpreting Technical Drawings Curriculum (8 hours)

Drawing Basics
Industry Standards and Nomenclature
Note Blocks and Note Generation
Third Angle Projection
General and Best Practices
Section Views
Vendor Item and Source Control Drawings
Digital Product Definition
Advanced drawing applications
Design for Manufacturability

Geometric Dimensioning and Tolerancing Curriculum (8 hours)

Introduction into GD&T Basics
Datums
Feature Control Frames
Flatness, Straightness, Perpendicularity, Parallelism
True Position
Surface Profile
Tolerance Stack
Maximum Material Condition
Least Material Condition
Virtual Condition

Laptops will be required for each session.