Excel 365 Advanced

Excel 365 Advanced

Learning Outcome

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 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
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon