Exploring Excel

Basic Workbook Skills

• Create, Save & Close a new Workbook
• Selecting Cells with the Keyboard and Mouse
• Entering numbers and text in a Worksheet

Working with Cell Ranges

• Selecting Cell Ranges with the Keyboard/Mouse (both adjacent and non-adjacent cells)
• Entering Values into a range of selected Cells
• Using the AutoFill feature (create a series of names/numbers for easy data entry)

Creating Simple Formulas

• Using formulas (discussion about procedure)
• Creating simple formulas (long-hand formulas)
• Using Sum/Max/Min/Average within Formulas
• AutoSum Button (automatically calculate the total of a range of cells)
• AutoCorrect (suggested help to fix formula errors)
• Paste Function Button (helps create formulas)
• AutoCalculate (on-screen calculator)

• Range Finder (identify cells used in a formula)

Copying and Moving Data

• Copy, Cut and Pasting data (including pasting from the Clipboard toolbar)
• Creating an Absolute Reference
• Using Autofill (copy the contents of a single cell to adjacent cells – including formulas)
• Drag and drop editing
• Using Undo and Redo

Formatting Numbers

• Currency Style (£/$) / Percent Style (%)
• Using the Comma Style
• Changing the number of decimal places

Formatting Text

• Align Right/Left/Centre Buttons
• Using the Font List
• Using the font colour Button
• Rotating text in a cell
• Shrinking text to fit a cell automatically

Formatting Cells

• Changing the cell alignment
• Using the merge and centre button
• Using the borders and fill colour buttons
• Using the format paintbrush

Using Page Set-up

• Setting the Page Margins/ Page Orientation
• Creating/Customizing Headers and Footers
• Printing With/Without Gridlines
• Repeating Row and Column Headings
• Scaling a worksheet (adjusting the overall size)
• Using Page Break Preview
• Setting/removing a print area (for repeating rows of information on each printed page)

Working with Columns and Rows

• Selecting Inserting/Deleting Columns/Rows
• Changing the Width and Height of Columns/Rows
• Hiding/Unhiding Columns/Rows

Using AutoFormat

• Applying an AutoFormat (assign pre-set formats to a range of cells (coloured text / background etc)
• Changing the AutoFormat options
• Extending list formats and formulas
• Creating a Style by example – applying the Style
• Modifying and merging styles

Creating & Editing Charts

• Creating Charts using the Chart Wizard
• Changing the Chart Type (pie/bar/line)
• Changing the Plot Direction (column to row)
• Adding a Data Table under the Chart
• Formatting Chart Objects (colours/line styles etc)
• Changing the Chart Range (selecting new data)

• Changing the Chart Type / Sub-Type
• Adding Chart Titles / Moving the Legend
• Changing the Chart Location

Working with Multiple Worksheets

• Switching between worksheets
• Renaming Worksheet tabs
• Inserting/deleting Worksheets
• Printing selected worksheets

Managing Excel Files

• Changing Workbook properties
• Different file views

This is just a 'sample' of a possible customised training course for your staff. 

If you have any questions, please contact us

 Back to Custom Solutions