Three useful habits in Excel

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.

Manually enter day, month, year – set the required cells form and date type – fix errors if necessary. Select a cell – pick a date from a calendar – done!
  • Which order: Day/Month/Year?
  • Which separator “-” or “/”?
  • Which day of the week is it?
  • Which week number is it?
  • Uses system settings for date format.
  • Displays days of the week and week numbers.
  • Share an ”embedded” calendar with colleagues.
  Download Apps in Office Store

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.

1. Meticulously copy & paste by hand.
2. Or, write a macro.
Select a table – specify where to place the flat list – done.
  • What if you work with huge tables?
  • How to avoid errors while copying?
  • How can a beginner write a macro?
  • Converts ranges of any size.
  • All values get transferred correctly.
  • No need to use VBA macro.
  Download Apps in Office Store

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.

1. Save Excel file as CSV file.
2. Or, create a macro.
Select the range – choose a separator – done.
  • The source XLSX file automatically closes.
  • How to export a small range, not the entire sheet?
  • Can you change a CSV delimiter?
  • How can a beginner write a macro?
  • The source XLSX file remains open and does not change its extension.
  • Export any selected range.
  • Choose any delimiter: comma, semicolon, or tab.
  • No need to use VBA macro.
  Download Apps in Office Store

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:

2 Responses to Three useful habits in Excel

  1. Kam Dodd says:

    Can i use the app on more than one computer with one license for XL tool? Thx

Leave a Reply to Maria Balobanova Cancel reply

Your email address will not be published. Required fields are marked *