What readers are saying about In 30 Minutes® guides Dropbox In 30 Minutes “I was intimidated by the whole idea of storing my files in the cloud, but this book took me through the process and made it so easy.” “This was truly a 30-minute tutorial and I have mastered the basics without bugging my 20year- old son! Yahoo!” “An excellent primer on using Dropbox. It taught us several new tricks and ways to utilize the service for our business.”
Google Drive & Docs In 30 Minutes “I bought your Google Docs guide myself (my new company uses it) and it was really handy. I loved it.” “I have been impressed by the writing style and how easy it was to get very familiar and start leveraging Google Docs. I can’t wait for more titles. Nice job!
Twitter In 30 Minutes “A perfect introduction to Twitter. Quick and easy read with lots of photos. I finally understand the # symbol!” “Just the quick, light intro I wanted. No annoying bits of philosophy. Some careful warnings about privacy and courtesy are included.”
Excel Basics In 30 Minutes “Fast and easy, this book is everything it claims to be. The material presented is very basic but it is also incredibly accessible with step-by-step screenshots and a friendly tone more like a friend or co-worker explaining how to use Excel than a technical manual.”
LinkedIn In 30 Minutes “This book does everything it claims. It gives you a great introduction to LinkedIn and gives you tips on how to make a good profile.” “I already had a LinkedIn account, which I use on a regular basis, but still found the book very helpful. The author gave examples and explained why it is important to detail and promote your account. Reading this book has motivated me to return to my account and update it to make it more thorough and attention-grabbing.”
More In 30 Minutes® guides
Online Content Marketing In 30 Minutes: If you’re in business, you want more customers. This book shows how to leverage online content to get them. Personal Finance for Beginners In 30 Minutes: This two-volume series uses common sense, easy-to-understand language, and lots of examples to show you how to cut expenses and save more money for the things that really matter in life. Windows 8 Basics In 30 Minutes: Expert Tim Fisher covers Windows 8 personalization, app installation, email configuration, and more. He’ll also walk you through dozens of must-have apps from the Windows Store, ranging from games to Microsoft Office! jQuery Plugin Developement In 30 Minutes: Robert Duchnik shows you how to write clean and efficient jQuery plugins that are easy to maintain and collaborate on. While jQuery Plugin Development in 30 Minutes is intended for people who already have some experience with JavaScript and jQuery, most of the concepts in the guide will not require any advanced knowledge. C. Diff In 30 Minutes: Clostridium difficile is one of the most common hospital-acquired infections in the United States. In this guide, Dr. J. Thomas Lamont of Harvard Medical School explains what C. Diff is, how you can get it, and treatment options. Easy Chinese Recipes In 30 Minutes: A new approach to authentic Chinese dishes! Use fresh vegetables, meat, seafood, and other ingredients that can be picked up in any large supermarket. No MSG or deep-frying required!
Go to http://in30minutes.com for more information
Excel Basics
In 30 Minutes The quick guide to Microsoft Excel and Google Sheets
Second edition
Ian Lamont
We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.
Copyright © 2015 i30 Media Corporation In 30 Minutes® Guides in30minutes.com All rights reserved.
The author and the publisher make no representations with respect to the contents hereof and specifically disclaim any implied or express warranties of merchantability or fitness for any particular usage, application, or purpose. The author and the publisher cannot be held liable for any direct, indirect, incidental, consequential, or special damages of any kind, or any damages whatsoever, including, without limitation, those resulting in loss of profit, loss of contracts, goodwill, data, income, information, anticipated savings or business relationships, arising out of or in connection with the use of this book or any links within. i30 Media Corporation and IN 30 MINUTES guides are not associated with other brand names, product names, or trade- marks cited in this book, including Microsoft Excel®, Office 365™, Google Drive™ or Google Sheets. Excel Basics In 30 Minutes is an independent publication and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation. Screenshots featuring Excel are used with permission from Microsoft. Google and the Google logo are registered trademarks of Google Inc., used with permission.
Cover Design: Steven Sauer, Single Fin Design Interior Design and Layout: Rick Soldin, Print/Digital Book Production Specialist
Contents Introduction: Excel: Not Just For Nerds! .....................1 Chapter 1: The Basics: Cells, Functions, and Formulas ................................................ 2 The dierent flavors of Excel (and Google Sheets) ................................... 2 Excel 2003 (and earlier), Excel for Mac (2008 or earlier) ..................................... 3 Excel 2007, Excel 2010, Excel 2013, and Excel for Mac (2011 or later)................... 3 OďŹƒce 365 ................................................. 3 Excel Online.............................................. 4 Excel for mobile devices ............................ 4 Google Sheets .......................................... 4 Using this guide with Excel and Google Sheets . 4 Firing up Excel and creating a new file .......... 5 Spreadsheet terminology .............................. 5 Working with cells ......................................... 6 Your first spreadsheet formula ........................... 7 Introducing functions with SUM ..................... 9 AutoSum and the one Greek letter you need to know .........................................10 Quickly accessing other functions .............11 Formatting cells and text ..............................12 Chapter quiz ................................................14 Excel Ninja Skill #1: AutoFill .......................................15 AutoFill magic..............................................15 Formulas and AutoFill...................................... 16 Dragging to extend functions ........................17 Chapter 2 : More Basic Excel Skills: Percentages, Pasting, and Rows ....................................... 19 Working with multiple worksheets .................19 How to create a new worksheet .................19 Copy, paste, and paste special ......................... 20 How to duplicate a worksheet ....................22 Adding rows ................................................22 What happens to functions, formulas, and references .....................................23 Using percentages .......................................... 23 Parentheses and PEMDAS.......................25 Declining percentages..............................27 V
Static cell references .................................. 28 Spreadsheet division .................................. 29 Referencing other worksheets .................... 30 Chapter quiz............................................... 32 Excel Ninja Skill #2: Charts ...................................... 33 Chart wizards ............................................. 33 Pie charts ................................................ 33 Chart options and customizations ............ 35 Column charts and line charts..................... 37 Chapter 3: Sorting and Filtering...................... 38 Sorting ....................................................... 38 Hiding rows and columns......................... 39 Rearranging a list in alphabetical order .... 40 Basic sorting in Excel .............................. 40 Basic sorting in Google Sheets ................ 41 An alternate sorting scenario ................... 41 Sorting with multiple criteria ..................... 42 Filtering ...................................................... 43 Chapter quiz............................................... 45 Chapter 4 : Printing, PDFs, and Import/Export Features ........................... 46 Printing....................................................... 46 Adjust column widths............................... 46 Switch from portrait to landscape mode .... 46 How to set the print area .......................... 47 Printing cell outlines ................................ 47 Exporting PDFs .......................................... 48 Importing and exporting .............................. 49 Importing data into Excel ......................... 49 Exporting data ......................................... 51 Exporting charts ...................................... 52 Chapter quiz............................................... 52 A Message from the Author ...........................53 About the Author .......................................54 Glossary ..................................................55 Appendix I: Registering for Google Sheets.......... 56 Appendix II: Quiz answers .................................. 58
We are making a service for people who want a MS office 365 student A1 account with lifetime licence. If you are interested on this service check the link: https://www.fiverr.com/share/emV5Ek If you want this ebook just contact us in the previous link and you will get it with your MS accounts for 5 dollars (both book+ MS account). Note: I can’t share all the ebook here on this website, because of Copyright so I will share with you just the summary of the content.