Microsoft Excel - Excel from Beginner to Advanced 2023 | Royal Open College

Search

Courses
Health and Social Care
Health Care
Health and Safety
Food Hygiene and Safety
Counselling and Therapy
Career and Employability
Administration and Office Skills
View All

Health and Social Care Level 3 Diploma

Level 5 Designated Safeguarding Lead (DSL)

Level 5 Diploma in Pastoral Safeguarding

Health and Social Care Level 2 Diploma

Care Certificate Course – Standards (1 to 16)

Health and Social Care Level 5 Diploma

Family Support Worker Level 5 Diploma

Level 3 Safeguarding Children and Vulnerable Adults

ADHD Training

Understanding Autism Level 2 Diploma
Hot Deals
Subscription
Live Training

Login

Microsoft Excel – Excel from Beginner to Advanced 2023 12 Sections45 LessonsLifetime Access

Curriculum

12 Sections
45 Lessons
Lifetime Access

Expand all sectionsCollapse all sections

Module 1: EXCEL BASICS
7 Items
Module 2: ROWS, COLUMNS, AND CELLS
2 Items
- 2.1
  Adding Rows and Columns
- 2.2
  Modifying Rows and Column lengths
Module 3: DATA HANDLING
2 Items
- 3.1
  Copy, Cut, and Paste
- 3.2
  Copying Formulas
Module 4: PAGE SETTING UP AND PRINT
3 Items
Module 5: SORTING AND FILTERING
3 Items
Module 6: WRITING FORMULAS
4 Items
Module 7: ADVANCED FORMULAS
2 Items
- 7.1
  VLOOKUP formula
- 7.2
  HLOOKUP formula
Module 8: XLOOKUP ONLY FOR 2021 AND OFFICE 365
2 Items
- 8.1
  XLOOKUP
- 8.2
  Handling and Approximates match in XLOOKUP
Module 9: DATA AND TOOLS
6 Items
Module 10: FORMATTING DATA AND TABLES
5 Items
Module 11: PIVOT TABLES
2 Items
- 11.1
  Pivot Tables
- 11.2
  Pivot Charts
Module 12: CHARTS
7 Items

This content is protected, please login and enroll in the course to view this content!

Start Excel Spreadsheet

Royal Open College provides high-quality online courses covering a variety of topics along with certificates issued by top organisations.

+447877601578
01223 944865
info@royalopencollege.org

Facebook X-twitter Instagram Pinterest Linkedin Youtube

Explore

FAQs
Blog
About Us
Contact Us
Privacy Policy
Terms & Conditions
Accreditations

FAQs
Blog
About Us
Contact Us
Privacy Policy
Terms & Conditions
Accreditations

Important Links

Order Your Certificate
Redeem Voucher
Become an Instructor
Become an Affiliate
Claim Your Pre-ordered Certificate

Order Your Certificate
Redeem Voucher
Become an Instructor
Become an Affiliate
Claim Your Pre-ordered Certificate

royat open college 14 days moneyback guarantee

royat open college 100% satisfaction guarantee

Payment methods possible

Company Registration No : 14422633

Copyright © 2026 Royal Open College. All Right Reserved.

Privacy Policy | Terms & Conditions

Added to cart

Your Cart Is Empty

0

Check out our shop to see what's available

Cart Total: Total£0.00

Your cart is empty. Shop now →

Log in with your account

Lost your password?

Remember Me

Not a member yet? Register now

Register a new account

Are you a member? Login now

Modal title

Main Content