Excel for Sales Professionals – Chris B. Smith, Dave Ludwig
Topics include:
- Using, modifying, and sharing templates
- Importing data from a database
- Cleaning up data
- Refreshing queries
- Pasting data
- Sorting and filtering tables
- Using slicers
- Adding a dynamic commission calculation
- Using conditional formatting
- Working with PivotTables and PivotCharts
- Creating a leaderboard
- Create period, monthly, and yearly summaries
- Creating dashboard
Contents:
- Introduction
- 1. Getting Started with Templates
- 2. Importing Sales Data
- 3. Working with Tables
- 4. Analyzing Sales Data
- 5. Build Awesome Sales Solutions
- Conclusion
Sale page: Excel for Sales Professionals – Chris B. Smith, Dave Ludwig
Find out more Business & Marketing Courses