Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Prepares for: | • 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 our Excel VBA course. |
| Geared towards: | Our 1 day 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. |
| Requirements: | A working knowledge of Excel or our Introduction to MS Excel course. |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Course Content
Advanced Functions
• IF Function & Nested IF Statements
• And & Or Functions
• Lookup Functions (Horizontal And Vertical Lookup
• Subtotals
• Conditional Formatting
3D Ranges
• Create & Maintain (Within Worksheets In a Single File & Between External Files)
• Consolidate Data (via 3D Ranges & Using The Consolidate Tool)
Pivot Tables
• Create Pivot Table
• Work With Row/ Column Fields
• Data Fields
• Customise Table Display
Organising Workbooks
• Create Templates
• Protect Ranges & Worksheets
Data
• Enter & Select Records Using The Input Form
• Sort Data Into Lists
• Filter Data - Autofilter, Advanced Filter
• Validation Rules
Goal Seeking
• Solver
• Goal Seeking With Charts
• What-If
Scenarios
• Create Scenarios
• Create Summary Report
• Merge Scenarios
• Protect Scenarios
Macros
• Create Macros – Record & Modify the VBA Code
Generated
• Relative Referencing
• Assign To Toolbars/ Keyboard
• Make Available To All New Documents/ Current Document Only
Outlines
• Group Row/ Column Data To Create Outline Levels Based On
Worksheet Formulae
• Display Summary Rows And Summary Styles
Advanced Functions
• IF Function & Nested IF Statements
• And & Or Functions
• Lookup Functions (Horizontal And Vertical Lookup
• Subtotals
• Conditional Formatting
3D Ranges
• Create & Maintain (Within Worksheets In a Single File & Between External Files)
• Consolidate Data (via 3D Ranges & Using The Consolidate Tool)
Pivot Tables
• Create Pivot Table
• Work With Row/ Column Fields
• Data Fields
• Customise Table Display
Organising Workbooks
• Create Templates
• Protect Ranges & Worksheets
Data
• Enter & Select Records Using The Input Form
• Sort Data Into Lists
• Filter Data - Autofilter, Advanced Filter
• Validation Rules
Goal Seeking
• Solver
• Goal Seeking With Charts
• What-If
Scenarios
• Create Scenarios
• Create Summary Report
• Merge Scenarios
• Protect Scenarios
Macros
• Create Macros – Record & Modify the VBA Code
Generated
• Relative Referencing
• Assign To Toolbars/ Keyboard
• Make Available To All New Documents/ Current Document Only
Outlines
• Group Row/ Column Data To Create Outline Levels Based On
Worksheet Formulae
• Display Summary Rows And Summary Styles
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 1st Floor Blackstaff Studios, 8-10 Amelia Street, Belfast, BT2 7GS - BT2 7GS
Mullan Training
Mullan Training is a Northern Ireland based Computer Training Provider and has been providing high quality training to the public and private sectors for over 15 years.
Located at Blackstaff Studios (Amelia Street, Belfast) we occupy spacious fully air-conditioned training suites right in the heart of Belfast City Centre - Just opposite the Europa Hotel.
We offer an extensive range of public and closed courses including
• Microsoft Office
• Microsoft
• Adobe Creative Suite
• QuarkXpress
• Crystal Reports
• Sage
Meeting Your Needs
To ensure your training needs are met, we have a number of delivery types available. Please review below and if you have any queries do not hesitate to contact us.
Public Courses
• Our public courses are detailed on our public schedule
• The courses run from 9.30am - 4.30pm, and are open to individuals or groups
• Group rates apply
• These are run on scheduled dates at our premises
• Lunch Provided
Closed Courses
• To suit your training needs we can deliver for your group only
• We can customize content and duration to ensure you get maximum benefit of the course
• Where appropriate it is possible to use your own data, particularly useful for database, report writing and spreadsheet courses
• For web, image & video editing course you can bring your own material to work on
• Lunch optional
One-To-One
• Ad-hoc course covering specific topics within a single application
• Alternatively various topics within a number of applications can be covered
• Can be delivered on our premises or onsite - where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Lunch Provided
Onsite
• Use your own data, live if possible
• Tailored (customise course outlines to meet specific needs)
• Courses can be delivered at our training premises or onsite at your premises -where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Group rates apply
Located at Blackstaff Studios (Amelia Street, Belfast) we occupy spacious fully air-conditioned training suites right in the heart of Belfast City Centre - Just opposite the Europa Hotel.
We offer an extensive range of public and closed courses including
• Microsoft Office
• Microsoft
• Adobe Creative Suite
• QuarkXpress
• Crystal Reports
• Sage
Meeting Your Needs
To ensure your training needs are met, we have a number of delivery types available. Please review below and if you have any queries do not hesitate to contact us.
Public Courses
• Our public courses are detailed on our public schedule
• The courses run from 9.30am - 4.30pm, and are open to individuals or groups
• Group rates apply
• These are run on scheduled dates at our premises
• Lunch Provided
Closed Courses
• To suit your training needs we can deliver for your group only
• We can customize content and duration to ensure you get maximum benefit of the course
• Where appropriate it is possible to use your own data, particularly useful for database, report writing and spreadsheet courses
• For web, image & video editing course you can bring your own material to work on
• Lunch optional
One-To-One
• Ad-hoc course covering specific topics within a single application
• Alternatively various topics within a number of applications can be covered
• Can be delivered on our premises or onsite - where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Lunch Provided
Onsite
• Use your own data, live if possible
• Tailored (customise course outlines to meet specific needs)
• Courses can be delivered at our training premises or onsite at your premises -where we can also provide laptops, LCD projectors and flipchart at no extra charge.
• Group rates apply
Search similar to IT, ICT and Computing
Courses similar to IT, ICT and Computing
Microsoft Excel Advanced Expert
In a classroom | 6 Hours
