Hello, Optima Training has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'

Customised Microsoft Excel Training

This Microsoft Excel Intermediate training course is a 1 Day programme, designed for anyone who wants to improve his or her knowledge of Microsoft Excel. Participants will learn topics, which will improve their efficiency and productivity in the work place.

 

Course Date: 21st Jan

Product Code:
MS4.2
Duration:
1 Day
Times:
09:30-16:30
Cost Includes:
Training course materials and after-training support
Contact Name:
Sinead Landers
Venue:
Limerick
Date:
X €650.00
Make an Enquiry
Attendee(s), if more than one seperate with a comma
Course Content
Intended Audience
Method Of Delivery
Reviews

Microsoft Excel Intermediate Outline:

Setup & Printing Issues

  • Worksheet Setup
  • Headers and Footers
  • Scaling Your Worksheet to Fit a Page(s)
  • Printing Titles On Every Page
  • Printing the Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options

Functions and Formulas

  • Getting Help With Functions
  • Nested Functions
  • Mixed References within Formulas

Time & Date Functions

  • TODAY
  • NOW
  • DAY
  • MONTH
  • YEAR

Functions

  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • SUMIF

Logical Functions

  • IF
  • AND
  • OR

Lookup Functions

  • VLOOKUP

Statistical Functions

  • COUNT
  • COUNTA
  • COUNTIF
  • CONCATENATE

Text to columns

Named Ranges

  • Naming Cell Ranges
  • Removing a Named Range
  • Named Cell Ranges and Functions

Cell Formatting

  • Applying Styles to a Range
  • Conditional Formatting
  • Custom Number Formats

Manipulating Worksheets

  • Copying or Moving Worksheets
  • Splitting a Window
  • Hiding Rows, Columns & Worksheets

Templates

  • Creating Excel Templates
  • Editing Excel Templates

Paste Special Options

  • Using Paste Special to Add, Subtract, Multiply & Divide
  • Using Paste Special ‘Values’
  • Using Paste Special Transpose Option

Database & List Management – Sorting and Filtering Data

  • Sorting Data by Multiple Columns
  • Custom Sorts
  • Customized List
  • AutoFilter

Subtotalling

Charts

  • Combined Line and Column Chart
  • Adding a Secondary Axis
  • Changing the Chart Type For a Data Series
  • Adding a Data Series to a Chart
  • Removing a Data Series from a Chart
  • Modifying the Chart Title, Legend & Data Labels
  • Chart Axis Scales
  • Inserting Images Into Chart Columns
  • Formatting the Chart Area

Pivot Tables

  • Introduction to Pivot Tables

This Microsoft Excel Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the Intermediate features of Microsoft Excel.

A basic understanding of Excel is required for this training course.

Classroom based, instructor lead, practical hands on course with Computer / Laptop per person during the session

There are no reviews yet.

Be the first to review “Customised Microsoft Excel Training”