Course overview

Duration: 1 day (6.5 hours)

Our Excel Module 1 – Key Skills and Formula Creation course shows you all the key features to allow you to confidentially build Excel spreadsheets. It shows quick tips and tricks for working with spreadsheets and looks at different types of formula and how to use Excel more effectively.

The course is aimed at new or existing users who want to build their skills and confidence in Excel.

Objectives 

By the end of the course you will be able to:

• Create workbooks and worksheets
• Create different types of formula
• Use basic Excel functions
• Use absolute and relative references in formula
• Edit and manipulate information
• Format worksheets for professional presentation
• Create and amend graphs
• Preview, print and PDF information

Content

Creating a Worksheet 

• Adding text, numbers, dates and times
• Using automatic features
• Renaming worksheets
• Saving a workbook

Creating simple formulas 

• Basic formulas
• Formula syntax
• Operators and brackets
• Ordering calculations

Using basic functions 

• The function wizard
• Using SUM, AVERAGE, MAX and MIN
• Copying formula
• Auto calculate

Handling formulas 

• Editing formulas
• Using absolute references in formulas

Working with workbooks 

• Navigating and editing worksheets
• Moving and copying
• Adjusting column widths and row heights
• Deleting data
• Inserting and deleting columns and rows
• Zoom
• Freeze panes

Text and number formatting  

• Changing text attributes
• Changing number formats
• Using list autofill
• Adding simple borders
• Using the Mini Toolbar
• Applying cell styles

Graphs 

• Creating simple charts
• Changing the type of graph
• Adding data labels
• Customising the graph
• Creating Sparklines

Printing 

• Using print preview
• Amending page setup options
• Printing a worksheet
• Creating a PDF of your worksheet
• Using Page Layout view and Page Break Preview

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

• Email: [email protected]
• Phone: +44 (0)20 8152 6551

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!