Advanced Excel

Advanced Excel

Advanced Excel

AIM

Learn how to create complex models involving multiple linked spreadsheets and files, analysing data using what ifs and scenarios, validating and auditing data and automating commonly used features with macros.

COURSE CONTENT

Introduction and Review:
What’s New in Excel 2010, Efficient Spreadsheet Design, Review Basic Spreadsheet Development – Formulas, Cell Referencing, Formatting, Tools Options, Task Panes, Smart Tags and Options button

Functions
Review Basic Functions, Statistical Functions, Time / Date Functions, Text Functions, Nesting Functions, Conditional Formatting with Functions

Multiple Sheets / Files
Review Multiple Sheets, Grouping Sheets, Linking Sheets, Workbook Features

Consolidation
Building a Consolidation, Creating Consolidation Links

Data Validation and Auditing
Limiting Entries into a Cell, Creating a Drop Down List, Data Validation and Functions, Circling Invalid Data, Tracing Precedent and Dependent Cells

Analysing Data
Creating Data Tables for What-If Analysis, Building a Scenario, Multiple Scenarios, Summary Scenarios, Using Goal Seek and Solver

Spreadsheet Database Features
Advanced Filtering, Database Functions, Lookup Functions, Pivot Tables Review – Creating and Updating the Table, Changing the Table Structure, Creating Charts from the Data, Grouping Options , Pivot Table Options, On / Off Subtotals, Calculated Items, Showing / Hiding Fields, Slicers

Advanced Charts
Review of Creating a Chart, Advanced Chart Options, Advanced Formatting, Adding Trend lines, User Defined Charts

Customising the Work Area
Creating a Template, Using a Template, Styles, Custom Toolbars

Sharing Workbooks
Tracking Changes Options, Accepting and Rejecting Changes, Merging Workbooks

Excel Macros
Macro Fundamentals, Creating a Macro, Running a Macro, Assigning a Macro to a Button / Menu

METHODOLOGY

This is a highly interactive, practical and participative course.

TARGET AUDIENCE

Aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel

DATES and VENUES

28th September 2016.9.30am – 5.00pm. Olas, Dublin

23rd November 2016.9.30am – 5.00pm. Olas, Dublin

FEE:

1 day course: €230 ISME Skillnet Members, €315 Non Members

Booking Essential

FOR FURTHER INFORMATION OR TO BOOK CONTACT:

Liz Carroll, Training and Development Manager, 01 6622755, liz@isme.ie

The ISME Skillnet is funded by member companies and the Training Networks Programme, an initiative of Skillnets Ltd. funded from the National Training Fund through the Department of Education and Skills.