Helpful information for event managers.
Discover exciting articles about the implementation of unforgettable events.
When processing guest lists in guest management, event managers are often confronted with a mountain of data that needs to be processed. Editing guest lists in Excel is often time-consuming, nerve-wracking and prone to errors. In this article, we explain the best cheats for your guest lists and guest management in Excel that will help to reduce the effort to a minimum.
.svg){kind=small}
To format an Excel file as a table, all data must be selected and then transformed into a table via 'Insert > Table'. Tables allow filtering and analysing data in columns.
In some cases, multiple data are displayed in one column. An example of this is .CSV (Comma-Separated Values) files. A .CSV file can be converted into an Excel format, where the data is split into multiple columns via 'Data > Data Tools > Text to Columns'. In the subsequent Text-to-Columns Wizard, the file type 'Delimited' must be chosen, and then the delimiter, for example, 'Comma' for .CSV files. After completion, the data will be split into multiple columns.
Duplicates in an Excel file can either be highlighted with colour or automatically removed.
To highlight duplicates, the desired column can be selected and then, via 'Home > Styles > Conditional Formatting > Highlight Cells Rules > Duplicate Values', a colour can be chosen to mark duplicate values.
To remove duplicates, the desired column can be selected and then, via 'Data > Data Tools > Remove Duplicates', all duplicates can be removed.
Sometimes, data need to be adjusted throughout an entire file. For example, all guests of an account manager may need to be reassigned to another manager, or the language of contacts may need to be formatted in a certain way for further processing in another tool. Excel's 'Find and Replace' function can be used for this purpose.
Via 'Home > Editing > Find & Select > Replace' or the shortcut 'Control + F', the dialog box can be opened. In it, either all can be replaced at once 'Replace All', or the data can be adjusted individually 'Replace' or 'Find Next'.
To quickly determine the count of selected data fields, the 'Count' can be used at the bottom right. This way, all guests who, for example, have registered for a certain programme item can be selected, and then the number can be read at the bottom.
VLOOKUP is a function in Excel used to map datasets together. Through VLOOKUP, for example, two tables with information about the same guest can be merged.
Example: If these two tables exist and the account ID should be taken over for the guests in the first table where available, the VLOOKUP can be searched and selected via 'Insert Function'.
Close a workbook: Windows: CTRL+W / Mac: ⌘W
Open a workbook: Windows: CTRL+O / Mac: ⌘O
Open a new workbook: Windows: CTRL+N / Mac: ⌘N
Save a workbook: Windows: CTRL+S / Mac: ⌘S
Select all: Windows: CTRL+A / Mac: ⌘A
Copy selection: Windows: CTRL+C / Mac: ⌘C
Paste selection: Windows: CTRL+V / Mac: ⌘V
Undo last action: Windows: CTRL+Z / Mac: ⌘Z
Cut selection: Windows: CTRL+X / Mac: ⌘X
Find and Replace: Windows: CTRL+F / Mac: ⌘F
We hope these tips will help you as an event manager to implement your guest management. If you would still like to use a digital solution, arrange a free demo with us.
.svg)
Learn more about digitising your guest management with Oniva.
Discover exciting articles about creating unforgettable events.
.svg){kind=icon}
