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:

Retake

Sit through the course again
if you want

Mock Tests

Get confidence to pass & assess your preparation before the exam

Meals

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

What is included with the Microsoft Excel Training Course?

Includes Official Exam Fee

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

Authorized Test Center

Take the official vendor certification exam at the Logitrain training center

Includes Books & Meals

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

Includes Mock & Test Questions

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

Includes Course Retake

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

Our Price Beat Guarantee

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

DATES, LOCATIONS & PRICES

online_banner

LocationTypeDurationPriceDates
LocationTypeDurationPriceDates

Accreditations

OUR SATISFIED CUSTOMERS

Learn More

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