Excel - Creating a simple and professional document

Duration : 1 day

Prerequisites

Windows - User or equivalent

Objectives

• Acquire essential knowledge to create simple tables with Excel

Teaching method

Presentations - Demos – Guided and individual exercises

Contents

Chapter 1 - Identify interface elements

• Recognise Identify components of the environment
• Identify the parts of Excel
• Access commands
• Get help
• The File tab and the Backstage view mode
• Start screen, templates, navigation, cloud

Chapter 2 - Open and manipulate a workbook

• Open a workbook
• Adapt the on-screen display as needed
• Navigating a spreadsheet · Select cells
• Freeze titles

Chapter 3 - Create a workbook and enter data

• Create and save a workbook
• Recognize the types of data
• Enter data into a spreadsheet
• Use the fill handle to create a series of data
• Save a workbook
• Close a workbook and exit Exce
• Cancel or restore the last operations
• The cloud and templates, choice of sharing, instant fill

Chapter 4 - Manipulate columns, rows or cells

• Modify the size of columns and rows
• Insert columns and rows
• Remove columns and rows
• Hide columns and rows

Chapter 5 - Manipulate data

• Copy and move data
• Search or replace data

Chapter 6 - Apply formatting to cells

• Apply formats
• Set the font · Align, merge cells, and apply indents
• Set numeric formats
• Apply borders and fill colour
• Manipulate formats
• Quick analysis and conditional formatting

Chapter 7 - Format and print workbook data

• Set display mode
• Set layout
• Insert page breaks
• Set a print area
• View page breaks and print areas
• Use Print Titles to repeat headers
• Use scaling and printing options
• Print spreadsheets