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
We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !
OFFSET in Excel
Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods.
The function wizard allows you to use any of Excels functions in a very user friendly way. You therefore do not need to remember the complex syntax of any of the commands.
Forumulas and Functions
Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused. What's more, the formula and function capabilities built into Excel might not always be what you want, further complicating the situation. Fortunately, there are a lot of ways you can keep your formulas and functions sane.
Save To SpreadsheetML And Extracting Data
Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.
In Excel there is a help tool for functions called the Function Wizard. Learn how to easily use functions with the function wizard.
How to Create Simple Pie Charts Using Excel
Create two different type of financial pie charts using microsoft excel.
Create a toolbar button for an existing macro
Step by step instructions with screenshots on how to create a toolbar button for an existing macro in excel. This a great little time saver when working with macros.
How To Use the Product Function In Excel
This video tutorial shows how to multiply two values using the product function in Excel.
Select a random sample of rows in Excel
Use the excel random number generator to get random sample data from a spreadsheet.
How To Zoom Into A Spreadsheet
This video tutorial shows how to change the zoom settings in a spreadsheet
How To Set Conditional Formatting
This video tutorial shows how to set conditional formatting in Excel.
Formulas in Excel
Formulas are entries that have an equation that calculates the value to display. We DO NOT type in the numbers we are looking for; we type in the equation. This equation will be updated upon the change or entry of any data that is referenced in the equation.
Goalseeking in Excel
The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph.
How To Change The Chart Legend Font In Excel
This video tutorial shows how to change the font of the chart legend in Excel.
How To Change The Cell Color Fill
This video tutorial shows how to change the color fill of a cell in Excel.
Total Tutorials in Category: 585