Duration: 1 Day
Course Overview
This 1 day instructor led training course provides delegates with a solid grounding in Microsoft Excel. Delegates will be introduced to spreadsheet concepts and gain an appreciation of the main features of Excel and what it has to offer.
How can I attend my course?
COURSE OBJECTIVES
• Understand spreadsheet concepts
• Enter and modify data and structure
• Create worksheets from scratch
• Create basic formulas
• Calculate with common functions
• Format spreadsheets
• Create Charts
• Choose required printing options
Course Content
Getting started
• Spreadsheet terminology
• The Excel environment
• Getting help
• Navigating a worksheet
Entering and editing data
• Moving and copying data
• Inserting and deleting ranges, rows, and columns
• Modifying column widths and row heights
• Autofit columns and rows
Formulas
• Create basic calculations
• Order of calculation
• Absolute referencing
• Moving and copying formulas
Functions
• Overview of functions
• Using AutoSum
• Using other common functions
• Display formulae on a worksheet
Formatting
• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options
Printing
• Preparing to print
• Page Setup options
• Printing worksheets
Managing large workbooks
• Viewing large worksheets
• Printing large worksheets
• Working with multiple worksheets
Charts
• Chart basics
• Formatting charts
COURSE PREREQUISITES
Before taking this course, you should be familiar with using a computer, keyboard, mouse and a basic knowledge of using Windows.