Microsoft Excel Training – Level 1 Course Contents - Duration: 1 day
An Introduction to the Excel Environment
- Accurately distinguish and use different parts of the Excel screen.
- Understand cell referencing.
Basic Spreadsheet Skills
- Enter spreadsheet data
- Edit, clear and delete spreadsheet data.
- Insert and delete columns and rows.
- Adjust column widths and row heights.
Moving and Copying Data
- Move and Copy the data provided using Icons
- Move and Copy the data provided using the mouse
Formatting Cells
- Correctly apply cell font formatting
- Correctly apply numeric formatting.
- Correctly apply advanced cell formats using the Format Cells window
- Clear out formats from cells accurately
- Copy formatting using the Format Painter.
Working with Worksheets
- Insert and Rename new Worksheets efficiently
- Delete Worksheets
- Move and Copy Worksheets using the mouse
- Link worksheets to copy data onto multiple sheets
Autofill
- Quickly copy the contents of a cell by "Dragging Down"
- Automatically enter sequential dates, days or months
- Create your own numeric sequences
Excel Formulas
- Accurately enter an Excel formula
- Accurately enter an Excel function e.g. Sum, Min or Max
Working with Basic Excel Functions
- Accurately enter SUM, MIN, MAX, AVERAGE, COUNTA and TODAY functions.
Using Quick Analysis*
- Entering formulas using the Quick Analysis feature
Freeze rows and Columns
- Keep a portion of the sheet visible while the rest of the sheet scrolls
Sorting and Filtering Data
- Sort data into alphabetical or numeric order.
- Use Custom Sorting to sort to more than one level.
- Filter data to show only the data you want to see.
Printing
- How to use the Print and Print Preview areas
- How to change margins and paper size
- Using Headers and Footers
- Scaling the page to fit on A4
- Using Page Layout View
Simple Charts
- How to insert a simple chart to show your data accurately.
- How to modify a chart
*Only applicable in an Excel 2013 training course
Speak to a trainer now
0800 0199 746
for any questions about the courses we offer