Intermediate Microsoft Excel Training

Intermediate Microsoft Excel Training Intermediate Microsoft Excel Training
By TED Integrated
PSMB HRDF Claimable
Course Title:
Microsoft® Excel 2007/2010 – Intermediate Level
Training Category:
Information Technology
Target Audience:
Anyone who has used Excel before to create and alter simple spreadsheets.
Duration:
1 Day
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • Computer Lab Work
  • Internet Access
  • Case Studies
  • Certificate of Participation
Ad by Google
Microsoft Excel Training Series:

Microsoft® Excel 2007/2010 – Intermediate Level

“Already have some basics on Microsoft Excel? Move forward to the intermediate level for higher productivity and efficiency!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service+603-2386-7788

Introduction

In this one day Intermediate Excel course, students will be able to apply intermediate features of Microsoft Excel to improve their work quality and productivity. These features are like creating new templates, charts, using functions and range name. With this 1-day hands on training under the guidance of an experienced trainer, students can pick-up more easily than going for trial-and-error basis all by themselves in a time consuming manner. By completing this intermediate level of Microsoft Excel course, students will also be able to proceed to advanced level if they want to. This intermediate course is also one of the most popular Excel courses as most people already have the basic experience of Microsoft Excel.

Prerequisites

Students are encouraged to attend Foundation level before attending Intermediate level. In addition experience in creating, editing, formatting, saving and printing basic spreadsheets in Foundation level. To ensure program run successful, students are advisable to have a basic excel skills.

Course Objectives

At the end of this training program, participants should be able to understand the following:

  • Customizing and Enhancing Workbooks and the Excel Environment
  • Functions and Formulas
  • Working With Names and Ranges
  • Presenting Data Using Charts
  • Conditional Formatting

Course Outline

DAY 1

Lesson 1: Customizing and Enhancing Workbooks and the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Create and Use Templates

Lesson 2: Functions and Formulas

  • Basic Mathematical Functions
    • Sumif
    • Sumifs
    • Countif
    • AverageA
  • Inserting Dynamic Dates and Times
    • Today
    • Now

Lesson 3: Working With Names and Ranges

  • What's in a Name?
  • Creating Names Using Define Name Dialog Box
  • Creating Name Using the Name Box
  • Rules for Naming Names
  • Creating Names Automatically
  • Using Names in Formulas
  • Deleting Names

Lesson 4: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Saving a Chart Template

Lesson 5: Conditional Formatting

  • Applying Cell Highlighting
  • Applying Top, Bottom and Average Rules
  • Applying Data Bars, Color scales and Icon Sets
  • Customizing Rule
  • Managing Rules

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service [email protected]

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,