-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Excel 365 Advanced
Excel 365 Advanced
PRIVATE
PRIVATE COURSE OR
1 Year Access 
Advanced
3 Students -
4 hours, 55 minutes
Learning Outcome
- Learn how to customise the ribbon and summarise data sources
- Discover how to use VLOOKUP and the SUBSTITUTE functions
- Know how to set date functions and show formulas
- Gain ways to analyse data tables and add effective encryption
- Explore ways to create complex macros and add combo boxes
- Understand how to validate data and co-author worksheets
Overview
If you feel that you are not using the full potential of Microsoft’s spreadsheet software, you can soon learn how to remedy that with this Excel 365 Advanced training. During these interactive modules, you will be taken beyond beginner and intermediate levels and discover the true potential of spreadsheet software. This knowledge will be essential in upgrading your presentational and calculating abilities to new highs.
This comprehensive Excel tutorial will ensure that you will fully understand all the functions that Microsoft’s platform offers. You’ll be shown how to customise features, manipulate data, add layers of security, share workbooks, and much more. By completing this course, you will gain an edge in business skills and take steps towards becoming a true Excel expert.
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 [course_title] 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 | ||
Related Courses
Intermediate
Important Links
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add