background preloader

Reports, analyses, charts, & formulas for business

Reports, analyses, charts, & formulas for business

Microsoft Excel Tips - Excel.Tips.Net Contextures Excel Tips, Excel Tutorials, Microsoft Office Consulting Microsoft Excel Training & Word 2007 Tutorial - Learn Free Office Online Video Course 2010 The Spreadsheet Page - By John Walkenbach Excel Formulas Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data. A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data. To start this lesson, open Excel. Set the Enter Key Direction In Microsoft Excel, you can specify the direction the cursor moves when you press the Enter key. Click the Microsoft Office button. Click Advanced. Perform Mathematical Calculations In Microsoft Excel, you can enter numbers and mathematical formulas into cells. + Addition - Subtraction * Multiplication / Division ^ Exponential In the following exercises, you practice some of the methods you can use to move around a worksheet and you learn how to perform mathematical calculations. Addition Type Add in cell A1. Note: Clicking the check mark on the Formula bar is similar to pressing Enter. Subtraction Division

MrExcel.com | Excel Resources | Excel Seminars | Excel Products Vertex42 - Excel Templates, Calendars, Calculators and Spreadsheets

Related: