- #Microsoft excel online time sheet how to
- #Microsoft excel online time sheet install
- #Microsoft excel online time sheet manual
(Check the “From” and “To” dates in the panel to set the dates to match the entries to test.) Make sure you have data in your Beebole account if you press Refresh data and don’t see any data, it might be because there’s no data to pull.There are two keys in your account, and the Excel add-in needs this specific one. Make sure that you used the Base64 API key.If your connection doesn’t work, try out these simple troubleshooting steps: You should see data pulled into the spreadsheet.
To test out the connection, click on Refresh Data in the sidebar to test the connection. You’ve now connected Excel to your Beebole account. Paste in that API key and confirm the settings.
Make sure you grab the value from the Base64 window and copy it to your clipboard. You’ll see the new panel labeled API Token, similar to the screenshot below. This will make it easy to view the API key that we need. Now, drag-and-drop the label API Token onto your dashboard. Type in “api” into the search box that opens up as you can see in the screenshot below. The easiest way to find your account’s API key is to click on the Customize option at the top of the dashboard. Go ahead and log into your account and reach the Beebole dashboard so that we can retrieve the API key. Now, let’s switch gears and open Beebole in our web browser. You’ll see the field API Token (Base64) in the pop-up window. This magic key helps authenticate the add-in to talk to the time tracking data that lives in our Beebole account. Now, we need to get an API token from our Beebole dashboard. Click on the add-in icon to configure it to work with your account.
#Microsoft excel online time sheet install
The first time you install the add-in, you’ll see a welcome message. Find the Beebole Timesheets icon on the Home Tab. Now, you’re ready to connect the Beebole add-in to your account. Click on Add, and Excel will do the work of installing the add-in for you. Let’s find the official Beebole add-in by simply searching “Beebole” in the box you see in the upper left corner.Īfter you press enter, you’ll see the official Beebole add-in showing. Now, you’ll see a new window that acts as a browser for Excel add-ins. Then, click on the Add-ins dropdown and choose Get Add-Ins. In Excel, jump to the Insert tab on the ribbon. Press one button, and the add-in imports time tracking data automatically.
#Microsoft excel online time sheet manual
In this case, the Beebole add-in removes the manual work of downloading your time tracking data for analysis. If you’ve never used an add-in, think of it as a tool that adds power to Excel. We’ll connect to Beebole with the official add-in. An active Beebole account, ready with time tracking data to test outĪfter you’ve set up Excel and Beebole, it’s time to install the add-in.To walk through this tutorial, make sure that you have both of the following:
#Microsoft excel online time sheet how to
You can download the add-on here and read about how to best use it here. (If you prefer to watch this tutorial instead, don’t miss the screencast at the very end of the post!)īy the way, if you prefer to use Google Sheets, we’ve got you covered with Beebole’s add-on for Google Sheets. At the end of this tutorial, Excel will talk directly to Beebole so that you’ll never need to download data manually again. Let’s learn how to install and set up the Beebole Add-In in this tutorial. That makes it easier than ever to analyze and work with your time tracking data. The Beebole Microsoft Excel add-in has arrived! With this new tool, you can connect spreadsheets directly to your Beebole account.
0 kommentar(er)
