Microsoft Excel Training

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)

• 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: