How to chart and graph data in Excel. 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; I'll show you how to do that here.
How to Analyze data in Excel. Video tutorials covering everything you need to know. 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.
All your finance needs and calculations done in Microsoft Excel. 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 functions.
How to use, edit, and manipulate formulas and functions in Excel. Formulas in excel allow you to calculate averages, sums, standard deviations, loan payment amounts, interest rates, etc. You can do everything from creating a financial model to testing engineering data.
All your Excel data import and export needs. 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.
How to properly print your Excel spreadsheets. 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.
How to keep your data, worksheets, workbooks, and files safe and protected in Excel. 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.