PMP® Exam Prep Tips

Receive PMP® Exam Preparation Tips & Project Management Articles

Learning For Life

Subscribe to our Learning for Life Newsletter & Get Interesting Articles & Training Updates!

 Email:
Name:
Intellisoft Systems PMI R.E.P.


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

 


Intellisoft Training Calendar   
View the Latest Advanced Excel Training Schedule to reserve a seat.

Course Enquiry

Course Title*
Course Date*
Self / Company Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*
Pass Type (SG / PR / EP / SP / Others)
Number of Participants*

Our Clients

Large MNCs, Local Companies & SMEs have selected Intellisoft Systems as their Training Provider.

Some of our clients are M1, Bayer, 3M, DSO National Labs, OLAM International, National Healthcare Group, HP, NUS, ITE,  LTA, MOH, Richemont, BHP Billiton, Science Centre, American Express, Standard Chartered Bank,  Estee Lauder, Amadeus and many more.


Basic/Intermediate Excel 2010

Microsoft Excel 2010

Course Duration : 2 Full Days (9am to 5pm)

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 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 for Excel 2010 Basic to Intemediate Level

Excel 2010 for Beginners & Intermediate Level is best suited for people who want to get more out of Microsoft Excel and 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.

Who Should Attend?

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 a spreadsheet application on a personal computer.

Excel 2010 – Basic and Intermediate - COURSE OUTLINE

  1. Getting Started with Excel 2010
    a. The Excel environment
    b. Getting Help
    c. Navigating Worksheet
    d. Entering and Editing Data
    e. Save and Open the file
     
  2. Working with Worksheets in 2010
    a. Move and Copy data
    b. Copy and Paste Special
    c. Modifying Worksheet

  3. Using Functions in Excel 2010
    a. Entering Formulas
    b. Commonly used Function
    c. Sumif Functions
    d. Autofill Options
     
  4. Formatting Options within Excel 2010
    a. Formatting Cell
    b. Conditional Formatting
    c. Format Painter
    d. Number, Date formatting
    e. Find and Replace
    f. Working with Styles

  5. Creating Charts With Excel 2010
    a. Creating Charts
    b. Modifying Charts
    c. Working with Pie Charts
    d. Sparkline
     
  6. Working with illustrations
    a. Picture
    b. Drawing Shapes
    c. Smart Art
    d. Clip Art

  7. Managing Large Workbooks in Excel 2010
    a. View large Worksheets
    b. Splitting, Freezing
    c. Preparing to Print
    d. Page Setup Options
     
  8. Filtering with Microsoft Excel 2010
    a. Sorting Data
    b. Filtering Data
     
  9. Working with Ribbons in Excel 2010
    a. Customizing Quick Access Toolbar
    b. Customizing Ribbon
    c. Customizing Group

  10. Pivot Table with Excel 2010 (Optional)

How to Register for Microsoft Excel 2010 - Basic to Intermediate Class:

Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at 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 Singapore.

The funding is NOT AVAILABLE TO INDIVIDUALS - only to Company Sponsored Singaporeans/PRs.

Call Kamini at 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.

 

PMP is a registered mark of Project Management Institute, Inc.