
Master professional, minimalist, and aesthetic Excel charts. Learn principles for flow chart, 2d map chart, and funnel chart, with compatibility for older Excel versions.
Master minimalist, professional charts by eliminating chart junk and applying clean bar visuals. Align color, axis, and data labels for a consulting-grade graphic.
Build a minimalist, professional chart showing turnover and profit with a percentage overlay across countries, using clustered columns, overlapping data series, and conditional formatting.
Turn a minimalist chart into a dynamic data display using checkboxes linked to cells for turnover, profit, and profit percentage.
Create an embedded column chart type 2 in Excel to visualize profit across locations A, B, C and three years with max and min lines in a monochromatic gray scheme.
Create an embedded clustered column chart in Excel to show four projects' revenue across four years, applying a green gradient and refined axis and titles.
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 a vertical bullet chart in Excel to compare current and target values for three projects, with dynamic updates and a minimalist gray scheme.
This lecture demonstrates building minimalist in-cell charts in Excel 2019/2016 using Wingdings fonts, CHAR and REPT functions to create Gantt bars, with conditional formatting data bars as an alternative.
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.