Data-Driven Presentations with Excel and PowerPoint [2013, ENG]
movies, software, shows...
Files
| 00 Introduction | |||
| 1 Welcome.mp4 | 10.87 MB | ||
| 2 What you should know before watching this course.mp4 | 3.46 MB | ||
| 3 Using the exercise files.mp4 | 5.64 MB | ||
| 01 Data-Driven Presentations The Basics | |||
| 1 Creating a data-driven presentation.mp4 | 6.72 MB | ||
| 2 Using Excel data in PowerPoint.mp4 | 18.43 MB | ||
| 3 How themes impact presentation data.mp4 | 19.15 MB | ||
| 02 Formatting Excel Tables for Presentations | |||
| 1 Formatting a range as a table.mp4 | 29.67 MB | ||
| 2 Setting table options.mp4 | 12.61 MB | ||
| 3 Changing a table to a range.mp4 | 9.3 MB | ||
| 4 Dividing large numbers.mp4 | 10.46 MB | ||
| 03 Highlighting Data with Conditional Formatting | |||
| 1 Understanding conditional formatting.mp4 | 8.39 MB | ||
| 2 Formatting a cell based on its contents.mp4 | 23.7 MB | ||
| 3 Using data bars.mp4 | 15.51 MB | ||
| 4 Using icon sets.mp4 | 15.97 MB | ||
| 5 Editing a conditional format.mp4 | 25.55 MB | ||
| 04 Using Charts to Illustrate Data | |||
| 1 Choosing the right chart.mp4 | 11.48 MB | ||
| 2 Creating a pie chart.mp4 | 9.46 MB | ||
| 3 Creating a column chart.mp4 | 15.17 MB | ||
| 4 Building an infographic using a picture fill.mp4 | 16.84 MB | ||
| 5 Creating a 100% chart.mp4 | 12.51 MB | ||
| 6 Creating a combination chart.mp4 | 7.11 MB | ||
| 7 Creating charts in PowerPoint.mp4 | 18.67 MB | ||
| 05 Summarizing with PivotTables and PivotCharts | |||
| 1 Creating and formatting a PivotTable.mp4 | 22.31 MB | ||
| 2 Filtering items in a PivotTable.mp4 | 6.46 MB | ||
| 3 Creating a PivotChart.mp4 | 15.72 MB | ||
| 06 Taking Excel to PowerPoint | |||
| 1 Copying data and charts in Excel.mp4 | 18.78 MB | ||
| 2 Pasting charts and tables from the Office Clipboard.mp4 | 15.86 MB | ||
| 3 Linking data and objects.mp4 | 20.49 MB | ||
| 4 Copying tables and pasting pictures.mp4 | 24.7 MB | ||
| 5 Building a data-driven presentation directly in PowerPoint.mp4 | 22.77 MB | ||
| 6 Using sparklines in presentations.mp4 | 12.66 MB | ||
| 07 Using SmartArt in Data-Driven Presentations | |||
| 1 Creating a SmartArt diagram.mp4 | 9.5 MB | ||
| 2 Repurposing lists as diagrams.mp4 | 6.16 MB | ||
| 3 Creating an organization chart with photos.mp4 | 9.73 MB | ||
| 4 Converting SmartArt to shapes.mp4 | 35.12 MB | ||
| 08 Animating Charts and Data | |||
| 1 Animating charts.mp4 | 20.76 MB | ||
| 2 Removing animation.mp4 | 2.99 MB | ||
| 3 Focusing your audience with emphasis effects and shapes.mp4 | 17.83 MB | ||
| 4 Modifying animation orde.mp4 | 3.03 MB | ||
| 5 Animating SmartArt.mp4 | 20.88 MB | ||
| 6 Animating large tables and objects.mp4 | 30.03 MB | ||
| 09 Finalizing Your Presentation | |||
| 1 Documenting your presentation.mp4 | 11.2 MB | ||
| 2 Saving your presentation as a template.mp4 | 9.15 MB | ||
| 10 Conclusion | |||
| Next steps.mp4 | 2.94 MB | ||
| Ex_Files_DDP_Ex_PP.zip | 162.6 MB |
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Офисные программы Microsoft
Data-Driven Presentations with Excel and PowerPoint
Год выпуска: 10/2013
Производитель: Lynda
Сайт производителя: lynda.com/Excel-tutorials/Data-Driven-Presentations-Excel-PowerPoint/139994-2.html
Автор: Gini Courter
Продолжительность: 3:46
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Learn how to drive your Microsoft PowerPoint presentations with data straight from the source—Excel. Gini Courter first shows you how to use conditional formatting to highlight important data, summarize data with PivotTables, and visualize your data with sparklines and charts. Then learn how to leverage the linking and embedding features of Office to bring Excel tables and charts into PowerPoint. Gini then uses SmartArt to provide a conceptual framework in PowerPoint and animates the results. Finally, learn to create links from PowerPoint to Excel to fire up a workbook directly from a presentation. If you've wondered how to create compelling, data-driven presentations that always stay up to date, this course is for you.
Как связать пауэрпойнтовские презентации с таблицами из экселя.
[spoiler="Содержание"]
Introduction 5m 42s
Welcome 1m 6s
What you should know before watching this course 2m 20s
Using the exercise files 2m 16s
1. Data-Driven Presentations: The Basics 18m 21s
Creating a data-driven presentation 2m 11s
Using Excel data in PowerPoint 8m 47s
How themes impact presentation data 7m 23s
2. Formatting Excel Tables for Presentations 18m 49s
Formatting a range as a table 8m 57s
Setting table options 3m 53s
Changing a table to a range 2m 47s
Dividing large numbers 3m 12s
3. Highlighting Data with Conditional Formatting 28m 6s
Understanding conditional formatting 2m 41s
Formatting a cell based on its contents 7m 21s
Using data bars 4m 47s
Using icon sets 4m 50s
Editing a conditional format 8m 27s
4. Using Charts to Illustrate Data 33m 37s
Choosing the right chart 7m 4s
Creating a pie chart 2m 52s
Creating a column chart 4m 34s
Building an infographic using a picture fill 5m 39s
Creating a 100% chart 3m 54s
Creating a combination chart 2m 27s
Creating charts in PowerPoint 7m 7s
5. Summarizing with PivotTables and PivotCharts 14m 1s
Creating and formatting a PivotTable 6m 45s
Filtering items in a PivotTable 2m 17s
Creating a PivotChart 4m 59s
6. Taking Excel to PowerPoint 41m 20s
Copying data and charts in Excel 5m 50s
Pasting charts and tables from the Office Clipboard 6m 24s
Linking data and objects 8m 42s
Copying tables and pasting pictures 7m 44s
Building a data-driven presentation directly in PowerPoint 7m 40s
Using sparklines in presentations 5m 0s
7. Using SmartArt in Data-Driven Presentations 21m 15s
Creating a SmartArt diagram 3m 37s
Repurposing lists as diagrams 1m 58s
Creating an organization chart with photos 3m 40s
Converting SmartArt to shapes 12m 0s
8. Animating Charts and Data 35m 34s
Animating charts 8m 11s
Removing animation 1m 7s
Focusing your audience with emphasis effects and shapes 7m 25s
Modifying animation order 1m 16s
Animating SmartArt 8m 11s
Animating large tables and objects 9m 24s
9. Finalizing Your Presentation 8m 3s
Documenting your presentation 4m 20s
Saving your presentation as a template 3m 43s
Conclusion 1m 49s
Next steps 1m 49s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC 960x540 (16:9) 30fps 1200kbps
Аудио: AAC 48kHz stereo 160kbps
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 299.5 MB | freecoursewb | 1 month | 0 | 0 | |
| 847.8 MB | freecoursewb | 2 months | 0 | 0 | |
|
Udemy - Build AI-Driven Data Warehouses - ChatGPT ETL, and Python BI Posted by
freecoursewb in Other
|
1.7 GB | freecoursewb | 5 months | 4 | 0 |
| 1.2 GB | freecoursewb | 10 months | 2 | 1 | |
| 3.9 GB | freecoursewb | 1 year | 0 | 1 |
All Comments