28
- × MS Access Databases Forms and Reports Level 3 1 × £25
- × PDF Certificate (Special Gift - 67% OFF) 14 × £5.99
- × Yoga Training Diploma 1 × £25
- × Vegan and Vegetarian Cooking 1 × £25
- × Health and Nutrition for Optimal Health 1 × £25
- × Aromatherapy 1 × £25
- × Animal Diet & Nutrition 1 × £25
- × Natural Therapies: Crystal Reflexology 1 × £25
- × Understanding Addiction and Mental Health 1 × £25
- × ACT Therapy for Social Anxiety 1 × £25
- × Access 2016 Essential 1 × £25
- × Access 2019 Intermediate 1 × £25
- × A Beginners Guide to Sports Psychology 1 × £25
- × 3-Statement Budget Model in Excel 1 × £25
- × 5 in 1 bundle £29 1 × £29
Subtotal: £437.86

View basket Checkout
LOGIN

Welcome to

Course Cloud

the best place for online learning!

Keep me logged in

Forgot Password?

Don’t have an account yet? Sign Up

Already have an account? Log In

By signing up, I accept Course Cloud’s Terms & Conditions

Excel 2016 Intermediate

What Will I Learn? Custom Excel Work with Range Names Analyze Data with Common Lookup Functions Analyze and Organize with …

★ ★ ★ ★ ★

5(4 reviews)

860 enrolled on this course

What Will I Learn?

Custom Excel

Work with Range Names

Analyze Data with Common Lookup Functions

Analyze and Organize with Tables

Outline with Subtotals and Grouping

Work with Date and Time Functions

Link Workbooks and Worksheets

Analyze Data with Common Logical Functions

Sort and Filter Range Data

Use Conditional Formatting

Display Data Graphically

Work with Flash Fill

Work with Common Text Functions

Course Overview

You can increase your understanding of various tools in Excel 2016 by completing this Excel 2016 Intermediate course.

You will learn how to manage and view data in Excel. This skill will help you gain new career opportunities upon completion.

In this Excel 2016 Intermediate course, you will be able to confidently work with workbooks, worksheets and more. This course will teach you how to use specific features such as conditional formatting and graphs. Learn how to easily understand pivot tables, work with date and time functions by taking this course. You can also practice what you learn throughout the course.

Excel 2016 Intermediate is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector.
This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Intermediate is packed with [unit_count] modules and [course_duration] of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.
It doesn’t matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime.
Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Preview

Certification

After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).

Course Curriculum

Introduction
	Introduction	FREE	00:01:00
Customizing Excel
	Customizing the Ribbon		00:06:00
	Customizing the Quick Access Tool Bar		00:04:00
	Customizing the General and Formula Options		00:02:00
	Customzing the Auto Correct Options		00:04:00
	Customizing the Save Default		00:02:00
	Customizing Advanced Excel Options		00:03:00
Linking Workbooks and Worksheets
	Linking Workbooks and Worksheets		00:05:00
	Linking Worksheets with 3D References		00:03:00
	Understanding the Consolidate Feature		00:05:00
Working with Range Names and Advanced Formulas
	What are Range Names		00:03:00
	Creating Range Names Using the Name Box and Define Name		00:07:00
	Creating Range Names Using Create from Selection		00:03:00
Analyzing Data with Common Logical Functions
	Working with the Most Common Logical Functions		00:03:00
	Evaluate Data with the AND Function		00:03:00
	Evaluate Data with the OR Function		00:03:00
	Understanding IF Functions		00:04:00
	Nesting AND and OR Inside and IF Function		00:06:00
Analyzing Data with Common Lookup Functions
	What are Lookup Functions		00:02:00
	Using VLookup		00:08:00
	Using HLookup		00:02:00
Sorting and Filtering Range Data
	Differences Between Sorting & Filtering		00:02:00
	Sorting Lists		00:04:00
	Filtering Lists		00:03:00
Analyzing and Organizing with Tables
	Creation and Benefits of a Table		00:02:00
	Elements of a Table		00:03:00
	Formatting a Table		00:03:00
	Sorting Tables		00:02:00
	Filtering Tables		00:03:00
	Filtering with Slicers		00:03:00
	Calculating with Tables		00:04:00
	Removing Erroneous Table Data		00:02:00
	Exporting, Refreshing, Converting Tables		00:02:00
