Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Basic & Intermediate Excel 2007


SDF Funding is available to Singapore Companies (For company sponsored candidates). Call 6296-2995 for Details.

Course Duration :
2 days

Excel is a simple tool, and it is very easy to pick up, with our simple tips and tricks and step-by-step approach.

Learn Microsoft Excel 2007 easily in 2 day hands-on workshop in Singapore.

 


Course Objectives

Excel for Beginners & Intermediate Level is best suited for people who are relatively new to Excel, and want to get more out of Microsoft Excel to make the best use of the software in their day-to-day use.

Learn Excel tips and techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes or seconds.

Target Audience

The Microsoft Excel Training Program is highly recommended for those who to understand the basic concepts of Excel  spreadsheets and want to demonstrate the ability to expertly use a spreadsheet application.

Level: Beginners in Excel 2007 with basic skills. We will teach you how to use Microsoft Excel 2007 from the begining - with our step by step approach.

Course Outline

Microsoft Excel 2007 (Beginner/Intermediate Level) Covers:

Day 1 of Excel 2007 Training

Section 1: Getting Started
1.1. Starting Out
1.2. About Workbooks
1.3. Exploring Workbook
1.4. Getting Help in Excel 2007

Section 2: The New Interface
2.1. The Quick Access Toolbar
2.2. The Home Tab
2.3. The Insert Tab
2.4. The Page Layout Tab
2.5. The Formulas Tab
2.6. The Data tab
2.7. The Review Tab

Section 3: Excel Basics
3.1. Working with Excel 2007
3.2. Basic Excel Features
3.3. Moving your Data
3.4. Smart Tags and Option Buttons
3.5. Editing Tools

Section 4: Editing Your Workbook
4.1. Modifying Cells and Data
4.2. Cell Formatting
4.3. Enhancing a Worksheet’s Appearance
4.4. Working with Charts, Part 1
4.5. Working with Charts, Part 2

Section 5: Printing and Viewing your Workbook
5.1. Using the View Tab
5.2. Managing  Single Window
5.3. Managing  Multiple Windows in Excel 2007
5.4. Printing your Workbook
Day 2 of Excel 2007 Training

Section 1: Advanced File Tasks
1.1. Using My Computer within Excel
1.2. Saving your Files
1.3. Using Templates

Section 2: Working with Functions and Formulas
2.1. Using Formulas in Excel
2.2. Exploring Excel Functions
2.3. Using Functions in Excel
2.4. Working with Names and Ranges
2.5. Working with Array Formulas

Section 3: Managing Tables
3.1. Working with Tables
3.2. Working with Records and Fields
3.3. Working with Tables and Filters
3.4. Using Excel as a Database

Section 4: Enhancing your Workbook
4.1. Customizing your Workbook
4.2. Working with Text Boxes
4.3. Word Art
4.4. Clip Art
4.5. Using Objects

Section 5: Finalizing your Workbook
5.1. Protecting your Workbook
5.2. Finishing your Workbook
5.3. Using Excel in Word
5.4. Using Excel and Access
5.5. Using Excel with other Programs and Files
How to Register

Register for the 2 Day Microsoft Excel 2007 – Basic - Intermediate Class Today to Learn Excel. Simply fill the form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at (65) 6296-2995 or (65) 9066-9991.

To claim SDF Funding of $32 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Call Kamini at (65) 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class and begin learning Microsoft Excel 2007. We have regular public classes each month, and Custom Corporate Trainings can be arranged at your office  too!

Intellisoft System Facebook Link Intellisoft System Linkedin Link Intellisoft System Youtube Link Intellisoft System Twitter Link Intellisoft System Blog Link

Course Enquiry

Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*  
Pass Type
No. of Participants*
Our Clients
Mindef Singapore Ministry of Manpower Nanyang Polytechnic National Heart Center Singapore National University Hospital NUS PSB Academy Richemont Standard Chartered Bank Singapore Polytechnic Singapore Land Authority StatsChipPac ST Electronics The RITZ Carlton At Sunrice AXA BNY Mellon Guthre HDB Johnson Control JTC Marina Bay Sands National Park Paypal Semdcorp Vodaphone Xilinx

 

Excel Training Testimonials

I learnt many new tips and techniques to cut down my time in using Excel - Manager, Diethelm Travel

 

Thanks for the excellent training material and step-by-step instructions. The trainer was very knowledgeable about Excel and answered all my questions patiently. - Sentosa Leisure Group.

The greatest strength of this workshop is the handson approach, and a bubbly trainer, which makes the training session much more enjoyable - Changi Airport Group.

Able to apply VLookup, Macros and Pivot Tables easily - M1

Improved my job productivity by 75% - ITE

Exercises and examples to help us understand the functions of Excel, and the pace is good - not too fast and not too slow - Vestas