Excel's Toolbars
In this section you will learn about the three (3) main toolbars used in Microsoft Excel for Mac.
There will be three (3) movie pages attached to this page; one for each toolbar.
The Standard Toolbar :
In order to get a live version of these instructions click here
for the movie version.

The standard tool bar is the one most people are familiar with if they have ever used Microsoft Office.
This is the tool bar that allows you to open up new, or saved, files, print, or see a preview of what you want printed.
It also allows you to cut, copy, and paste items. Some extra functions it performs in Excel is to allow you to auto sum, sort groups of information either from smallest to largest (ascending), or largest to smallest (descending). Finally, this toolbar also allows you to magnify (or de-magnify) your whole Excel page, just in case you need to.
**In order to see it, you need to go to the View > Toolbars> and check Standard.
The Formatting Toolbar:
In order to get a live version of these instructions click here
for the movie version.

The formatting toolbar is the second most familiar toolbar for anyone who has worked with Microsoft Office.
This toolbar allows you to change the font, size of font, alter the font (to bold, italics, or underline), or align it either to the left, right, or center.
In Excel, this toolbar will allow you to merge cells, modify the way currency, percentages, commas, or decimal places are handled. It will also frame, or outline any cell or group of cells. Finally, this toolbar allows you color a cell or color the font inside a cell.
**In order to see it, you need to go to the View > Toolbars> and check Formatting.

The Formula Toolbar;
In order to get a live version of these instructions click here
for the movie version.

The third and final toolbar that is necessary to use Excel efficiently, is the formula toolbar.
This toolbar is custom made for Excel. It allows you to see the cell reference and make calculations between cells. The equal sign (=) allows you to enter formulas into cells. It's most important point, though, is to show you what is actually in each cell. The long empty space after the equal sign shows you what data is in each cell, be it a formula, simple data, or reference to another cell. With the formula bar, all the magic of Excel comes alive.
In all reality, all three of these toolbars work together to allow you to make the most out of Excel and your database. You should see all three of them when you start up the program. However, if you do not, follow this picture to see all the toolbars necessary to run Excel.