Course description
As a knowledge worker, you have a need to produce compelling PowerPoint presentations. You know your data for charts and graphs is already available in Excel. This one-day course will be an opportunity to see how these two great software products from Microsoft can work in concert to be greater than the sum of their parts!
Upcoming start dates
Who should attend?
Training content
During this one-day dynamic workshop, you will learn about:
Excel 9:00 to Noon
Section 1: Working with Functions and Formulas
- Using Formulas in Excel, Part 1
- Using Formulas in Excel, Part 2
- Exploring Excel Functions
- Using Functions in Excel
- Working with Names and Ranges
- Working with Array Formulas
Section 2: Pivoting Data
- Getting Started with PivotTables
- Working with PivotTable Data
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Advanced PivotTable Tasks
- Using PowerPivot
Section 3: Managing Tables
- Working with Tables
- Working with Records and Fields
- Working with Tables and Filters
- Using Excel as a Database
Section 4: Charting Pivoted Data
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
- Advanced PivotChart Tasks
PowerPoint 1:00 to 4:30
Section 5: Adding Diagrams, Charts, and Tables
- Inserting Tables
- Editing Tables
- Formatting Tables
- Inserting Charts
- Inserting SmartArt
- Formatting SmartArt
Section 6: Adding Multimedia to a Presentation
- Inserting Video Files
- Editing Video Files
- Inserting Audio Files
- Editing Audio Files
Section 7: Setting up Slide Masters
- Creating a Slide Master
- Using Placeholders
- Using Slide Masters
- Using Handout Masters
- Using Notes Masters
Quick stats about BBLN?
In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.
All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.
We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.
Contact this provider
Building Blocks Learning Network
Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...