Excel 2019: Edit & Format Charts

Course description

This course shows how to transform ordinary Excel 2019 charts into clear, credible visuals that communicate meaning effectively. It begins with an overview of selecting appropriate chart types, explaining when clustered columns support comparisons, when line charts reveal trends over time, and why certain chart designs can create misleading impressions. You’ll learn how to move charts within a workbook or to a separate sheet for cleaner, presentation-ready layouts while maintaining accurate data relationships. The course also covers controlling visibility by filtering categories, limiting time periods, and redefining data ranges so charts focus on the most relevant information. Next, you’ll refine chart design using Excel’s formatting tools, including selecting styles, adjusting color palettes, balancing text elements, and applying labels, legends, and titles that improve interpretation without creating clutter. You’ll explore how to manage axes effectively by setting appropriate bounds, units, and number formats that make scales both accurate and easy to understand. The course also examines spacing, overlap, and proportion settings that affect readability and perception, helping you improve visual impact without distorting the underlying message. Finally, you’ll learn efficient techniques for reusing layouts, aligning fonts, and saving templates for future projects. By the end, you’ll have a practical approach to editing, moving, filtering, and formatting Excel charts for dashboards, reports, and presentations.

Course outline