In this course, we dive into enhanced features of Excel. You will learn how to create effective and functional graphics with Pivot table.
After this training, you will be able to use Excel effectively and, you will learn how visualize your data with different tools.
This course is for people who already master Excel basics.
Excel Windows versions 2010, 2013, 2016, 2019, 365 and Excel for Mac.
- 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.
- Enhanced use of Excel charts
- Conditional formatting and Sparklines
Excel, charts, graphics, reports, conditional formatting, sparklines, Pivot, Pivot Chart, Slicer