Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Insert Tab

EXCEL 2010 INSERT RIBBON

Symbols

EXCEL 2010 SYMBOLS GROUP

You can insert characters that are not on your keyboard, such as copyright symbols, trademark symbols, paragraph marks and Unicode characters by utilizing the Symbol button in the Symbols section of the Insert tab.

To add a special symbol or character to a cell, select the Symbol button. The Symbol dialog box will appear as shown in the image below. The Symbol dialog box contains two tabs: Symbols and Special Characters.

EXCEL 2010 INSERT SYMBOL
EXCEL 2010 INSERT SYMBOL


From the Symbols tab you can change your font.

 

The Wingdings and Webdings fonts include a wide variety of symbols that you won’t find with most other common fonts.

The Subset drop-down list includes foreign alphabets, accented characters and mathematical operators.

Select the Special Characters tab for a variety of characters to choose from. 

EXCEL 2010 RECENTLY USED SYMBOLS

The most recently used symbols appear near the bottom of the symbols tab.

Select your special symbol or character and click Insert. The Symbol dialog box will stay open so you can insert multiple symbols/characters without reopening the dialog box for each one.

Excel worksheets are often utilized for their formulas. If you set up a formula properly, it computes the correct answer when you enter it into a cell. From then on, it keeps itself up-to-date, recalculating the results whenever you change any of the values that the formula uses.

EXCEL 2010 INSERT EQUATIONS





Insert common mathematical equations or build up your own equations using a library of math symbols.

Select the Equation button in the Symbols section of the Insert tab. As shown in the image to the right, the drop-down menu includes a list of preformatted equations or you can insert a new equation at the bottom.

In our example, we are selecting Area of Circle equation.

EXCEL 2010 INSERT EQUATIONS


The equation is now inserted into our working space (as shown in the image to the left).

You can resize and move the equation box as needed.

In order to edit the equation, simply click in it and select the information and start typing your numbers.

 

When your equation is selected, the Drawing Tools Format and Equation Tools Design tabs will be added to your ribbon (as shown in the images below).

The Drawing Tools Format tab appears on an as needed basis. When you click on a drawing object such as a shape or equation, the tab becomes visible in your ribbon. It gives you access to shapes, shape styles and WordArt.

EXCEL 2010 DRAWING TOOLS FORMAT

There are various symbols available for insertion on the Equations Tools Design tab. Clicking on the Equation drop-down menu in the Tools section of this tab will reveal several predefined equations that can be inserted as a starting point for your equation. Utilize the Structures section to add fractions, scripts, functions and more to your equation.

EXCEL 2010 EQUATION STRUCTURES
Next Tutorial


This concludes the tutorial for the Insert tab.
Click next to continue to the Excel 2010 Page Layout Tab tutorial.