Excel Basic Level - Getting Started & Basic Skills

Excel Basic Level, Welshpool, 14th November 2024

Starting up Excel & Basic uses of Worksheets
The Excel Window, use of Menus and Toolbars
Creating A New Workbook
Saving and Password Protecting Workbooks, using Save As and Save
Opening a Workbook
Closing a Workbook
Exiting Excel
Entering, Editing and deleting data
Using the Undo Feature
Selecting Cells and Ranges of data
Formatting the Workbook, including Changing Font/Font Size, Changing the Number Format, Alignment, Colours and Shading

Formatting Rows and Columns, including Sizing, Adding, Deleting and Hiding
Moving Around the Worksheet
Sorting Data into Alphabetical or Numerical order
Printing and Print Preview
Page Set-up including Headers and Footers, Page Orientation, Margins and Fit to Page
Automatically inserting lists used on a regular basis, i.e. Jan, Feb, Mar using the AutoFill feature
Copy, Cut and Paste using Text between one or more Workbooks
Naming Ranges to make worksheets easier to manipulate
Entering Values as Text
Inserting Cell Comments
Splitting and Freezing Cells
Using the AutoSum feature to automatically add values