Microsoft Excel in easy steps guides you through the essential functions of Microsoft Excel – whether you are new to Excel and the spreadsheet concept, or just upgrading from an older version. This edition is illustrated using the most up-to-date version of Excel in Microsoft 365 at the time of printing.

Microsoft Excel in easy steps starts with the basics then reveals the key clever features on offer – all in easy steps! Areas covered include:

Creating, editing, and manipulating worksheets.

Formulas, functions, tables and importing data.

Handy templates to give you a head start.

Macros for everyday tasks to save time.

Charts to get an overview of your data.

What-if, Goal Seek and Optimization.

Using the Excel Online app to share and collaborate on spreadsheets and workbooks.

Adding images and illustrations to your spreadsheets to impress your colleagues!

Whether you’re new to Microsoft Excel or new to spreadsheets, use this guide to get more out of Microsoft Excel, and manage your finances and data effectively – both at home and at work!

Table of Contents

Introduction

Begin with Excel

Manage Data

Formulas and Functions

Excel Tables

Advanced Functions

Control Excel

Charts

Macros in Excel

Templates and Scenarios

Links and Connections