Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features. You must have a working knowledge of Excel or passed the Intermediate Excel course. Course Syllabus: Working with Advanced Formulas - Using Names - Using decision-making functions - Creating nested functions - Using financial functions Lookups and Data Tables - Working with lookup functions - Creating data tables Advanced List Management - Creating subtotals - Validating cell entries - Exploring database functions Working with PivotTables and Pivot Charts - Working with PivotTables - Rearranging PivotTables - Formatting PivotTables Exporting and importing text files - Querying external databases Using Analytical Options - Working with Goal Seek and Solver - Working with scenarios - Working with views Working with Macros - Running and recording a macro - Viewing VBA code - Function procedures All one-day IT courses are bespoke and not qualification-based. Training formats available: - 1 day instructor-led at the College - Onsite at your company office UK wide - Bespoke one-to-one basis - Tailored training courses to your requirements At the end of this course, you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and advanced analysis, record macros and integrate with other office applications. You will then be qualified to progress to the VBA course for Excel. Candidates can be directed toward the European Computer Driving License
Name: Advanced Microsoft Excel Qualification title: - Qualification type: Assessment Training formats available 1 day instructor-led at the CollegeOn-site at your company office UK wide Bespoke one-to-one basis Tailored training courses to your requirements Awarding - Created 20150423 09:28:20 Updated 20150423 09:28:20
Pen and paper. Equipment required Pen and paper.
Eastleigh College
Further Education
experts@eastleigh.ac.uk
023 8091 1000
https://www.eastleigh.ac.uk/
Chestnut Avenue Town: Eastleigh County:Hampshire