Tips for working with spreadsheeets

Updated 4 months ago ​by Taís Hamamoto

Need to make some changes to your spreadsheets? Here are some tips on how to make your daily tasks easier

Merge dates and times in a cell

Do you need to fill out the schedules, flights, transfers or rooms with the date and time information?

Use:

= text (cell where the date is; "dd / mm / yyyy") & text (cell where the time is; "hh: mm: ss").

Dynamic table

Want to easily summarize your base numbers? Then click the "Pivot Table" button

Select which time you would like to track and apply filters to your searches

Looking for information to fill a table?

The most known function of event producers is PROCV.

Assemble your reports by searching for the information you need in different tabs of your spreadsheet.