Tips for working with spreadsheeets
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?
= text (cell where the date is; "dd / mm / yyyy") & text (cell where the time is; "hh: mm: ss").
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.