Course Description

Microsoft Excel – IT Skills Preparation Course for MOS Exam

Kilroy’s College



In today’s competitive economic climate, having certifications that validate one’s skills are essential to “set yourself apart from the pack” in the marketplace. Having Microsoft certifications not only increase one’s marketability but also validates an employee’s skills and experience to a potential employer.

The Microsoft Office Excel 2013 exam assesses candidates for their knowledge of Microsoft Office Excel 2013. The certification is targeted at professionals who are involved in creating business deliverables with Microsoft Office Excel 2013 and might have experience with previous versions of Microsoft Office Excel. The exam covers areas to create, modify, and manage common business workbooks and worksheets in organizations of every size. Candidates for this exam should be able to use Microsoft Office Excel 2013 to create and edit professional-looking spreadsheets for a variety of purposes and situations.


Course Contents

Introducing Excel

Entering and Editing Worksheet Data

Essential Worksheet Operations

Working with Cells and Ranges

Introducing Tables

Worksheet Formatting

Understanding Excel Files

Using and Creating Templates

Printing Your Work

Introducing Formulas and Functions

Creating Formulas That Manipulate Text

Working with Dates and Times

Creating Formulas That Count and Sum

Creating Formulas That Look Up Values

Creating Formulas for Financial Applications

Miscellaneous Calculations

Introducing Array Formulas

Performing Magic with Array Formulas

Getting Started Making Charts

Learning Advanced Charting

Visualizing Data Using Conditional Formatting

Creating Sparkline Graphics

Enhancing Your Work with Pictures and Drawings

Customizing the Excel User Interface

Using Custom Number Formats

Using Data Validation

Creating and Using Worksheet Outlines

Linking and Consolidating Worksheets

Excel and the Internet

Protecting Your Work

Making Your Worksheets Error Free

Importing and Cleaning Data

Introducing Pivot Tables

Analyzing Data with Pivot Tables

Performing Spreadsheet What-If Analysis

Analyzing Data Using Goal Seeking and Solver

Analyzing Data with the Analysis ToolPak

Introducing Visual Basic for Applications

Creating Custom Worksheet Functions

Creating UserForms

Using UserForm Controls in a Worksheet

Working with Excel Events

VBA Examples

Creating Custom Excel Add-Ins


Our Microsoft Excel course includes

Expert Instructor-Led Training

We use the content from the finest publishers and only the IT industry’s finest instructors. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can study at your own pace. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.

Interactive Exercises

Our courseware includes include real world, interactive exercises. The exercises always focus on real world scenarios and skill-set development.

Exercises, Quizzes & Flashcards

Exersizes, quizzes and flashcards prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes, flashcardsand exercises after each module to ensure you are confident on the topic you have completedbefore proceeding. This will allow you to gauge your effectiveness before moving to the next module in your course.

Practice Test Sets

Our course also include full length practice test sets designed to test your knowledge under real exam conditions. The course has a number of test sets consisting of hundreds of items to ensure you are 100% prepared before taking your certification exam.

Exam Simulators

There are online labs to supplement your training. These labs are inexpensive and way safe to explore and learn. They are versatile – labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Please note that this course is available for the following MS Office versions:

  • Microsoft Office 2013
  • Microsoft Office 2010
  • Microsoft Office 2007

 



College Name Kilroy’s College
Course Category Computers & IT (Information Technology), Microsoft Excel
Course Type Online Learning
Course Location Dublin, Ireland
Location Postcode Dublin 2
Delivery mode Elearning
Course Fee 225.00
Course Duration 12 months
Course Times Flexible Online Study
Awarding Body Microsoft
Entry Requirements The good news is that you don’t need any previous experience or qualification to take this Microsoft Excel course.
Career Path This Kilroy’s College MOS outlook course is ideal for people wanting to develop the basic desktop skills they have learnt from their day to day work. The course is aimed at people looking to improve these vital skills as a general introduction to the world of IT or for people who have specific computer requirements and want to use them more effectively as part of their current job.
For information about Kilroy’s College, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

Kilroy’s College



(01) 662 0539
Wentworth House, Dublin, Republic of Ireland

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to Kilroy’s College.



Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map