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 and many more.
Basic & Intermediate Excel 2007
Do you know how to do simple data analysis, pivoting, charting and simple calculations using Microsoft Excel?
Don't worry. You are not alone. Almost 98% people have never attended any formal Microsoft Excel training class, and suffer daily.
Fortunately, you don't have to suffer any more or be ridiculed by anyone for your lack of Excel skills.
Microsoft Excel 2007 is a simple tool, and it is very easy to pick up, once you know the simple tips and tricks to do simple to complex tasks easily with our step-by-step approach.
We conduct customised and standard Microsoft Excel Training Class in Singapore and other countries in Asia regularly.
Microsoft Excel 2007 Class for Beginner & Intermediate Levels
Microsoft Excel Training Courses Cover The Most Important Topics
- How to Quickly Copy Data From any Source
- Format Text, Numebrs using Colours, Fonts, Alignment Options
- How to Write Formulas in Excel
- The Best Way to Create Charts and Graphs in Minutes
- How to Sort, Find, Replace Data
- Print any section or multiple sections quickly
- How to Present the Data in an Attractive Manner
- How to do Complex tasks in Excel easily
- How to use Pivot Tables to Summarize and Analyze large amount of data
- Learn How to use Auto Fill features
Outline of the 2 Day Basic to Intermediate Excel 2007 Training Workshop:
Day 1
- Opening and Saving Workbook
- Exploring Workbook
- Getting Help in Excel 2007
- The Quick Access Toolbar
- The Ribbons
- The Dialog Box Launcher
- The Window Frame
- Formatting Cells
- Using AutoFill
- Copying and Moving Data
- Smart Tags and Option Buttons
- Find and Replace Data
- Formatting Cells using Mini Toolbar
- Conditional Formatting
- Using Themes
- Creating Charts
- Editing Charts
- Using the View Tab
- Managing a Single Windows
- Managing a Multiple Windows
- Printing your Workbook
- Working with Text Box
- Working with WordArt
- Working with ClipArt
- Working with Other Object
Day 2
Section 1
- Working with Files and Folders
- Saving File into Different Formats
- Using Templates
Section 2
- Auditing Formulas
- Using Statistical Functions
- Using IF function
- Using AutoCalculate
- Using SUMIF, COUNTIF and AVERAGEIF Functions
Section 3
- Working with Tables
- Using AutoFilter
- Using Custom AutoFilter and Advanced Filter
- Performing Data Validation
- Protecting Workbook
- Using Document Inspector
- Using Compatibility Checker
- Mark Workbook as Final
- Insert Objects from other Applications
- Import External Data
- Creating PivotTable
- Perform Calculations Using PivotTables
- Creating PivotCharts
Why should you Learn Basic Microsoft Excel
- Get more out of Microsoft Excel and make the best use of Excel in their day-to-day use.
- It simplifies the work, and you spend less time doing the same stuff, allowing you to do more in the same time.
- 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.
Email to training@intellisoft.com.sg for more information, or call us at 9066-9991. Book Your Seats Early as classes get full pretty quickly.
Who should attend?
This program is highly recommended for those who to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use a spreadsheet application on a personal computer.
We also offer an Advanced Microsoft Excel Training.
Microsoft Excel Class - Training Methodology
Classroom based lessons, exercises, real life scenarios to be practiced in Excel.
This course is taught by very Experienced and Certified Excel trainers. Our trainers will walk you through every day scenarios of doing forecasting, sales analysis, inventory, tracking data in a very simple and easy to use manner. The practical training on Microsoft Excel all the time is the real benefit of this Excel Mastery workshop.
Ready to Register for Basic & Intermediate Microsoft Excel Class?
Fill the Registration form to book your seat for this practical, hands-on Microsoft Excel Training course in Singapore and become an Excel guru yourself...
To claim SDF Funding of $32 for this training, you must register for the training at the SDF website. This SDF funding is available only to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.
Call Kamini at 9066-9991 or send an online enquiry for any questions you have, or to register for the upcoming class.