1. Use a lookup function to create the data sheets for each alumnus as soon as the last name is entered. When no last name is present, the data sheet should be blank
2. Update the direct exchange rates, highlighted in orange, in the Exchange Rate Table. Create formulas that will automatically update the indirect rates in blue.
3. Update the direct exchange rates highlighted in orange in the Exchange Rate Table. Create formulas that will automatically update the indirect rates in blue.
4. Use HLOOKUP and VLOOKUP to fill in the registration list
5. Calculate the correct tax amount using the INDEX and MATCH functions and the Tax Table worksheet
I have good experience managing work on excel. Pass it on to me and take it job done well. They want me to write 100 characters for no good reason. If interested, let me know. Ciao