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.
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
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
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
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
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
Tracking Changes Options, Accepting and Rejecting Changes, Merging Workbooks
Macro Fundamentals, Creating a Macro, Running a Macro, Assigning a Macro to a Button / Menu
This is a highly interactive, practical and participative course.
Aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel
DATES and VENUES
To be confirmed.
1 day course: €230 ISME Skillnet Members, €315 Non Members
FOR FURTHER INFORMATION OR TO BOOK CONTACT:
Sheila Flannery, Training and Development Manager, 01 6622 755, firstname.lastname@example.org.
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.