Excel - Intermediate 2010/2013/365

BENEFITS

This course will give you the skills to:

• Perform simple data analysis in Excel
• Apply conditional formatting, data validation, 
• Protect your worksheets/ workbooks
• filtering and sorting and many more data analysis features

During the course, delegates will work through structured exercises, gaining experience in & improving efficiency/ productivity

WORKSHEET OPERATIONS

• Copy & Move:
o Within Current File
o To External Files
• Group Sheets:
o Update Data, Formula & Layout
o Select Adjacent & Non-Adjacent Sheets

WORKING WITH EXCEL DATA
• Sort Data Lists:
o By Data Value(s)
o By Cell/ Font Colour
• Group & Ungroup to Create Outlines:
o Rows & Columns
o Using Outline Levels

• Filter Data:
o Autofilter
o Advanced Filter
o Reapply Filter Criteria
o Filter by Cell/ Font Colour

IF FUNCTION
• Use IF to Make Your Spreadsheet ‘Smarter’
• Identify When to Use

CONDITIONAL FORMATTING
• Create, Edit & Replicate
• Apply formatting to:
o A cell based on it’s own value
o An entire row based on a cell value in that row

VALIDATION RULES
• Create & Apply to Dates, Numbers & Create
Drop Down Lists for Text
• Reuse to Apply to Other Data Ranges
(for Dates, Numbers & Text Lists)
• Update

LINKING SPREADSHEETS
• Create & Maintain Links:
o Within Worksheets in a Single File

SECURITY
• Protect Cell Ranges
• Protect Sheets
• Password protect files (read only & restrict opening)

Excel Intermediate - with Mullan Training:

• Click here to view dates on our Public Course Schedule

• Click here to download our Excel Course Outlines