Bill's Functional IT Skills Masterclass

Welcome to the functional skills IT masterclass where you will find the resources needed to prepare you for the exams.

Microsoft Word

      Formatting Text                        Tables                                     Charts                              Mail Merging

To complete the FULL Word course, click on the following link: GCFlearnfree

PowerPoint

Creating a Presentation           Apply Themes                    Using Transitions                   Presenting

To complete the FULL PowerPoint course, click on the following link: GCFlearnfree

 Excel

            Formulas                  Conditional Formatting           Formatting Text                 Cell References

          Sorting Data                      Filtering Data                     Creating Charts                      Pivot Tables

To complete the FULL Excel course, click on the following link: GCFlearnfree

Access

            Databases                              Objects                             Getting Started              Managing a Database

                Tables                                Forms                                       Queries                             Reports

To complete the FULL Access course click on the following link: GCFlearnfree

Bill's Bytes

Excel

Below is a step by step guide to completing the level 2 IT exam, this will give you an understanding on what to expect in the exam.