Course Description

Microsoft Excel 2013 Beginner to Advanced Level

Microsoft Excel 2013 Beginner to Advanced Level is a course run by 1 Training, Dublin. It is a 'Online Learning' course with a duration of Guided Learning Hours 60. For more information about Microsoft Excel 2013 Beginner to Advanced Level at 1 Training, please review the details below.

Microsoft Excel 2013 Beginner to Advanced Level

Do you need to get to grips with 2013?

Course Description:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course will give a full introduction to Excel, and them moves on to the more advanced functions, so whether you’re a beginner or have some experience, you’ll become an expert.

Our online courses offer you the opportunity to study 24/7 wherever you are in the world. These intensive on line courses are open to anyone with an interest in the topic and give you access to world-class learning led by IAP.

What skills will I gain?

  • Learn how to manage cell contents in a worksheet
  • Learn how to create financial reports
  • Understand accounting formulas, functions & specialised functions
  • Learn cell attributes & cell formatting
  • Gain a full understanding of printing excel sheets
  • Logging in to this course, you’ll learn how to insert & modify graphic objects
  • Learn conditional formatting and data validations
  • Learn how to export, import & integrate data with other sources

What is the target audience?

  • Job hunters & School leavers
  • College or University students, graduates & Teachers
  • Personal assistant & Receptionist
  • Assistant for company director
  • Office Administrators & Office managers
  • Office clerk, Marketing assistant & Administration Assistant
  • Secretary or Executive
  • Account assistance, Bookkeeper & Accountant
  • IT professionals & Businessman

How will I be assessed?

  • At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
  • Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

What Certification am I going to receive?

If you pass the exam successfully then you will be awarded a Microsoft Excel 2013 Basic to Advanced Training Certificate.

Course Curriculum Total Units : 41

Microsoft Excel 2013 – Beginner
Identify the Elements of the Excel Interface
Create a Basic Worksheet & Use the Help System
Create Formulas in a Worksheet
Insert Functions in a Worksheet
Insert, Manipulate, and Delete Cells, Columns, & Rows
Search, Replace Data & Spell Check a Worksheet
Modify Fonts, Add Borders and Color to Cells
Align Cell Contents & Apply Cell Styles
Printing Workbook Contents
Format and Manage Worksheet
Manage the View of Worksheets and Workbooks
Customize General and Language Options
Customize Formula
Customize Proofing and Save Options
Customizing Other of Excel Functions

Microsoft Excel 2013 – Intermediate
Apply Range Names
Use Specialized Functions
Analyzing Data with Logical and Lookup Functions
Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Customizing Workbooks
Manage Themes
Create and Use Templates
Protect Files

Microsoft Excel 2013 – Advanced
Apply Conditional Formatting
Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline
Create Sparklines and Scenarios
Perform a Statistical Analysis with the Analysis ToolPak
Create Interactive Data with Power View
Consolidate Data
Link Cells in Different Workbooks
erge Workbooks
Export and Import Excel Data
Integrate Excel Data with the Web
Create a Web Query

The Microsoft Excel 2013 Beginner to Advanced Level course at 1 Training is listed in's national courses finder.
Training Provider1 Training
Course LocationDublin
Course TypeOnline Learning
Course DurationGuided Learning Hours 60
Course Fee18
Entry Requirements• You must be 16 or over • You should have a basic understanding of English, Maths and ICT • You will need a computer or tablet with internet connection (or access to one) • Learners must have Microsoft Excel 2013 installed onto their computer
Phone+44 208 610 9650
For more information about 1 Training, please visit our College page on by clicking here.

Course Provider

1 Training

63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE, Dublin, United Kingdom. Eircode: EC1N 8LE

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to 1 Training

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


1 Training
63/66 Hatton Garden, 5th Floor, Suite 23, London. EC1N 8LE
United Kingdom
Visit Website