Description
This course is for anyone who has been using Excel for budgets or other data that needs calculations and would like to learn more features to improve their ability to organise and analyse data. Learners must have used Excel before to create calculations that include absolute cell references (e.g. $B$4) and IF statements. It is suitable for users of both Excel 2007 and Excel 2010.
What you will learn
- Create Partial Absolute Cell References to lock just the Column or just the Row reference in a formula
- Move around a spreadsheet speedily using range names and use them in formula to improve accuracy and readability
- Accurate data entry by using Data Validation. e.g. a dropdown list to choose from to avoid errors
- Use the table tools and calculate within a table
- Advanced Conditional Formatting – using ‘If Formula Is’ to format cells other than the one that contains the value you are testing
- Create calculations based on single or multiple conditions. For example, calculate a discount for those over a specific age or ordering a high volume (IF with AND and OR)
- Use ISERROR and ISNA to tidy up your results
- Cross reference data using an Hlookup or Vlookup function. For example, look up a National Insurance Number to find other personal details from another sheet or book
- Use Formula Auditing tools to check for errors and make nested formulas easier to fix
- Create charts that include a secondary axis and trendlines
- Create Pivot Charts
- Create macros to automate your work and assign it to a toolbar button to make it easier to use
020 7375 7300
Email