Microsoft Excel Physical Class, Advanced Excel Training & Certification

[Advanced Excel Training & Certification] Excel spread sheets are the most powerful tool, extensively used for financial reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market if you want to be successful. This advanced Microsoft Excel training course will teach you how to use the advanced features of Excel to their full extent. By the end of this course, you will be able to report on data in a list using PivotTables, edit and analyse complex data using advanced features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros. This course is instructor led, and involves lots of examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. At the end of this training trainees will be confident to:

Create and use defined names in a workbook
Work with logical function in Excel
Use a variety of data validation techniques
Use a range of lookup and reference functions
Create summaries in your spreadsheets using subtotals
Understand and create simple Pivot Tables
Construct and operate Pivot Tables using some of the more advanced techniques
Use the Data Consolidation feature to combine data from several workbooks into one
etc.