How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Tools Tutorials
Pivot Tables in Excel
Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, and the ability to easily add or remove rows and columns.
Customizing the Office 2007 Ribbon
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.
Excel Graphics, Shapes WordArt and Text Boxes
Microsoft Excel has extensive tools for drawing graphic objects.
Working with Excel Files
This tutorial discover the new Excel interface that provides you with the right tools at the right time.
Running sensitivites over multiple sheets
Shows how to run the sensitivity tools within the AssumeIT macro over multiple sheets
Forecast The Outcomes Of Expanding A Business
When you want to grow your business - and avoid economic surprises - Excel has tools to help you determine your targets and analyze the data. You can create and modify different scenarios that let you speculate on a variety of business outcomes.
Use The Office 2001 Car Loan Analysis Tools
If some enchanting car has ensnared you in its siren song, check out these easy-to-use loan analysis tools in Office 2001.
Paste Special in Excel
The Paste Special command has a number of useful tools built into it. Besides allowing you to Paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.
The tips and tools in these free tutorials include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful, roll-up-your-sleeves guide shows you new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible.
Working with Excel 2007 Files
This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options.
Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc.