Office Productivity
Excel - Getting Started
Get hands-on with Excel and build your first tables, calculations and charts.
This course introduces the Excel environment and the essential actions to enter, calculate and present your data. You learn to structure a sheet, write simple formulas and create readable charts. Running project: you build an operational tracking table step by step.
Objectives
- Master the interface and navigation within an Excel workbook
- Enter and organise data reliably
- Write simple calculations and formulas
- Apply clear and professional formatting
- Create basic charts to visualise data
Program
Discovering the Excel environment
- Interface, ribbons, tabs and shortcuts
- Workbooks, sheets, rows and columns
- Entering and editing data
- Saving and file formats
Calculating and formatting
- Basic operations and formulas
- Relative and absolute references
- SUM, AVERAGE, MIN, MAX functions
- Formatting cells and tables
Visualising and presenting
- Creating a basic chart
- Choosing the right chart type
- Setting up the page for printing
- Running project: tracking table
Prerequisites
No prerequisites.