contador web Saltar al contenido

How to embed calendars and fields in Excel | Productivity

Microsoft Excel 2016 offers a variety of tools as supplements to the program. Dynamic calendars, differentiated graphical schemes, currency exchange control, dictionary and other resources are available natively and can make spreadsheets more effective for any type of work.

The supplements came as a way of replacing macro nuisances, disabled in the Microsoft Office spreadsheet software. Check out, in the following tutorial, how to install and activate calendars and fields in Excel with the Supplement Store.

Ten tips and tricks to master Excel

The Microsoft Excel 2016 supply pack replaces many of the macro tools Photo: Carolina Ochsendorf / TechTudo         The Microsoft Excel 2016 supply pack replaces many of the macro tools Photo: Carolina Ochsendorf / TechTudo

The Microsoft Excel 2016 supply pack replaces many of the macro tools Photo: Carolina Ochsendorf / TechTudo

Want to buy cell phones, TV and other discounted products? Meet Compare TechTudo

Step 1. To access the Microsoft Excel add-on package, go to the Insert tab and click the Store button;

In the Insert tab, press on Store to access the available tools Photo: Reproduo / Daniel RibeiroIn the Insert tab, press on Store to access the available tools Photo: Reproduo / Daniel Ribeiro

In the Insert tab, press on Store to access the available tools Photo: Reproduo / Daniel Ribeiro

Step 2. In the Supplement Store window, there are dozens of tools to install and activate in your Excel. As there are 5 different calendars, look for Mini Calendar in the search text box and click on the magnifying glass icon;

Type Mini Calendar in the search box and press the magnifying glass icon Photo: Reproduo / Daniel RibeiroType Mini Calendar in the search box and press the magnifying glass icon Photo: Reproduo / Daniel Ribeiro

Type Mini Calendar in the search box and press the magnifying glass icon Photo: Reproduo / Daniel Ribeiro

Step 3. The Mini Calendar and Date Picker is Microsoft's official supplement for integrating calendars and watches into spreadsheets. Click the Install button to quickly download the resource;

Press Install to download the Mini Calendar and Date Picker Photo: Reproduo / Daniel RibeiroPress Install to download the Mini Calendar and Date Picker Photo: Reproduo / Daniel Ribeiro

Press Install to download the Mini Calendar and Date Picker Photo: Reproduo / Daniel Ribeiro

Step 4. After installing the add-in, it will be shown in the spreadsheet. To activate the tool's calendar function, select a cell in the table and click on the calendar date to represent it immediately;

Click on a cell and select the date in the Mini Calendar and Date Picker Photo: Reproduo / Daniel RibeiroClick on a cell and select the date in the Mini Calendar and Date Picker Photo: Reproduo / Daniel Ribeiro

Click on a cell and select the date in the Mini Calendar and Date Picker Photo: Reproduo / Daniel Ribeiro

Step 5. It is also possible to reproduce the time with the Mini Calendar and Date Picker. Select a field in the spreadsheet and click the clock format button to record the time;

Click on a cell and select the highlighted icon to insert the time Photo: Reproduo / Daniel RibeiroClick on a cell and select the highlighted icon to insert the time Photo: Reproduo / Daniel Ribeiro

Click on a cell and select the highlighted icon to insert the time Photo: Reproduo / Daniel Ribeiro

Step 6. To insert other features already installed in Excel, access the installed add-ins. Touch the Insert tab and then the My Supplements button to view the integrated tools;

In the Insert tab, click on My Supplements to view and activate the features installed in Excel Photo: Reproduo / Daniel RibeiroIn the Insert tab, click on My Supplements to view and activate the features installed in Excel Photo: Reproduo / Daniel Ribeiro

In the Insert tab, click on My Supplements to view and activate the features installed in Excel Photo: Reproduo / Daniel Ribeiro

Step 7. Some add-ons, once installed, get shortcuts on the toolbar. Dicionrios da Lngua Portuguesa, for example, has a button on the "Start" tab and works as a search bar integrated with Excel;

Some supplements, such as Dicionrios da Lngua Portuguesa, have shortcuts on the toolbar Photo: Reproduo / Daniel RibeiroSome supplements, such as Dicionrios da Lngua Portuguesa, have shortcuts on the toolbar Photo: Reproduo / Daniel Ribeiro

Some supplements, such as Dicionrios da Lngua Portuguesa, have shortcuts on the toolbar Photo: Reproduo / Daniel Ribeiro

Ready. Take advantage of the tips and optimize your spreadsheets with the Excel add-in package.

How to transfer data between pages in Excel? See the TechTudo forum.

How to Watermark Microsoft Excel Spreadsheets

How to Watermark Microsoft Excel Spreadsheets