1 day Adv Microsoft Excel CourseTraining in Belfast Northern Ireland OR On your Own Premises - Places Available - Call Now to Book

22 April 2024

Online and Classroom Based Training Courses Available

 PREREQUISTES

A working knowledge of creating & formatting simple spreadsheets with basic formulas using + - * / and basic functions eg SUM, COUNT, AVERAGE. Or attendance of our Excel Intro Course.

BENEFITS

This course will give you the skills to perform simple data analysis in Excel. You will learn how to use formulas, conditional formatting, filtering and sorting and many more data analysis features. By completing structured exercises, this course will increase your competence in day-to-data analysis making you more efficient & productive.

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

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

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)

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

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