00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Management Development Skills

Home / Corporate Training / Soft Skills Training / Management Development Skills

Description

Next Date/Duration:
  • Call for Dates, 2 +3 Days
Target Audience:
Course Objectives:
  • Increase knowledge of the nature of management work and the strategic activities of managers
  • Develop skills of leadership and team working in order to achieve organisational goals
  • Develop effective meetings management techniques
  • Be able to manage staff performance using appropriate approaches
  • Develop change management skills for organisational change
  • Develop understanding of key aspects of approach to influencing techniques
  • Develop knowledge of own interactive style profile
  • Develop skills in handling people interaction and behaviours including conflict
  • Be able to communicate effectively with all staff and customers in various media formats
  • Be capable of dealing with informal and formal disciplinary issues according to procedures
  • Develop personal time management and work organisation techniques
Prerequisites
Upon successful completion of this course, students will be able to:
Price

€2100

Course Contents

Lesson 1

Introduction to the Programme

Lesson 2

Objectives, Content and Expectations

Lesson 3

Creating an Excel Spreadsheet

  • Best Practices
  • Entering Information – Labels, Numbers, Formulae
  • Saving, Opening, Closing and Deleting Workbooks
  • Document Properties and Management
Lesson 4

Editing

  • Selection Techniques
  • Drag and Drop
  • Editing on Spreadsheets or with Formula Bar
  • Delete / Clear Options
  • Cutting, Copying, and Pasting Text
  • Paste Options
  • Clipboard
  • Moving and Copying Text between Workbooks
  • Inserting and Deleting Columns, Rows and Cells
  • AutoFill
Lesson 5

Excel Formulae

  • Entering and Referencing Formulae
  • Calculations with Formulae
  • Editing Formulae
  • Order of Operations
  • AutoFill with Formulae
Lesson 6

Excel Functions

  • Basic Functions – Sum, Average, Min, Max, Count
  • Trace Error Options
  • Relative and Absolute Cell Addressing
  • Naming Cells
Lesson 7

Emailing

  • Email as word attachment
  • Email as (97-2003 Doc) or PDF (2007/2010)
Lesson 8

Formatting the Spreadsheet

  • The Format Cells Options –
  • Fonts, Alignment, Numbers
  • Changing Cell Colours
  • Cell Styles (2007/2010)
  • Format Painter
Lesson 9

Comments

  • Inserting Comments
  • Editing and Deleting Comments
  • Printing Options
  • View Options
Lesson 10

Page Setup

  • Orientation
  • Scaling
  • Margins
  • Auto Margins (2007/2010)
  • Header/Footers
  • Gridline Options
  • Header Row/column options
Lesson 11

Printing

  • Print Preview
  • Printing Options
  • Header and Footer
Lesson 12

Using Multiple Sheets in a Workbook

  • Naming Sheets
  • Moving and Copying Sheets
  • Inserting and Deleting Sheets
  • Formulas across Sheets
Lesson 13

Excel Charts

  • Chart components
  • Create new charts
  • Moving location of charts
  • Changing the chart type
  • Chart Options
  • Using Sparklines (2010)
  • Editing Charts
  • Chart Ribbon (2007/2010)
  • Chart Styles (2007/2010)
  • Quick Styles (2007/2010)
Lesson 14

Creating an Excel Databases

  • Setting up an Excel Database
  • Setting up an Excel Database using Tables (2007/2010)
  • Sorting Data
  • Filtering Data
  • Custom Filtering
Lesson 15

Training Course Summary and Review

  • Recap of Topics Covered
  • Question Time
Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.