Excel basics in a day

Excel is one of the most useful skills in working life. In a day you will learn the structure of a spreadsheet, basic formulas and a simple chart.

You will need

• Excel or a free alternative (Google Sheets, LibreOffice Calc)
• Practice data, e.g. your own budget

Steps

1. Get to know the structure

   A spreadsheet consists of cells, each with an address: the column is a letter and the row a number, e.g. B3.

2. Enter data

3. Format

4. Learn formulas

5. Copy a formula

6. Sort and filter

7. Make a chart

8. Save and share

The full guide with every step is for members. Try 7 days for €0.99.

People also search for: excel basics · how do i make formulas in excel · how to filter and sort data in excel · learn spreadsheets quickly · how to make a chart from your own data in excel for beginners

More guides on: Digital skills and AI

• Protect your accounts with two-step verification
• Spot an online scam
• A website for your small business
• Back up the photos on your phone
• Setting up a new phone
• Speeding up your computer
• Improving your Wi-Fi
• Password manager

Digital skills and AI – All guides ›