Excel 365 Basics

Excel 365 Basics covers all you need to quickly get up to speed in creating spreadsheets to provide solutions for your data.

If you are new to Excel and the thought of spreadsheets makes your head spin, you've come to the right place. This book will hold your hand through a step-by-step process of becoming skilled with Excel.

If you already have some Excel skills and want to skill up on more advanced topics, then you've also come to the right place. Excel 365 Basics goes beyond introductory topics and covers topics like functions, Excel tables, Pivot tables, and analyzing your data with charts.

This book aims to guide you from beginner to being skilled with Excel within a few short hours.

This book cuts to the chase without the unnecessary verbosity seen in many other Excel books. You don't need to get through a wall of text to learn how to quickly perform various tasks in Excel. Hence, Excel 365 Basics focuses on providing clear and direct explanations for completing tasks with screenshots where necessary to illustrate the concepts.

Excel 365 Basics uses practical examples applicable to real-world tasks. The best way to learn is through practice, so downloadable sample files have been provided so you can follow the examples in the book hands-on.

This book covers Excel for Microsoft 365 (2022 update) and Excel 2021 (the latest standalone version of Excel).

In this book, you'll learn how to:

• Add, name, copy and move worksheets.
• Freeze and unfreeze panes (rows and columns).
• Use AutoFill and Flash Fill to automate repetitive tasks.
• Move and copy data.
• Format cells, ranges, and tables.
• Create formulas for different types of calculations.
• Use absolute and relative cell references.
• Use AutoSum to automate calculations quickly.
• Use functions like IF, DATEDIF, MID, and XLOOKUP.
• Work with Excel tables, including applying table styles.
• Easily filter and sort your data.
• Dynamically analyze data with Pivot Table tools that can carry out automated data summaries in seconds that would have taken hours to do manually!
• Use the Quick Analysis tool to generate charts and sparklines with a few clicks.
• Secure your workbook data and design with a password.