Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Excel for Sales Professionals (2017)

via LinkedIn Learning

Write review

Details

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

2 hours 43 minutes
Sessions

Self-Paced
Level

Intermediate

Found in

Boot.dev

The Fastest Way to Become a Backend Developer Online

Coursera

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Learn essential features, best practices, and strategies to track, analyze, and forecast sales.

Syllabus

Introduction

Welcome
How to use the exercise files

1. Getting Started with Templates

Get started with a template
Modify a template and chart
Add a drop-down list
Share a template with your team

2. Importing Sales Data

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

3. Working with Tables

What is a table?
Sort and filter
Slicers
Automatic rows and columns
Add a dynamic commission calculation

4. Analyzing Sales Data

Conditional formatting
PivotTables
Unpacking PivotTables
Create a leaderboard
Leaderboard finishing touches
PivotCharts
Funnel charts
Quick forecasting
3D maps

5. Build Awesome Sales Solutions

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

Conclusion

Summary

Taught by

Dave Ludwig and Chris B. Smith

Reviews

4.7 rating at LinkedIn Learning based on 597 ratings

Start your review of Excel for Sales Professionals (2017)