Excel 2016 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 then you've come to the right place. This book will hold your hand through a step-by-step process in becoming skilled with Excel.
If you already have some Excel skills and you want to skill-up on more advanced topics like functions, tables, and creating charts, then you've also come to the right place. Excel 2016 Basics goes beyond the fundamentals and covers topics like functions, Excel tables, and analysing your data with charts.
Learn Excel Quicker By Avoiding Unnecessary FillersThis 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 carry out various tasks in Excel. Hence, Excel 2016 Basics focuses on providing direct step-by-step instructions for how to complete tasks within Excel. There are also lots graphical representations of the content being taught to enhance your learning.
The aim of this book is to guide you to being very competent with Excel within a very short time.
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.
- Use AutoSum to quickly automate calculations.
- Use functions like IF, DATE, DATEDIF, and VLOOLUP.
- Work with Excel tables, including applying table styles.
- Filter and sort your data.
- Use The Data Analysis tool to create charts and sparklines
- Secure your workbook with a password.
- And much more...
Scroll up and click the buy button on the top right of the page to get started today!