|
FREE*AS PART OF AN ITQ LEVEL 3
Advanced Excel
Spreadsheets
*Subject to conditions and availability
An Advanced Level I.T. qualification in spreadsheets, recognised internationally. The training programme involves self-study sessions, with tutor support (if required).
This course will give you an Advanced ECDL in Spreadsheets Certificate.
This qualification is accredited by the British Computer Society. The course comprises up to 40 hours of guided learning. The delivery of training is as flexible as possible; in order to help learners fit it around work schedules. Students are provided with continuous guidance and support during training.
This course will enable you to be able to understand and use the more advanced features of Microsoft Excel, e.g.:
- Pivot Tables
- Worksheet & Cell Protection
- Formulas & Auditing
- Scenarios
- Linking to External Data
- Macros
- Data Tables
Entry requirements:
You do not need to have any prior qualifications to join the programme. However, all candidates will be required to undertake brief, standard initial assessments in Literacy, Numeracy and I.T.
Course contents:
|
SECTION 1: Formatting Freezing Titles
- Conditional Formatting
- AutoFormat
- Paste Special
|
SECTION 2: Protection
- Protection
- Cell Protection
- Hiding Rows and Columns
- Workbook Protection
- Hiding Worksheets and Workbooks
|
|
SECTION 3: Comments
- Cell Comments
- Display Comments
- Create, Edit & Delete Comments
|
SECTION 4: Names
- Names
- Using Names in Formulas
- Using Go To with Names
|
|
SECTION 5: Templates
- Creating a Template
- Using a Template
- Editing a Template
- Deleting a Template
|
SECTION 6: Formulas
- Displaying Formulas
- Formulas that Produce Errors
- Custom Number Formats
|
|
SECTION 7: Scenarios
- Creating Scenarios
- Using and Editing Scenarios
- Scenario Summary Reports
|
SECTION 8: Linking
- Linking
- Creating Links
- Linking between Workbooks
- Linking to a Word Document
|
|
SECTION 9: Sorting
- Sorting & Multiple Column Sorts
- Custom Sorts
SECTION 11: Pivot Tables
- Pivot Tables
- Grouping Data in Pivot Tables
|
SECTION 10: Lists
- Lists
- Creating a List
- Filtering Lists AutoFilter
- Custom AutoFilter
- Advanced Filtering
- Extracting Filtered
- Data Adding Subtotals
|
SECTION 13: Charts
- Formatting Charts
- Modifying Charts
- Insert Image in 2D Chart
SECTION 14: Data Tables
- One Input Data Table
- Two Input Data Table
|
SECTION 12: Functions
- Functions
- Logical Functions
- Date and Time Functions
- Lookup Functions
- Math’s & Statistical Functions
- Text Functions
- Financial Functions
- Database Functions
- Nested Functions
|
| |
|
|
SECTION 15: Macros
- Macros
- Recording a Macro
- Running a Macro
- Assigning a Macro to a Button
|
SECTION 16: Auditing
- Auditing
- Tracking Precedents
- Tracing Dependants
- Tracing Errors
|
|
SECTION 17: Importing Data
|
How to apply
To contact our training staff please email us on info@atc-uk.com or call us on 020 8992 4144
Acton Training Centre is committed to promoting Equal Opportunity and celebrating Diversity
|
