Excel Basics In 30 Minutes (2nd Edition): The Beginner’s Guide To Microsoft Excel And Google Sheets
By Ian Lamont
4/5
()
About this ebook
Do you want to learn how to use Microsoft Excel, for a career boost or for school, or to better handle numbers, lists, and other data? The revised and expanded edition of this popular Excel user guide will quickly get your Excel skills up to speed with basic spreadsheet concepts, tips, and tricks! Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions, screenshots, and examples that demonstrate exactly what to do.
This Excel book can be used with recent versions of Excel, including Excel 2013, Excel for Office 365, and Excel Online, as well as older Excel versions. For users who don't own Excel, the guide explains how to use a free online spreadsheets program called Google Sheets (part of the Google Drive online office suite).
Topics include:
* Screen layout, cells, and terminology
* Formatting cells and text
* AutoFill
* Excel formulas and functions
* How to make charts
* Sorting and filtering
* Printing
* Importing and exporting PDFs, .CSV files, and other formats
This is not an Excel bible, but rather a quick guide that answers the core questions that most new Excel users will have:
* What is a spreadsheet?
* What are cells?
* What is the button with the Greek letter for?
* How can spreadsheets create basic financial projections?
* How can certain data in a worksheet be highlighted?
* How can data be alphabetized or ranked?
* How to edit a chart in Excel
* How to print an Excel spreadsheet without cutting off columns
Excel Basics In 30 Minutes, 2nd Edition is authored by Ian Lamont, an award-winning technology writer and author of Google Drive & Docs In 30 Minutes, Twitter In 30 Minutes, and Dropbox In 30 Minutes.
Ian Lamont
Ian Lamont is an award-winning business and technology journalist and the founder of i30 Media Corporation. He has written for more than a dozen online and print publications and has also served as the managing editor of The Industry Standard. His writing and editorial work has garnered industry awards from the Society of American Business Editors and Writers and the American Society of Business Publication Editors. Lamont has written several In 30 Minutes guides, including Dropbox In 30 Minutes, Google Drive & Docs In 30 Minutes, and Excel Basics In 30 Minutes. He is a graduate of the Boston University College of Communication and MIT's Sloan Fellows Program.
Read more from Ian Lamont
Personal Finance For Beginners In 30 Minutes, Volume 1: How to cut expenses, reduce debt, and better align spending & priorities Rating: 3 out of 5 stars3/5Personal Finance For Beginners In 30 Minutes, Volume 2: How to build savings and investments to secure your financial future Rating: 0 out of 5 stars0 ratings
Related to Excel Basics In 30 Minutes (2nd Edition)
Related ebooks
Access 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsMicrosoft Excel: Advanced Microsoft Excel Data Analysis for Business Rating: 0 out of 5 stars0 ratingsExcel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5150 Most Poweful Excel Shortcuts: Secrets of Saving Time with MS Excel Rating: 3 out of 5 stars3/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Guerilla Data Analysis Using Microsoft Excel Rating: 0 out of 5 stars0 ratingsExcel 2016 Hands-On Lab Rating: 0 out of 5 stars0 ratingsPower Outlook: Unleash the Power of Outlook 2003 Rating: 0 out of 5 stars0 ratingsData Analysis with Excel: Tips and tricks to kick start your excel skills Rating: 0 out of 5 stars0 ratingsExcel 2007 Miracles Made Easy: Mr. Excel Reveals 25 Amazing Things You Can Do with the New Excel Rating: 0 out of 5 stars0 ratingsExcel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5Excel :The Ultimate Comprehensive Step-by-Step Guide to Strategies in Excel Programming (Formulas, Shortcuts and Spreadsheets): 2 Rating: 0 out of 5 stars0 ratingsThe Ridiculously Simple Guide to Google Sheets: A Practical Guide to Cloud-Based Spreadsheets Rating: 4 out of 5 stars4/5Mastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Excel Outside the Box: Unbelieveable Excel Techniques from Excel MVP Bob Umlas Rating: 4 out of 5 stars4/5EXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsLearn Microsoft Office Word Fast and Easy: Ultimate Beginners Guide Rating: 4 out of 5 stars4/5Cleaning Excel Data With Power Query Straight to the Point Rating: 5 out of 5 stars5/5Excel 2021 Rating: 4 out of 5 stars4/5Increase Your Productivity Using Microsoft Outlook 2010 Rating: 0 out of 5 stars0 ratingsExcel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables Rating: 5 out of 5 stars5/5Excel 365 for Beginners: Excel 365 Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel Guide for Success Rating: 5 out of 5 stars5/5Excel 2007 All-In-One Desk Reference For Dummies Rating: 3 out of 5 stars3/5How to Do Everything: Microsoft Office Online Rating: 0 out of 5 stars0 ratingsExcel 101: A Beginner's Guide for Mastering the Quintessence of Excel 2010-2019 in no time! Rating: 0 out of 5 stars0 ratings
Accounting & Bookkeeping For You
The Intelligent Investor, Rev. Ed: The Definitive Book on Value Investing Rating: 4 out of 5 stars4/5Financial Feminist: Overcome the Patriarchy's Bullsh*t to Master Your Money and Build a Life You Love Rating: 4 out of 5 stars4/5Tax-Free Wealth: How to Build Massive Wealth by Permanently Lowering Your Taxes Rating: 5 out of 5 stars5/5Die With Zero: Getting All You Can from Your Money and Your Life Rating: 4 out of 5 stars4/5Accounting For Dummies Rating: 5 out of 5 stars5/5How to Start a Nonprofit Organization: The Complete Guide to Start Non Profit Organization (NPO) Rating: 4 out of 5 stars4/5The ZERO Percent: Secrets of the United States, the Power of Trust, Nationality, Banking and ZERO TAXES! Rating: 5 out of 5 stars5/5The Tax and Legal Playbook: Game-Changing Solutions To Your Small Business Questions Rating: 3 out of 5 stars3/5All About Asset Allocation, Second Edition Rating: 4 out of 5 stars4/5The Book on Advanced Tax Strategies: Cracking the Code for Savvy Real Estate Investors Rating: 4 out of 5 stars4/5Bookkeeping For Dummies Rating: 5 out of 5 stars5/5Start, Study and Pass The CPA Exam FAST - Proven 8 Step CPA Exam Study Playbook Rating: 5 out of 5 stars5/5Profit First (Review and Analysis of Michalowicz's Book) Rating: 5 out of 5 stars5/5Financial Accounting For Dummies Rating: 0 out of 5 stars0 ratingsProfit First for Therapists Rating: 0 out of 5 stars0 ratingsFinancial Statement Basics: From Confusion to Comfort in Under 100 Pages Rating: 4 out of 5 stars4/5Law of Leverage: The Key to Exponential Wealth Rating: 4 out of 5 stars4/5Your First CFO: The Accounting Cure for Small Business Owners Rating: 4 out of 5 stars4/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsOvercoming Underearning(TM): A Simple Guide to a Richer Life Rating: 4 out of 5 stars4/5QuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsThe Nonprofit Fundraising Solution: Powerful Revenue Strategies to Take You to the Next Level Rating: 5 out of 5 stars5/5Bookkeeping Basics: What Every Nonprofit Bookkeeper Needs to Know Rating: 4 out of 5 stars4/5Nonprofit Meetings, Minutes & Records: How to Properly Document Your Nonprofit's Actions Rating: 4 out of 5 stars4/5Full Charge Bookkeeping, For the Beginner, Intermediate & Advanced Bookkeeper Rating: 5 out of 5 stars5/5
Reviews for Excel Basics In 30 Minutes (2nd Edition)
1 rating0 reviews
Book preview
Excel Basics In 30 Minutes (2nd Edition) - Ian Lamont
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 20-year-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
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 trademarks 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!
Chapter 1: The Basics: