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.
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.
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|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|
|Lesson 01-Importing a Text File||00:04:00|
|Lesson 02-Exporting Data to a Text File||00:01:00|
|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
Get accredited certificates
Add skills to your CV
Test your skills
For any questions
Set your own speed
Save your money