In this course, we dive into enhanced features of Excel. You will learn how to create effective and functional graphics with Pivot table.
Goals
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.
Software requirements
Excel Windows versions 2010, 2013, 2016, 2019, 365 and 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
Reviews
There are no reviews yet.