Basic-Intermediate Excel 2016

Microsoft Excel 2016 Public Classes at Intellisoft Training Rooms or Corporate In-house Training at your office.

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call +65 6250-3575 for Details.  SkillsFuture for Microsoft Excel course is only available for Singaporeans.

UTAP: In addition, NTUC members can utilize UTAP to offset 50% of remaining fees (capped at $250 per year).

Course Overview For Basic-Intermediate Excel Training

Microsoft Excel 2016 is a simple and easy to use software, which improves your office productivity and efficiency in doing numbers and calculations.

It is very easy to pick up, and you can learn the simple tips and tricks in Excel 2016, which make simple to complex tasks easy, with our step-by-step, practical, and hands-on teaching methodology.

Basic-Intermediate Excel 2016 Training @Intellisoft
Basic-Intermediate Excel 2016 Training @Intellisoft

We also have Excel training on the older versions of Microsoft Excel.

Course Duration: 2 Full Days to Learn For Latest Microsoft Excel 2016 – Basic – Intermediate Level

Detailed Outline: Basic-Intermediate Excel Training

Lesson 1: Getting Started with Excel 2016

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

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

Lesson 3: Managing Worksheets in Excel 2016

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

 Lesson 4: Formatting Cells in Excel 2016

  • 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 Auto Fill 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 2016

  • 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 2016

Objectives of This Excel Training Workshop in Singapore

Microsoft Excel 2016 for Beginners & Intermediate Level is suitable for beginners to Excel, and people with some experience in using Microsoft Excel 2016. 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.

Learn Basic-Intermediate Excel 2016
Learn Basic-Intermediate Excel 2016

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

A very Practical, Hands – on approach to learning Excel 2016 – 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 2016 tips & techniques that will make your work faster, efficient, and you will be able to do complex tasks in a matter of minutes.

Go To Top

Target Audience For Basic-Intermediate Excel Training

This program is most suitable for those who want to understand the basic concepts of Excel Spreadsheets and want to show their ability to use Microsoft Excel 2016 for data entry, writing simple formulas, manipulating data and generating simple reports and charts easily.

Be prepared to do a lot of Hands-On Exercises on Excel to learn the new concepts and shortcuts, tips & techniques of Microsoft Excel 2016. This is what makes this Excel Training program unique and beneficial for you.

Go To Top

Detailed Outline: Basic-Intermediate Excel Training

Lesson 1: Getting Started with Excel 2016

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

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

Lesson 3: Managing Worksheets in Excel 2016

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

 Lesson 4: Formatting Cells in Excel 2016

  • 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 Auto Fill 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 2016

  • 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 2016

Go To Top

Pre-Requisites For Basic & Intermediate Level Excel Training

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. All you need is basic PC skills to make the most of this Excel Training Course.

Go To Top

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can Claim SDF Funding, subject to SSG Eligibility Criteria.

Applicable for Company Sponsored Singaporeans & PRs.

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!

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!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help 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..."
Michele Martin
Project Engineer
"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"
Joy Tan
HR Manager

How To Register

How To Register For Basic-Intermediate Excel Training in Singapore

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

Need Help?

  1. Call us at +65 6250-3575, 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 2016 training.

We have regular public classes For Excel Training each month, and Corporate Training can be arranged at your office too!

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 2016 pre – loaded is provided to each participant for use during this workshop.

Join today, and begin to Master Excel 2016 with our Step-by-step instructions, and helpful, patient, Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

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, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!