Excel for Microsoft 365: Basics

Calculating is one of the most widely used applications on the computer, since of course it is a calculator itself. There are many calculation and spreadsheet programs, and Excel for Microsoft 365 has a prominent place in that market.

With Excel you can create calculation models, for example, for financial controlling and accounting, for calculating a tax declaration form, for compiling an annual report, and so on. In this user guide you’ll learn the basic skills, functions, features and options of this popular spreadsheet program.

Excel for Microsoft 365: Worksheets

This workbook focuses on the worksheets you create in the workbooks (files) of Excel for Microsoft 365. In particular, formatting, both of the text and numbers in your cells, and of the worksheet itself, is discussed. Also, you’ll see how to quickly build models by copying formulas. The special views you can use to look at your worksheets, and the most important issues about printing are discussed in this user guide as well. 

Excel for Microsoft 365: Charts

‘A picture is worth a thousand words’, or in this case: ‘…a thousand numbers’. It is not quite easy to draw conclusions from a large number of figures in a worksheet. Charts representing the numbers give a lot more insight and overview. In this user guide you learn how to design comprehensible charts in Excel for Microsoft 365, which (combined) types you can choose from, and how to add the required captions. Further, this ebook discusses how to discover trends in your figures by drawing trendlines or sparklines. By using charts your models and figures can get more predictive power. 

Excel for Microsoft 365: Advanced Options

There are quite a few tools in Excel for Microsoft 365 that you can use when designing your models, checking your formulas, coming up with solutions or scenarios, and so on. In this workbook we discuss various options and techniques for the advanced user. You’ll learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, matters such as (external) reference, security, and (saving in a certain) format of your workbooks are discussed.

Excel for Microsoft 365: Special Models

In a spreadsheet program it is all about designing and building an appropriate calculation model: what is the purpose of it, what should it calculate, what do we want to find out, analyse or even predict, and so on? In this workbook we discuss various (advanced) model designs in Excel for Microsoft 365, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.

Excel for Microsoft 365: VBA Macro Editor

With the programming language Visual Basic for Applications (VBA) you can develop (more) functionality of your own. It allows you to customise recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program with questions like 'What is the initial value for the calculation?', 'Where is the data?' or 'What report do you want to print?'.
In this workbook we will discuss VBA and the environment where instructions in macros can be edited. The follow-up book VBA Programming then contains some more advanced application options and practical examples of VBA within Excel for Microsoft 365.

Excel for Microsoft 365: VBA Programming

This workbook on programming in the Excel environment covers some of the more advanced applications and practical examples of VBA. The modules in a VBA project in Excel for Microsoft 365 contain instructions and elements that can make use of existing data, objects, and tools such as sheets, tables, charts, or buttons. This requires advanced techniques in programming and editing code in the VBA development environment. This was discussed extensively in the previous workbook Excel for Microsoft 365 VBA Macro Editor.

Excel 2021: Basics

Calculating is one of the most widely used applications on the computer, since of course it is a calculator itself. There are many calculation and spreadsheet programs, and Excel 2021 has a prominent place in that market.

With Excel you can create calculation models, for example, for financial controlling and accounting, for calculating a tax declaration form, for compiling an annual report, and so on. In this user guide you’ll learn the basic skills, functions, features and options of this popular spreadsheet program.

Excel 2021: Worksheets

This workbook focuses on the worksheets you create in the workbooks (files) of Excel 2021. In particular, formatting, both of the text and numbers in your cells, and of the worksheet itself, is discussed. Also, you’ll see how to quickly build models by copying formulas. The special views you can use to look at your worksheets, and the most important issues about printing are discussed in this user guide as well. 

Excel 2021: Charts

‘A picture is worth a thousand words’, or in this case: ‘…a thousand numbers’. It is not quite easy to draw conclusions from a large number of figures in a worksheet. Charts representing the numbers give a lot more insight and overview. In this user guide you learn how to design comprehensible charts in Excel 2021, which (combined) types you can choose from, and how to add the required captions. Further, this ebook discusses how to discover trends in your figures by drawing trendlines or sparklines. By using charts your models and figures can get more predictive power.

Excel 2021: Advanced Options

There are quite a few tools in Excel 2021 that you can use when designing your models, checking your formulas, coming up with solutions or scenarios, and so on. In this workbook we discuss various options and techniques for the advanced user. You’ll learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, matters such as (external) reference, security, and (saving in a certain) format of your workbooks are discussed.

Excel 2021: Special Models

In a spreadsheet program it is all about designing and building an appropriate calculation model: what is the purpose of it, what should it calculate, what do we want to find out, analyse or even predict, and so on? In this workbook we discuss various (advanced) model designs in Excel 2021, such as outlines, consolidations, data tables, pivot tables, and forecasts. We also discuss searching and filtering in models.

Excel 2021: VBA Macro Editor

With the programming language Visual Basic for Applications (VBA) you can develop (more) functionality of your own. It allows you to customise recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program with questions like "What is the initial value for the calculation?", "Where is the data?" or 'What report do you want to print?'.
In this workbook we will discuss VBA and the environment where instructions (in macros) can be edited. The follow-up book VBA Programming then contains some more advanced application options and practical examples of VBA within Excel 2021.

