Excellence in Excel! Create a dynamic block chart in Excel!
Год выпуска: 2015
Производитель: Udemy
Сайт производителя: udemy.com/excel-block-chart
Автор: Nicky Wong
Продолжительность: 1:19
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: Excel, create by Doing!
Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
Do you want to create those cool looking infographic block charts?
Do you want to know a more impressive way to display data professionally?
Do you want to see instantly the most value information by using a graph?
Do you struggle with too much facts and tool less visuals?
If any of these are a yes, than this course is for you!
Создание динамических графиков в Экселе.
Содержание
Section 1: Welcome
What will you learn in this course!
Download the Excel file with Raw Data! - 2 slides
Section 2: Create single block chart!
Creating the formula`s for the Single Block Chart
Creating the graph for the Single Block Chart
Exercise Single block chart
Answers Exercise Single Block Chart
Section 3: Create the multiple block chart
Creating a dynamic Multiple Block Chart
Creating a dynamic Multiple Block Chart, create the engine room tab
Creating the combined VLOOKUP and conditional formatting of the Block Chart!
Exercise Multiple block chart
Answers Exercise Multiple block chart
Section 4: Thank You!
Final Points
Excel Reference Sheet by Udemology - 4 pages
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1350x720(1.85:1), 10fps, 349kbps
Аудио: AAC, 44.1kHz, 48kbps, mono
