Course Overview

This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.

The best way to learn Excel is to use Excel. In this specialization, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. Excel workbooks, quizzes, and challenges provide countless opportunities to practice and use spreadsheet software in a variety of business contexts

Training DurationTotal Training Hours : 30 Hours
Training Duration : 1 Week
Total Training Days : 5 Working Days
Training SchedulesWeekdays (Sunday to Thursday)
Regular Sessions : 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included

WeekEnds (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
Certifications:1) Certificate from Laurels Training Institute, Attested by Knowledge & Human Development Authority (KHDA) government of Dubai, UAE

2) Certificate from American Institute of Professional Studies (AIPS) from USA (After 15 Days of course Completion which will couriered to the attendees office address)
Learning AidsYes
Course MaterialHard & Soft Copies of Study Material
Language of InstructionEnglish
Instructor HelplineYes
1. Email
2. Social Media (For Emergency requirements)
Registration Requirements1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Mode of Payment:Cash / Cheque / Credit Card / Bank Transfer.
Eligibility Criteria
(Who should attend this training)

This course is designed for delegates who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel worksheets.

Business Analysts

All Analysts

Accountants and officers

MIS officers

Admin and support staff"

Course Benefits

Create a basic worksheet by using Microsoft Office Excel 2010.

Perform calculations in an Excel worksheet.

Modify an Excel worksheet.

Format a worksheet.

Print the content of an Excel workbook.

Manage an Excel workbook.
Course Contents / Outline

Getting Started with Excel

Identify the Elements of the Excel Interface

Navigate and Select Cells in Worksheets

Customize the Excel Interface

Create a Basic Worksheet

Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet

Insert Functions in a Worksheet

Reuse Formulas

Modifying a Worksheet


Edit Worksheet Data

Find and Replace Data

Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet


Apply Font Properties

Add Borders and Colors to Cells

Align Content in a Cell

Apply Number Formatting

Apply Cell Styles

 Managing an Excel Workbook


Manage Worksheets

View Worksheets and Workbooks

Printing Excel Workbooks


Define the Page Layout

Print a Workbook



V lookup

H lookup


Conditional Formatting

If Conditions


Master Macros

Formula Mix

Database building"

© Laurels Training Institute 2017. All Rights Reserved.