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 following exam(s).

  1. Microsoft 77-420
  2. Microsoft Excel 2013

The certification exam if included in your course 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
  • 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:


Sit through the course again
if you want

Mock Tests

Get confidence to pass & assess your preparation before the exam


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

What is included with the Microsoft Excel Training Course?

Includes 100% Pass Guarantee

Walk away with the certification. Included in full-time courses. Click here for more Info

Includes Career Counselling

Career Counselling is an integral part of job hunting, it is included with this course

Includes Trainer & Lab Support

6 month support with full-time courses, 3 month support with part-time courses

Includes Official Exam Fee

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

Includes Mock & Test Questions

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

Includes Books & Meals

Course material in hardcopy included for you to keep. Full-time courses include meals

Includes Course Retake

Sit through the entire course again to clear any doubts. Included in full-time courses

Authorized VUE Test Center

Take the official vendor certification exam at the Logitrain training center

Upgrade Your Course Benefits

Add Pass Guarantee, extra support, retake in part-time course with a full-time fee

Our Price Beat Guarantee

We will beat competitor’s advertised price. Our course has no extra costs

Our Flexible Training Options

Attend classroom courses weekdays, weeknights, weekends or join from anywhere

Delivering Training Since 2004

There is no substitute for experience, we have trained 3000+ students. Train with the best