Basic-Intermediate Excel 2010

Training For Your Entire Department?
We offer Customized Solutions For Training at Your Office or Our Training Centre
Get Corporate Training Quote
One-to-One Training
Can’t attend the whole day?
Get a 1-1 coaching for the topics you need.
Arrange a One-To-One Training

Microsoft Excel 2010 Public Classes at Intellisoft Training Rooms 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. SkillsFuture credits ready for Singaporeans.

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.

We also have Excel training on other versions

Course Duration : 2 Full Days

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
Lesson 1: Getting Started with Excel 2010

  • Starting Excel
  • Excel 2010 Working Environment
  • Using the Ribbon as the Excel 2010 User Interface
  • Navigating within the Worksheet
  • Selecting a Cell or Range of Cells
  • Entering Data
  • Entering Cell Contents
  • Cutting, Copying, and Pasting Cell Values
  • Copy and Paste Special
  • Saving your Workbook
  • Opening your Workbook

Lesson 2: Managing Rows & Columns

  • Inserting, Moving & Deleting Cells
  • Managing Columns and Rows
  • Hide and Unhide Rows/Columns
  • Changing Column Width & Row Height

Lesson 3: Managing Worksheets

  • Format Worksheet Tabs
  • Insert and Delete Worksheet
  • Move and Copy Worksheet
  • Hide & Unhide Worksheet

 Lesson 4: Formatting the Cell

  • Formatting the Cell
  • Number and Date Formatting
  • Finding and Replacing Text
  • Working with Styles

 Lesson 5: Working with Formulas and Functions

  • Excel Arithmetic Operators & Order of Operations
  • Using AutoFill Options
  • Using Commonly Used Functions
  • Using SUMIF() and COUNTIF():
    Adding and Counting only the Cells you Specify
Lesson 6: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table

Lesson 7: Working with Chart

  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Change the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart

Lesson 8: Working with Graphics

  • Adding Pictures into a Worksheet
  • Customizing Pictures and Objects
  • Adding Drawing Objects into a Worksheet
  • Adding SmartArt into a Worksheet
  • Adding Clip Art into a Worksheet

Lesson 9: Managing Large Workbook

  • Managing Large Workbooks
  • Printing Worksheets
  • Setting Page Setup Options
  • Setting Page Breaks

Lesson 10: Customizing & Enhancing Workbooks

  • Customizing Excel to the Way You Work
  • Creating Hyperlinks
  • Working with Workbook Themes
  • Working with Templates

Pre-Requisites

Basic knowledge of computers, using the keyboard, mouse and Windows is required. This is a beginner level program, so we will teach you all about getting started with Excel, and then how to get the most of it for day to day use at your office or home.

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.

Go To Top

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.

Go To Top

Course Outline
Lesson 1: Getting Started with Excel 2010

  • Starting Excel
  • Excel 2010 Working Environment
  • Using the Ribbon as the Excel 2010 User Interface
  • Navigating within the Worksheet
  • Selecting a Cell or Range of Cells
  • Entering Data
  • Entering Cell Contents
  • Cutting, Copying, and Pasting Cell Values
  • Copy and Paste Special
  • Saving your Workbook
  • Opening your Workbook

Lesson 2: Managing Rows & Columns

  • Inserting, Moving & Deleting Cells
  • Managing Columns and Rows
  • Hide and Unhide Rows/Columns
  • Changing Column Width & Row Height

Lesson 3: Managing Worksheets

  • Format Worksheet Tabs
  • Insert and Delete Worksheet
  • Move and Copy Worksheet
  • Hide & Unhide Worksheet

 Lesson 4: Formatting the Cell

  • Formatting the Cell
  • Number and Date Formatting
  • Finding and Replacing Text
  • Working with Styles

 Lesson 5: Working with Formulas and Functions

  • Excel Arithmetic Operators & Order of Operations
  • Using AutoFill Options
  • Using Commonly Used Functions
  • Using SUMIF() and COUNTIF():
    Adding and Counting only the Cells you Specify
Lesson 6: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Getting Summary Information in a Table

Lesson 7: Working with Chart

  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Change the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart

Lesson 8: Working with Graphics

  • Adding Pictures into a Worksheet
  • Customizing Pictures and Objects
  • Adding Drawing Objects into a Worksheet
  • Adding SmartArt into a Worksheet
  • Adding Clip Art into a Worksheet

Lesson 9: Managing Large Workbook

  • Managing Large Workbooks
  • Printing Worksheets
  • Setting Page Setup Options
  • Setting Page Breaks

Lesson 10: Customizing & Enhancing Workbooks

  • Customizing Excel to the Way You Work
  • Creating Hyperlinks
  • Working with Workbook Themes
  • Working with Templates

Go To Top

Pre-Requisites

Basic knowledge of computers, using the keyboard, mouse and Windows is required. This is a beginner level program, so we will teach you all about getting started with Excel, and then how to get the most of it for day to day use at your office or home.

Go To Top

Microsoft Access 2010 Training at Intellisoft

Claim SDF & PIC Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Further, they can claim 40% of training fee or 400% Tax Rebate from IRAS With PIC scheme.

skills-future-training

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

computer-training-participants

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

How To Register

Register for the 2 Days Excel Basic-Intermediate 2010 today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at +65 6296-2995, SMS / WhatsApp: +65 9066-9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have  any questions regarding Excel Basic-Intermediate 2010 training.

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, helpful, patient, Microsoft Certified Trainers to guide you.

Some of the companies that experienced our trainings

“The expert trainers really made a difference. I would have never discovered so many shortcuts, tips & tricks of Excel on my own! The training was everything I hoped for, and more…”
Learn WordPress at Intellisoft Singapore
Julia Andrews
Sales Manager
“What I love about this training is that the trainers made sure we practice the steps on our own. The practical exercises & examples helped a lot. I will definitely come back for more trainings”
25497478040_140ce47f31_k.jpg
Joy Tan
HR Manager

Accelerate your Career With the Most Effective Training!

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!