c2
Connect on:
  • Home
  • Course Centre
    • Project Management >
      • Professional Project Management
      • Project Management Essentials
      • Managing Project Requirements
      • Scheduling & Cost Control Project Managers
      • Project Leadership, Management & Communication
      • Risk Management for Project Managers
      • Negotiation Skills for Project Managers
      • Managing Remote Project Teams
      • Project Quality Management
      • Project Procurement Management
      • Earned Value Management
      • Professional Project Management - Best Practice
      • Professional Project Management - Exam Preparation
      • PRINCE2® Foundation & Practitioner
      • PRINCE2® Overview
    • Agile Project Management Courses >
      • Agile Project Management
      • Using Scrum in organistations
      • Certified ScrumMaster
    • Java >
      • Core Java Programming
      • Advanced Java Programming
      • Java Programming & XML
      • Java Networking
      • Java Virtual Machine (JVM)
      • Java & Java EE Open Source Testing Tools
    • Java Enterprise Edition (EE) >
      • Enterprise Java with Hibernate and Spring
      • Developing Java Web Applications
      • Java & Java EE Open Source Testing Tools
      • Spring Framework Development
    • C/C++ Programming >
      • C Programming Techniques
      • C++ Programming Fundamentals
      • C++ for C Programmers
      • Advanced C++ Programming
      • C++ & STL Design Patterns
      • Object Oriented C++ for Real-time Applications
    • Unix/Linux >
      • Linux Fundamentals
      • Linux Administration Essentials
    • Windows Server Courses >
      • Installing and Configuring Windows Server 2012
      • Windows Server 2008 - Server Administration
      • Configuring Windows Server 2008 Active Directory
    • .NET Courses >
      • ASP.NET MVC 4.0
    • Perl Programming Courses >
      • Perl Programming
      • Advanced Perl Programming
    • Python Programming Courses >
      • Python Programming
    • Database Courses >
      • MySQL for Developers
    • CompTIA >
      • CompTIA Network+
    • Scripting >
      • JavaScript - Introduction
      • JavaScript - Advanced
    • Data Analysis & Design >
      • Data Analysis & Design - Introduction
      • Data Analysis & Design with UML
    • Microsoft Office Courses >
      • Microsoft Word - Introduction
      • Microsoft Word - Intermediate
      • Microsoft Word - Advanced
      • Microsoft Access - Introduction
      • Microsoft Access - Intermediate
      • Microsoft Access - Advanced
      • Microsoft Excel - Introduction
      • Microsoft Excel - Intermediate
      • Microsoft Excel - Advanced
      • Microsoft Excel - Dashboards
      • Microsoft Excel - Macros
      • Microsoft Excel - Expert
      • Microsoft PowerPoint - Level 1
      • Microsoft PowerPoint - Level 2
      • Microsoft PowerPoint - Advanced
      • Microsoft Outlook - Introduction
      • Microsoft Outlook - To Manage Your Time Efficiently
      • Microsoft Project - Introduction
      • Microsoft Project - Advanced
      • Microsoft Publisher - Introduction
      • Microsoft Visio - Introduction
    • Solaris >
      • Solaris 10 Administration
  • Testimonials
  • About
  • Contact

Microsoft Excel - Intermediate

Course Description

This is a Microsoft Excel Intermediate course.  The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending.  For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.

Course Duration

1 day

Course Objectives

The course provides candidates with practical experience of the topics listed in the course outline below.  On completion, candidates should have an excellent knowledge of the basic concepts and a working knowledge of some advanced features.

Course Content

MANIPULATING DATA, & NAMED RANGES
Paste special
Importing text
Naming cell range(s) in a worksheet
Named ranges within formulas
Creating subtotals
Removing subtotals

TEMPLATES

Using templates
Creating templates
Opening and editing templates


FORMATTING & DISPLAY TECHNIQUES
Formatting tables
Using conditional formatting

Creating custom number formats
Freezing columns and rows
Hiding and un-hiding rows and columns
Hiding and un-hiding worksheets

SORTING AND QUERYING DATA

Sorting internal Excel database lists
Custom sort options
Using AutoFilter to query data
Multiple queries
Removing filters
Top 10 AutoFilter
Filtering unique records
Advanced Filter

LINKING & CONSOLIDATING DATA

Linking individual cells within a worksheet
Linking charts to data within a worksheet
Linking a cell range on one worksheet to another worksheet
Linking data on one worksheet to a chart in another
Linking data from one workbook to another
Linking a chart from one workbook to another
Copying data from Excel into a Word document
Linking data from Excel into a Word document
Copying a chart from Excel into a Word document
Linking a chart from Excel into a Word document
Consolidating data over several worksheets or worksheet pages

CHARTS FORMATTING TECHNIQUES

Changing the angle of pie chart slices
Formatting the chart axis fonts
Formatting the chart axis scales
Formatting the chart axis text orientation
Creating and positioning a chart title
Re-positioning a chart legend
Re-positioning chart data labels
Exploding the segments within a pie chart
Deleting a data series within a chart
Adding a data series to a chart
Modifying the chart type for a defined data series
Widening the gap between columns / bars within a 2-D chart
Inserting an image into a 2D chart (as a background)
Inserting an image into a 2D chart (to format a column or bar of data)
 
PROTECTION AND SECURITY
Specifying a password for opening a workbook
Using the “read-only recommended” option
Removing a password from an Excel workbook
Protecting a worksheet or worksheet elements
Removing workbook protection

Who should attend?

This course is aimed at users who wish to build on their basic knowledge of Microsoft Excel.

Pre-requisites

Those attending should have a basic understanding of Microsoft Excel to an introductory level, be competent Windows users and be familiar with the basics of file and disk management.
Powered by Create your own unique website with customizable templates.