Excel Basics and Advanced Functions Guide
Excel Basics and Advanced Functions Guide
1
Why Excel?
Proficiency in Excel is crucial for any business
Analysis – Accessible –
Omnipresent – Easy – Easiest Accurate –
Can present Comes
Everyone uses data entry & Calculations
data & analysis installed on
it analysis tool free of errors
together Windows
Prone to Errors: Since formulae are built by people, there is always a probability of putting in wrong formulae and data entries, resulting in
erroneous calculations & analysis.
Hence, it is advisable to double-check all the inputs & formulae.
2
Contents of this Presentation
Consulting Additional
frameworks slides
4
About Umbrex
A1
BX800
EEE20
Range A contiguous set of cells referenced by the top left and bottom right cells, separated
by a colon (:):
A1:D23
BA2:CT8
Row Cells from left to right
Column Cells from top to bottom
6
6
Contents of this Presentation
Consulting Additional
frameworks slides
Source:_______ 8
Basic Shortcuts (2/3)
Cell Formatting
11. To edit a cell F2 18. To add an outline to the select cells Ctrl + Shift + &
12. To copy and paste cells Ctrl + C, Ctrl + V 19. To move to the next cell Tab
13. To italicize and make the font 20. To move to the previous cell Shift + Tab
Ctrl + I, Ctrl + B
bold
21. To select all the cells on the right Ctrl + Shift + Right arrow
14. To center align cell contents Alt + H + A + C
22. To select all the cells on the left Ctrl + Shift + Left Arrow
15. To fill color Alt + H + H 23. To select the column from the
Ctrl + Shift + Down Arrow
selected cell to the end of the table
16. To add a border Alt + H + B
24. To select all the cells above the
Ctrl + Shift + Up Arrow
17. To remove outline border Ctrl + Shift + _ selected cell
25. To select all the cells below the
Ctrl + Shift + Down Arrow
selected cell
Source:_______ 9
Basic Shortcuts (3/3)
Rows & Columns
Description Excel Shortcuts
Source:_______ 10
Contents of this Presentation
Consulting Additional
frameworks slides
Cells referenced
by a formula
Formula
12
Cell references (continued)
13 13
Absolute cell references
Relative referencing
As a formula is copied along, the
row/column numbers adjust accordingly
Absolute referencing
As a formula is copied along, it continues
to refer to the same cell as before
14 14
Absolute cell referencing
With absolute cell referencing, a dollar sign ($) appears in the cell
reference:
=B4 Refers to column B and row 4,
but this will vary if the formula is copied across a range of cells
(relative reference)
=$B4 Will always refer to column B, but row reference can vary
=B$4 Will always refer to row 4, but column reference can vary
=$B$4 Will always refer to column B and row 4
(absolute reference)
Keyboard shortcut F4 cycles through the four absolute cell reference options
15
12
Contents of this Presentation
Consulting Additional
frameworks slides
17
Example – Delimited text
header
DBN,SCHOOL NAME,Num of SAT Test Takers,SAT Critical Reading Avg. Score,SAT Math Avg. Score,SAT Writing
Avg. Score
01M292,HENRY STREET SCHOOL FOR INTERNATIONAL STUDIES,29,355,404,363
01M448,UNIVERSITY NEIGHBORHOOD HIGH SCHOOL,91,383,423,366
01M450,EAST SIDE COMMUNITY SCHOOL,70,377,402,370 delimiter text qualifier
01M458,FORSYTH SATELLITE ACADEMY,7,414,401,359
01M509,MARTA VALLE HIGH SCHOOL,44,390,433,384
01M515,LOWER EAST SIDE PREPARATORY HIGH SCHOOL,112,332,557,316
01M539,"NEW EXPLORATIONS INTO SCIENCE, TECHNOLOGY AND MATH HIGH SCHOOL",159,522,574,525
01M650,CASCADES HIGH SCHOOL,18,417,418,411
01M696,BARD HIGH SCHOOL EARLY COLLEGE,130,624,604,628
02M047,47 THE AMERICAN SIGN LANGUAGE AND ENGLISH SECONDARY SCHOOL,16,395,400,387
02M288,FOOD AND FINANCE HIGH SCHOOL,62,409,393,392
02M294,ESSEX STREET ACADEMY,53,394,384,378
02M296,HIGH SCHOOL OF HOSPITALITY MANAGEMENT,58,374,375,362
02M298,PACE HIGH SCHOOL,85,423,438,432
02M300,"URBAN ASSEMBLY SCHOOL OF DESIGN AND CONSTRUCTION, THE",48,404,449,416
02M303,"FACING HISTORY SCHOOL, THE",76,353,358,340
02M305,"URBAN ASSEMBLY ACADEMY OF GOVERNMENT AND LAW, THE",50,375,388,385
02M308,LOWER MANHATTAN ARTS ACADEMY,40,403,392,405
02M313,"JAMES BALDWIN SCHOOL, THE: A SCHOOL FOR EXPEDITIONARY LEARNING",69,408,390,390
02M316,"URBAN ASSEMBLY SCHOOL OF BUSINESS FOR YOUNG WOMEN, THE",42,373,370,384
02M374,GRAMERCY ARTS HIGH SCHOOL,60,391,391,394
02M376,NYC ISCHOOL,92,473,483,479
18
Text to columns
• You might have text in one column that should be split across multiple
columns, such as “1-Q-Fred” in the example below
• You can use the “Text to Columns” wizard to accomplish this
19
References to worksheets and workbooks
• You can also use data from other worksheets or other workbooks in your
formulas
• Another worksheet in the same workbook is represented by “Sheet!”
• A worksheet in a different workbook is represented by
“[[Link]]Sheet!”
20
Contents of this Presentation
Consulting Additional
frameworks slides
[Link]: included with Excel, functions are engineered formulas that carry out specific calculations. For example, the PI() function
returns the value of pi: 3.142...
[Link]: refer to individual cells or ranges of cells. A2 returns the value in cell A2
[Link]: numbers or text values entered directly into a formula, such as 2.
[Link]: These are mathematical operators, such as + (add), - (subtract), and so on.
Note:
An equal sign ( = ) is must as the first character in a cell that contains a formula.
Without the = sign, the formula will not calculate anything. It will simply display the text of the formula.
22
Common Functions in Excel
These are the most commonly used functions in Excel (non-exhaustive)
Functions
23
Addition Functions (1/4)
Sum Function
Gives sum of the numbers in the selected range or in the mentioned cell address. It can also result
in the sum of numbers mentioned in the formula itself.
Syntax: =sum(sumrange or absolute numbers)
=sum(A1, B1, C1) The function adds numbers in the cells A1, B1, and C1. If extra
columns with numbers are added between columns A, B, and C,
they would not be calculated in the result.
=sum(A1:C1) The function adds numbers in the range A1:C1
If extra column(s) are added between columns A and C, they
would be incorporated in the formula too.
=sum(A1:C10) The function adds numbers in the range mentioned
=sum(A1:C1, A4:C6, 2, 5) The function adds numbers in the range A1:C1, A4:C6, and the
absolute numbers 2 and 5 altogether.
24
Addition Functions (2/4)
Sumproduct Function
=sumproduct(A1:A10,B1:B1 The function multiplies the value in A1 with B1, A2 with B2, and
0) so on till A10 with B10. The resulting numbers are added
together to give the result.
=sumproduct(A1:A10, The function multiplies the values in A1, B1, and C1 together,
B1:B10, C1:C10) A2, B2, and C2 together, and so on till A10, B10, and C10. The
resulting numbers are added together to produce the final
result.
=sumproduct(A1:A10) The function adds the numbers in the range A1:10.
The size of the arrays being multiplied together must be the same, else the formula would result in
an error
Sumproduct can also be used to apply conditions, much like Sumif. To apply condition, double
negative (- -) is used. The formula below would only add the numbers in the range A1:A10
corresponding to “India” in column C.
=sumproduct(- - (C1:C10=“India”), A1:A10)
25
Addition Functions (3/4)
Sumif Function
=sumif(C1:C10, ”India”, The function would only add the numbers in the range A1:A10
A1:A10) corresponding to “India” in column C.
=sumif(A1:A10, C1:C10, The function only adds the numbers in the range A1:A10
”*tan”) corresponding to the text that ends in ”tan” in column C.
* Is an important tool in Excel which is used to replace text
(more on this later)
Sumrange should be the same size and shape as Criteriarange. If it isn't, performance may
suffer, and the formula will sum a range of cells that starts with the first cell in Sumrange but has
the same dimensions as Criteriarange. For example:
=sumif(C1:C10, “India”, A1:B10) would actually be =sumif(C1:C10, “India”, A1:A10). To incorporate
column B, use
=sumif(C1:C10, “India”, A1:A10) + sumif(C1:C10, “India”, B1:B10)
26
Addition Functions (4/4)
Sumifs Function
Returns the sum of the products based on one or more than one condition(s)
Syntax: =sumifs (sumrange, criteriarange1, criteria1, criteriarange2, criteria2, ….)
Function Description Result
=sumifs(A1:A10, C1:C10, The function only adds the numbers in the range A1:A10
”India”) corresponding to “India” in column C.
=sumifs(A1:A10, C1:C10, The function only adds the numbers in the range A1:A10
”India”, ) corresponding to the text that ends in ”tan” in column C.
* Is an important tool in Excel which is used to replace text
(more on this later)
Sumrange should be the same size and shape as Criteriarange. If it isn't, performance may
suffer, and the formula will sum a range of cells that starts with the first cell in Sumrange but has
the same dimensions as Criteriarange. For example:
=sumif(C1:C10, “India”, A1:B10) would actually be =sumif(C1:C10, “India”, A1:A10). To incorporate
column B, use
=sumif(C1:C10, “India”, A1:A10) + sumif(C1:C10, “India”, B1:B10)
27
Addition Functions (1/4)
Sum Function
What it does?
sums items in a list matching a condition
Syntax:
sumif(in this range,values that meet this criteria,[sum-this-range])
Example:
=sumif(A1:A20,10) = sums the cells with the value of "10"
28
SUMIF
Color Printers Dept Quanity
We want to know how many HP Laser Jet
Printers we have. HP Laser Jet Admin 4
30
AVERAGE
What it does?
averages a group of numbers
Syntax:
average(of this number range)
Example:
=average(2,4,6) 4 5 10
=average(c9:d11) 12.4166667 3.5 20
6 30
31
ROUND
What it does?
rounds a number to the nearest decimal you specify
Syntax:
round(this number, to this many digits after decimal)
Example:
=round(12.416667,2) 12.42
Other:
=rounddown(12.416667,2) 12.41
=roundup(12.416667,2) 12.42
32
Using Rounding for Budgeting
If
And
Or
Not
Choose
Iferror
Istext
35
IF
What it does?
checks whether a condition is met and returns one value if TRUE and another if FALSE
Syntax:
if(is-this-true,then do this, or this)
Example:
=if(25<15,"looser","winner") = winner
Other:
=sumif(condition range,condition, sum range)
36
IFERROR
What it does?
an easy way to handle errors in formulas
IFERROR returns the value you want incase of
an error with the formula
Syntax:
iferror(formula, value to return if there is an error)
Example:
=iferror(1/0,"can't divide by zero") can't divide by zero
=iferror(0/1,"can't divide by zero") 0
37
Summary statistics
COUNT()
Counts numbers
COUNTBLANK()
Counts empty cells
COUNTA()
Counts non-empty cells
MIN()
Returns minimum
MAX()
Returns maximum
AVERAGE()
Returns average/mean
ROWS/COLUMNS()
Return number of
rows/columns
38
38
Status bar
39
27
Find a consultant now
40
Umbrex Services Find a consultant now
• Change Management
• Maternity & Paternity Leave • Talent Management
Organization • Diversity & Inclusion
• Organization Design • Umbrex Academy
• Interim Executives
• Channel Management
Sales
• Sales Effectiveness
Pro bono
41
Industries Umbrex Serves Find a consultant now
42
Umbrex offers flexible options to engage talent Find a consultant now
Seniority Location
Partner
Manager
Associate
Remote On-site
43
Umbrex connects you with a community of Join our community
other top-tier independent consultants
44
You're global and local - Umbrex is, too Find a consultant now
Independent consultants available where you need them –
in every global region
45
Umbrex thought leadership Find a consultant now
Produce Unleashed, the leading Organized over 300 events for Over 1,000 consultants have
podcast on how to thrive as an independent consultants used our video guide to set up
independent professional their own practice
46
How Umbrex can help
47
Umbrex provides resources to help consultants thrive
How To Set Consulting Fees LinkedIn for Consultants: Best Practices to Optimize Your Profile
How To Find Clients For Your Consulting Practice How to Build a Consulting Website
How to Write a Consulting Proposal: Guide and Templates Guide To Setting Up Your Own Practice
Access resources
48
About this document
Subtitle would go right here, but we don’t have one for this slide
This template was created by Umbrex for the free use of independent consultants everywhere.
You can customize this template with your own logo and color scheme.
Find instructions at: [Link]
We are continuing to add new slides to this template. For the latest version, visit that same link.
.01
Title in 1 line
Short description here in 1 or two
lines
01 02 03
Source:_______ 51
Template - Elements
Subtitle
4 CONSIDERATION
Source:_______ 52
Template - Content slide
Subtitle
Consulting Additional
frameworks slides
• Text
Image • Text
• Text
55
Template — Executive Summary 2
Subtitle
xxx
• Sed ut perspiciatis unde omnis iste natus error sit volup • Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor tatem accus antium dolor
• Sed ut perspiciatis unde omnis iste natus error sit volup • Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor tatem accus antium dolor
• Sed ut perspiciatis unde omnis iste natus error sit volup • Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor tatem accus antium dolor
• Sed ut perspiciatis unde omnis iste natus error sit volup • Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor tatem accus antium dolor
• Sed ut perspiciatis unde omnis iste natus error sit volup • Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor tatem accus antium dolor
• Sed ut perspiciatis unde omnis iste natus error sit volup
tatem accus antium dolor
56
Template — Executive Summary 3
Subtitle
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
57
Template — Executive Summary 4
Subtitle
xxx xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed
eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed
eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed
eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed
eget. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
58
Template — Executive Summary 5
Subtitle
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
• Text
• Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
• Text
• Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
• Text
• Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
• Text
• Text
59
Template — Executive Summary 6
Subtitle
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
‒ Text
‒ Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
‒ Text
‒ Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
‒ Text
‒ Text
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed eget. Lorem ipsum dolor sit amet, consectetur adipiscing elite.
• Text
• Text
‒ Text
‒ Text
60
Template — Executive Summary 7
Subtitle
[Complication – what has changed or will change, and what will be the impact]
• Text
• Text
• Text
• Text
61
Template — Description slide
Subtitle
xxx xxx
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
xxx natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
antium dolor
Source:_______ 62
Template — Description slide
Subtitle
xxx xxx
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
xxx
antium dolor
Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste
xxx natus error sit volup tatem accus antium dolor. Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus
antium dolor
Source: 63
Template — Description slide
Subtitle
xxx xxx
01
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
02
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
03
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
04
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
05
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
Source:_______ 64
Template — Description slide
Subtitle
xxx xxx
01
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
02
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
03
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
04
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
05
XXX Sed ut perspiciatis unde omnis iste natus error sit volup tatem accus antium dolor
Source:_______ 65
Template — Description Slide
Subtitle
A B C D E
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit. Sed adipiscing elit. Sed adipiscing elit. Sed adipiscing elit. Sed adipiscing elit. Sed
eget. eget. eget. eget. eget.
Source:_______ 66
Template — Statements
Subtitle
Our mission
Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed
eget.
Source:_______ 67
Template — Four categories
Text Text
Text
Text Text
Source:_______ 69
Template — Table
Subtitle
Text
Text
Text
Text
Text
Text
Text
Text
Person name
Source:_______ 73
Template B — Quote
Person name
Source:_______ 74
Template C — Quote
Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing amet, consectetur adipiscing amet, consectetur adipiscing
Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem amet, consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur
adipiscing elit. adipiscing elit. adipiscing elit.
Source:_______ 75
Template D — Quote
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum
dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet,
consectetur adipiscing consectetur adipiscing
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum
dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit
amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet,
consectetur adipiscing consectetur adipiscing
Source:_______ 76
Template E — Quote
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Lorem consectetur adipiscing elit. Lorem consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor adipiscing elit. Lorem ipsum dolor adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing sit amet, consectetur adipiscing sit amet, consectetur adipiscing
elit. elit. elit.
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit. consectetur adipiscing elit.
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Lorem consectetur adipiscing elit. Lorem
ipsum dolor sit amet, consectetur ipsum dolor sit amet, consectetur
adipiscing elit. Lorem ipsum dolor adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing sit amet, consectetur adipiscing
elit. elit.
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit
Source:_______ 77
Template — Key points diagram
Subtitle
Text
STRENGTHS
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
S ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
W EA K N ESS ES
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
W ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
O P P O RT U N I T I E S
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
O ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
T H R E AT S
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem
T ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor
sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Source:_______ 79
Template B - SWOT Analysis
Subtitle
Source:_______ 80
Template — Checklist
Source:_______ 81
Template — Problem-Solving Process Checklist
Status
1. Define problem
2. Structure problem
3. Prioritize issues
4. Plan analyses
5. Conduct analyses
6. Synthesize findings
7. Craft recommendations
8. Communicate
82
Template — Problem Definition Worksheet
83
Template — Problem Statement
84
Template A — Stakeholder Analysis
85
Template B — Stakeholder Analysis
86
Template A - Statistics table
Text Text
Text Text
Text Text
Text Text
Text Text
Your logo here Source:_______ 89
Template index
Consulting Additional
frameworks slides
xxx
$$$ xxx
Text Text; 20
Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed
eget.
Text Text; 20
Text Text; 20
Text Text; 20
Text Text; 20
Source:_______ 91
Template — Stacked bar chart
Subtitle
xxx
$$$ xxx
Source:_______ 92
Template — 100% Stacked bar chart
Subtitle
xxx
$$$ xxx
Text Text
Lorem ipsum dolor sit amet,
Text Text; 20 Text2; 20 consectetur adipiscing elit. Sed
eget.
Source:_______ 93
Template — Clustered bar chart
Subtitle
xxx
$$$ xxx
Social Media; 35
Lorem ipsum dolor sit amet,
Between 40-60 Business; 18 consectetur adipiscing elit. Sed
eget.
Entertainment; 35
Social Media; 22
Entertainment; 25
Social Media; 20
Under 18 Business; 24
Entertainment; 43
Source:_______ 94
Template — Waterfall bar chart
Subtitle
xxx
$$$ xxx
Text Text; 30
Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed
eget.
Text Text; 60
Source:_______ 95
Template — Bar chart with words
Consulting Additional
frameworks slides
xxx
$$$
80
70
60
50
40
30
20
10
Source:_______ 98
Template - Stacked column chart
Subtitle
xxx
$$$
10 Text
10
10
10
10
80 Text
10 70
60
10 50
40
10 30
20
10
Source:_______ 99
Template - 100% stacked column chart
Subtitle
xxx
$$$
10 10 10 Text
10 10
10
10
10
60 70 80 Text
40 50
30
20
10
Source:_______ 100
Template - Clustered column chart
Subtitle
xxx
$$$
10 10 10 10
5 5 5 5
Source:_______ 101
Template - Waterfall column chart
Subtitle
xxx
$$$ xxx
Source:_______ 102
Template - Vertical dot chart
Subtitle
48%
40% 40%
38% 37%
Text Text
Text
Text
Source:_______ 103
Template - Grouped column chart
Subtitle
xxx
$$$ xxx
Business; 44
Entertainment; 43
Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed
Entertainment; 35 Social Media; 35 eget.
Entertainment; 25
Business; 24
Social Media; 22
Social Media; 20
Business; 18
Source:_______ 104
Template - Multiple column chart
Subtitle
xxx
$$$
2000
1600
1200
800
400
0
2016 2017 2018 2019 2020
Source:_______ 105
Template – Pyramid column chart
Subtitle
YOUR TITLE
YOUR TITLE
YOUR TITLE
YOUR TITLE
YOUR TITLE
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed [Link] ipsum dolor sit
amet, consectetur adipiscing elit. Sed [Link] ipsum dolor sit amet, consectetur adipiscing elit. Sed eget..
Source:_______ 106
Template - Combination chart
Subtitle
6 5
4.5
4.3 4.5
5
4
3.5
3.5
4
3
2.5
3 2.5
2
2
1.5
1
1
0.5
0 0
Categoría 1 Categoría 2 Categoría 3 Categoría 4
xxx
xxx
xxx
Source:_______ 108
Template - Histogram
Text
Text
Text
xxx xxx
35 30
30 25
25
20
20
15
15
10
10
5 5
0 0
1 2 3 4 5 1 2 3 4 5
xxx xxx
30
25
20
15
10
0
5 4 3 2 11 2 3 4 5
xxx xxx
Consulting Additional
frameworks slides
xxx
$$$
150 Title 01
Lorem ipsum dolor sit amet,
consectetur adipiscing elit.
120
90
Title 02
60
Lorem ipsum dolor sit amet,
consectetur adipiscing elit.
30 Title 03
Lorem ipsum dolor sit amet,
consectetur adipiscing elit.
0
2013 2014 2015 2016 2017 2018 2019 2020
Source:_______ 116
Template - Vertical line chart
Subtitle
Category 5
Category 4 Series1
Series3
Category 3 Series5
Series7
Category 2
Category 1
Source:_______ 117
Template - Multiple line chart
Subtitle
90 90 90
60 60 60
30 30 30
0 0 0
2016 2017 2018 2019 2020 2016 2017 2018 2019 2020 2016 2017 2018 2019 2020
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur
adipiscing elit. adipiscing elit. adipiscing elit.
Source:_______ 118
Template - Data over time line chart
Subtitle
Text
5
Text
3
Text
1
Text Text Text
0
2018 2019 2020 2021
Source:_______ 119
Template - Growth curve line chart
Subtitle
36%
Text
27%
Text 22%
Text
10%
5% Text
Text
Source:_______ 120
Template — Product Life Cycle
Intro-
Innovators duction Growth Maturity Decline
XXX
12
10 Text
Text
6
Text
0
Text Text Text Text Text Text
Source:_______ 122
Template - Arrow line chart
Subtitle
Text 8
Text 7
Text 6
Text 5
4 Text
3 Text
2 Text
1 Text
Source:_______ 123
Template - Evolution Chart
Subtitle
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit.
100
80
60
40
20
0
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Source:_______ 124
Template - Radial chart
Subtitle
Text
40
20
Text Text
0
Text
Text
Text Text
Source:_______ 125
Template index
Consulting Additional
frameworks slides
25% 25%
Text Text
Source:_______ 127
Template - Doughnut chart
Subtitle
Text Text
25% 25%
25% 25%
Text Text
Source:_______ 128
Template - Multiple Doughnuts
Subtitle
Source:_______ 129
Template - Multiple Doughnuts
Subtitle
01 03
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit.
Sed eget. Sed eget.
02 04
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit.
Sed eget. Sed eget.
Source:_______ 130
Template - Harvey Ball Slide
Subtitle
Source:_______ 131
Template - Harvey Ball Slide
Subtitle
xxxx
xxxx
xxxx
xxxx
xxxx
Source:_______ 132
Template - Harvey Ball Slide
Subtitle
Source:_______ 133
Template - Harvey Ball Map Slide
Subtitle
Your Title
Lorem ipsum dolor
sit amet, consectetur
Your Title
Lorem ipsum dolor
sit amet, consectetur
Your Title
Lorem ipsum dolor
sit amet, consectetur
Source:_______ 134
Template - Wheel chart
Subtitle
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit.
Sed eget. Sed eget.
xxx
XXX
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit.
Sed eget. Sed eget.
Source:_______ 135
Template index
Consulting Additional
frameworks slides
35
30
25
Text
20
15
10
Text
5
0
2019 2020 2021 2022 2023
Source:_______ 137
Template - Proportional area chart
Subtitle
Source:_______ 138
Template - Rectangle area chart
Subtitle
Source:_______ 139
Template index
Consulting Additional
frameworks slides
Text
X% X% X%
Text Text Text
Text Text
Text Text
Text
3.5
Valores Y; 3.2
3
Valores Y; 2.7
2.5
1.5
1
Valores Y; 0.8
0.5
0
0.5 1 1.5 2 2.5 3
Source:_______ 143
Template - Scatter chart with four quadrants
Subtitle
3.5
Text Text
Value Y; 3.2
3
Value Y; 2.7
2.5
1.5
1
Text Text
Value Y; 0.8
0.5
0
0.5 1 1.5 2 2.5 3
Source:_______ 144
Template - Scatter chart with segmentation
Subtitle
3.5
Text
Valores Y; 3.2
3
Text
Valores Y; 2.7
2.5
1.5
1 Text
Valores Y; 0.8
0.5
0
0.5 1 1.5 2 2.5 3
Source:_______ 145
Template - XY Bubble chart
Subtitle
3.5
4
3
Text
10
2.5
Text
1.5
1
8
Text
0.5
0
0.5 1 1.5 2 2.5 3
Source:_______ 146
Template index
Consulting Additional
frameworks slides
• Text
Text
Text Text
Text Text
Text
• Text
Source:_______ 148
Template - Repeating process
Subtitle
1 Text
• Text
• Text
2 Text 3 Text
• Text • Text
• Text • Text
Source:_______ 149
Template - Timeline
Subtitle
1 2 3
Source:_______ 150
Template - Boat chart
Subtitle
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Source:_______ 151
Template - Boat chart horizontal
Subtitle
Lorem ipsum dolor sit Lorem ipsum dolor sit amet, Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur consectetur adipiscing elit amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Source:_______ 152
Template - Boat chart
Subtitle
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Source:_______ 153
Template - Boat chart vertical
Subtitle
XXX
Lorem ipsum dolor sit amet, consectetur adipiscing elit
Text
XXX
Lorem ipsum dolor sit amet, consectetur adipiscing elit
Text
XXX
Lorem ipsum dolor sit amet, consectetur adipiscing elit
Text
Source:_______ 154
Template - From-to chart
Subtitle
From To
Source:_______ 155
Template - Circular process
Subtitle
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed consectetur adipiscing elit. Sed
eget. eget.
xxx
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit. Sed
eget.
Sed eget.
Source:_______ 156
Template - Circular process
Subtitle
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. Sed consectetur adipiscing elit. Sed
eget. eget.
xxx
xxx xxx
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet,
consectetur adipiscing elit. consectetur adipiscing elit. Sed
eget.
Sed eget.
Source:_______ 157
Template - Journey Slide
Subtitle
YOUR YOUR
TITLE TITLE
Lorem ipsum Lorem ipsum
dolor sit amet, dolor sit amet,
consectetur consectetur
adipiscing elit adipiscing elit
Source:_______ 158
Template - Linear Process
Subtitle
YOUR TITLE 1 YOUR TITLE 2 YOUR TITLE 3 YOUT TITLE 4 YOUR TITLE 5
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Source:_______ 159
Template - Linear Process
Subtitle
YOUR TITLE YOUR TITLE YOUR TITLE YOUR TITLE YOUR TITLE
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Source:_______ 160
Template - Snake process
Subtitle
Source:_______ 161
Template - Go-To-Market Slide
Subtitle
A B C D E
XXXX XXXX
Source:_______ 162
Template - Project timeline
Subtitle
JAN ‘19 FEB ‘19 MAR ‘19 APR ‘19 MAY ‘19 JUN ‘19 JUL ‘19 AUG ‘19 SEP ‘19 OCT ‘19 NOV ‘19 DEC ‘19
YOUR TITLE
YOUR TITLE
Source:_______ 163
Template - Customer Touchpoints
Subtitle
xxxx
xxx
xx
xxx xxx
xxxx
xxx xxx
xxx
xx xxx
xxxx xxxx
xxxx
Source:_______ 164
Template - Customer Phases
Subtitle
Expectations
Touchpoint Touchpoint
Touchpoint
Touchpoint
Touchpoint
Touchpoint
Touchpoint
Touchpoint
Touchpoint
Touchpoint Touchpoint
Touchpoint
Touchpoint
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
Voice Of
Customer
Source:_______ 165
Template - Hype cycle
Text
Text
Text
Text
Text
Text
Text
Text Text
Text
Text
Text Text
Text
Text
Your logo here Source:_______ 166
Template - Business workflow
Subtitle
END
consectetur consectetur consectetur consectetur
adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit.
Source:_______ 167
Template – Circular process
Subtitle
• XXX • XXX
• XXX
• XXX
03 • XXX
• XXX
02
04
• XXX • XXX
• XXX • XXX
• XXX • XXX
01
05
• XXX • XXX
• XXX
• XXX 06 • XXX
• XXX
Source:_______ 168
Template - Road flow chart
Subtitle
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
Source:_______ 169
Template - Plans vs. actual chart
Subtitle
XXX
XXX
XXX
XX XX XX
xxx xxx
X X X
Text
Text Text Text Text Text
Text
Text
Text
Text
Text
Text Text
Text Text
Text Text
Text Text
1 YOUR TITLE 5
YOUR TITLE 6
3
YOUR TITLE
Source:_______ 176
Template - Decision Tree
Subtitle
xxx
Lorem ipsum dolor sit amet, consectetur adipiscing elit Lorem ipsum dolor sit amet, consectetur adipiscing elit Lorem ipsum dolor sit amet,
consectetur adipiscing elit Lorem ipsum dolor sit amet, consectetur adipiscing elit Lorem ipsum dolor sit amet, consectetur adipiscing elit Lorem
ipsum dolor sit amet, consectetur adipiscing elit Lorem ipsum dolor sit amet, consectetur adipiscing elit Lorem ipsum dolor sit amet, consectetur
adipiscing elit Lorem ipsum dolor sit amet, consectetur adipiscing elit
Source:_______ 177
Template — Hypothesis Tree
Text
Text
Text
Text
Text Text
Text
Text Text
178
Template — Issue Tree
Text
Text
Text
Text
Text
Text
Text Text
Text Text
Text
Text
Text
Text
179
Template – Gantt chart
Subtitle
Text Text
Text Text
Text Text
Text Text
Text Text
Source:_______ 180
Template — Plan Analyses
Timing /steps /
Issue or hypothesis Analysis Sources of insight End product
responsibility
xxx xxx xx xxx xxx
181
Template — Analysis Plan
182
Template — High-level Workplan
Subtitle
Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11 Week 12
YOUR TITLE
YOUR TITLE
183
Template — 5-Week Workplan
Subtitle
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
Heading Lorem ipsum dolor sit Lorem ipsum dolor Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur sit amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit adipiscing elit adipiscing elit adipiscing elit adipiscing elit
184
Template — One-Week Workplan
Subtitle
xx xx xx
xxx
xx xx xx
xxx
xx xx xx
xxx
xx xx xx
xxx
185
Template — Image timeline
Text
Text
Text Text
Text Text
Text
Text
Text
Text Text
Text
Text
Text Text Text
Text
Text Text
Text
Text Text
Text
Text Text
Consulting Additional
frameworks slides
xxxx xxxx
xxxx xxxx
xxxx xxxx
xxxx
Source:_______ 189
Template - Hierarchy Infographic
Subtitle
TITLE 01
Lorem ipsum dolor sit
amet, consectetur
Source:_______ 190
Template - Business systems/hierarchy
Subtitle
Text Text
Text Text
Text Text
Text Text
Text Text
Source:_______ 191
Template - Many-to-one chart
Subtitle
Text
Text
Text
Text Text
Text
1
Text Text Text Text Text Text
2
Text Text Text Text Text Text
3
Text Text Text Text Text Text
4
Text Text Text Text Text Text
5
Text Text Text Text Text Text
Text Text
Text
Text
Text
Text Text
Label name
Y Label
Label name
Source:_______ 196
Template - 3x2 Matrix
Label name
Y Label
Label name
Source:_______ 197
Template - 3x3 Matrix
Label name Label name Label name
Y Label
Source:_______ 198
Template index
Consulting Additional
frameworks slides
• XXX • XXX
• XXX • XXX
• XXX xxx xxx • XXX
• XXX • XXX
• XXX xxx xxx • XXX
xxx
• XXX • XXX
Source:_______ 200
Template – Hexagon concept
Text Text
Text Text
Text Text
Text Text Text
Text Text
Text Text
Text
Text Text
Text Text
Text
Text
Text Text
Text Text
Text
Text
Text
Text
Text Text
Text Text
Text
Text
Text
Te Text
xt
xt
Te
Text
Text
TITLE 01 TITLE 01
Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
01 Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
CHALLENGES
SOLUTIONS
TITLE 02 TITLE 02
Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
02 Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
TITLE 03 TITLE 03
Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
03 Lorem ipsum dolor sit amet, consectetur
adipiscing elit.
Source:_______ 207
Template - Challenges and solutions
Subtitle
CHALLENGES SOLUTIONS
CHALLENGE 01 SOLUTION 01
CHALLENGE 02 SOLUTION 02
CHALLENGE 03 SOLUTION 03
High-risk Interpersonal
Alternatives Uncertainty Consequences Issues Complexity
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit.
Source:_______ 209
Template - Decision Diagram
Subtitle
High-risk Interpersonal
Alternatives Uncertainty Consequences Issues Complexity
Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit Lorem ipsum dolor sit
amet, consectetur amet, consectetur amet, consectetur amet, consectetur amet, consectetur
adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit. adipiscing elit.
Source:_______ 210
Template - Tree diagram
Subtitle
Text
Text Text
Text Text
xxx
xxx
Source:_______ 212
Template – Funnel chart
Subtitle
Source:_______ 214
Template - Mind map
Subtitle
Text
Text Text
Text Text
Text
Text Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
Text
xxx xxx
4 Text
3 Text
• Text
• Text
2 Text
• Text
1 Text
• Text
Text
xxx xxx
xxx
xxx xxx
XXX XXX X
XXX XXX X
XXX XXX X
XXX XXX X
XXX XXX X
XXX XXX X
xxx xxx xxx
XX XX XX XX
xxx xxx
xxx xxx
Text
Text
Text
Text Text
Text
Text Text
Text
Text Text
Text Text
Text Text
Text
Text Text
Text
Text
XXX
Text
Text
Text
Text
Text Text
Text Text
Text
Text
Text
Text
Text
Your logo here Source:_______ 231
Template - Three axis diagram
Text
Text
Text
Text Text Text
Text
Text
Text
Text
Consulting Additional
frameworks slides
Text
Text
Text Text
Text
Text
Text
Text Text Text Text Text Text Text
NA EU AS NA EU AS
ME ME
AF AF
OC OC
LA LA
Text X
Text
X Text
X
X
X X Text
X
X
X
X Text
X
X
X
X X
X Text
X Text
X Text
X Text
X Text
X Text
X Text
X Text
X Text
X Text
Consulting Additional
frameworks slides
Intensity of
competition from
existing
competitors
Text
• Text
Text
• Text
t
Tex
Text
Text
• Text
Text
• Text
t
Tex
Your logo here Source:_______ 240
Template — Porter's Generic Strategies
XXX
XXX XXX
XXX XXX
XXX XXX
XXX
XXX
XXX XXX
XXX XXX
XXX
• Text • Text
• Text • Text
• Text • Text
Structure
Lorem ipsum dolor sit amet, consectetur
Lorem ipsum dolor sit amet, consectetur
adipiscing elit. Ut elit tellus, luctus nec
adipiscing elit. Ut elit tellus, luctus nec
ullamcorper mattis, pulvinar dapibus leo.
ullamcorper mattis, pulvinar dapibus leo.
Strategy Systems
3C’s Strategy
• XXX
Company
• XXX
Customers
• XXX
Competitors
• XXX • XXX
Product Price
• XXX • XXX
Place Promotion
Driving force (positive forces for change) Restraining forces (Obstacles to change)
XXX XXX
1
XXX XXX
2
XXX XXX
3
XXX XXX
4
XXX XXX
10 MM
Volume
Revenue segment
• By segment
$300 MM • By product
• By geography
Revenues
$30
Price per unit
Fixed expense
$100 MM
• Rent
Profits • Staff overhead
• XXX
$80 MM
$10 MM
Fixed costs
Volume
$200 MM
Variable expenses
Costs
• Raw materials
$120 MM $12 • Delivery
• XXX
Variable costs Cost/ unit
XXX XXX
• XXX • XXX
• XXX • XXX
• XXX Text • XXX
• XXX • XXX
• XXX • XXX
• XXX Text • XXX
• XXX • XXX
• XXX • XXX
• XXX Text • XXX
• XXX • XXX
• XXX • XXX
• XXX Text • XXX
XXX
• XXX
• XXX
• XXX
• XXX
XXX XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
• XXX • XXX
Observability Complexity
• Lorem ipsum dolor sit amet, consectetur • Lorem ipsum dolor sit amet, consectetur
adipiscing elit. 5 3 adipiscing elit.
Trialability
4 • Lorem ipsum dolor sit amet, consectetur adipiscing elit.
S I P O C
Supplier Inputs Process Outputs Customers
• XXX • XXX • XXX • XXX • XXX
• XXX • XXX • XXX • XXX • XXX
• XXX • XXX • XXX • XXX • XXX
Political • Text
P
Economic • Text
E
Social • Text
S
Technological • Text
T
Legal • Text
L
Environmental • Text
XXX
XXX • XXX
XXX
XXX
• XXX
XXX
• XXX
XXX
XXX
• XXX
XXX
XXX
• XXX XXX
Horizon 3
Seed future business (es)
>5 years
Value
Horizon 2
Foster emerging
3-5 years
Horizon 1
Maintain and defend core business
1-3 years
Time
Lorem ipsum dolor sit amet, Lorem ipsum dolor sit amet, consectetur
consectetur adipiscing elit. adipiscing elit.
People Structure
Star
model
Lorem ipsum dolor sit amet, consectetur Lorem ipsum dolor sit amet, consectetur
adipiscing elit. adipiscing elit.
Rewards Process
Consulting Additional
frameworks slides
xxx
$$$
xxxx xxxx xxxx xxxxx
100
12 xxxx
90 17 17
80 15 xxxx
45
70 23 25
17 xxxx
60
10 5 xxxx
50 16
15
40 20
10
30 27
5 51 xxxx
20
30
25
10
15
0
0 0 12.5 25 25 25 37.5 50 50 50 62.5 75 75 75 87.5 100 100
Source:_______ 260
Template - Percentage breakdown (circles)
Subtitle
xxx
xxx xxx
xxx