Excel – reports and graphics

In this course, we dive into enhanced features of Excel. You will learn how to create effective and functional graphics with Pivot table.

Goal

After this training, you will be able to use Excel effectively and, you will learn how visualize your data with different tools.

Target audience

This course is for people who already master Excel basics.

Version 

This training is suitable for Windows versions of Excel 2013, 2016, 2019, and 2022, as well as for the 2016 version of Excel for Mac.  

Content

Databases

• Reviewing the basics: Sorting, filtering ja format as table feature
• How do I hide unnecessary data? Grouping and hiding
• Use of a search functions in databases
• Pivot, the most effective way to analyze your data.

Visualizations

• Enhanced use of Excel charts
• Conditional formatting and Sparklines

Keywords 

Excel, charts, graphics, reports, conditional formatting, sparklines, Pivot, Pivot Chart, Slicer