Microsoft Excel Training: Level 1
This beginner's Microsoft Excel training course aims to give the new spreadsheet user fundamental skills in creating and working with Excel.
Classroom: 1 day | Remote: 2 x 4 hour sessions
Overview
This is a beginner’s Microsoft Excel training course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Excel.
Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.
Key Topics
- Getting to know Microsoft Excel
- Creating A New Workbook
- Working With Workbooks
- Selecting Ranges
- Formulas And Functions
- Copying Data
- Formula Referencing
- Font Formatting
- Cell Alignment
- Row And Column Formatting
- Number Formatting
- Printing
- Creating Charts
Learning Objectives
Topic Outline
Target Audience
Prerequisites
When the participant completes this course they will be able to:
- navigate your way around Microsoft Excel 2016
- create and work with a new workbook
- open and navigate within workbooks and worksheets
- make changes to data in a workbook
- understand and work with ranges in a worksheet
- copy and paste data in Excel
- use the fill operations available to fill a data series
- move the contents of cells and ranges within and between workbooks
- understand, create and work with formulas and functions
- understand and use formula cell referencing
- use font formatting techniques
- align the contents of cells in a number of ways
- understand and use the number formatting features in Excel
- format rows and columns in a worksheet
- work with elements that make up the structure of a worksheet
- sort data in a list in a worksheet
- filter data in a table
- print your workbook data
- create effective charts in Microsoft Excel
- obtain help for Excel whenever you need it
- understand points to consider to avoid problems in your worksheets