Skip navigation

Bookboon.com The best way to educate yourself

Download free Excel Books

Are Excel skills part of your daily work? Then we have got what you are looking for. No matter if you are an Excel beginner or master, these 4 free Excel books can take you to the next Excel level! The time when you asked your colleagues basic Excel questions is over. Enjoy delving into the world of Office Excel!

 

 

Excel 2013 - The basics

  • Excel 2013 Core: Intro

    This user guide will take you through all the things you need to know when using Excel at a simple level.

    You will learn how to: Get around Excel 2013, add text and numbers to spreadsheets, use autofill to copy formula and create series, create a basic formula, use average minimum and maximum, work with worksheets and much more

    View eBook!

Excel 2013 - Advanced

  • Excel 2013 Core: Advanced

    This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.

    You will learn how to:

    • Use Conditional Logic in a formula – IF statements
    • Use the SumIF and CountIF functions
    • Produce a chart
    • Sort and filter
    • Apply subtotals
    • Introduction to Pivot Tables
    • Introduction to Macros
    View eBook!

Excel 2010 - Introduction

  • Excel 2010 Introduction: Part I

    Formulas, Functions and Formatting

    Excel 2010 is a powerful spreadsheet application that allows users to produce tables containing calculations and graphs. These can range from simple formulas through to complex functions and mathematical models.

    After reading this eBook you will be able to understand the differences between Excel 2010 formulas and functions. Further you will learn how to use simple functions and formulas, like addition, subtraction and multiplications.

    View eBook!

Relevant eBook

  • Excel 2010 Introduction: Part II

    Printing, Names and Sheets

    In the second part of the Excel 2010 introduction series you will learn more about printing, names and sheets. If you want to learn about formulas, functions and formatting, download the first part of the Excel 2010 Introduction ebook.

    Excel 2010 printing

    When you want a hard copy of worksheet data, Excel gives you many tools for choosing how that printout will look. In the section about Excel 2010 printing you will learn for example how to set up printing preferences by using the page setup dialog. Insert and edit headers and footers and use print preview and page layout views.

    Excel 2010 names

    When entering formulas or referring to any area in a workbook, it is usual to refer to a ‘range’. For example, B6 is a range reference; B6:B10 is also a range reference. One problem with this sort of reference is that it is not very meaningful and therefore easily forgettable. In the section about names you will learn how to name cells and ranges by three methods. Further you will learn how to edit and manage names and how to sort and filter names.

    Excel 2010 sheets

    When you create a new workbook, Excel gives you multiple pages within that workbook called worksheets. In the section about sheets you will learn how to deal with sheets in Excel 2010. You will learn for example how to create and rename worksheets, how to create formulas and functions across worksheets and how to group worksheets.

    View eBook!

Relevant eBook

  • Excel 2007 Introduction: Part I

    Excel 2007 Introduction: Part I is one of the great eBooks available to download from our website.

    There are more than 500 textbooks, Business Books & Travel Guides in our book collection.

    View eBook!