TECH Bar Documentation

'Excel' Documentation

Create your first Excel Workbook

Here are some basic steps for creating a workbook and editing data in Microsoft Excel. Click on the link below for step-by-step instructions: Still have questions? Link to Microsoft's documentation

Defining Numbers in Excel 2007

Microsoft Excel allows you to quickly and easily designate different types of numbers. Depending on your selection, the number displayed will be formatted differently. Click on the link below for step-by-step instructions: Still have questions? Link to Microsoft's documentation

Excel Shortcuts & Tips

Here are few quick tips and shortcuts you can use in Microsoft Excel 2007. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Freezing Panes in Excel

Freezing panes in Excel 2007 can be an extremely useful tool when working with documents that contain large amounts of data and/or many different categories of information. Freezing the top row, the first column, or any other panes will cause those panes to remain in place as you scroll through the rest of the data. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Mail Merge

Mail merge is a great tool for creating customized formatted letters and envelopes from a central mailing list. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Making Charts in Excel

These basics will help you when making and changing charts in Microsoft 2007. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Making Tables in Excel

Some Quick Tips to get you started using Tables in Excel 2007. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Printing Excel Spreadsheets

You have created a spreadsheet, analyzed your data, and you are now ready to print in Excel 2007.To optimize the use of space, and created a printed document which is easily legible and conserves paper, use the following tips. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Quick Tips for using Macros

Having trouble or getting an error message with Macros in Microsoft Word or Excel 2007 - check out these quick tips. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website for macros in Excel: Link to Microsoft's documentation

Sorting Data in Excel

Using the Sort & Filter option in Microsoft Excel 2007 also makes it easier to work with data in Excel. You can choose to simply sort data from A to Z (or Z to A), or to use the Custom Sort feature to sort based on a different rule. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Using Excel Formulas

Some quick tips for using formulas in Excel 2007. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation

Using Pivot Tables in Excel

Some quick tips for using Pivot Tables in Excel 2007. Click on the link below for step-by-step instructions: Still have questions?  Take a look at the Microsoft website's tutorials: Link to Microsoft's documentation