Excel for Beginners

This course is suitable for delegates who are new to Excel or are self-taught and wish to ensure they make the most of the basic functions. There are no prerequisites however, you must have a basic understanding of using a PC, including keyboard and mouse familiarity.

Objectives
The aim of the course is to provide you with the skills to create and print a spreadsheet containing text, numbers and simple formulae and calculations.

Course Outline

• How to start
• The Quick Access Toolbar and File Menu
• Exploring your Workbook
• About Workbooks
• Getting Help with Excel
• Working with Excel
• Moving your Data
• Basic Excel Features
• Smart Tags and Options Buttons
• Editing Tools
• The Formulas Tab
• The Data Tab
• The Home Tab
• The Insert Tab
• The Review Tab
• Using Recommended and Standard charts
• Chart Elements
• Chart Tools - Design & Format
• Cell Formatting
• Conditional Formatting
• Enhancing a Worksheet’s Appearance
• Using the View Tab
• Managing a Single Window
• Managing Multiple Windows
• Printing your Workbook
• Print Page Layout options

Delegates will be asked to carry out exercises as we progress. Handouts will be provided for reference during the course.

Delegates must have a laptop (or equivalent) running Excel for Microsoft 365(not online version).

Book here