Excel Basic Level - Getting Started & Basic Skills

Excel Basic Level, Welshpool, 2nd December 2025

Starting up Excel & Basic uses of Worksheets
The Excel Window, use of Tabs & Ribbon
Using the Quick Access Toolbar
Creating A New Workbook
Entering, Editing and deleting data
Using the Undo Feature
Saving and Password Protecting Workbooks, using Save As and Save
Autosave (365 version only) and Version History
Saving file as a PDF
Sending a file via email
Sharing spreadsheets with other users
Opening a Workbook
Closing a Workbook
Exiting Excel
Using the different workbook views
Selecting Cells and Ranges of data
Formatting the Workbook, including Changing Font/Font Size, Changing the Number Format, Alignment, Colours and Shading
Spell checking the spreadsheet

Copy, Cut and Paste using Text between one or more Workbooks
Advanced Paste- pasting values, formats, formula etc.
Use of Transpose Feature
Entering Numeric values as text
Moving Around the Worksheet
Automatically inserting lists used on a regular basis, i.e. Jan, Feb, Mar using the AutoFill feature
Sorting Data into Alphabetical or Numerical order
Formatting Rows and Columns, including Sizing, Adding, Deleting and Hiding
Inserting Cell Notes and Cell Comments
Inserting Symbols
Using Find & Replace
Printing and Print Preview
Page Set-up including Headers and Footers, Page Orientation, Margins and Fit to Page, setting a print area
Freezing rows and columns in spreadsheets
Working with multiple workbooks
- Switching between books
- comparing workbooks
- arrange all
- split
Using the Autosum feature to automatically add values