Mr. Spreadsheet’s Favorite Excel 2010 Tips & Tricks
- 2.5 hours on-demand video
- 2 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Customize the Ribbon and Quick Access Toolbar
- Understand conditional formatting features
- Work with formulas and functions
- Discover the different types of data
- Create Sparkline graphics
- Add images to your charts
- Protect your spreadsheet and avoid errors
- All Internet browsers, including Internet Explorer 9 or higher, Safari, Chrome, and Firefox
Let Mr. Spreadsheet welcome you to the wonderful world of Excel with this information-packed video training and e-book course
In Mr. Spreadsheet’s Favorite Excel 2010 Tips & Tricks Video Training Course, Deluxe Edition, you’ll gain valuable insight to essential spreadsheet tools and techniques to help you make Excel 2010 more efficient than you ever imagined. This one-of-a-kind collection of Excel video lessons covers everything from transforming data without using formulas to customizing the Ribbon, importing a text file into a worksheet range, using images to display your data, and other new and innovative ways to put Excel to work for you. You’ll also get a special edition of John Walkenbach’s Favorite Excel 2010 Tips & Tricks e-book filled with over 200 easy-to-follow Excel hints, timesavers, and secrets to take your spreadsheet skills to the next level. Whether you’re a longtime Excel enthusiast or just getting started with spreadsheets, this course has something for you. So, if you’re ready to start your journey to Excel excellence, Mr. Spreadsheet is ready to show you the way.
- Beginner to intermediate Excel users
Using the Ribbon is straightforward enough, and in this video, you’ll learn about the different tabs and their uses.
One of the new features in Excel 2010 is called Protected View. Although it may seem like Excel is trying to keep you from opening your own files, Protected View is all about protecting you from malware. Learn the Protected View basics in this video so you can keep your files safe.
Many Excel users think that the only way to select a range of cells is to drag over the cells with the mouse. Although selecting cells with a mouse works, it’s rarely the most efficient way to accomplish the task. A better way is to use your keyboard to select ranges.
If you find that you continually need to switch Ribbon tabs because a frequently used command never seems to be on the Ribbon that’s displayed, this video is for you. The Quick Access toolbar is always visible, regardless of which Ribbon tab is selected. After you customize the Quick Access toolbar, your frequently used commands will always be a click away.
If you have data in a column or row that you don’t want to see, you can hide the column or row. Doing this is often useful if you have formulas that provide intermediate calculations and you don’t want them to appear in a report. Or, you may just want to hide unused rows and columns so that you can focus only on the used area of the sheet.
Excel makes it easy to convert a range of cells into a picture. The picture can either be a dead image (it doesn't change if the original range changes) or a live picture (which reflects changes in the original range). The range can even contain objects, such as charts or shapes.
When you type something into a cell in a worksheet, Excel goes to work and makes decisions regarding the type of data you entered. If you understand how Excel interprets the data you enter into a cell, you can save yourself a bit of frustration when Excel’s decision about what you entered doesn’t correspond to what you had in mind.
A common type of worksheet contains a table of data with descriptive headings in the first row. But, as you scroll down the worksheet, the first row scrolls off the screen so you can no longer see the column descriptions. A feature introduced in Excel 2007 eliminated this age-old spreadsheet problem — but it only works if your data is in the form of a table.
Excel is capable of speaking to you. You can have this feature read back a specific range of cells, or you can set it up so that it reads the data as you enter it, but it’s not the easiest tool to find. Fortunately, the feature is still available — you just need to spend a few minutes to make it available.
Normally, Excel watches you type, and if it looks at all like you’re typing an e-mail address or a Web URL, the entry is converted into a hyperlink. Sometimes that capability is helpful, but sometimes it’s not. Learn how to control what you type so that it doesn't automatically turn into a hyperlink with this video.
Conditional formatting enables you to apply cell formatting selectively and automatically, based on the contents of the cells. Microsoft significantly enhanced conditional formatting to include several visualization features: data bars, color scales, and icon sets.
An Excel chart consists of a number of different elements. For example, all charts contain a plot area and at least one data series. A chart can also contain elements such as a chart title, axes, data labels, and so on. To work with a particular chart element, you need to select it — something that is often easier said than done.
Excel lets you place quite a few different types of objects on a worksheet: charts, shapes, clip art, and SmartArt, for example. To work with an object, you must select it. The easiest way to select a single object is to click it. What if you want to select multiple objects? Watch this video to find out.
If you need to insert a text file into a specific range in a worksheet, you might think that your only choice is to import the text into a new workbook and then to copy the data and paste it to the range where you want it to appear. However, you can do it in a more direct way.