Computer Skills
Videos, live and on-demand courses, and other tools on a variety of computer skills, including learning paths that lead to certification.
Excel
Excel Training Program with CCAC
The Office of Human Resources partners with the Community College of Allegheny County to offer an Excel training program. The program consists of two concise courses — foundational and advanced Excel — designed for practical application. By focusing on key concepts, participants gain the confidence to tackle real-world tasks within their roles.
Training Resources
- Excel 2019 for Windows: Creating & Saving Workbooks
- Excel 2019 for Windows: Getting Started
- Excel 2019 for Windows: Illustrating Documents
- Excel 2019: Creating Charts & Graphics
- Excel 2019: Custom & Conditional Formatting
- Excel 2019: Finding & Grouping Data
- Excel 2019: Forecasting & Solving Problems
- Excel 2019: Getting to Know Macros in Excel
- Excel 2019: Inserting PivotTables
- Excel 2019: Managing Data
- Excel 2019: Referencing Data
- Excel 2019: Sorting & Filtering Data
- Excel 2019: Using Conditional Formulas
- Excel 2019: Working with Excel Tables
- Excel 2019: Working with Macros in Excel
- Excel 2019 for Dummies (Book)
Certificate Opportunities
- Master Microsoft Excel
- Excel: PivotTables for Beginners
- Learning Excel 2019
- Excel: Tips and Tricks
- Excel: Advanced Formulas and Functions
- Excel Quick Tips
- Excel: Creating a Basic Dashboard
- Excel: Introduction to Formatting
- Excel 2019 Essential Training
- Excel: Introduction to Charts and Graphs
- Getting Started with Microsoft Excel
- Excel for Accountants
- Excel: Introduction to Formulas and Functions
PowerPoint
Training Resources
- PowerPoint 2019 (Windows): Creating Presentations
- PowerPoint 2019 (Windows): Enhancing Presentation Designs
- PowerPoint 2019 (Windows): Formatting Presentations
- PowerPoint 2019 (Windows): Getting Started
- PowerPoint 2019 (Windows): Inserting & Manipulating Text
- PowerPoint 2019 (Windows): Saving Presentations
- PowerPoint 2019: Adding Animations
- PowerPoint 2019: Adding Data to Presentations
- PowerPoint 2019: Creating Graphics & Diagrams
- PowerPoint 2019: Organizing Presentations Assets
- PowerPoint 2019: Preparing & Delivering Slideshows
- PowerPoint 2019: Sharing & Collaborating on a Presentation
- PowerPoint 2019: Using Multimedia in Presentations
- PowerPoint 2019 for Dummies (Book)
Certificate Opportunities
- Cert Prep: PowerPoint Associate - Microsoft Office Specialist for Office 2019 and Office 365
- Designing a Presentation
- Learning PowerPoint 2019
- PowerPoint 2019 Essential Training
- PowerPoint Quick Tips
- PowerPoint Tips and Tricks
- PowerPoint: Animating Text and Objects for Beginners
- PowerPoint: Audio and Video
- PowerPoint: Creating a Self-Running, Interactive Presentation
- PowerPoint: Creating an Infographic
- PowerPoint: Silicon Valley Presentation Secrets
- PowerPoint: Using Photos and Video Effectively for Great Presentations
Word
Training Resources
- Word 2019 (Windows): Creating, Opening & Saving Documents
- Word 2019 (Windows): Editing Documents
- Word 2019 (Windows): Formatting Documents
- Word 2019 (Windows): Opening & Setting Up
- Word 2019 (Windows): Using Find & Replace Tools
- Word 2019: Adding Data & Calculations
- Word 2019: Configuring the Application
- Word 2019: Creating Forms
- Word 2019: Creating Graphics & Diagrams
- Word 2019: Illustrating Documents
- Word 2019: Shaping Documents
- Word 2019: Sharing & Collaborating on a Document
- Word 2019: Structuring Documents
- Word 2019: Using Research Tools
- Word 2019: Using Table Tools
- Word 2019 for Dummies (Book)