Microsoft Excel 2010/2013 Intermediate Training

Microsoft Excel 2010/2013


A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel 2010/2013 Beginner course.

Microsoft Excel spreadsheet software has become an integral part of most business organizations across the world. MS Excel is used for various purposes by business establishments. Some organizations use this spreadsheet software for generating memos, track sales trends, and other business data. Microsoft Excel spreadsheets software come with million rows of data and automate number crunching, but this popular spreadsheet software is capable of doing more than just figures. MS Excel has a simple interface, that allows users to easily understand this software and also perform basic activities.

Microsoft Excel is commonly used for financially-related activities. The reason for its popularity is that the user can define custom formulas for calculating quarterly, half yearly and annual reports. This spreadsheet software also helps the individuals and professionals to effectively keep a track of sales leads, project status reports, and invoice reports. Microsoft Excel is also very popular among professionals from science background as it allows them to easily work with statistical formulas and graphing.

Following are the learning benefits of Microsoft Excel 2010/2013 Intermediate training program:

  • Trained candidates will be able to carry out conditional formatting and apply it to tables, worksheets, PivotTables, and cells and also use formulas for applying conditional formatting.
  • Participants will be able to use VLOOKUP for finding relevant information or data from large spreadsheets.
  • Filter and sort data entailed here enables the professionals to quickly huge sets or lists of data and extract the necessary information.
  • Trained participants will be able to switch and upgrade to newer versions of Excel and begin with the new version.

MS Excel 2010/ 2013 (Intermediate)

Date Venue Early Bird
5-6th March 2018 Training Centre: Wisma Goshen, Plaza Pantai, KL
23rd February 2018
3-4th May 2018 23rd April 2018
FEE Venue Early Bird After Early Bird
KL RM 475 RM 575
Penang,Langkawi RM 675 RM 875

OR Register 1st and 2nd Person gets 20% Discount


Calculating With Formulas

  • How formulas work
  • Using “$” in formulas
  • SUM function
  • MAX and MIN function
  • AVERAGE and AVERAGEA function
  • COUNT and COUNTA function
  • COUNTIF & SUMIF function

Customising & Enhancing Excel Environment

  • Using freeze panes
  • Using split windows
  • How to handle multiple windows
  • Using sheet tab colours
  • How to copy worksheets
  • Grouping worksheets

Inserting Graphic Objects

  • Drawing and modifying shapes
  • Illustrating workflow with smart art
  • Inserting and modifying pictures
  • Removing picture background
  • Layering, resizing and grouping objects

Data Visualisation With conditional Formatting

  • How to use conditional formatting
  • Using conditional formatting presets
  • Managing and prioritising rules
  • Using top bottom rules
  • Customising data bars
  • Using formulas in conditional formatting

Data Visualisation With Sparkline

  • Inserting sparklines
  • Formatting sparklines

Data Visualisation With Charts

  • Creating a chart
  • Using Excel’s recommended charts
  • Formatting charts
  • Changing chart data
  • Filtering chart data
  • Creating a dual axis line chart
  • Saving a chart template