Find Courses Find Providers Providers - Promote Your Courses About Us

Excel Advanced Belfast NI

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

Our 1 day Microsoft Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features. Prerequisites: A working knowledge of Excel or our Introduction to MS Excel course. Benefits: 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.

Regions:
Delivery:
  • Public
Category:
Difficulty:
  • Advanced

Further Details

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

Guide price

£140+VAT pp

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net