Microsoft Excel 2010/2013/2016 Intermediate

Excel intermediate

Microsoft Excel 2010/2013/2016 Intermediate Training

Prerequisites

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

About Our Excel Intermediate Training

Microsoft Excel spreadsheet software has become an integral part of most business organizations across the world so it is used for various purposes by business establishments. Some organizations use this spreadsheet software for generating memos, track sales trends, and even more business data. Microsoft Excel spreadsheets software come with million rows of data and automate number crunching, while 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.

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 also begin with the new version.

What can excel be used for in business?

Microsoft Excel is commonly used for financially-related activities due to its popularity is that the user can define custom formulas for calculating quarterly, half-yearly also 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.

Training Schedule, Cost and Place

DateVenueEarly Bird
24-25th January 2019Training Centre: Wisma Goshen, Plaza Pantai, KL
9am-5pm
14th January 2019
5-6th March 201925th February 2019
9-10th May 201929th April 2019
8-9th July 201928th June 2019
FEEVenueEarly BirdAfter Early Bird
KLRM 500RM 600

COURSE CONTENTS

Module 1 : 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

Module 2 : 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

Module 3 : Inserting Graphic Objects

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

Module 4: 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

Module 5 : Sparkline

  • Inserting sparklines
  • Formatting sparklines

Module 6 : 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
No announcements at this moment.

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 3 students
Duration: 2 Days
Level: Intermediate

Archive

Working hours

Monday9:30 am - 6.00 pm
Tuesday9:30 am - 6.00 pm
Wednesday9:30 am - 6.00 pm
Thursday9:30 am - 6.00 pm
Friday9:30 am - 5.00 pm
SaturdayClosed
SundayClosed