Categories
Excel Training

Excel 2010: Creating Custom Lists

There are many built in lists in Excel, numerical, date/time, text and numerical, and some text entries for month and day (try typing Jan in a cell and replicate the sequence down with the bottom right corner of the cell). For sequences that are not immediately available, Excel gives you the option of creating your own customised text lists.

Go to the File tab and select Options. On the Advanced page (tab at the left), scroll down to the General section where you see the Edit Custom Lists button. Click to open the dialog box.

Adding a custom listIf you have a list already in a spreadsheet, select the cells first. Now go to the Custom Lists dialog box and use the Import button to save retyping the entries.

Categories
Excel Training

Excel 2010: Writing Equations

To enter the equation editor, click on the Insert tab and select the equation button on the far right. Equation buttonThis brings up the Equation Tools ribbon with many preset symbols and options. Equation ribbonThe equation is entered in the highlighted text box on the worksheet.

the log cabin joke Mathematicians, have fun!