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.
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
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.
Our courseware includes include real world, interactive exercises. The exercises always focus on real world scenarios and skill-set development.
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.
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.
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:
| Location Postcode | Dublin 2 |
| Course Type | Online Learning |
| Course Qualification | Award / Certificate |
| Awarding Body | Microsoft |
| Course Duration | 12 months |
| Course Time | Flexible Online Study |
| Course Fee | 225.00 |
| 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. |
The objective of this Business Administration distance learning course is to develop your understanding of the administration of an organization, enabling you to appreciate the impacts of the factors which may affect a business.
Would you like to see your writing in print? Could you write a best seller? Our experienced Creative Writing tutor will guide and help you to develop your writing skills throughout your Kilroy’s College Creative Writing course.
This general Education Studies course will provide you with a sound basic knowledge in Mathematics, Written English and recent Irish History.
By studying our Nail Technician course you will learn the skills and acquire the knowledge you will need to succeed in the nail business.
