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 - Introduction

Course Description

This is a Microsoft Excel Introduction 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 of Excel.

Course Content

A FIRST LOOK AT EXCEL
Starting the Excel program
What is the Active Cell?
The Excel cell referencing system
Worksheets and Workbooks
Saving a workbook
Opening a workbook

HELP
Getting help
The Help Table of Contents
Printing a Help topic
Alt key help

SELECTION TECHNIQUES
Selecting a cell
Selecting a range of connecting cells
Selecting a range of non-connecting cells
Selecting the entire worksheet
Selecting a row
Selecting a column

MANIPULATING ROWS AND COLUMNS
Inserting rows into a worksheet
Inserting columns into a worksheet
Deleting rows within a worksheet
Deleting columns within a worksheet
Modifying column widths
Modifying column widths using drag and drop
Automatically resizing the column width to fit contents
Modifying row heights

COPYING, MOVING AND DELETING

Copying the cell or range contents
Deleting cell contents
Moving the contents of a cell or range
Editing cell content
Undo and Redo
AutoFill
Sorting a cell range

MANIPULATING WORKSHEETS

Switching between worksheets
Renaming a worksheet
Inserting a new worksheet
Deleting a worksheet
Moving a worksheet


FONT FORMATTING
Font type
Font size
Bold, italic, underline formatting
Cell border formatting
Formatting the background colour
Formatting the font colour

NUMBER FORMATTING

Number formatting
Decimal point display
Comma formatting
Currency symbol
Date styles
Percentages


FREEZING ROW AND COLUMN TITLES
Freezing row and column titles

FORMULAS

Creating formulas
Operators

CELL REFERENCING

Relative cell referencing within in formulas
Absolute cell referencing within formulas

FUNCTIONS

What is a function?
Common functions
Sum function
Average function
Max function
Min function
Count function
What are IF functions?
Using the IF function

WORKSHEET SETUP

Worksheet margins
Worksheet orientation
Headers and Footers
Scaling your worksheet to fit a page(s)

PREPARING TO PRINT A WORKSHEETS

Visually check your calculations
Previewing a worksheet
Zooming the views

Who should attend?

This is a course with a high level of practical content, aimed at those who have not used Microsoft Excel for Windows before.  It is designed for candidates with widely differing experience and skill levels.

Pre-requisites

No previous experience of Microsoft Excel for Windows is necessary, but candidates should have a good understanding of computer basics and be familiar with the Windows operating system.
Powered by Create your own unique website with customizable templates.