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 / dnetc
Want to buy cell phones, TV and other discounted products? Meet Compare dnetc
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 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 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 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 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 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 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 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 dnetc forum.
How to Watermark Microsoft Excel Spreadsheets