Excel 2021: VBA Programming

This workbook on programming in the Excel environment covers some of the more advanced applications and practical examples of VBA. The modules in a VBA project in Excel 2021 contain instructions and elements that can make use of existing data, objects, and tools such as sheets, tables, charts, or buttons. This requires advanced techniques in programming and editing code in the VBA development environment. This was discussed extensively in the previous workbook Excel 2021 VBA Macro Editor. 

Excel 365: Basics - Calculating on the Computer

Calculating is one of the most widely used applications on the computer, since of course it is a calculator itself. There are many calculation and spreadsheet programs, and Excel 365 has a prominent place in that market.With Excel you can create calculation models, for example, for financial controlling and accounting, for calculating a tax declaration form, for compiling an annual report, and so on. In this user guide you’ll learn the basic skills, functions, features and options of this popular spreadsheet program. 

Excel 365: Advanced Options

Excel 365 has numerous tools to help you designing your models, checking your formulas, finding solutions or creating scenarios, and the like. You’ll also learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, some advanced topics are discussed such as (external) references, security, and the (saving in a certain) format of your workbooks. 

Excel 365: Charts - Graphical Representation of Figures

‘A picture is worth a thousand words’, or in this case: ‘…a thousand numbers’. It is not quite easy to draw conclusions from a large number of figures in a worksheet. Charts representing the numbers give a lot more insight and overview. In this user guide you learn how to design comprehensible charts in Excel 365, which (combined) types you can choose from, and how to add the required captions. Further, this ebook discusses how to discover trends in your figures by drawing trendlines or sparklines. By using charts your models and figures can get more predictive power.

Excel 365: Model Design

In a spreadsheet program it is all about designing and building an appropriate model: what is the purpose of it, what should it calculate, what do we want to find out, analyse of even predict, and so on? In this ebook we discuss various (advanced) model designs in Excel such as outlines, consolidations, data tables, pivot tables, and forecasts. Also, we cover some topics on searching and filtering in models, and elaborate formatting and printing in more detail. 

Excel 365: VBA programming

Excel has a powerful toolbox and a lot of functionality. So why creating own applications in such an extensive computer program ... just to automate routine tasks? There’s more than just that, you can develop more functionality with programming language VBA. It allows you to customize recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program. Consider questions like "What is the initial value for the calculation?", "Where is the data?" or 'What report do you want to print?'.This ebook shows you to create your own applications, to edit (recorded) macros and to add all sorts of own functionality to the spreadsheet program. 

Excel 2019: Basics - Calculating on the Computer

Calculating is one of the most widely used applications on the computer, since of course it is a calculator itself. There are many calculation and spreadsheet programs, and Excel 2019 has a prominent place in that market.With Excel you can create calculation models, for example, for financial controlling and accounting, for calculating a tax declaration form, for compiling an annual report, and so on. In this user guide you’ll learn the basic skills, functions, features and options of this popular spreadsheet program.

Excel 2019: Advanced Options

Excel 2019 has numerous tools to help you designing your models, checking your formulas, finding solutions or creating scenarios, and the like. You’ll also learn to fill cells with (own) lists of labels or data, to add comments to your models, and to create planning schedules. Furthermore, some advanced topics are discussed such as (external) references, security, and the (saving in a certain) format of your workbooks.  

Excel 2019: Charts

‘A picture is worth a thousand words’, or in this case: ‘…a thousand numbers’. It is not quite easy to draw conclusions from a large number of figures in a worksheet. Charts representing the numbers give a lot more insight and overview. In this user guide you learn how to design comprehensible charts in Excel 2019, which (combined) types you can choose from, and how to add the required captions. Further, this ebook discusses how to discover trends in your figures by drawing trendlines or sparklines. By using charts your models and figures can get more predictive power. 

Excel 2019: Model Design

In a spreadsheet program it is all about designing and building an appropriate model: what is the purpose of it, what should it calculate, what do we want to find out, analyse of even predict, and so on? In this ebook we discuss various (advanced) model designs in Excel such as outlines, consolidations, data tables, pivot tables, and forecasts. Also, we cover some topics on searching and filtering in models, and elaborate formatting and printing in more detail. 

Excel 2019: VBA Programming

Excel has a powerful toolbox and a lot of functionality. So why creating own applications in such an extensive computer program ... just to automate routine tasks? There’s more than just that, you can develop more functionality with programming language VBA. It allows you to customize recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program. Consider questions like "What is the initial value for the calculation?", "Where is the data?" or 'What report do you want to print?'.This ebook shows you to create your own applications, to edit (recorded) macros and to add all sorts of own functionality to the spreadsheet program.

Excel 2016: VBA programming

Excel has a powerful toolbox and a lot of functionality. So what’s the need to program in such an extensive computer program ... just to automate routine tasks? There’s more than just that, you can develop more functionality with programming language VBA. It allows you to customize recorded macros as desired, and for example, provide custom elements or dialogs for communication with the user about the execution of the program. Consider questions like "What is the initial value for the calculation?", "Where is the data?" Or 'What report do you want to print?'.
This ebook shows you to create your own applications, to edit (recorded) macros and to add all sorts of own functionality to the spreadsheet program.