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
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
Excel 2013 - 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
Excel 2010 - Introduction
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.
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.