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 Qualification | Award / Certificate |
| 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. |
Course Provider
