Microsoft Excel 2013 Beginner to Advanced

Global Edulink

Add to wishlist

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

Course details

Looking for Microsoft Excel 2013 course for beginners to advanced?

This online Excel course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.

Microsoft Excel is the world’s most popular spreadsheet program; learning how to use the software with Global Edulink shows that you have taken one of the best Excel courses available. This Microsoft Excel 2013 course (USA Stadards) comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace.

Our course includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on realistic scenarios explained by the instructor. In our high definition video lessons led by experienced certified trainers, you will learn basic Excel techniques including: formatting, building formulas, the three essential Excel concepts, how to use logic and text functions, how to organise data by sorting and filtering, how to effectively present your data with chart formats, and much more. You will also learn intermediate and advanced Functions such as: IF, VLOOKUP, INDEX and MATCH, create and format PivotTables, record basic Macros, and more.

As an employee, learning how to use Excel efficiently provides value, since most jobs utilise this application. This opens up more opportunities for employment and career advancement. Whether you use Excel for work or study, this online Excel course will kick-start journey to becoming an Excel expert and boost your career with our Excel Certificates.

Studying with Global Edulink has many advantages. The course material is delivered straight to you, and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand. This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months). An effective support service and study materials will build your confidence to study efficiently and guide you to secure your qualification.

Please Note: This Course is Based on USA Standards.

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
Merge Workbooks
Export and Import Excel Data
Integrate Excel Data with the Web
Create a Web Query
How to create and edit a Macro

Method of Assessment:

At the end of the course learners will also take an online multiple choice questions assessment test. This online multiple choice questions test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certification:

Successful candidates will be awarded certificate for Certificate in Microsoft Excel 2013 Beginner to Advanced Training. Updated on 13 May, 2024

Eligibility / Requirements

This course is available to all students, of all academic backgrounds. However, basic IT skills would be an advantage.
Learners should be ages 16 or over to undertake the qualification.
Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.

Job roles this course is suitable for:

Admin Assistant , PA , Secretary , Office Administrator , Accountant , Accounting Assistant , Bookkeeper , Office Manager

About Global Edulink

Global Edulink – online education for a skill-hungry workforce

Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.
Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.
How the courses work

Learn with Global Edulink and you’ll have the opportunity to gain insight and knowledge from tutors that are well qualified and experienced in their industry sector. Your tutor will be your mentor and support during your learning journey.

Because each course combines practical and theory, you’ll pick up essential knowledge and gain the confidence to put it into practice at the same time.
High-quality course materials are provided, which you can access at any time during the course, which will help strengthen your knowledge and help you to perform well in the workplace.
You’ll find a course structure focused around modules, which can have mock and final exams at the end, with pass grades and diplomas awarded on completion. Some courses will lead to professional qualifications assessed and awarded by external bodies such as NCFE, PEARSON, and PEOPLECERT etc.
Browse through the course guides and you will find details on any skill level or entry requirements, who the course is best suited to and what you can hope to achieve and build on while you learn. Some courses require no prior knowledge or experience, while others are for those already in a specific job or with some experience to build on. The course details also cover the method of assessment and length of course.

275 students have enrolled with Global Edulink through Laimoon

See all Global Edulink courses

Pay & enrol now