Join instructor Paul Fujimoto-Pihl for a crash course in some of the more advanced features of Microsoft Excel, and how they can be used to make your life easier, better, and more rewarding. We’ll cover navigation tips and tricks, workbook and reference structures, recording macros, and formatting tools. We’ll explore reviewing and locking features, as well as a number of useful formulae like vlookup and conditional statements. We’ll also cover handy tools like drop-down lists and entry shortcuts. Finally, you’ll get a look at the powerful engine known as the Pivot Table. We’ll look at all these tools in the context of real-world examples of time sheets, budgets, schedules, and costings.
- Paul Fujimoto-Pihl – Project Manager, The Grand Theatre (London)