Microsoft Basic-Intermediate Excel

Microsoft Excel training at Intellisoft.

Looking for Microsoft Basic / Intermediate Excel Training? You have come to the right place.

At Intellisoft, We regularly conduct public classes, And in-house corporate trainings on Basic / Intermediate Excel in Singapore, Malaysia, Indonesia, Middle East, India etc.

COMPANY SPONSORED: Claim SDF, PIC Grants for Training in Basic / Intermediate Microsoft Excel.

SELF SPONSORED: Use SkillsFuture Funding for Basic/Intermediate Excel Training Classes in Singapore.

Basic & Intermediate Excel Training Course
Workshop Duration
Microsoft Basic & Intermediate Excel 2016 Version

– Learn about formatting, workbooks, sheets, simple and intermediate Excel formula, in-built functions, tables, charts, using graphics.

Practical & Hands-on training in Microsoft Excel 2016.

2 Days
Microsoft Basic & Intermediate Excel 2013 Version

– Learn about formatting, sheets, formula, tables, charts, graphics and much more. Practical & Hands-on training in Excel 2013.

2 Days
Microsoft Basic & Intermediate Excel 2010 Version

– Learn about formatting, sheets, formula, tables, charts, graphics and much more. Practical & Hands-on training in Excel 2010.

2 days
Microsoft Basic & Intermediate Excel 2007 Version

– Learn about formatting, sheets, formula, tables, charts, graphics and much more. Practical & Hands-on training in Excel 2007.

2 days
Excel training in Singapore at Intellisoft
Excel training in Singapore at Intellisoft

Course Objectives:

Microsoft Excel for Beginners & Intermediate Level is suitable for beginners to Excel, and people with some experience in using Microsoft Excel. We will teach you how to get more out of Microsoft Excel to make the best use of the software in your day-to-day work.

Improve your productivity and efficiency with the new time saving features in Excel.

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

The class is taught by Certified, Experienced Microsoft Trainers with years of experience in using Microsoft Excel.

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

Course Outline:

Lesson 1: Getting Started with Excel

  • Starting Excel With Excel
  • Using the Ribbon as the Excel 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 in Excel

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

Lesson 3: Managing Worksheets in Excel

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

Lesson 4: Formatting Cells in Excel

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

Lesson 5: Working with Formulas & Functions

  • Excel Arithmetic Operators & Order of Operations
  • Using AutoFill Options
  • Using Commonly Used Functions
  • Writing simple & useful Formulas on your own
Lesson 6: Organizing Worksheet & Table Data

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

Lesson 7: Working with Charts

  • 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
  • Using Chart Titles & Placing Charts

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 Workbooks with Excel

  • 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
  • New Templates in Excel

Target Audience

This program is most suitable who if you want to understand the basic concepts of spreadsheets and want to demonstrate the ability to expertly use Microsoft Excel for keying in, manipulating and reporting data easily.
Be prepared to do a lot of Exercises, to learn the new concepts and shortcuts, tips & techniques of Microsoft Excel.

Pre-Requisites:

Basic knowledge of computers, using the keyboard, mouse and Windows is required. This is a beginner / intermediate 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.

Contact us at +65 6296-2995 for any questions, Or to join our upcoming Basic & Intermediate Excel Training classes in Multiple Versions.

If you have a group of 10 or more participants, we can arrange for our trainer to meet you, and customize the training, to be conducted at your office location.

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!