Excel Basics In 30 Minutes, 2nd Edition is written in plain English, with lots of step-by-step instructions and screenshots that demonstrate exactly what to do. This MS Excel tutorial references Excel 2016, but most of the step-by-step instructions apply to earlier versions of MS Excel released as part of the Microsoft Office and Office 365 suites, including Excel 2013 and Excel 2010. If you don't own Excel, the book explains how to use two free online spreadsheets programs: Excel Online and Google Sheets (part of the Google Drive online office suite). The book also covers the Excel mobile apps: Excel for Android and Excel for iOS.
Topics in this top-selling Excel book include:
* Excel screen layout, cells, and terminology
* Excel 2016 vs. Excel Online vs. Google Sheets
* Basic Excel formatting
* Excel formulas and functions
* How to make charts in Excel
* Sorting and filtering
* Collaboration and sharing
* Exporting PDF, CSV, and other forms
* Printing tips
* Excel import and export formats (PDF, .CSV, .TSV, text, etc.)
This is not an Excel bible, but rather a basic Excel tutorial and reference that answers the core questions that any new Excel user will have:
* What is a spreadsheet?
* What are cells?
* What is the button with the Greek letter for?
* How can Excel 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
The second edition is up-to-date with new instructions and high-resolution screenshots of Excel 2016, Excel Online, and the new Google Sheets. It includes new sections about collaboration, OneDrive, and other features.
Here are some real reader reviews of 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.”
"One thing I particularly liked about 'Excel Basics in 30 minutes' is that it covers BOTH the MS Excel basics and the Google version basics. Explaining anything this intricate in 30 minutes is a challenge. (Can it be read in 30 minutes? Yes, I could do it, but I am not a typical user, I did not need to stop and practice the examples.) I was impressed that the book does go into some of the ‘meat’ of Excel while still being a book that someone with NO previous exposure to a spreadsheet can grasp.”
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.
Excel Basics In 30 Minutes (2nd Edition) is authored by Ian Lamont, 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 in Innovation and Global Leadership.
Excel expert Paul McFedries shows how to use Excel 2010’s core features to solve problems and get the answers you need! Using real-world examples, McFedries helps you get the absolute most out of breakthrough Excel 2010 improvements–from Sparklines to the brand-new version of Solver. Along the way, you’ll discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions… insider insights… even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.Create more powerful formulas Use conditional formatting to instantly reveal anomalies, problems, or opportunities Analyze your data with standard tables and PivotTables Use complex criteria to filter data in lists Understand correlations between data Perform sophisticated what-if analyses Use regression to track trends and make forecasts Build loan, investment, and discount formulas Troubleshoot problems with formulas, ranges, and functions
About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excelskills, and presents focused tasks and examples for performing them rapidly and effectively. Selectedby Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will:Dramatically increase your productivity—saving you 50 hours a year, or more Present proven, creative strategies for solving real-world problems Show you how to get great results, no matter how much data you have Help you avoid critical mistakes that even experienced users make
• Write letters and reports
• Crunch numbers and create online data entry forms
• Give presentations
• Collaborate online with classmates and colleagues
• Convert Microsoft Office documents to Google formats, and vice versa
• Print documents, drawings, and spreadsheets
• Export PDFs
• Make pie charts, bar charts, and simple tables
• Publish documents and spreadsheets online using the new Google Sites
After covering registration, file creation and other basics, Google Drive and Docs In 30 Minutes (2nd Edition) zeroes in on the most important time-saving tips and productivity tools. Highlights include:
• Converting files between Microsoft Office and Google formats.
• Best practices for organizing files in Google Drive.
• What to expect with collaboration and sharing.
• The pros and cons of Google’s mobile apps for Drive, Docs, Sheets, and Slides.
• Accessing older versions of files.
• How to publish your documents to the Web for colleagues or members of the public to view.
• Functions, sorting and filtering in Google Sheets (with examples).
• Using Google Forms to gather data.
• Google Slides: Is it a suitable alternative to Microsoft PowerPoint?
• Working with offline files.
• Downloading third-party apps.
The tone of Google Drive and Docs In 30 Minutes is friendly and easy to understand, with lots of step-by-step instructions, screenshots, and examples. The guide can be used by anyone with a PC, Mac, or Chromebook. It also includes instructions for using Drive, Docs, Sheets, and Slides on Android and iOS phones and tablets.
Google Drive and Docs In 30 Minutes, 2nd Edition is authored by Ian Lamont, an award-winning technology and business journalist. He has written several books in the "In 30 Minutes" series, including Dropbox In 30 Minutes, Twitter In 30 Minutes, and Excel Basics In 30 Minutes.
Here's what readers are saying about Google Drive & Docs In 30 Minutes:
“I am so glad this was made! I've been using Google Docs for a while now and have been encouraging my teacher colleagues to do so as well to facilitate collaboration. It has become my go-to text book to help new users understand quickly. If you're new to Google Drive or Google Documents, this will help you. If you're experienced, and want something to help those who come to you with questions, this is a nice tool to help them remember what you show them. I highly recommend it.”
“I just got a new position that requires record keeping. Having used Google Docs in the past, I decided to update my knowledge. I googled "Docs for dummies" and this was one of the results. I liked the concept that the title implies - a concise guide that will distill what I need and allow me to complete a task quickly”
“A clear and concise explanation of how to navigate your way through google docs.”
“Excellent introduction to Google drive. Well researched, easy to read, nicely organized.”
This friendly book gets you started with the basics of Excel 2010, such as creating a spreadsheet from scratch, selecting commands from the Ribbon, customizing the Quick Access toolbar, creating simple formulas, moving and copying data with drag and drop, using the AutoCorrect and AutoFill features, and more.
Navigate effectively — see how the Ribbon interface and the Backstage View give you access to all the tools you need for every task
Be a mover and a shaker — move and copy data with cut, copy, and paste or drag and drop
Summing up — total columns and rows of numbers with the AutoSum button
Making it pretty — format data tables, adjust column widths and row heights, hide columns and rows, and format with Styles or the Format Painter
Safety net — save your work and recover spreadsheets after a computer crash
Open the book and find:
What's new in Excel 2010
How to surf an Excel 2010 worksheet and workbook
Instructions for entering data in a worksheet
Tips for keeping your data secure
How to enter and edit formulas with built-in functions
Tips for undoing or deleting data entry mistakes
Get comfortable with Excel 2010 and Backstage View
Create and edit spreadsheets
Format cells, create formulas, and fix data entry errors
Copy, cut, move, paste, or delete data
keywords: microsoft excel, ms excell, novice, beginner, introduction to excel, formatting, printing, excel basics
* Create a new Twitter account online or on your phone
* Customize your Twitter profile with photos and a bio that's right for you
* Navigate Twitter icons, the Twitter app, and Twitter.com
* Follow other Twitter accounts … and block those you don't like
* Identify local people and organizations using Twitter
* Find people who share the same interests and hobbies
* Compose your first Tweets
* Share photos
* Use hashtags, retweets, and other Twitter conventions
There's more. Twitter In 30 Minutes shows you how all kinds of people use Twitter to promote their businesses, connect with their followers, explore their interests, and have fun! It's peppered with real-world examples, from everyday people to celebrities.
Authored by award-winning technology journalist Ian Lamont, the revised third edition of Twitter In 30 Minutes covers Twitter's new interface for the Web and mobile devices such as the iPhone and Android phones. There are new screenshots, along with instructions for registration on iOS and Android devices.
Twitter In 30 Minutes is a perfect introduction to people who are new to Twitter, as well as those who already have accounts and want to learn how to get the most out of Twitter. Buy the book today!
Here's what real readers are saying about TWITTER IN 30 MINUTES:
"I quickly set up a Twitter account and started using it within a half hour. I would recommend this book for anyone who doesn't have a Twitter account, for those who do have one but aren't actively using it, and for those who aren't quite sure how to get the most out of their account."
"Though I have been using Twitter for some time now, I still learned a thing or two from reading this."
"Clarified any issues I had or concerns and listed some excellent precautions."
"Perfect introduction to Twitter. Quick and easy read with lots of photos. I finally understand the #!"
"I've been tweeting for over a year but learned a lot if helpful details I hadn't been aware of until now. Lots of easy to understand info, and good instructions with screenshots that make it easy to understand. Thanks for the help and making Twitter even more fun."
"Just the quick, light intro I wanted. No annoying bits of philosophy. Some careful warnings about privacy and courtesy are included. You really can skim it in 30 minutes."
"Easy to read and actually fun to fire up my twitter account and play along with each chapter. Everyone has 30 spare minutes spread out over a week (if not a day) to read this guide."
The second edition of this popular Dropbox book includes updated chapters as well as additional sections describing new Dropbox features of the Dropbox application for Windows and Mac PCs and laptops, the Dropbox app for iOS devices (including the Dropbox app for iPhones and iPads), and the Dropbox app for Android phones and tablets. The Dropbox manual also covers many useful features of Dropbox.com for backing up, sharing, and recovering files. In addition, the book's popular Dropbox FAQ has been expanded.
* Dropbox system requirements
* How Dropbox works in the cloud
* Installing Dropbox on Windows PCs (Dropbox on Windows 7 and earlier, Dropbox on Windows 10 and Windows 8)
* Installing Dropbox on Macs (macOS), iOS and Android
* Saving files to Dropbox
* Working with Dropbox folders and files
* Dropbox preferences and Selective Sync
* Opening a file or folder from a second computer
* Dropbox mobile app: Downloading/uploading files
* Dropbox Camera Upload for backing up and transferring photos from your mobile phone
* Dropbox sharing via links
* Dropbox collaboration
Dropbox In 30 Minutes also includes an unofficial FAQ that answers the following questions:
* How can I get free space on Dropbox?
* How secure is Dropbox?
* How do I delete Dropbox?
* Why is Dropbox taking so long to sync?
* Are Dropbox Business and Dropbox Pro accounts worth the extra cost?
* How can I recover deleted Dropbox files?
* What is Dropbox Paper and is it a substitute for Microsoft Word or Google Docs?
* What are Dropbox comments?
* What happens when the same file is opened simultaneously on more than one computer?
* What are third-party Dropbox apps?
What readers are saying about this Dropbox book
Thousands of satisfied readers have purchased this Dropbox book or downloaded the Dropbox ebook edition. While Dropbox In 30 Minutes is intended for beginners, even experienced users will discover a few new Dropbox tricks. Here's what real readers are saying:
"This was truly a 30-minute Dropbox tutorial. I have mastered the basics without bugging my 20-year-old son! Yahoo!"
"I have read Ian's books on Dropbox and Google Drive/Docs. He's an excellent writer, and the books are highly worthwhile, especially for people new to these applications."
"A short but thorough introduction to Dropbox. In my opinion, this is highly recommendable book for those who are approaching Dropbox or who need it for work and cooperative projects."
"I didn't know how to use Dropbox when I bought this book, and after reading it, I was able to set up my account and to use it with my students. It is short and to the point. I am a beginner and much of these online storage options are new to me, but I was able to read the book and to then use the app."
Buy your copy today!
Note: Dropbox In 30 Minutes is not affiliated with "For Dummies" books, Dropbox, or other services referenced in the guide. In 30 Minutes® is a registered trademark of publisher i30 Media Corp. All rights reserved.