While working in Excel, we often do no question habitual actions that turned into a routine. Need to enter a date into a cell? Manually type in day, month, year, press Cells Format, assign date type, edit date, etc. Need to save a table in CSV format? Copy data to a new worksheet, File, Save as CSV, open the source file again…
10-15 habitual clicks are almost automatic and seem inevitable. It’s time to change these unproductive habits to new useful habits with the help of free Office Store apps.
Habit 1. Enter dates into Excel cells from a calendar
The simple operation of entering dates into cells can take outrageously long. Try the Calendar App for Excel a few times, and you will not want to go back to entering dates manually.
Habit 2. Convert crosstab tables into a flat list with an app
Crosstab, or two-dimensional, tables are already a visual result of some analysis conducted on source data. What if you need to get to the initial flat list and to analyze source data under a different angle? Try the Unpivot Table App.
Habit 3. Export data from Excel to CSV with an app
If you work with data export a lot, you know how frustrating it can be to convert Excel tables into CSV text format – you have to open the original files many times over. Export to CSV App will save your time and energy.
Practice productive habits
The Office Store has already over 200 handy apps available directly from Excel interface. The next time you catch yourself thinking that some operations in Excel have turned into a long painstaking routine, browse the Office Store. It’s very likely there is a solution that will help replace your unproductive routine to a useful habit:
- Calendar – dates editing made easy;
- SQL Queries – run queries on Excel tables;
- Data Cleaning – remove extra spaces, change text case, etc.;
- Export to CSV – export data from Excel to CSV;
- SendGrid Reports – load SendGrid delivery reports to Excel;
- Columns Match – compare and match columns;
- Unpivot Table – redesign crosstab tables into a flat list.