Workiva Inc. · NYSE:WK
Workiva — Investor Presentation (August 2024)
35 slides from Workiva's investor presentation, August 2024
Slide 1: The Basics of Spreadsheets
The Basics of Spreadsheets Why do we need a Spreadsheet? YOUR LOGO HERE
Slide 2: Why do we need a Spreadsheet?
The Basics of Spreadsheets Why do we need a Spreadsheet? • Spreadsheets stand as a central location for finalized data ◦ 1 place to update - values, dates, text, etc. ◦ Link out to various documents, charts, presentations, other spreadsheets, etc. YOUR LOGO HERE
Slide 3: Why do we need a Spreadsheet?
The Basics of Spreadsheets Why do we need a Spreadsheet? • Spreadsheets stand as a central location for finalized data ◦ 1 place to update - values, dates, text, etc. ◦ Link out to various documents, charts, presentations, other spreadsheets, etc. • Data can be brought into the Workiva Platform via
Slide 4: Why do we need a Spreadsheet?
The Basics of Spreadsheets Why do we need a Spreadsheet? • Spreadsheets stand as a central location for finalized data ◦ 1 place to update - values, dates, text, etc. ◦ Link out to various documents, charts, presentations, other spreadsheets, etc. • Data can be brought into the Workiva Platform via
Slide 5: The Spreadsheet
The Spreadsheet YOUR LOGO HERE
Slide 6: The Spreadsheet - What's similar
The Spreadsheet - What's similar YOUR LOGO HERE
Slide 7: The Spreadsheet - Right Hand Panel - Properties
The Spreadsheet - Right Hand Panel - Properties YOUR LOGO HERE
Slide 8: The Spreadsheet - Right Hand Panel - Properties
The Spreadsheet - Right Hand Panel - Properties YOUR LOGO HERE
Slide 9: The Spreadsheet - What's Unique
The Spreadsheet - What's Unique YOUR LOGO HERE
Slide 10: The Spreadsheet - What's Unique
The Spreadsheet - What's Unique YOUR LOGO HERE
Slide 11: Real-time Collaboration in a Spreadsheet
Real-time Collaboration in a Spreadsheet • Multiple users can make edits simultaneously • Changes update real-time (although you need to publish updates to linked values) • The overlay: Authorship shows who made what change Note: Each user is designated a different color in the Spreadsheet; you will
Slide 12: Demo Spreadsheets
Demo Spreadsheets • Authorship • Overlays • Formula Properties • Publish/Partial Publish • Revision History • Milestones
Slide 13: Create a Spreadsheet
Create a Spreadsheet Your Turn! 1. From Wdesk Home a. Click Create > Spreadsheet > Spreadsheet from Template b. Choose the Workiva Platform Training - SS Template Spreadsheet 2. Go to File in Spreadsheet > Rename and change name to "YourName SS - MM.DD.YY" 3. Move your spreadsheet to the Participant
Slide 14: Getting Data into a Spreadsheet
Getting Data into a Spreadsheet What are the ways to get data into a Spreadsheet? • Frequent updates and/or large amounts of data ◦ Connected sheets ▪ Connect data from an external source - most secure form ◦ Import from csv or xlsx ◦ Wdesk Sync • Infrequent or small amounts of data ◦ Copy/paste fro
Slide 15: Update the Dates Template - SS - Activity
Update the Dates Template - SS - Activity Your Turn! 1. Update the blue input cells 2. Select "Reporting Period" 1, 2, 3 or 4 a. 1 means Q1 (period ending March 31) b. 2 means Q2 (period ending June 30) c. 3 means Q3 (period ending September 30) d. 4 means Q4 (period ending December 31) 3. Update th
Slide 16: Spreadsheets
?s Spreadsheets
Slide 17: Linking - Why is it so AWESOME?
Linking - Why is it so AWESOME? • Eliminates the inefficiency of manually updating the same number that appears in many places • Eliminates the human error from manual processes • Makes rolling forward your document an efficient process • Saves time once established Note : Linking streamlines data u
Slide 18: Linking - When to Link?
Linking - When to Link? • When you have dates, text and/or numbers that appear in multiple places in one or more documents ◦ Month End, Quarter End, Year End ◦ Company Name • When this type of data needs to be updated frequently • If working with documents requiring iXBRL, be careful with linking, a
Slide 19: Linking - What does it Look like?
• Blue = Source Link (only 1) • Green = Destination Link (many) Linking - What does it Look like? EXAMPLE DOCUMENT EXAMPLE SPREADSHEET
Slide 20: Demo Linking
Demo Linking • Creating Links ◦ 1:1 ◦ 1:many ◦ Subcell • Formatting Links • Updating the Source • Publish
Slide 21: Linking Dates - Activity
Linking Dates - Activity Your Turn! 1. Browse your document for dates that should be linked a. What is the first section in your document that contains a date? b. What is the date? 2. Go to the "Dates Template" section in the Spreadsheet a. Locate the date you just found b. Copy that cell 3. Go to w
Slide 22: Linking Numbers - Tables - Activity
Linking Numbers - Tables - Activity Your Turn! 1. From the "Performance" section in your Spreadsheet a. Copy all the numbers in the table 2. From your Table in the Document a. Click on the upper left most cell that has a number in it b. Paste c. From the clipboard select: i. Create links from . . .
Slide 23: Linking Numbers - Text - Activity
Linking Numbers - Text - Activity Your Turn! 1. Check the "Overview" section in your document - does it contain any numbers we should link? 2. Get data set up and ready for linking a. Start by creating an "Overview" section in the Spreadsheet b. Type 3,000 and 70% into the Spreadsheet section c. Typ
Slide 24: More Linking - Activity
More Linking - Activity Your Turn! Continue linking numbers in text 1. From the Spreadsheet you will be linking the following numbers: 2. You will need to add these to the Spreadsheet then, link to your Document. 3. Link the following numbers to the "Performance" section a. $29.2 million b. $26.2 mi
Slide 25: Linking
?s Linking
Slide 26: Entered In / Shown In
Entered In / Shown In Gives you the flexibility to enter the numerical value into the spreadsheet as one value and then convert the same number into different value formats at the destination links. This is also applicable when we are talking about rounding. YOUR LOGO HERE
Slide 27: Entered In/Shown In - What does it Look like?
Entered In/Shown In - What does it Look like? EXAMPLE DOCUMENT EXAMPLE SPREADSHEET
Slide 28: Linking - When does it pay off?
Linking - When does it pay off? Let's pretend a quarter has gone by. You need to update all the values and dates in your document to reflect the new quarter's info. Let's see what that would look like - this is referred to as "rolling forward". Note: You might find the split screen feature useful wh
Slide 29: Demo Rolling Forward
Demo Rolling Forward • Roll to a new Quarter • Update values • Publish
Slide 30: Link Properties
Link Properties Link Properties give users a way to navigate their linking structure quickly. So long as you have permissions to all locations you can use link properties to check your linking structure What if you need to update a date in the Document (for example) but you are not sure where that d
Slide 31: Link Properties
Link Properties Your Turn! 1. Locate a destination link in your document 2. Right-click on it and select "Link Properties" 3. Note that it shows a. Where the source is located b. Where all the destinations are located 4. Go ahead and navigate back to the source (do this by either double-clicking on
Slide 32: Linking
?s Linking
Slide 33: Support Center Resources
Support Center Resources • Keyboard Shortcuts - Workiva Icon on right side • Support Chat • ? - Support Center ◦ Help ◦ Community ◦ The Learning Hub YOUR LOGO HERE
Slide 34: Learning Objectives
Learning Objectives By the end of this session , you will be able to: • Access Wdesk • Navigate and Organize Home • Create/Edit Documents, Spreadsheets, and Presentations • Make Documentation Interactive • Utilize Digital Review features • Access Additional Resources YOUR LOGO HERE
Slide 35: Questions?
?s Questions? contact email