Excel for Sales Professionals
Offered By: LinkedIn Learning
Course Description
Overview
Learn essential features, best practices, and strategies to track, analyze, and forecast sales.
Syllabus
Introduction
- Welcome
- How to use the exercise files
- Get started with a template
- Modify a template and chart
- Add a drop-down list
- Share a template with your team
- Import data from a database
- Import data from a CRM
- Import data from a file
- Cleaning up columns
- Import data from many files
- Query refresh options
- Copy and pasting data
- Cleaning up pasted data
- What is a table?
- Sort and filter
- Slicers
- Automatic rows and columns
- Add a dynamic commission calculation
- Conditional formatting
- PivotTables
- Unpacking PivotTables
- Create a leaderboard
- Leaderboard finishing touches
- PivotCharts
- Funnel charts
- Quick forecasting
- 3D maps
- Multi-tier PivotTables
- Create monthly and yearly summaries
- Create period over period summaries
- Create reports for multiple sales reps
- Start a dashboard with existing PivotTables
- Add PivotCharts to a dashboard
- Add a map chart
- Add a chart with a running total
- Summary
Taught by
Dave Ludwig and Chris B. Smith
Related Courses
Using Covid-19 Data to Make Supply Chain Logistics Decisions in SpreadsheetsCoursera Project Network via Coursera Microsoft Excel - Excel from Beginner to Advanced
Udemy Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy Microsoft Excel Mastery: From Beginner to Pro
Udemy