Excel - Adv (1 Day) 2010/2013/365

We are currently delivering our 1 Day Excel Advanced course via:

• Online Training via Zoom/ Teams in our Virtual Classroom
• Classroom Based Training at our Belfast City Centre Premises - opposite Europa Hotel

PREREQUISTES

• A working knowledge of Windows is required
• A working knowledge of creating & formatting simple spreadsheets
  with basic formulas using + - * / and basic functions eg SUM, COUNT,
  AVERAGE
• OR attendance of our Excel Introduction/ Intermediate courses

BENEFITS

• At the end of this course you will have an understanding of the higher functions of Excel
• You will be able to perform advanced calculations and functions, manipulate data using pivot tables & ‘advanced’ analysis, record macros
• You will then be qualified to progress to our Excel VBA course
• During the course, delegates will work through structured exercises, gaining experience in & improving efficiency/ productivity

COURSE CONTENT

LINKING SPREADSHEETS
• Link Worksheets Within A Single File
• Link Worksheets to External Files

MACROS
• Create Macros – Record & Review the VBA
Code Generated
• Relative Referencing
• Make Available to All New Documents/
Current Document Only
• Optional: Add Macros to the Quick Access
Toolbar

ADVANCED FUNCTIONS
• IF Function:
o Nested IF Statements
o And & Or Functions
• LOOKUP Functions:
o Horizontal
o Vertical
o Optional: IFERROR
• SUBTOTAL
o Calculate Totals For Filtered Data

CUSTOM VIEWS
• Create & Delete
• Include Hidden Rows, Columns, Filter Settings

PIVOTTABLES & PIVOTCHARTS
• Create PivotTables & PivotCharts
• Work With Row/ Column Fields
• Data Fields
• Customise Table Display
• Generate PivotChart from PivotTable

3D RANGES
• 3D Range References
• Create & Maintain Ranges:
o Within Worksheets in a Single File
o Between External Files

Excel Advanced - with Mullan Training:

• Click here to view dates on our Public Course Schedule

• Click here to download our Excel Course Outlines