Current Promotions

PMP Exam Free Preview Session

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

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Basic/Intermediate Excel 2010


Course Duration : 2 Full Days

Microsoft Excel 2010 Public Classes at Intellisoft Training Room's or Corporate In-house Training at your location.

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

Microsoft Excel 2010 is a simple, and easy to use tool, which improves your office productivity and efficiency. It is very easy to pick up, and you can learn the simple tips and tricks in Excel 2010, which make simple to complex tasks easy, with our step-by-step, practical, and hands-on teaching methodology.


Course Objectives

Microsoft Excel 2010 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 Microsoft Excel 2010 tips & techniques that will make your work you work faster, efficiently, and you will be able to do complex tasks in a matter of minutes too!

A very Practical, Hands-on approach to learning Excel 2010 - by doing exercises, and learning simple tips and tricks in the class.

Target Audience

This program is highly recommended for those who want to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel 2010 for keying in, manipulating and reporting data easily.

Be prepared to do a lot of Exercises, to learn the concepts and techniques of Microsoft Excel 2010.

Course Outline
1. Getting Started with Excel 2010
 
  1. Starting Excel
  2. Excel 2010 Working Environment
  3. Using the Ribbon as the Excel 2010 User Interface
  4. Navigating within the Worksheet
  5. Selecting a Cell or Range of Cells
  6. Entering Data
  7. Cutting, Copying, and Pasting Cell Values
  8. Copy and Paste Special
  9. Saving your Workbook
  10. Opening your Workbook
2. Managing Rows & Columns
 
  1. Inserting, Moving & Deleting Cells
  2. Managing Columns and Rows
  3. Hide and Unhide Rows/Columns
  4. Changing Column Width & Row Height
3. Managing Worksheets
 
  1. Format Worksheet Tabs
  2. Insert and Delete Worksheet
  3. Move and Copy Worksheet
  4. Hide & Unhide Worksheet
4. Formatting the Cell
 
  1. Formatting the Cell
  2. Number and Date Formatting
  3. Finding and Replacing Text
  4. Working with Styles
5. Working with Formulas and Functions
 
  1. Entering Formulas
  2. Excel Arithmetic Operators & Order of Operations
  3. Using AutoFill Options
  4. Using Commonly Used Functions
 
6. Organizing Worksheet and Table Data
 
  1. Create and Modify Tables
  2. Sorting and Filtering Data in a Table
  3. Getting Summary Information in a Table
7. Working with Charts
 
  1. Summarizing Data Visually Using Charts
  2. Customizing Chart Data
  3. Format Chart Legend and Titles
  4. Change the Chart Body
  5. Saving the Chart as a Template
  6. Creating a Pie Chart
  7. Summarizing Data Using Sparklines
8. Working with Graphics
 
  1. Adding Pictures into a Worksheet
  2. Customizing Pictures and Objects
  3. Adding Drawing Objects into a Worksheet
  4. Adding SmartArt into a Worksheet
  5. Adding Clip Art into a Worksheet
9. Managing Large Workbook
 
  1. Managing Large Workbooks
  2. Printing Worksheets
  3. Setting Page Setup Options
  4. Setting Page Breaks
10. Customizing & Enhancing Workbooks
 
  1. Customizing Excel to the Way You Work
  2. Creating Hyperlinks
  3. Working with Workbook Themes
  4. Working with Templates
11. Working with Ribbons
 
  1. Customizing Quick Access Toolbar
  2. Customizing Ribbon User Interface
How to Register

Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at (65) 6296-2995.

To claim SDF Funding of $32 for this training, you must be COMPANY SPONSORED, and must be a SINGAPOREAN or PR.

You must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in SingaporeThe funding is NOT AVAILABLE TO INDIVIDUALS - only to Company Sponsored Singaporeans/PRs.

Call Kamini at (65) 6296-2995 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class of Basic to Intermediate Excel 2010.

Note: This class is a very practical, and hands-on workshop session. It requires you to take part in Excel exercises during the class. A laptop with Excel 2010 pre-loaded is provided to each participant for use during this workshop.

Join today, and master Excel 2010 easily, with step by step instructions, and helpful, patient, Microsoft Certified Trainers to guide you.

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