This is a task-oriented textbook designed for students in secondary and higher education. It is also great for anyone who wants to learn to use Excel, beginners and advanced.
The book contains many exercises. An Excel file is available for teachers in which the exercises are worked out.
Required software: Microsoft Excel 365. For the most part, the textbook can also be used for other Excel versions such as 2010, 2013, 2016 and 2019.
File Practicefiles-LearnExcel.zip contains all files from folder data and is generated through the script in R/generate-zip.R. When rendering the book, this script is pre-rendered by the option in _quarto.yml: pre-render: R/generate-zip.R
The script uses 7-zip which must be installed on the computer and in the path. The zip file is only updated when an existing file changes or when files are added or removed.
The interactive parts are answers to questions, tips, solutions, ... These are created by functions in package webexercises and this package must be installed.
To use webexercises with Quarto you need to add the webex.css and webex.js file to the format html option in the _quarto.yml file.
To make the functions available in all chapters, the necessary script webex.R is executed through R code in file .Rprofile. This is the easiest method, otherwise you'll have to include the code at the beginning of each chapter.
The css for the webexercises is present in include/webex.css.
The css specific for this textbook is in include/textbook.css.