Workbook Excel basic course

Click on Download to open the workbook.

With this workbook, you can practice assignments that you have learned during the course or through e-learning videos.
You will learn in a fairly simple way with the examples in each assignment the most commonly used settings and then effortlessly apply the components and formulas.

Global Excel Basic Course Content

Calculating a formula in Excel

Basic components of the Screen and Ribbon

Cell properties such as dates, currency, or phone numbers

Printing on 1 page, alignment print determination

Making column, row fit and Fill Handle (automatic fill)

Sorting and filtering an address file to create schedules

Dealing with text in Excel, Text Box and text formatting

Formatting borders and lines with the button and with Cell Properties

Entering formulas (embedding)

Creating various formulas

Calculating data in multiple tabs in one cell

Absolute and relative cell references in various formulas

SUM function – summing various ranges and cells at once

Statistical functions – extracting MIN, MAX, or AVERAGE from a table

Logical functions – IF; then – true; false – yes; no

Financial functions – calculating monthly payments and repayment

Creating and formatting charts – Pie chart and bar charts

Validating in 3 ways – creating dropdown menus and custom lists

Subtotals with NUMBER FUNCTION

Securing and hiding – Blocking and hiding cells and formulas

Exams assignments