Loading Please Wait .....

Microsoft Excel Training

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

Retake

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

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 Center.

Authorised Test Center

Take the official vendor certification exam at the Logitrain training center

Logitrain courses, programs and packages includes course material.

Includes Books & Meals

Course material in hardcopy is included. Full-time classroom courses include meals

Logitrain courses, packages and programs includes sample practise questions.

Includes Mock & Test Questions

Mock tests included in full-time courses for 3 months from course completion

Logitrain full-time course includes course retake, if you do not pass the official certification exam.

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. Our course has no extra costs

DATES, LOCATIONS & PRICES

Logitrain Live Online Training Banner


LocationTypeDurationPriceDates
LocationTypeDurationPriceDates

Accreditations

OUR SATISFIED CUSTOMERS

Learn More

  • This field is for validation purposes and should be left unchanged.