Integrate SproutVideo with Microsoft Excel

SproutVideo

SproutVideo is an online video platform that allows users to host, manage, and share their videos. From the website. “SproutVideo is a fully-hosted cloud-based service that empowers businesses, organizations, publishers and individuals to create, manage, monetize and distribute quality video.” (SproutVideo.com. Businesses can use SproutVideo for internal communication, customer support and training, and product demos.

Microsoft Excel

Microsoft Excel is a program that assists users in creating spreadsheets or tables. From the website. “Create and save spreadsheets with ease, and access them from virtually any device to work on them together with others or on your own.” (Microsoft.com. Microsoft Excel allows for business analysis of all types of data. It can be used for analysis of financial information, compliance requirements, human resources data, operational data, and more. For the purpose of this article, we will examine how Microsoft Excel can be used in combination with SproutVideo to analyze promotional costs and returns.

Integration of SproutVideo and Microsoft Excel

To begin our integration of SproutVideo and Microsoft Excel, we will open Microsoft Excel to create a new spreadsheet. Choose the template you wish to use based on the data that you want to analyze. In this example, we will use the “Totals” template because we are interested in calculating the total sales revenue per region. Once you have chosen your template, a window will pop up asking you to name your spreadsheet. You may choose what you like but I suggest naming it something relevant such as “XYZ Sales Revenue.”

Now that our spreadsheet is created, let’s populate it with some data. To do this, we will add a “Data” tab in the ribbon which can be found by clicking on the tab with the icon of a piece of paper.(Figure 1)

Figure 1. Ribbon Designating Data Tab

This will open up a blank area where we will add our data. We will start with adding the title at the top of the spreadsheet (Figure 2. To do this click in cell A1 and type your desired title. Figure 2. Title Added At Top of Spreadsheet (A1)

Next, we will add the cells where we will enter our data into. To do this click on cell B2 and drag down to cell B5. This will include cells B2 through B5 in our spreadsheet (Figure 3. Figure 3. Entire Spreadsheet (B2-B5)

Now that we have added our cpumns for our data to go into we will add the cells where we wish to put our formulas. We will look at two methods of doing this. The first method is by using the formula bar at the bottom of the spreadsheet (Figure 4. Figure 4. Formula Bar Located at Bottom of Spreadsheet

The second method invpves right clicking on the cell where you wish to insert your formula and choosing “Insert Function” (Figure 5. Figure 5. Right Clicking on Cell Allows for Function Insertion

If you choose to use the formula bar at the bottom of the spreadsheet then your formula would look like this. =SUM(B2:B5. where B2-B5 are the cells you have already been creating in your spreadsheet. If you choose to use the “Insert Function” option then your formula would look like this. =SUM(B2:B5. where B2-B5 are the cells you have already been creating in your spreadsheet. If you choose to use the “Insert Function” option then your formula would look like this. =SUM(B2:B5)

Once you have finished entering all your formulas, it is time to test drive your newly created spreadsheet! To do this simply click on cell A1 and move over to cell B1 (Figure 6. Figure 6. Using Cells A1 and B1 as an Input/Output Area

After clicking on cell B1 you should see a total number appear in cell A1 (Figure 7. Figure 7. Number Appearing in Cell A1

Now let’s test out another function! Let’s say you want to find out how many units were spd in each region. To do this we will first highlight cells B2 through B5 (Figure 8. Figure 8. Highlighting Cells B2 through B5

Once we have highlighted these cells we will open up the “Formulas” tab on the ribbon (Figure 9. Figure 9. Opening Formulas Tab on Ribbon

From here we will click on “Name Manager” (Figure 10. Figure 10. Name Manager Located in Formulas Tab on Ribbon

From here we will click on “Define Name” (Figure 11. Figure 11. Define Name Button Located in Name Manager

Once you click on “Define Name” you will see a box appear where you can name your variable (Figure 12. Figure 12. Naming Your Variable in Name Manager

After naming your variable you will be asked to insert your variable into your spreadsheet (Figure 13. Figure 13. Inserting Your Variable into Your Spreadsheet

You should now see your variable listed in your Name Manager (Figure 14. Figure 14. Variable Now Listed in Name Manager

From here, click on cell C2 and drag down to C5 (Figure 15. Figure 15. Cells C2-C5 Selected On Your Spreadsheet

Now fill in your variables into cells C2-C5 (Figure 16. Figure 16. Variables From Cells B2-B5 Now Present in Cells C2-C5

Now that you have filled in your variables it's time to test out our spreadsheet again! Move back over to cell A1 and enter in cell A1 =Sales_Count(C2. where C2 is replaced by one of our variables from cells C2-C5 (Figure 17. Figure 17. Cell A1 Now Populated By Cell C2

The process to integrate SproutVideo and Microsoft Excel may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.