In this Microsoft Excel® tutorial for the intermediate user, you'll explore some powerful features in Microsoft Excel for calculating and analyzing data. Learn how to write complex formulas using IF statements, work with PivotTables and add-ins, use database features such as forms and data validation and create your own Microsoft Excel macro commands and functions with VBA.
Don't let complex Excel functions intimidate you! In this lesson, you'll learn how to create powerful Excel formulas and functions that include logical conditions and other advanced attributes.
Excel provides many tools for helping you analyze numeric information. In this lesson, you'll learn about some of these tools, including Excel financial functions, goal seeking and working with PivotTables.
Besides serving as an excellent spreadsheet tool, Excel also functions as a flat-file database program. In this lesson, you'll learn how to modify and manage database data in a worksheet and how to integrate Excel-stored data into Microsoft Access.
Have you ever wished that Excel could do something it can't or that you could accomplish certain tasks more easily? With Excel macro commands and VBA scripts, you can extend Excel's capabilities. This lesson shows you how.
