Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

UpSlide Product Knowledge > Excel > Flashcards

Excel Flashcards

Master UpSlide functionality in Excel

1
Q

How should you demo features?

A

Frame your demo of each feature by re-iterating their challenge.

‘Currently you do X when linking. As you said this is wasting time and meaning you’re turning down business mandates. I’ll show you how we can fix all that with our Link’

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How does our smart formatting apply to complex charts and tables?

A

You will give us a default table style that smart format will auto-apply to every table. E.g., first line = title, second line = heading, last line = result)

Changing line styles is easy if you need to tweak anything

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What images pull through from Excel to PPT?

A

Enhanced meta files. Lighter than embedding full data set but also much higher quality than a standard image.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do I make a last minute change? Can I do that in PPT?

A

Our default link takes Excel as the source of truth and so if you use this link, you will have to make changes in Excel. Easily done with ‘go to source’.

But if you prefer, you can export data as a PPT table and use this flipped link.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How does UpSlide resize and export?

A

For a table, all it does is resize the first column’s width, all other columns stay consistent.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

How does the sizing guide work?

A

Select the top left box of a table/chart and then click the sizing guide button and resize as needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Where can you add / not add columns in a table?

A

Adding to the middle is fine, adding to the end won’t pull through

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the primary function of the Excel Link Manager in UpSlide?

A

It allows users to monitor, update, and manage all links between Excel and other documents, ensuring data consistency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How can you view link information in UpSlide?

A

Open the Link Manager and select a link to view its details, such as the source file and last update time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What should you do if a data source changes location?

A

Use the Link Manager to update the source path, ensuring the links point to the new file location.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What does the Advanced Export feature in UpSlide allow you to do?

A

It allows the user to preserve cell visibility in tables allowing the same table to be exported more than once and showing different values.

It also allows the user to preserve image width as opposed to automatically changing with the standard export.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Why is resizing your table or chart important before exporting to PowerPoint?

A

Proper resizing ensures that the exported elements fit well within the slide layout, maintaining visual consistency.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Can you change the way charts are exported?

A

Yes, UpSlide’s default is to modify the chart’s width only. But in settings you can toggle ‘Resize Chart Height’ and make the chart fit the exact area, not just the width.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Can we create custom shortcuts?

A

Yes, in settings you can edit the preset shortcuts to be whatever you want.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

How can we ensure consistency across Excel settings?

A

Ensure everyone has ‘use team settings’ toggled on.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How can you add CAGR arrows to charts in UpSlide?

A

Select the chart, go to the UpSlide ribbon, and click the CAGR button to insert arrows indicating compound annual growth rates.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is the purpose of UpSlide’s Advanced Paste feature? And what exactly is Advanced Paste?

A

The purpose is to save time when building complex financial models.

There are 4 different advanced paste options:
Preserve Formulas, Duplicate Formulas, Row Heights + Number Formats Only

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What does ‘preserve formulas’ do?

A

Pastes the exact same values and formulas as the original data.

19
Q

What does ‘duplicate formulas’ do?

A

Pastes the table and keeps the formulas, but the values can be changed

20
Q

How can you use the Fast Fill feature in UpSlide?

A

Fast Fill in UpSlide works like Excel’s native fill function but does not require preselecting the destination range. To use it, select a single cell and press Ctrl + Alt + D for Fill Down or Ctrl + Alt + R for Fill Right. UpSlide intelligently detects how far to fill based on surrounding data​

21
Q

What is the IfError feature and how do you apply it?

A

It wraps formulas in an IFERROR function to handle errors gracefully. To apply it, highlight the target cells, select IfError from the Formulas dropdown in the UpSlide ribbon, enter an error value or message, and click OK. This will apply the IFERROR function to each highlighted cell​

22
Q

How do you use the CAGR formula feature in UpSlide?

A

Select the target cell, choose CAGR from the Formulas dropdown in the UpSlide ribbon, select the data range and period (Annual, Quarterly, or Monthly) in the pop-up window, and click OK. UpSlide will automatically try to determine the data range based on adjacent cells​

