|
|
| Easy
| Assumes no previous knowledge; good for beginners.
|
| Easy |
Trickier than other easy tutorials but still good for the beginner. |
| Intermediate |
Difficult but no specific prior knowledge is needed to follow along. |
| Intermediate |
Assumes some prior knowledge of excel and basic formulas. |
| Intermediate |
These tutorials involve complicated topics which require a lot of knowledge of excel or which utilize basic functions in an inconventional or complicated way. |
| Advanced |
These will be the toughest tutorials. They are usually the most involved in terms of building a model in excel or using complex formulas which can be very confusing. |
Charts & Graphs in Excel - 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 in Excel - 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 and Functions in Excel - 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 in Excel - 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 in Excel - 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 in Excel - 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.
|
|
|
