Learn about the more advanced functions that areavailable in Microsoft Excel.
Who should attend?
Anyone that really needs to have a more in-depth knowledge of additional advanced functions and features, that are lesser known but very useful for more complex calculations.
Course overview
• Revision of Lookups
• FIND, CHOOSE, INDIRECT functions
• Array formulas
• Practical application and combination of functions such as using text functions for advanced sorts, text functions in lookups, handing #NA() in lookups, using MATCH to determine columns in vlookups and using data validation lists with lookups
• Calculate the future and net present values of loans and investments using Excels financial functions
• Dynamic named ranges using OFFSET
• Creating custom sort orders
• Creating unique items lists
• Data consolidation
• Protection of worksheets, workbooks and files
• Importing and Exporting data
• CSV files
• Financial functions EOMONTH, PPMT, PMT, XNPV, IRR, XIRR
• Use What-if analysis tools, Goal seek and solver
Pre-requisites
An advanced knowledge of Excel including being
able to use lookups.
Duration
1 day
Price
Onsite: £645 + VAT per day
Offsite: £795 + VAT per day
