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
|
