Microsoft Excel Training Course + Exam Details

Microsoft Excel Training Certification

At Logitrain, we offer Microsoft Office excel training course specialist 2013 certification, which is the latest office specialist certification program. This specialization helps individuals to validate their skills and advance their careers. Microsoft excel training course specialist 2013 enables candidates to develop mastery in MS Excel and learn the formulas used in it. In the market, there is high demand of real excel experts, because it is used in almost everywhere.

Logitrain not only focuses on delivering training sessions to students, but we aim to penetrate in every student’s mind and enable them to learn from the basics while clearing out all kinds of confusions and misconceptions. This makes our students better equipped with the certifications.

Course price includes classroom-based, instructor-led, hands-on training + course material + official MOS certification exam + practise questions

Basic Computer Knowledge

Candidates can achieve this certification by passing the following exam(s).

  1. Microsoft 77-420
  2. Microsoft Excel 2013

The certification exam can be registered and attempted within 3 months of course/module completion at Logitrain training centre on weekdays during normal business hours (excludes public holidays)

Image of the book Exam 77-420 Microsoft Excel, this is included with the training course at Logitrain

(course material provided is shown above)

  • Getting Started with Excel
  • Performing Calculations in an Excel Worksheet
  • Modifying an Excel Worksheet
  • Modifying Worksheet Appearance
  • Manipulate Page Setup options for worksheets
  • Applying AutoFill
  • Managing an Excel Workbook
  • Managing Worksheets
  • Printing Excel Workbooks
  • Calculating Data with Advanced Formulas
  • Organizing Worksheet and Table Data
  • Analyzing Data Using PivotTables, Slicers, and PivotCharts
  • Inserting Graphic Objects
  • Customizing and Enhancing Workbooks and the Excel Environment
  • Sharing Worksheet data with other users
  • Sharing Spreadsheets by using Backstage

This course is likely to add to the employment related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.

  • University students
  • Helpdesk operators
  • Candidates entering IT job market
  • First-level network support staff
  • Individuals seeking MOS certification
  • Identify the Elements of the Excel Interface
  • Navigate and Select Cells in Worksheets
  • Customize the Excel Interface
  • Create a Basic Worksheet
  • Create formulas
  • Enforce precedence
  • Apply cell references in formulas: Relative, absolute
  • Apply conditional logic in a formula
  • Apply named ranges in formulas
  • Apply cell ranges in formulas
  • Copy Formulas from one Worksheet to another
  • Edit Worksheet Data
  • Find and Replace Data
  • Manipulate Worksheet Elements
  • Formatting Cells and Worksheets
  • Apply Font Properties
  • Add Borders and Colors to cells
  • Align Content in a Cell
  • Apply Number Formatting
  • Apply Cell Styles
  • Merging and splitting cells
  • Using the Format Painter
  • Create row and column titles
  • Print row and column headings
  • Print rows to repeat with titles
  • Print columns to repeat with titles
  • Configure Titles to print only on Odd or Even pages
  • Configure Titles to skip the first worksheet page
  • Hide and Unhide Rows and Columns
  • Configure page orientation, manage page scaling
  • Configure page margins
  • Change Header and Footer size
  • Create and apply cell styles
  • Copy data using AutoFill
  • Fill series using AutoFill
  • Copy or preserve cell format with AutoFill
  • View Worksheets and Workbooks
  • Apply and manipulate hyperlinks
  • Create, Modify and Remove Hyperlinks
  •  Define the Page Layout
  • Print a Workbook
  • Calculate Data across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions
  • Apply conditional logic in a formula
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Presenting Data Visually
  • Presenting Data Using Charts
  • Create a chart
  • Modify Charts
  • Format Charts
  • Apply and manipulate illustrations
  • Create and modify images by using the Image Editor
  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts
  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects
  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Manage Comments
  • Insert, view, edit, and delete Comments

Weekdays (Full-Time) course offers more benefits:

Logitrain full-time courses offers course resit


Sit through the course again
if you want

Logitrain mock tests

Mock Tests

Get confidence to pass & assess your preparation before the exam

Logitrain full-time courses includes meals


No need to look for café`s, lunch and refreshment included

What is included with the Microsoft Excel Training Course?
Logitrain course includes official certification exam fee.
Includes Official Exam Fee

Take the certification exam within 3 months of course / module completion

Logitrain is an Authorised Pearson VUE Test Centre.
Authorised Test Centre

Take the official vendor certification exam at the Logitrain training center

Logitrain courses, programs and packages includes course material.
Includes Course Material

Course material in digital format is included for flexibility and ease of use

Logitrain courses, packages and programs includes sample practise questions.
Includes Mock & Test Questions

Mock test is included in the full-time courses to assist with your preparation

Skilled Trainers
Highly Skilled Trainers

Our trainers are highly skilled with expertise and extensive hands-on experience

Logitrain courses include price beat guarantee.
Our Price Beat Guarantee

Relax, we will beat competitor’s advertised price in Australia. Our course has no extra costs

Dates, Locations & Prices
Logitrain Live Online Training Banner

Location Type Duration Price Dates
Location Type Duration Price Dates

The supply of this course/package/program is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed dates are given, courses run subject to availability and minimum registrations.


Find out why we are the leading choice to help boost your career in Australia

medal first placePrepare to get IT job ready in 8 weeks

Classroom trainingsTrained 15,000+ professionals and counting

training accessibilityExperienced Provider: Operating Since 2004

TeamworkTrained staff from 1200+ Australian Businesses

We Have Placed Candidates In
Attend live virtual training program

Over 1000 organisations have relied on Logitrain to be their trusted training partner.

five star ratings
High-quality, cost-effective training since 2004
Learn More
  • This field is for validation purposes and should be left unchanged.

Don’t Wait. Please fill the form now.