• No products in the basket.

  • LOGIN

Login

  • 0 Students

  • Certified

Overview

Become a trained professional from the safety and comfort of your own home by taking Excel 365 Advanced . Whatever your situation and requirements, One Education can supply you with professional teaching, gained from industry experts, and brought to you for a great price with a limited-time discount.

One Education has been proud to produce an extensive range of best-selling courses, and Excel 365 Advanced is one of our best offerings. It is crafted specially to promote easy learning at any location with an online device. Each topic has been separated into digestible portions that can be memorised and understood in the minimum of time. 

Teaching and training are more than just a job for the staff at One Education; we take pride in employing those who share our vision for e-learning and its importance in today’s society. To prove this, all learning materials for each course are available for at least one year after the initial purchase.  

All of our tutors and IT help desk personnel are available to answer any questions regarding your training or any technical difficulties. 

By completing Excel 365 Advanced, you will have automatically earnt an e-certificate that is industry-recognised and will be a great addition to your competencies on your CV.

Whatever your reason for studying Excel 365 Advanced, make the most of this opportunity from One Education and excel in your chosen field.

Please be aware that there are no hidden fees, no sudden exam charges, and no other kind of unexpected payments. All costs will be made very clear before you even attempt to sign up.  

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Excel 365 Advanced is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Course Introduction
Introduction 00:01:00
Unit 01
Lesson 01-Customizing the Ribbon 00:09:00
Lesson 02-Customizing the Quick Access Toolbar 00:06:00
Lesson 03-Customizing the General and Formula Options 00:04:00
Lesson 04-Customizing the AutoCorrect Options 00:03:00
Lesson 05-Customizing the Save Defaults 00:04:00
Lesson 06-Customizing Advanced Excel Options 00:03:00
Unit 02
Lesson 01-Working with the Most Common Logical Functions 00:03:00
Lesson 02-Understanding IF Functions 00:06:00
Lesson 03-Evaluating Data with the AND Function 00:05:00
Lesson 04-Evaluating Data with the OR Function 00:03:00
Lesson 05-Creating a Nested IF Function 00:05:00
Lesson 06-Using the IFS Function 00:03:00
Lesson 07-Summarizing Data with SUMIF 00:03:00
Lesson 08-Summarizing Data with AVERAGEIF 00:02:00
Lesson 09-Summarizing Data with COUNTIF 00:02:00
Lesson 10-Summarizing Data with MAXIFS and MINIFS 00:03:00
Lesson 11-Using the IFERROR Function 00:03:00
Unit 03
Lesson 01-What are Lookup Functions 00:03:00
Lesson 02-Using VLOOKUP 00:08:00
Lesson 03-Using HLOOKUP 00:03:00
Lesson 04-Using VLOOKUP with TRUE 00:04:00
Lesson 05-Using HLOOKUP with TRUE 00:02:00
Lesson 06-Using the Index Function 00:03:00
Lesson 07-Using the MATCH Function 00:03:00
Lesson 08-Combining INDEX and MATCH 00:04:00
Lesson 09-Comparing Two Lists with VLOOKUP 00:02:00
Lesson 10-Comparing Two Lists with VLOOKUP and ISNA 00:04:00
Lesson 11-Using the New XLookup Function-v2 00:07:00
Lesson 12-Using Dynamic Array functions-v2 00:06:00
Lesson 13-Other New Functions-v2 00:04:00
Unit 04
Lesson 01-What are Text Functions 00:01:00
Lesson 02-Using CONCAT, CONCATENATE, AND TEXTJOIN 00:04:00
Lesson 03-Using Text to Columns 00:02:00
Lesson 04-Using LEFT, RIGHT, and MID Functions 00:03:00
Lesson 05-Using UPPER, LOWER, and PROPER Functions 00:02:00
Lesson 06-Using the Len Function 00:03:00
Lesson 07-Using the Trim Function 00:01:00
Lesson 08-Using the SUBSTITUTE Function 00:02:00
Unit 05
Lesson 01-What are Date and Time Functions 00:02:00
Lesson 02-Using TODAY, NOW, and DAY Functions 00:03:00
Lesson 03-Using NETWORKDAYS and YEARFRAC Functions 00:03:00
Unit 06
Lesson 01-Showing Formulas 00:03:00
Lesson 02-Tracing Precedents and Dependents 00:04:00
Lesson 03-Adding a Watch Window 00:04:00
Lesson 04-Error Checking 00:04:00
Unit 07
Lesson 01-Using the Scenario Manager 00:07:00
Lesson 02-Using Goal Seek 00:03:00
Lesson 03-Analyzing with Data Tables 00:04:00
Unit 08
Lesson 01-Understanding Protection 00:02:00
Lesson 02-Encrypting Files with Passwords 00:05:00
Lesson 03-Allowing Specific Worksheet Changes 00:02:00
Lesson 04-Adding Protection to Selected Cells 00:03:00
Lesson 05-Additional Protection Features 00:03:00
Unit 09
Lesson 01-What are Macros 00:03:00
Lesson 02-Displaying the Developer Tab 00:03:00
Lesson 03-Creating a Basic Formatting Macro 00:05:00
Lesson 04-Assigning a Macro to a Button 00:03:00
Lesson 05-Creating Complex Macros 00:04:00
Lesson 06-Viewing and Editing the VBA Code 00:04:00
Lesson 07-Adding a Macro to the Quick Access Toolbar 00:03:00
Unit 10
Lesson 01-What are Form Controls 00:02:00
Lesson 02-Adding a Spin Button and Check Boxes 00:04:00
Lesson 03-Adding a Combo Box 00:07:00
Unit 11
Lesson 01-What is Data Validation 00:02:00
Lesson 02-Restricting Data Entry to the Whole Numbers 00:02:00
Lesson 03-Restricting Data Entry to a List 00:04:00
Lesson 04-Restricting Data Entry to a Date 00:02:00
Lesson 05-Restricting Data Entry to Specific Text Lengths 00:01:00
Lesson 06-Composing Input Messages 00:02:00
Lesson 07-Composing Error Alerts 00:03:00
Lesson 08-Finding Invalid Data 00:02:00
Lesson 09-Editing and Deleting Validation Rules 00:01:00
Unit 12
Lesson 01-Working with Comments-v2 00:03:00
Lesson 02-Printing Comments and Errors 00:02:00
Lesson 03-Sharing a Workbook 00:04:00
Lesson 04-Co-Authoring in Excel 00:02:00
Lesson 05-Tracking Changes in a Workbook 00:03:00
Lesson 06-Working with Versions 00:03:00
Lesson 07-Sharing files Via Email-v2 00:03:00
Unit 13
Lesson 01-Importing a Text File 00:04:00
Lesson 02-Exporting Data to a Text File 00:01:00
Course Recap
Recap 00:02:00
Final Exam
Final Exam – Excel 365 Advanced 00:20:00

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business

 width=

 

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

0
Your Cart