In this video we’ll take a brief tour of Excel 2007. Excel 2007 pretty much does the same things it always has done, like number crunching and displaying many types of charts such as bar and pie charts. But Excel now makes those charts easier to create and better looking as well.
Excel has been tuned-up so to speak under the hood to allow for bigger spreadsheets, up to 1 million rows and up to 16,000 columns. Excel can now take advantage of newer computers that have dual processing chips and multithreading by splitting the processing up for quicker results.
The Ribbon
Like the Word 2007 video where I talked about the Ribbon, Excel 2007 has the Ribbon as well. Like Word’s Ribbon, Excel’s Ribbon also has 7 Tabs. Within the Tabs are Groups. Within the Groups there are different types of Controls that we can use to manipulate our spreadsheets.
Dialog Launcher
The Dialog Launcher allows you to open up a dialog box that contains more features of a group. The dialog launcher is a button in the lower right-hand corner of a each group. When you mouse over the button, you will see a preview of that dialog box. By clicking on this button you will pop-up the appropriate dialog box for that group.
There are Toolbars after all
You can also add and remove your favorite commands on the Quick Access Toolbar. The Quick Access Toolbar sits to the right of the Microsoft Office Button.
Commands, Commands, Commands
To add commands, use the customize button to the right of the Quick Access Toolbar or right click on a command and select Add to Quick Access Toolbar.
To remove commands from the Quick Access Toolbar, right click on the command and select Remove from Quick Access Toolbar.
You can also hide and unhide the Ribbon by double-clicking on any tab on the Ribbon.
Don’t forget the keyboard shortcuts as well. If you hold down the Alt key you will see “Badges” that display the keyboard shortcuts.
The New Page Layout View
There is a new view called the Page Layout View and you can access it two ways. This allows you to work with headers and footers and almost gives it a look and feel of working in the print layout mode in Word.
Click here for the video that corresponds with this post.
Microsoft did a great job with Excel2007 but I can’t say the same thing about Excel2010. I thought that E2010 will come with more new stuff but… 😐
I checked the video out. Pretty much covered everything that I need in excel. Thank you very much. I just bookmarked the video.