General User

Getting Started with Excel

Interface
Ribbon
Quick access toolbar
Crating / opening workbooks
Compatibility mode

reading time

20''

Understanding One Drive

Benefits of One Drive
Opening and saving files

reading time

20''

Creating and Opening Workbooks

Handling workbooks

reading time

20''

Saving and Sharing Workbooks

Exporting workbooks

reading time

20''

Cell Basics

Working with cells
Copy / paste
Fill handle
Formatting

reading time

20'''

Three panes of a spreadsheet

Excel 3 panes.pdf

Study the document to understand how excel woks and why it seemingly commits errors.

reading time

15'

Modifying Columns, Rows and Cells

Width, height
Insert, delete
Wrap text in cell

reading time

20'''

Formatting Cells

Font
Alignment

reading time

20''

Understanding Number Formats

Date options
Why should you use number formats

reading time

20''

Working with Multiple Worksheets

Manipulate (create, edit, move...) worksheets

reading time

20''

Using Find and Replace

Finding content

reading time

20''

Checking Spelling

Ignoring spelling errors

reading time

20'''

Page Layout and Printing

Print a sheet or a workbook
Use preview pane

reading time

20''

Introduction to Formula

With cell references
Point and click method
To edit a formula

reading time

20''

Total

5 h

Page updated

Google Sites

Report abuse