Creating Infographics with Excel Masterclass.
Course overview.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIAInfographics, which stands for information graphics, are visual representations of data or knowledge by using graphic images to present information quickly and clearly. Infographics can make complex information eye catching and easily understandable.
Do you know that you can create professional looking infographics using MS Excel? Master the power of MS Excel to create beautiful visual and dynamic infographics for amazing presentations. A well-designed infographic can help simplify a complicated subject or turn a subject into a captivating experience.
Infographics has grown in importance in the business environment. Infographics in MS Excel is the way of showing the information or summary report through attractive charts, graphs, and images. Infographics are the art of visualising the data using external elements or images. They are different from dashboards and require the architectural mind to build your own infographics in Excel.
Having an interactive content like infographics is a good strategy in any reports. Ideally, an infographic is visually engaging and contains subject matter that is appealing to your target audience. The course shows you how to create infographics that are highly descriptive and visually impacting.
Key takeaways.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIABy the end of the course, participants will:
- The dos and don’ts of infographics
- Learn how to build stunning and informative Excel infographics
- Learn technical Excel skills needed to create dynamic and robust infographics
- How to tweak Excel charts to appear as infographics
- Learn how to visualise data using external elements or images
- Enhance your data visualisation skills
- Plot geographic and temporal data on a 3-D globe over time, and create visual tours with Power Map
- Learn how to grab your target audience’s attention
- Display key trends, comparisons and data graphically for greater clarity and faster insights
- Learn smart techniques that make infographics work productive
- Explore methods and best practice design principles to design your infographic
Who should attend.
Analysts, managers, reporting professionals, executives and business owners who prepare Excel infographics, including directors, general managers, CFOs, finance managers, accountants, marketing, sales and HR managers.
Prerequisites.
Participants should be comfortable with basic Excel tools and functions and navigate confidently in Excel.
The programme.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIASESSION 1Introduction
- Overview of training aim, objectives and agenda
SESSION 2The Importance Of Infographics
- What is an infographic?
- Why present data using infographics
- Purpose and benefits of infographics
SESSION 3Infographics Preparation
- Identifying target audience
- Understanding your data
- Organising data
- Tools and tricks to clean data before using it to build infographics
- Ability to link data to graphics
SESSION 4Design Principles
- Understanding infographics design principles
- Layout, colour and display
- Various aspects of chart types and subtypes
- Shapes that can be categorised as rectangles, lines, arrows, etc.
- Modifying different layouts
- Common mistakes when building infographics
SESSION 5Technical Excel Skills For Infographics
- Technical Excel skills needed to create dynamic and robust infographics in Excel
- Formatting of cell
- Functions and formulas for infographics
SESSION 6Creating Infographics Within Excel
- Displaying complex connection on a relatively small space
- Introducing vector objects
- Modifying charts and replacing with objects
- Creating custom infographics using icons
SESSION 7Seeking Information From Infographic
- Informing your message
- Comparing similarities or differences among values
- Showing changes that are continuous over time
- Organizing groups, patterns, and order
- Seeking for relationship amongst data
SESSION 8Making A Timeline Infographic
- Creating a story based on a timeline
- Updating time periods with objects
- Replacing placeholder text and formatting of objects and colors
- Narrowing the scope of Timeline
SESSION 9Creating A Communicative Infographic
- Conveying a message with infographic
- Modifying structure of chart to accommodate communicative infographic
- Adding images and descriptive data
- Importance of looking good
- The final touch
SESSION 10Create People Graph Infographics In Excel
- Steps to create People Graph infographics
- Change icons of the People Graph chart
- Build People Graph infographics by using external images
- Convert bar and line chart to People Graph
SESSION 11Mastering Power Map
- Display information in new ways using Excel’s 3-D data visualisation tool Power Map
- Gain new understandings by viewing your data in geographic space and seeing time-stamped data change over time
- Plot more than a million rows of data visually on Bing maps in 3-D format
- Capture screenshots and build cinematic, guided video tours that engage audiences like never before
- Export and share tours as video
SESSION 12Effective Infographics To Master
- Project Gantt Chart
- Capsule Chart
- Actual vs Target Chart
- Dynamic Progress Chart
- Spider Chart
- Dynamic Cylinder Chart
- Bike Race Chart
- Heatmap Chart
SESSION 13Putting It Together
- Creating your Excel infographics
Throughout the workshop, participants will work through practical exercises to enhance their knowledge of the tools available to build Excel infographics
Your trainer.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIAAlvin Yong is a UK-registered Fellow Chartered and Certified Accountant (FCCA). He obtained his Master of Science in Professional Accountancy (Merit) in 2017 from the University of London.
To bring.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIAReviews from our Malaysian clients.
CREATING INFOGRAPHICS WITH EXCEL MASTERCLASS TRAINING MALAYSIA“Content is very good, notes are sufficiently detailed, presentation is clear and pace is good. Alvin entertained questions calmly, clearly, and with sufficient depth. Very knowledgeable and qualified for the training subject.”
“Alvin is an excellent trainer. He led interesting, interactive and focused discussions during the workshop.”
“Alvin was well prepared, knowledgeable and easy to follow. Level of detail was where it needed to be and the documentation was very thorough. The course went quickly which was always a good sign.”
“Fantastic trainer in terms of knowledge and skills. Extremely friendly, helpful and patient.”
“Good understanding and knowledge of the subject. Attentive and responsive to participants' queries. Presented the subject very clearly.”
“The trainer is knowledgeable. He was helpful. He handled the class material well.”
“Very informative. Gave an excellent count of how-to's.”
“Alvin is a very people person. Sound knowledge in his area of expertise. He carried out the programme well.”
Related courses.
EXCEL · DATA VISUALISATIONReady when your team is.
Public runs across the region and live online — or we scope an internal cohort around your actual reports.
Enquire about in-house training