EXCEL 2019: A Comprehensive Beginners Guide to Learn Excel 2019 Step by Step from A – Z
Authors: Alexander Cane
ISBN-10: 1082766518
ISBN-13: 9781082766510
Publication Date 出版日期: 2019-07-26
Print Length 页数: 183 pages
Book Description
By finelybook
A Direct No-Nonsense Guide to Learning Excel
The Excel 2019 Guide has everything you need to get started in creating and making the most out of your spreadsheets.
This book is designed for Excel 2019 users of all levels. May you be new to working on data or are already knowledgeable in handling different kinds of spreadsheet work,then this book is for you.
Many people are overwhelmed by the powers of Excel,but these can be easily manipulated to your advantage,and this book helps you do just that. With this guide you can start playing with the program’s different functions such as:
Creating,naming and formatting worksheets
Freeze,unfreeze,hide,and protect rows and columns
Using and customizing AutoFill and Flash Fill functions for routine tasks
Move,copy,and format data
Create formulas and come up with specific calculations
Sort,filter,and pivot data for easier but reliable analysis
Create charts out of your data
Secure your workbook with passwords and restrictions for different users
Use other Excel features for math,statistical,financial,and other advanced computations
Part 1: The Basics of Excel
Chapter 1 The Basics of Excel 2019
Chapter 2 Personalizing Your Excel 2019
Part 2: The Worksheet Structure
Chapter 3 Facing Your Worksheet
Chapter 4 Worksheet Formatting
Chapter 5 Printing Your Worksheet
Part 3: Functions,Formulas and How to Use Them
Chapter 6 Basic Formulas
Chapter 7 Error Trapping and Logical Functions
Chapter 8 Date and Time
Chapter 9 Financial Formulas
Chapter 10 Math and Statistical Formulas
Part 4: Worksheet Collaboration,Review,and Protection
Chapter 11 Protecting Your Workbook and Worksheet Data
Chapter 12 Hyperlinks
Chapter 13 How to Prepare a Workbook for Distribution
Chapter 14 Sharing Your Workbook and Worksheet
Part5: Graphics and Charts
Chapter 15 Charting Your Worksheet Data
Chapter 16 Adding Graphic Objects
Part6: Managing Data
Chapter 17 Building Data Lists
Chapter 18 Filters and Queries
Part 7: Analyzing Data
Chapter 19 What-if Scenarios
Chapter 20 Large Scale Data Analysis
