Spoken Language: English
Business: Education and Training, Information Technology
Easy Excel Tutorial provides easy to follow, step by step instructions on how to use Excel 2010 or Excel 2007. It doesn't matter if you are new to Excel and want to start from scratch or just want to use this Microsoft Excel tutorial as a reference. We keep it simple!
This section is for Excel users who have just started using Excel. It explains some Excel Basics.
- Excel Workbook: A workbook is another word for your Excel file. Learn how to open a workbook, create a workbook from a template, password protect a workbook and view multiple workbooks at the same time.
- Excel Worksheets: A worksheet (or spreadsheet) is a collection of cells where you keep and manipulate the data. This chapter teaches you how to select, rename, insert, move, delete and copy a worksheet.
- Working with Excel Ranges: A range in Excel is a collection of two or more cells. This chapter gives an overview of some very important range basics.
- Format Excel Numbers: When we format numbers, we change the appearance of a number without changing the number itself.
- Excel Calendar: Making a calendar in Excel is easy. Instead of creating your own calendar from scratch, you can create a calendar from a template.
- Printing in Excel: This chapter teaches you how to print the entire worksheet or just a selection and how to change some important print settings.
- Save Excel File as PDF: Saves files in PDF format so that others can view your Excel spreadsheets without having Excel installed on their computer.
This section is for Excel users who want to learn more about formulas and functions in Excel.
- Formulas & Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
- Cell References in Excel: Cell references in Excel are very important. This chapter explains the difference between relative, absolute and mixed cell reference.
- Most Used Excel Functions: The most used functions in Excel are SUM, AVERAGE, COUNT, MAX and MIN. This chapter explains these functions and illustrates three options to access these functions.
- Logical Functions in Excel: Learn how to use logical functions in Excel such as the IF function, AND function and OR function. The IF function can be nested, when you have multiple conditions to meet.
- Date & Time Functions: An overview of the most important date and time functions in Excel.
- Text Functions in Excel: Excel has many functions to offer when it comes to manipulating text strings.
- Excel VLookup: The VLOOKUP function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table. This chapter clearly illustrates the VLOOKUP function.
- Excel Sumif: This chapter teaches you how to conditionally sum a range using the SUMIF function. In a similar way you can use the AVERAGEIF function to conditionally average a range and the COUNTIF function to conditionally count the values in a range.
- Excel Sumproduct: The SUMPRODUCT function is one of Excel's most powerful functions. Learn more about the SUMPRODUCT function in this chapter.
- Excel Pmt: The PMT function in Excel calculates the payments for a loan based on constant payments and a constant interest rate.
- Random Numbers in Excel: Excel has two very useful functions when it comes two creating random numbers. Learn all about it in this chapter.
- Excel Formula Errors: This chapter teaches you how to deal with the most common formula errors in Excel.
- Rounding Numbers in Excel: This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.
Working with Excel Data<
This section illustrates the powerful features Excel has to offer to analyze data.
- Sort & Filter in Excel: You can sort your data in descending and ascending order. You can filter your data If you only want to records that meet certain criteria.
- Excel Pivot Tables: Pivot tables are very powerful when you need to extract the significance from a large, detailed data set.
- Find & Replace in Excel: You can use Excel's find feature to quickly find specific text. You can use Excel's replace feature to quickly find specific text and replace it with other text.
- Hide Columns or Rows: This chapter teaches you how to hide columns or rows in Excel.
- Freeze Panes in Excel: If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.
- Excel Data Validation: You can use data validation to make sure that users enter certain values into a cell.
- Drop-down Lists in Excel: Drop-down lists are helpful if you want to be sure that users select an item from a list, instead of typing their own values.
- Working with Excel Tables: Excel tables allow you to analyze your data very easily.
- Remove Duplicates in Excel: This chapter teaches you how to remove duplicate rows from a sheet.
- Excel What-If Analysis: What-If Analysis in Excel allows you to try out different values (scenarios) for formulas.
- Excel Solver: Excel includes a tool called solver that uses techniques from the operations research to find optimal solutions for all kind of decision problems.
This section is about visualizing data in Excel. Visualizing your data makes your data easier to understand.
- Excel Charts: A simple chart can say more than a sheet full of numbers. As you'll see, creating Excel charts is very easy.
- Conditional Formatting: Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
- Excel 2010 Sparklines: Excel 2010 makes it possible to insert sparklines. Sparklines are graphs that fit in one cell and give you information about the data.
- Excel Pivot Charts: A pivot chart is the visual representation of your pivot table. Learn more about Excel pivot charts in this chapter.