2015
Udemy
Nicky Wong
1:19
English
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
Download File Size:236.9 MB