Microsoft Excel - Intermediate

Work more confidently with more complex features in Microsoft® Excel. From advanced formulae and analyzing large quantities of data with pivot tables, to creating templates and using macros.

Get much more from your spreadsheets with the advanced functionality of Microsoft® Excel. If you’re new to Microsoft® Excel, we recommend you take Microsoft® Excel Stage 1 before this course.

By the end of this course you will:

• Know how to create and edit named ranges
• Know how to use advanced formulae, such as Nested IF, SUMIF and VLOOKUP
• Be able to create pivot tables from raw data and then edit and reformat
• Know how to locate and fix errors in spreadsheets
• Be able to use the chart wizard to modify existing charts and add trend lines
• Know how to automate tasks to ensure accuracy and save time using the macro feature
• Be able to assign macros to buttons and graphics

Duration: 1 day