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:

1. Customizing and Enhancing Workbooks and the Excel Environment
2. Functions and Formulas
3. Working With Names and Ranges
4. Presenting Data Using Charts
5. Conditional Formatting