Learn Excel 2016 for Beginners: Master the Essentials

Learn Excel 2016 for Beginners: Master the

Essentials

Table of Contents

Chapter 1 ? Introduction Acquiring Excel 2016 and Information on Installation and Upgrade..................................6 Exercise Files .....................................................................................................................10

Chapter 2 ? What's New New and Improved Features in Excel 2016 .......................................................................11

Chapter 3 ? Using Touch Overview of Principles of Using Touchscreen ..................................................................12

Chapter 4 ? Getting Started Creating and Saving a Workbook ......................................................................................14 Opening a Workbook .........................................................................................................19

Chapter 5 ? Using Help Online Help and Contextual Help......................................................................................22

Chapter 6 ? Excel Options Personalizing Your Use of Excel .......................................................................................24

Chapter 7 ? The Ribbon and Toolbars Basics of Using the Ribbon................................................................................................28 Quick Access Toolbar........................................................................................................33 Tell Me Feature..................................................................................................................35 Mini Toolbars and Contextual Menus ...............................................................................38 Status Bar ...........................................................................................................................40

Chapter 8 ? Entering and Editing Data Basics of Entering and Editing Data in a Workbook .........................................................42 Exercise 01.........................................................................................................................46

Formatting Dates................................................................................................................47 Formatting Numbers ..........................................................................................................51 Exercise 02.........................................................................................................................55 Chapter 9 ? Backup and Recovery AutoSave, Recover Unsaved Workbook, and Create a Backup Copy ..............................56 Chapter 10 ? Fill and Series Working with Fill and Series .............................................................................................59 Flash Fill ............................................................................................................................62 Chapter 11 ? Viewing and Printing Workbook Views, Zoom, and Freeze ................................................................................64 Printing ...............................................................................................................................67 Exercise 03.........................................................................................................................72 Chapter 12 ? Cut, Copy, and Paste Methods of Cutting, Copying, and Pasting ........................................................................73 Chapter 13 ? Formatting a Worksheet Delete and Clear.................................................................................................................77 Insert, Hide, Column Width and Row Height, and Merge ................................................81 Alignment ..........................................................................................................................85 Themes and Styles .............................................................................................................89 Exercise 04.........................................................................................................................92 Chapter 14 ? Formulas and Functions Basics of Formulas and Functions .....................................................................................93 Complex Examples of Formulas........................................................................................96 Exercise 05.........................................................................................................................99 Chapter 15 ? Managing Worksheets

Rename, Insert, Move, and Reference a Worksheet ........................................................100 Chapter 16 ? Working with Multiple Workbooks

Working with Multiple Workbooks.................................................................................103 Chapter 17 ? Saving Workbooks

Saving in Different File Types.........................................................................................108 Chapter 18 ? Proofing

The Spell Checker............................................................................................................112 Chapter 19 ? Inserting Comments

Inserting Comments .........................................................................................................116 Exercise 06.......................................................................................................................118 Chapter 20 ? Basic Functions in Excel The VLOOKUP Function ................................................................................................119 Text Functions .................................................................................................................123 Date and Time Functions .................................................................................................126 Logical Functions.............................................................................................................128 Chapter 21 ? Graphs and Charts Creating Graphs and Charts .............................................................................................132 Customizing a Cluster Column Chart ..............................................................................136 Customizing a Pie Chart ..................................................................................................140 New Chart Types in Excel 2016 ......................................................................................145 Exercise 07.......................................................................................................................146 Chapter 22 ? Sorting and Filtering Data Managing Data by Sorting ...............................................................................................147 Managing Data by Filtering .............................................................................................150 Customizing Tables .........................................................................................................154

Chapter 23 ? Shapes and Pictures Inserting Shapes and Pictures ..........................................................................................158 Exercise 08.......................................................................................................................163

Chapter 24 ? Formatting Cells Based on Content Conditional Formatting ....................................................................................................164

Chapter 25 ? Protection and Security Protecting Worksheets .....................................................................................................168 Protecting Workbooks .....................................................................................................171

Chapter 26 ? Naming Items Giving Items Names ........................................................................................................174 Exercise 09.......................................................................................................................176

Chapter 27 ? Finding and Replacing Words Find and Replace..............................................................................................................177

Chapter 28 ? Borders Adding Borders ................................................................................................................180

Chapter 29 ? Workbook Inspection Inspecting a Workbook ....................................................................................................183

Chapter 30 ? Privacy Options Trust Center Privacy Options...........................................................................................185

Chapter 31 ? Sharing Options Sharing a Workbook ........................................................................................................187

Chapter 32 ? Recap Recap................................................................................................................................190

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download