Microsoft Office Excel 2013 – Complete

Study 365

Add to wishlist

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

Course details

Microsoft Office Excel 2013 Complete Training – Whatever your situation is we’ve got you covered. This course is a complete, in-depth guide to Microsoft Excel, so whether you’re a beginner, or have some experience, you’ll soon have a wealth of knowledge and skills. Having a recognised qualification on your CV is extremely useful and shows potential employers that you can use Excel to the highest standards.

Learning with Study 365 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 unlimited access. An effective support service and study materials will build your confidence to secure your qualification.

COURSE CURRICULUM

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

Course Objectives:

This Microsoft Excel training course will teach you to use the basic to advanced features of Excel in 2013 version. By the end of this course, you will be able to create charts, work effectively with multiple sheets in workbooks, use basic functions effectively, use productivity tools and work with the Excel list/database features.

Course Duration:

You will have unlimited access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straight away, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded a certificate for “Advanced Certificate in Microsoft Office Excel 2013”. Updated on 01 March, 2024

Eligibility / Requirements

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Job roles this course is suitable for:

Administrative Assistant , Personal Assistant , Secretary , Accounts Administrator , Payroll Administrator , Accountant , Accounts Assistant , Bookkeeper , Office Manager , Office Administrator

About Study 365

Study 365 is an online course provider, offering more than 400 courses to students across the globe. We have built a solid reputation which has elevated us to become one of the most trusted and reliable course providers in the online learning marketplace. With over 100,000 students on our books, we’re the preferred choice for many online learners.

Unrivalled choice

At Study 365, we offer a diverse range of online courses, where students can study everything from accounting, to design, beauty therapy, IT and education and training. All of our courses are completely relevant to the real world, so you can gain vital skills applicable to your chosen career.

Accessible and affordable

We aim to make it easy to help you gain new skills, so you’ll find that many of our courses are open to students without previous experience or qualifications. Of course, if you’re looking for a course that builds on existing skills, we offer these too, in which case, entry requirements may be stipulated. Crucially, our courses are affordable, making it easy for anyone to kick-start a new career.

Informative and secure

With our comprehensive course information, we make it simple for you to decide if a particular course is right for you. As well as detailing what the course involves, we reveal who might suit the course, and what career path you could take with it. With real student reviews, you can also find out what others have to stay from their experience of a course.
Once you’ve chosen a course, getting started is quick and fuss-free. Our online system is very secure, so your personal details will be kept safe at all times.

Learn at your own pace

Many people choose to study online because they have other commitments in their daily lives, such as juggling family and work. The beauty of learning through Study 365 is that you can learn at your own pace in the comfort of your own home, at any time of day or night, on any device, to suit your personal circumstances. This flexibility means studying with us is easy, even if your life is already busy.

Expert tutor support

Although you learn on your own with our courses, we appreciate that you’ll need expert guidance to make sure you’re on the right track and to offer support as and when it’s needed. That’s why each course is supported by professional tutors who are experienced and knowledgeable in your chosen course topic.

As good as the classroom

As an expert online course provider, we understand that students expect the same level of course quality as if they were in a classroom situation. At Study 365, all of our courses have been meticulously designed, so they easily rival any style of course offered in a classroom setting.

Versatile and motivated learning

We appreciate that some students can find it hard to motivate themselves to learn online under their own initiative, so we’ve tried to make the courses as inspiring and interesting as possible, to ensure students stay motivated, from start to finish. Tuition comes in the form of professional video tutorials, narrated e-learning modules, interactive quizzes, tests and exams.