Microsoft Excel 2013 Basic to Advanced

1TRAINING

Add to wishlist

Duration / Course length: Upto 60 Hours Start now
Accredited by: CPDiAP
Certificates:
Sample certificate
Course delivery: This course is delivered in video format

Course details

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

COURSE CURRICULUM

Module 01 : 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

Module 02 : 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

Module 03 : 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

Method of assessment

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.

Certification

If you pass the exam successfully then you will be awarded a Microsoft Excel 2013 Basic to Advanced Training Certificate.
Updated on 14 May, 2024

Eligibility / 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

Job roles this course is suitable for:

Microsoft Excel , office administrator , Microsoft Excel

About 1TRAINING

We believe that online learning should be modern and innovative, which is why we created 1Training. Offering courses on a wide range of topics, we can help you find the career of your dreams, and will help you every step of the way. Cutting edge teaching techniques, a wide range of topics, and the personal touch is our recipe for deliciously simple learning. If you don’t believe us, just ask the 10,000+ people we’ve already helped to realise their full potential.

Company Overview

1Training has established an excellent reputation in the UK for providing professional and vocational training, aiming particularly to train young people for the world of work. 1 Training aims to fill gaps in employment skills, whilst placing an emphasis on the changing nature of work itself. We are regarded as a leading provider of this type of training, as well as general workforce development, and are known throughout the UK and the world for our excellent results.
We offer hundreds of courses in accounting, teacher training, business and office administration, health and social care, project management, accounting, beauty therapy, IT and customer service etc. – providing a worthwhile and practical education in industries that are each rapidly growing and consistently recruiting.

Our Training

All of our 1Training tutors have a wealth of experience and qualifications in their field – they are highly knowledgeable, organised and fully equipped to provide courses that will stimulate and inspire.
Our training courses combine theoretical and practical sessions that work to develop knowledge and ability, as well as instil vital confidence, in our students.
We deliver a high-quality professional and vocational education, using excellent academic course materials that will not only educate but equip you to be successful in your field.
By participating in our education programmes, you will strengthen your academic, vocational, and technical skills through assignments that place an emphasis on each.
1Training is committed to helping all learners acquire worthwhile academic, vocational and technical skills. Upon completion, you will be prepared for the highly skilled, well paid, and in-demand employment opportunities of the 21st-century global economy.

By enrolling in to our online courses, you’ll get: