Functional Skills IT Level 2 3 Sections110 Lessons10 Weeks
Curriculum
- 3 Sections
- 110 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Functional Skills IT Level 215 Items
- 1.1How People Use Computers
- 1.2System Hardware
- 1.3Device Ports and Peripherals
- 1.4Data Storage and Sharing
- 1.5Understanding Operating Systems
- 1.6Setting Up and Configuring a PC
- 1.7Setting Up and Configuring a Mobile Device
- 1.8Managing Files
- 1.9Using and Managing Application Software
- 1.10Configuring Network and Internet Connectivity
- 1.11IT Security Threat Mitigation
- 1.12Computer Maintenance and Management
- 1.13IT Troubleshooting
- 1.14Understanding Databases
- 1.15Developing and Implementing Software
- Microsoft Excel Complete Course - Beginner To Professional86 Items
- 2.1Module 1 Intro to Excel
- 2.2Module 1.2 Whats New In Excel 2026
- 2.3Module 1.3 Overview of Formulas
- 2.4Module 1.4 Overview of the Excel window
- 2.5Module 1.5 Mouse feature
- 2.6Module 1.6 Backstage view
- 2.7Module 2.1 Text and Numbers
- 2.8Module 2.2 basic formula
- 2.9Module 2.3 Relative References
- 2.10Module 2.4 Order of Operations
- 2.11Module 2.5 Working with Ranges
- 2.12Module 2.6 practice
- 2.13Module 3.1 Working with Save and Save As Commands
- 2.14Module 3.2 Practice Exercise 3
- 2.15Module 4.1 Opening a File
- 2.16Module 4.2 Working with Larger Files
- 2.17Module 4.3 Freeze Panes
- 2.18Module 4.4 Split Screen
- 2.19Module 4.5 Practice Exercise 4
- 2.20Module 5.1 Print Titles
- 2.21Module 5.2 Comments in Excel
- 2.22Module 5.3 Page Setup Option
- 2.23Module 5.4 Fit to Print on One Page
- 2.24Module 5.5 Printing Workbooks
- 2.25Module 5.6 Practice Exercise 5
- 2.26Module 6.1 Adding and DeletingRows, Columns & Cells
- 2.27Module 6.2 Changing Column and Row Widths
- 2.28Module 6.3 Practice Exercise 6
- 2.29Module 7.1 Cut copy Paste
- 2.30Module 7.2 Copying Formulas
- 2.31Module 7.3 Practice Exercise 7
- 2.32Module 8.1 Overview of Formulas
- 2.33Module 8.2 Create Formulas Using Functions Part 2
- 2.34Module 8.3 Create Formulas Using Functions Part 1
- 2.35Module 8.4 Absolute Values
- 2.36Module 8.5 Practice Exercise 8
- 2.37Module 9.1 Adding Deleting and Renaming Sheets
- 2.38Module 9.2 Three Dimensional Formulas module
- 2.39Module 9.3 Additional Sheet Tab Options
- 2.40Module 9.4 Practice Exercise 9
- 2.41Module 10.1 Formatting Cells Part 1
- 2.42Module 10.2 Formatting Cells Part 2
- 2.43Module 10.4 Borders and Shading
- 2.44Module 10.3 Formatting Numbers
- 2.45Module 10.5 Using Styles
- 2.46Module 10.6 Using Format Painter
- 2.47Module 10.7 Protecting Sheets
- 2.48Module 10.8 Fill Handle and Custom Lists
- 2.49Module 10.9 Practice Exercise 10
- 2.50Module 11.1 Creating Charts
- 2.51Module 11.2 Types of Charts
- 2.52Module 11.3 Editing Charts Part 1
- 2.53Module 11.4 Editing Charts Part 2
- 2.54Module 11.5 Using Graphics to Enhance Charts
- 2.55Module 11.6 Linking Chart Titles
- 2.56Module 11.7 Practice Exercise
- 2.57Module 12.1 Creating Range Names
- 2.58Module 12.2 Managing Names
- 2.59Module 12.3 Using Names in Formulas
- 2.60Module 12.4 Practice Exercise
- 2.61Module 13.1 Remove Duplicates
- 2.62Module 13.2 Sort Data
- 2.63Module 13.3 Filter Data
- 2.64Module 13.4 Advanced Filters
- 2.65Module 13.5 Practice Exercise
- 2.66Module 14.1 Creating an Outline
- 2.67Module 14.2 Subtotals
- 2.68Module 14.3 Practice Exercise
- 2.69Module 15.1 Arranging Files
- 2.70Module 15.2 New Window Option
- 2.71Module 15.4 Practice Exercise
- 2.72Module 15.3 Custom View
- 2.73Module 16.1 Creating Formulas Between File
- 2.74Module 16.2 Working with Links
- 2.75Module 16.3 Practice Exercise 16
- 2.76Module 17.1 Goal Seeker
- 2.77Module 17.2 Text to Columns
- 2.78Module 17.4 Customizing Ribbons and Tabs
- 2.79Module 17.3 Watch window
- 2.80Module 17.5 Practice Exercise
- 2.81Module 18.1 close
- 2.82Module 19.1 Functions Part 1
- 2.83Module 19.2 Functions – Part 2
- 2.84Module 19.3 Autosum
- 2.85Module 20.1 How Date and Time Works MODULE
- 2.86Module 21.1 Closing Advance Excel
- Data Entry Administration9 Items
- 3.1Module 1: Introduction to Data Entry Administration
- 3.2Module 2: Using the Computer for Data Entry
- 3.3Module 3: Common Rules and Guidelines for Data
- 3.4Module 4: Using Excel for Efficient Data Entry
- 3.5Module 5: Using Excel’s Flash Fill and Autofill
- 3.6Module 6: How to Create a Data Entry
- 3.7Module 7: Using Statistics Packages in Data Entry
- 3.8Module 8: Data Quality and Error Handling
- 3.9Module 9: Advanced Data Entry Techniques and Trends
System Hardware
Next
Royal Open College provides high-quality online courses covering a variety of topics along with certificates issued by top organisations.
Explore
Important Links
Payment methods possible
Company Registration No : 14422633
Copyright © 2026 Royal Open College. All Right Reserved.