Using Conditional Formatting
	What is Conditional Formatting		00:01:00
	Conditional Formatting and Highlight Cells and Top Bottom Rules		00:04:00
	Conditional Formatting Data Bars, Icon Sets, and Color Scales		00:04:00
	Using Custom Fonts and Colors		00:02:00
	Using Custom Conditional Formatting		00:03:00
	Modify or Remove Conditional Formatting		00:02:00
Outlining with Subtotals and Grouping
	What are Subtotals and Grouping		00:01:00
	Creating Subtotals		00:03:00
	Grouping and Ungrouping Data		00:02:00
Displaying Data Graphically
	What are Charts		00:04:00
	Creating Charts		00:04:00
	Understanding Chart Elements		00:03:00
	Modifying Chart Elements		00:07:00
	Changing and Moving Charts		00:04:00
	Filtering a Chart		00:02:00
	Formatting Charts		00:07:00
	Adjusting Numbering		00:03:00
	Creating Dual Axis Charts		00:02:00
	Forecasting with Trendlines		00:05:00
	Creating a Chart Template		00:01:00
	Displaying Trends with Sparklines		00:04:00
Understanding PivotTables and PivotCharts and Filtering with Slicers
	What is a Pivot Table		00:04:00
	Creating a Pivot Table		00:03:00
	Working with the Pivot Table Fields Pane		00:07:00
	Basic Data Organization and Analysis with Pivot Table		00:04:00
	Formatting Pivot Tables		00:06:00
	Creating a Pivot Chart		00:04:00
	Modifying and Formatting a Pivot Chart		00:03:00
	Adding Slicers and Timeline Slicers		00:03:00
	Formatting Slicers		00:03:00
Working with Flash Fill
	What is Flash Fill		00:01:00
	Using Flash Fill and Autofill		00:03:00
	Filling Various Series		00:04:00
Working with Date and Time Functions
	What are Date and Time Functions-		00:02:00
	Using TODAY, NOW, and DAY Functions		00:02:00
	Using NETWORKDAYS and YEARFRAC Functions		00:02:00
Working with Common Text Functions
	What are Text Functions		00:01:00
	Using CONCATENATE		00:03:00
	Using Text to Columns		00:02:00
	Using LEFT, RIGHT, & MID Functions		00:02:00
	Using UPPER, LOWER, & PROPER Functions		00:02:00
Conclusion
	Course Recap		00:02:00
Resources
	Resources – Excel 2016 Intermediate		00:00:00

Course Cloud Endorsed

Benefits:

Accredited and Endorsed
Professional Credibility
Evidence of Achievement
Certification Validation
Skill Development

CPD QS Accredited

Benefits:

Recognised Internationally
Awarded CPD Hours & Points
Free Additional Transcript
Employer Recognised
Competitive Edge

~~£ 50~~

£ 25

( 50% Off Limited Time )

TAKE THIS COURSE

Add to Cart with Other Products

Buying more than one course?

Get huge discounts for team training!

Buy for Business

Buying for someone special?

Get for Family or Colleagues

Gift this course

This Course Includes

76 Units
1 Year Access
4 hours, 3 minutes
Intermediate
Accredited Certificate

Share this Course:

Frequently asked questions

Can’t find the anwser you’re looking for ? Reach out to customer support team.

Which courses will I be able to study?

As a Lifetime Prime Member, you will receive lifetime access to our entire course library and a student ID card. You will also receive a PDF certificate with every course you complete. Furthermore, you can get unlimited PDF transcripts and 5 hardcopy certificates.

Are there any restrictions?

What does the Prime Learning Membership include?

How do I become a Lifetime Prime Member?

Frequently Bought Together

Product Management

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Lifeguard Training

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Decision Making and Critical Thinking

★ ★ ★ ★ ★

★ ★ ★ ★ ★

4.7(6 reviews)

Add to Cart See More

Welcome to

Course Cloud

Excel 2016 Intermediate

What Will I Learn?

Custom Excel

Work with Range Names

Analyze Data with Common Lookup Functions

Analyze and Organize with Tables

Outline with Subtotals and Grouping

Work with Date and Time Functions

Link Workbooks and Worksheets

Analyze Data with Common Logical Functions

Sort and Filter Range Data

Use Conditional Formatting

Display Data Graphically

Work with Flash Fill

Work with Common Text Functions

Course Overview

Preview

Certification

Course Curriculum

Course Cloud Endorsed

Benefits:

CPD QS Accredited

Benefits:

Buying more than one course?

Get huge discounts for team training!

Buying for someone special?

Get for Family or Colleagues

This Course Includes

Share this Course:

Frequently asked questions

Frequently Bought Together

Important Links

Site Links

Certificate Validator

Important Links

Site Links