Course Types
Course Categories
Animal Care
(27 Courses)
Art
(7 Courses)
Business
(46 Courses)
Care
(47 Courses)
Chemistry & Biology
(18 Courses)
Construction & Architecture
(10 Courses)
Cooking & Baking
(8 Courses)
Culture & Tradition
(5 Courses)
Design
(20 Courses)
Environment
(17 Courses)
Fashion & Beauty
(2 Courses)
Finance
(32 Courses)
Health
(204 Courses)
Hospitality
(22 Courses)
HR
(26 Courses)
IT
(45 Courses)
Language
(8 Courses)
Law & Regulations
(12 Courses)
Management
(85 Courses)
Marketing & Sales
(26 Courses)
Office Skill
(20 Courses)
Personal Development
(63 Courses)
Profession
(28 Courses)
Project Management
(10 Courses)
Property & Surveying
(8 Courses)
Safety
(22 Courses)
Science
(14 Courses)
Service
(26 Courses)
Teaching & Academics
(67 Courses)
Travel & Tourism
(2 Courses)
Writing
(8 Courses)Accident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Explore Course Categories
- Explore Course Categories
-
Environment
17 Courses -
Health
204 CoursesHealth View AllAccident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Language
8 Courses -
Management
85 Courses -
Marketing & Sales
26 Courses -
Personal Development
63 Courses -
Science
14 Courses -
Service
26 Courses
-
Explore Careers Categories
-
All Courses
-
Get Adams Premium (Remove Ads)
-
Adams Blog
-
Resume Builder
-
Adams For Business
-
Download the Adams App
Welcome Back!
What will you learn today? Find out with Adams Academy
Sign Up For Free
Join the World's Largest Free Learning Community
-
Welcome Back!
- Don't have an Adams account? Sign Up
or -
Sign Up For Free
Join the World’s Largest Free Learning Community
- Already have an Adams account? Log In
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
This course includes:
-
7 hours, 59 minutes -
CPD Accreditation
-
24 units
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion
Share:
course plublisher
Course CloudLearning Outcomes
- Create and modify tables to organise data effectively.
- Use range names to reference data in Excel easily.
- Analyse data with PivotTables and PivotCharts for insightful data analysis.
- Create advanced charts and trendlines to visualise data trends.
- Use specialized financial, logical, and lookup functions to perform complex calculations.
- Filter and sort data using slicers and date functions to isolate and analyse specific data sets.
- Protect and prepare workbooks for multiple audiences to maintain data privacy and accuracy.
Course Overview
The Microsoft Excel 2016 Part Two course provides you with the advanced understanding and techniques to master the powerful features of Excel. In this course, you will learn how to create and modify tables, use range names, and analyse data with PivotTables and PivotCharts.
The course covers creating advanced charts and trendlines to visualise data trends and using specialised functions to perform complex calculations. You will also learn how to filter and sort data using slicers and date functions to isolate and analyse specific data sets. By the end of the course, you will be able to protect and prepare workbooks for multiple audiences, maintaining data privacy and accuracy.
Course Benefits
The Microsoft Excel 2016 Part Two course provides numerous benefits to individuals seeking to improve their Excel wisdom. Through this course, you will learn how to create and modify tables, use range names, and analyse data with PivotTables and PivotCharts. You will also learn how to create advanced charts and trendlines to visualise data trends and use specialised functions to perform complex calculations.
By filtering and sorting data by using slicers and date functions to isolate and analyse specific data sets, you will be able to gain insights into your data. Additionally, you will learn how to protect and prepare workbooks for multiple audiences, maintaining data privacy and accuracy. With the knowledge learned in this course, you can take your Excel proficiency to the next level.
Career Path
- Financial Analyst – Uses Excel to analyse financial data and create financial reports.
- Data Analyst – Analyzes data to identify trends and patterns for informed decision-making.
- Business Intelligence Analyst – Uses Excel to create dashboards and reports for data-driven decision-making.
- Marketing Analyst – Uses Excel to analyse marketing data and create marketing reports.
- Operations Analyst – Analyzes operational data to identify areas for improvement and cost savings.
- Project Manager – Uses Excel to track project progress, manage budgets, and create project reports.
- Sales Analyst – Analyzes sales data to identify trends and patterns for sales strategy development.
Course content
Microsoft Excel 2016 Part Two -
Module 01 Filter Data by Using Slicers 00:09:00 -
Module 02 Use Text Functions 00:25:00
-
Module 03 Use Subtotal and Database Functions to Calculate Data 00:23:00
-
Module 04 Use Specialized Functions 00:56:00
-
Module 05 Use Lookup Functions 00:15:00
-
Module 06 Use Logical Functions 00:14:00
-
Module 07 Use Financial Functions 00:17:00
-
Module 08 Use Date Functions 00:07:00
-
Module 09 Sort and Filter Data 00:21:00
-
Module 10 Protect Files 00:35:00
-
Module 11 Preparing a Workbook for Multiple Audiences 00:19:00
-
Module 12 Modify and Format Charts 00:13:00
-
Module 13 Manage Themes 00:06:00
-
Module 14 Layer and Group Graphic Objects 00:12:00
-
Module 15 Insert and Modify Graphic Objects 00:32:00
-
Module 16 Customize Workbooks 00:19:00
-
Module 17 Create Charts 00:24:00
-
Module 18 Create and Use Templates 00:15:00
-
Module 19 Create and Modify Table 00:23:00
-
Module 20 Create Advanced Charts 00:20:00
-
Module 21 Create a Trendline 00:14:00
-
Module 22 Create a PivotTable 00:26:00
-
Module 23 Apply Range Names 00:23:00
-
Module 24 Analyze Data with Pivot Charts 00:11:00
Certify Your Skills
A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Adams Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Adams Certification with potential employers to show off your skills and capabilities.
About Course Publisher
Courses
Unlock your potential with Course Cloud, the UK's leading online provider of career-enhancing skills. With everything from IT and business to healthcare and skilled trades, our diverse range of courses are researched diligently and accredit-rated. Enjoy interactive, self-paced learning through diverse formats that include instructor-led sessions, multimedia lessons and expansive study material. You could be the next to power your career with us. Don't miss out on the opportunity of learning anything at any place with unprecedented flexibility through courseware available on any device. With dedicated tutor support, Course Cloud assures a learning journey that is not just informative but transformative. Join us in taking the first step towards achieving your career aspirations. Request the information today in English (UK) language.
More Free Online Courses by This Publisher
Certificate
Learn MySQL from Scratch for Data Science and Analytics
88
Lessons
17
Students
Certificate
Complete Python from Scratch: Start your career in Python 3+
60
Lessons
17
Students
Certificate
Microsoft SQL Server Bootcamp 2022
88
Lessons
10
Students
Certificate
Email Marketing for Beginners
18
Lessons
12
Students
Certificate
Master JavaScript with Data Visualization
76
Lessons
20
Students