September 2010
Beginner
408 pages
10h 23m
English
Content preview from Excel® 2010 Workbook for Dummies®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 24. Top Ten Tips for Using Excel Like a Pro
In This Chapter
Generating new workbooks from templates
Creating data series with AutoFill
Trapping error values in their original formulas
Performing the exercises in this workbook gives you an opportunity to work with the most important features of Excel 2010, especially those related to building and maintaining spreadsheets. To help you make the most of this hands-on experience, this chapter brings together ten of the most important ways to work efficiently and design the best possible spreadsheets as you start to work on your own.
Generating New Workbooks from Templates
Whenever possible, generate new workbooks from templates that are available for Excel. Don't forget that the program provides you with a whole host of useful templates from online Office.com from Agendas to Time Sheets that you can start using right out of the box. To do so, just open the Available Templates panel in the Backstage View by clicking File
In addition to the templates listed in the various categories in the Available Templates panel, you can search Microsoft Office Online for other templates, which you can then download for use in Excel 2010. Simply click the Start Searching button (the one with arrow pointing to the right) located after the text box in the Office.com Templates section of the panel that contains, Search Office.com for Templates.
If you can't ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.