
Build a minimalist, professional chart showing turnover and profit with a percentage overlay across countries, using clustered columns, overlapping data series, and conditional formatting.
Create a minimalist concurrent ring chart with donor charts to compare interim project revenue to targets. Link title, set donut hole to 60%, apply blue scheme, and add data labels.
Create an Excel heat map with a three-color scale to visualize production across 12 areas and 31 weeks, using min 80, mid 90, max 100, and hide numbers.
Create a dynamic stacked column combo chart for three projects' cost breakdown; the chart updates automatically and features a minimalist amber monochromatic style with data labels showing series names.
COURSE OBJECTIVE: MINIMALISM. AESTHETICS. PROFESSIONALISM.
The primary objective of this course is to train you to create charts in excel that are professional while being minimalist and aesthetic at the same time. Let me be honest with you, speedometer and highly colourful charts with data junk and information overload will not impress top tier clients.
SUITABLE FOR PROFESSIONALS / CONSULTANTS / STUDENTS
This master course will be extremely useful for professionals and students alike; within a short period of time, you will be able to create Excel based charts that will positively amaze your clients and professors.
The charts you will learn to create in this master course is as good if not better than the charts you usually find in professional journals and management consultant reports.
All the charts created in this course, with the exception of the 2D Map Chart, can be made in older versions of Excel as well.
Excel 2019 has 2 special charts namely the aforementioned 2D Map Chart and a new Funnel chart. However, in this course, I will show you how to create and even better funnel chart in older versions of Excel.
So, if you are looking to take your consulting and presentation skills to a whole new level, enrol now! I look forward to significantly augmenting your chart creation skills.
WATCH THE SAMPLE VIDEO TUTORIAL
Please watch the sample video lecture where I will show you the basic principles associated with creating a highly professional, minimalist and aesthetic chart.