Normal Course Fee: £220 + VAT (before discount) Objective: To give users an extended knowledge of Excel's advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.
Excel Advanced Part 2 Auditing a Worksheet Collaborating with Workgroups Working with Data Lists PivotTables Data Management Using Analysis Tools
With Discount: £176 + VAT (JustAccountancyJobs Members)
Duration: 1 Day
Course Dates: 09&24 Sep, 08&21 Oct, 5&18 Nov, 10&23 Dec 2010
To give users an extended knowledge of Excel’s advanced features. Delegates will gain practical knowledge on how to analyse and share spreadsheet data and create spreadsheet databases.
Suitability:
This course is suitable for existing users of Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets in a short space of time. Participants on this course should have a good working knowledge of Excel, gained from prior attendance on an “Excel Advanced” course or from a user environment.
Review Exercise
- Using Worksheet Auditing Tools
- Data Entry Validation
- Validating the Whole Worksheet
- Auditing Data Dependency
- Finding and Replacing Data
- Applying Worksheet Protection
- Password Protecting a File
- Changing Workbook Properties
- Adding Comments to the Worksheet
- Shared Workbooks
- Tracking Changes
- Resolving Conflicts
- Merging Workbooks
- E-mailing Workbooks for Review
- Setting Up Lists
- Sorting Lists
- Filtering Lists
- Using Forms
- Creating a PivotTable
- Modifying a PivotTable
- Creating a PivotTable Chart
- Creating Interactive PivotTables for the Web
- Searching for Data with Advanced Filters
- Compiling Consolidations
- Summarising Data with Outlines
- Querying a Database
- Data Sources
- Controlling Formatting and Layout
- Refreshing External Data
- Goal Seeking
- Using Solver
- The Scenario Manager
- Scenario Summaries
- Merging Scenarios
Just Accountancy Jobs has negotiated a special discount of 20%, for candidates if you apply via our website link below:-