23
Q

What is the purpose of the cleaning tools in UpSlide?

A

UpSlide’s cleaning tools help optimize workbook size, remove unnecessary data, and prepare files for sharing or presentation. These tools ensure that workbooks are efficient and free of clutter, making them easier to work with and share​

24
Q

How do UpSlide’s collaboration tools enhance teamwork in Excel? 3 key features.

A

UpSlide’s collaboration tools facilitate teamwork by offering features for:
- co-authoring
- sharing links
- tracking changes

These tools enable multiple users to work on the same document simultaneously and ensure that everyone is on the same page​

25
Q

How can you set up theme colors in Excel to reflect your company’s branding using UpSlide?

A

Go to Page Layout > Colors dropdown > select your custom palette. Save as a template (File > Export > Change File Type > Template *.xltx) to apply to new workbooks​

26
Q

Is it possible to undo formatting actions in UpSlide?

A

Yes, just use CTRL + Z as normal

27
Q

Why is it important to resize tables or charts before exporting them to PowerPoint or Word using UpSlide?

A

Resizing ensures they fit well within the slide or document, maintaining visual consistency and readability​

28
Q

Is it possible to add effects to a Waterfall (Bridge) chart using UpSlide?

A

Yes, UpSlide provides options to customize and enhance Waterfall charts with various effects​

29
Q

What causes a warning when building a Waterfall chart in UpSlide?

A

Warnings usually occur due to data range or formatting issues. Ensure the data range is properly selected and formatted​

30
Q

What is the key benefit of Smart Format?

A

It’s about ensuring consistency across the team so that every practitioner is formatting tables/charts etc in the same way

It’s a little bit about time saving too, but this isn’t the main attraction

31
Q

How much is the extra modelling solution?

A

€200

32
Q

What does the native Excel tracking do and what is it called?

A

It is called tracking precedence + dependence

It just shows an arrow pointing off screen to say there is an error somewhere else in the excel file, it doesn’t show you exactly where like UpSlide’s does (using arrow keys)

33
Q

How should you go through Autocolour?

A

No need to go through one by one, just say it shows clearly different results in different colours
- hard coded (black)
- references (green)
- formulas

34
Q

Can you add multiple CAGR arrows?

A

Yes, in charting, go to CAGR add the first one then push ‘add’ below and add the second

35
Q

Can you have your own Autocolour colours?

A

Yes, in theory, but only for enterprise, not really for MM deals

36
Q

Can I have flags in my tombstones?

A

Yes, you can have anything

37
Q

How much does excel tombstones cost?

A

€200

38
Q

How do you add an input to a waterfall chart?

A

Insert row in data table

Right click on chart

Go to ‘select data range’; reselect data

It will then pull across correctly

39
Q

Which teams will use Advanced Export the most?

A

Probably not IB teams, probably more suited for advisory/ts or asset management (reporting on a p&l)

40
Q

How should you bench the UpSlide Link when discussing it against a competitor?

A

Don’t mention the competitor link, just speak to their pains and ESPECIALLY the dream state.

Show them that to get to the dream state they need the UpSlide link. It’s not apples v apples, it’s apples v pears

41
Q

Why is autocolour good?

A

Bankers / PE professionals will receive data from 3rd parties (big 4, advisory etc.) and be able to instantly see which cells are hard-coded/formulas.

Helps them get from a->b faster

42
Q

What’s the good thing about IFERROR?

A

You can neatly show the error in the sheet, but also you can see the formula that went wrong as opposed to it just being ERROR

43
Q

What are the colours in autolour?

A

They are the standard wall street colours

Blue = hard coded
Green = calculations + references to other sheets on the Excel file
Red = external links or error warnings
Black = calculations + references in the same sheet

44
Q

What is the maths on the waterfall charts?

A

/

UpSlide Product Knowledge (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions