Excel Basics In 30 Minutes: The beginner's guide to Microsoft Excel, Excel Online, and Google Sheets

by Ian Lamont

Overview

Do you want to learn Microsoft Excel, for a career boost, or to better handle numbers, lists, and data? This popular Excel tutorial covers basic concepts, formatting, AutoFill, formulas, functions, sorting, filtering, collaboration, and charts. Examples apply to Excel 2019, Excel Online, Excel mobile apps, and Google Sheets.

Product Details

ISBN-13:	9781641880404
Publisher:	I30 Media Corporation
Publication date:	01/30/2020
Edition description:	3rd Revised ed.
Pages:	110
Product dimensions:	6.00(w) x 9.00(h) x 0.31(d)

About the Author

Ian Lamont is an award-winning technology journalist, author, and publisher, and the founder of i30 Media Corp. and IN 30 MINUTES Guides. His books include Twitter In 30 Minutes and Lean Media: How to focus creativity, streamline production, and create media that audiences love. A graduate of Boston University and the Massachusetts Institute of Technology, he lives in the Boston area with his family.

Table of Contents

INTRODUCTION Excel: not just for nerds!

CHAPTER 1 The basics: cells, functions, and formulas. The different flavors of Excel (and Google Sheets) Using this guide with Excel and Google Sheets Firing up Excel and creating a new file What the different tabs do

Working with cells Your first spreadsheet formula Introducing functions with SUM AutoSum and the one Greek letter you need to know Formatting cells and text Using templates and themes Chapter quiz

INTERLUDE Excel Ninja skill #1: AutoFill AutoFill magic Formulas and AutoFill Dragging to extend functions

CHAPTER 2 More basic skills, from pasting to percentages Working with multiple worksheets Copy, paste, and paste special Adding and deleting rows Using percentages Parentheses and PEMDAS Static cell references Referencing other worksheets Calculating the difference between two numbers Chapter quiz

INTERLUDE Excel Ninja skill #2: charts Chart wizards Pie charts Customizing charts Other chart types

Sorting and filtering

Hiding rows and columns Rearranging a list in alphabetical order

Filtering

Chapter quiz

CHAPTER 4 Printing, import/export features, and collaboration

Printing

Exporting PDFs

Importing and exporting

Collaboration and sharing

Chapter quiz

A message from the author

About the author

Glossary

APPENDIX I Registering for Google Sheets

APPENDIX II Quiz answers

Index

Editorial Reviews

INTRODUCTION Excel: not just for nerds!

CHAPTER 1 The basics: cells, functions, and formulas. The different flavors of Excel (and Google Sheets) Using this guide with Excel and Google Sheets Firing up Excel and creating a new file What the different tabs do

Working with cells Your first spreadsheet formula Introducing functions with SUM AutoSum and the one Greek letter you need to know Formatting cells and text Using templates and themes Chapter quiz

INTERLUDE Excel Ninja skill #1: AutoFill AutoFill magic Formulas and AutoFill Dragging to extend functions

CHAPTER 2 More basic skills, from pasting to percentages Working with multiple worksheets Copy, paste, and paste special Adding and deleting rows Using percentages Parentheses and PEMDAS Static cell references Referencing other worksheets Calculating the difference between two numbers Chapter quiz

INTERLUDE Excel Ninja skill #2: charts Chart wizards Pie charts Customizing charts Other chart types

Sorting and filtering

Hiding rows and columns Rearranging a list in alphabetical order

Filtering

Chapter quiz

CHAPTER 4 Printing, import/export features, and collaboration

Printing

Exporting PDFs

Importing and exporting

Collaboration and sharing

Chapter quiz

A message from the author

About the author

Glossary

APPENDIX I Registering for Google Sheets

APPENDIX II Quiz answers

Index

From the Publisher