Training: Excel – Fundamentals

Module 1: Basic features of Excel

• Use of the ribbon
• Workbooks and worksheets
• Display and zoom options
• Selecting parts of a worksheet
• Columns and rows
• Copying Data from a Cell
• Using the copy handle
• Shortcuts for data entry
• Backstage mode

Module 2 : Formatting

• Formatting cells (font, background color,…)
• Use of the Brush tool
• Width/height of rows and columns
• Formatting of numbers
• Layout of the spreadsheet for printing

Module 3: Formulas and Functions

• Presentation of cell references
• Inserting a simple formula
• Inserting a function
• Frequently used functions (SUM, AVERAGE, MAX, MIN, NB)
• Relative and absolute references

Module 4: Using tables

• Presentation of the Filter tool
• Sort data in ascending/descending or alphabetical order
• Filtering data

Module 5: Charts

• Create a simple chart
• Apply a predefined layout and chart style
• Add or remove graphical elements