Subscribe Us

Enter your email address:

Loading

Advanced Topics in Excel Spreadsheets

Labels:


Advanced topics, such as working with scenarios, macros, lookup functions, pivot tables, and auditing formulas can be found in this category. These topics are explained and covered in a variety of ways.

The Date in Excel

There are many ways of using dates in Excel. There are functions or formulas to add the current date to an Excel spreadsheet. You can also subtract one date from another or find out how many days between the start date and end date of a project. You can format the date in a variety of ways.

Excel Conditional Formatting

Excel's conditional formatting features let you control how a cell is formatted - such as changing colors - depending on the data the cell contains. If the cell data meets the conditions you set, then the formatting is applied to the cell.

Creating a Drop Down List in Excel 2007

Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet.

Excel Macro Tutorial

Excel VLOOKUP

Excel’s VLOOKUP function is used to find specific information that has been stored in a spreadsheet table of data.

Excel HLOOKUP

Similar to the above VLOOKUP function, Excel’s HLOOKUP function is used to find specific information that has been stored in a spreadsheet table of data.

Using Excel's Goal Seek Feature

Excel's Goal Seek feature allows you to alter data in formulas to get different results. Goal Seek can be useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.

Create Excel Pivot Tables

A pivot table is a reporting tool that sorts, counts, and sums the data from a spreadsheet, database, or other external data source. The pivot table is a second table that displays the summarized data.

Microsoft Excel Sort Feature

Learn how to manage large amounts of data. Sorting data not only helps you to keep it organized, but it makes it easier to find exactly the data you are looking for.


More Topics 

  • Advanced formulas

  • VB Code

  • Data Import

  • Data Filter

  • Data Validation

  • Consolidate

  • And much more...


Please provide your comments or idea or involved as possible as you can to make it the most

'



0 comments:

Post a Comment

Post a Comment