Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By : John Walkenbach
Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By: John Walkenbach

Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.
Table of Contents (10 chapters)
Free Chapter
1
Cover
2
Table of Contents
3
Title Page
4
Introduction

Tip 6: Using a Workbook in a Browser

Microsoft’s Office Web Apps enable you to create, view, and edit workbooks directly in a browser. The experience isn’t exactly the same as using the desktop version of Excel, but it’s very similar. A key advantage is that you can access your workbooks from any location, and Excel need not be installed on the computer you use.

note.eps This tip assumes that you have a Microsoft SkyDrive account (free) and are logged in. You can also use SharePoint.

After creating a workbook, choose File⇒Save As and choose a location on your SkyDrive. This action saves your workbook on the cloud, and also saves a copy in your local SkyDrive folder. The two versions are synched.

Open your web browser and navigate to skydrive.com. Locate the workbook and click it. The workbook appears in the Excel Web App. Figure 6-1 shows a workbook displayed in the Google Chrome browser. As you can see, it’s remarkably similar to the desktop...