|
|
Tutorials
Arrays - Definition
Arrays are formulas that allow you to perform multiple calculations at once with only one formula; they allow for the removal of many manual processes from the calculation process.
|
Charts & Graphs - Definition
Any data, numbers, or set of ranges within excel can be graphed and charted. There are many different types of graphs and charts available as well as many different ways to format and present them.
|
Financial Functions & Models - Definition
There are many financial functions in excel which allow you to create many complex financial models and analysis. In this section, you will learn how to use many financial functions within excel as well as how to build some financial models with those functinos.
|
Formatting - Definition
You can format cells, rows, columns, graphs, text, numbers, etc. to the point that you can change almost any visual aspect of the excel spreadsheet.
|
Formulas - Definition
Formulas in excel allow you to calculate averages, sums, standard deviations, loan payment amounts, interest rates, etc. As well, they allow you to manipulate the data in spreadsheets and to create complex financial statements and models.
|
Data Analysis - Definition
Excel allows you to perform data analysis including: statistical analysis, regressions, goal seek, solver, etc. These functions allow you to analyze complex decisions in order to determine the best course of action.
|
Import, Export, & Link Data - Definition
You can bring many different types of data into excel from many different locations including: Microsoft Word and Access and also web pages. You can also export data from excel into many formats including an XML format.
|
Lists & Forms - Definition
This section is as of yet empty. Consideration is being given to postponing the addition of this section to a later date. Sorry for the inconvenience.
|
Macros - Definition
Macros allow you to perform a large number of operations or actions very quickly and with little effort. We show you how to make them and how to use them as well as offering free macros for you to use.
|
Printing - Definition
Here you will learn everything there is to know about printing in excel. You can print considerable amounts of data on one page; print multiple worksheets at once; or even print multiple workbooks at once as well as much more.
|
Security - Definition
Whether trying to prevent sensitive information from getting into the wrong hands, preventing someone from messing up your worksheet, or just 'idiot-proofing' your worksheets, you will learn all of this here.
|
Tips & Tricks - Definition
Saving time, workarounds for excel's limitations, or just cool things you can do in excel are just some of the topics presented here.
|
|
|
